Manage

Oracle jobs careers and resources

• How to create an Oracle database link

  From remote databases to database migrations, this tip shows you how to create an Oracle database link and avoid potential pitfalls. Continue Reading

• Turn database administrator skills into leadership skills

  In a session at Collaborate 16, database architect Ziaul Mannan will reveal the ways DBAs are being overlooked as potential executives and how to prove internally that DBA skills translate well to IT leadership roles. Continue Reading

• How to make sense of Oracle licenses for VMware environments

  Oracle licenses are a tricky subject and Oracle licensing for VMware environments doubly so. Find out about the important documents and policies that guide Oracle licensing and VMware. Continue Reading

• Oracle's cloud services push brings users options, issues

  In a Q&A, OAUG president Melissa English discusses how Oracle's increasing focus on cloud computing services affects users and what Oracle and the OAUG are doing to answer questions. Continue Reading

• Matelski mentors techies to help lead Oracle user group IOUG

  John Matelski, an IT executive and current president of the Independent Oracle Users Group, makes bringing out the leadership skills of DBAs and other technical staffers who are IOUG members a priority. Continue Reading

• New president brings global change management skills to OAUG

  The 2015 OAUG president, Melissa English, found a love of education in teaching her peers. Now she brings global change management skills to the OAUG.Continue Reading

• Not much Exadata training necessary for experienced DBAs, says expert

  A database consultant says using Exadata is relatively easy for IT shops already managing Oracle Database. But some new DBA skills may be required.Continue Reading

• How can today's DBAs contribute to big data databases?

  In the big data puzzle, data scientists and NoSQL are all the rage. Find out how traditional DBAs fit in, and what they have to do to stay there.Continue Reading

• Independent Oracle Users Group celebrates 20th anniversary

  Independent Oracle Users Group President John Matelski argues for the value of an Oracle users group in today's day and age.Continue Reading

• Book excerpt: Effective MySQL Backup and Recovery

  As a DBA, you need to create an effective strategy. How? Read this excerpt from Ronald Bradford's 'Effective MySQL: Backup and Recovery' to find out.Continue Reading

• Do I buy an extra license for an OAS to Fusion Middleware 11g upgrade?

  Learn whether you need to buy an extra license when performing an upgrade from Oracle Application Server (OAS) to Oracle Fusion Middleware 11g for Forms and Reports in this tip from Oracle licensing expert Scott Rosenberg.Continue Reading

• New Oracle Database 11g book offers 'underground' tips

  April Sims, a DBA at Southern Utah University and an Oracle Certified Professional, talks about her new book, “Oracle Database 11g Underground Advice for Database Administrators.”Continue Reading

• Understanding the Oracle user provisioning process

  This chapter describes the various sophistication levels of the user provisioning process, including discretionary account provisioning, self-service provisioning, workflow-based provisioning and more.Continue Reading

• Using Oracle Identity Manager (OIM) connectors and integration

  Learn how to use the Oracle Identity Manager (OIM) integration platform, including the OIM connectors such as prebuilt connectors and generic technology connectors , and provisioning and reconciliation integrations.Continue Reading

• The Oracle Identity Manager (OIM) deployment model

  Read about the Oracle Identity Manager (OIM) deployment model and its multiple tiers, which include the client tier, web tier, business logic tier and data tier.Continue Reading

• How to use Oracle Identity Manager for user provisioning

  Read about how Oracle Identity Manager is used for the user provisioning process, including enabling simpler administration, reduced risk and easier integration.Continue Reading

• How to land your dream Oracle DBA job

  Despite the recession, companies are willing to pay top dollar for qualified Oracle professionals. Don Burleson offers guidance on nabbing the dream Oracle DBA job.Continue Reading

• Part 2: Maintaining your place in the race -- ERP project management

  Get tips on ERP project management for an R12 implementation, including ERP organization and staffing, in this second installment of a three-part series on ERP project success.Continue Reading

• Oracle management downsizing tips: Saving on Oracle hardware and software in a down economy

  Learn how to reduce Oracle database costs with exclusive expert advice from Donald Burleson. Find out how to trim the fat without compromising security or quality.Continue Reading

• Data integration challenges and solutions revealed

  Forrester's Noel Yuhanna sizes up Oracle and SQL Server interoperability features and sheds light on data virtualization, a new way to solve the data integration problem.Continue Reading

• How to start multiple instances in Oracle 10g

  I want to know how to start multiple instances in Oracle 10g. I have created two databases using DBCA and I have one database server.Continue Reading

• How to create a database schema in Oracle?

  How to create a database schema?Continue Reading

• How to find transactions being committed to Oracle database

  How to find the transactions being committed? Which database views help to find this?Continue Reading

• How to create a password file in Oracle 9i?

  How to create a password file in Oracle 9i? What is the exact command and do we need to make any changes in the parameter file?Continue Reading

• How to uninstall Oracle

  Part of our "How do I do that in Oracle?" series, this tip, compiled largely of advice from our expert Oracle DBAs, explains in detail how to uninstall Oracle software from your system.Continue Reading

• How to find all USER_OBJECTS in database?

  How can I get all the USER_OBJECTS in the database?Continue Reading

• How to find Oracle database instance size

  How to find out the Oracle database instance size (BG + SGA)?Continue Reading

• How to become a successful Oracle DBA?

  I want to be an Oracle DBA in the near future. I have an information systems background and a basic understanding of SQL and Oracle.Continue Reading

• DBA time tracking and change management

  I'm looking for ideas on how to best track and account for the time my DBA team uses. Also, what best practices can you prescribe for implementing a database change management framework?Continue Reading

• Interview questions about managing an Oracle database

  I have an interview relating to managing an Oracle database. What types of questions will they ask me?Continue Reading

• How to practice Oracle 9i on home PC

  I want to practice Oracle at home. I have a single PC with Windows 2000 installed on it. I have got three disks of Oracle 9i version 9.2.0.Continue Reading

• Backup strategy for 1TB database

  I work for a small firm with less than 400GB of data which is backed up on a daily basis. What is the best backup strategy if the firm expands its database to 1TB?Continue Reading

• How to drop all tables from database with one SQL query

  How to drop all tables from the database using one SQL query?Continue Reading

• Relational Database Management System (RDBMS) fundamentals tutorial

  New to database administration or development? Here's a quick guide that can get you started by providing background on the relational model and practical advice for working with a relational database management system.Continue Reading

• Manage users using Oracle Internet Directory

  Continue Reading

• The Top 10 (more or less) J2EE best practices

  Much has been written in recent years about J2EE best practices, including books and articles offering insight into how J2EE apps should be written. Here are the best.Continue Reading

• 30 Oracle tips in 30 minutes

  An IOUG guide to 30 practical tips and tricks to make an Oracle database administrator's and developer's job easier.Continue Reading

• How to get an Oracle DBA job

  Despite the steepest downturn in the history of IT, there are jobs to be had by Oracle certified professionals and DBAs. To get them, insiders say, IT pros need to remember some of the rules they learned long ago and apply some new strategies as ...Continue Reading

• Object vs. relational database management systems

  Author Doug Barry weighs in about the pros and cons of the ODBMS.Continue Reading