Tip

Oracle flexible architecture layout

In order to support a robust environment for Oracle, the best basis for your Oracle directories should be based on the Oracle Flexible Architecture layout (OFA).

In addition to the OFA guidelines,

    Requires Free Membership to View

there are some additions that I like to make:

Create an environmental variable ORACLE_ADMIN and point it to ORACLE_BASE/admin. Use this directory to house all your database directories, and their subdirectories, dump directories (adump, bdump, cdump, udump), your parameter files (pfile), the scripts used to create the database (create), and a directory for all the addition SQL used for this database (admin).

I like to use the admin directory to store all security scripts (creation of roles, grants to users), plus the scripts for the creation of database links, and any special synonym creations. Make sure you use prompts in any SQL that uses passwords (like database link creations). The use of the admin directory makes the creation of copies of the database much easier, and makes life easier for other DBAs who are trying to fill in for you.

Under the ORACLE_ADMIN directory you should also create a sql and bin directory to store all common SQL scripts, and shell scripts that you use to administer Oracle. Make sure the you add ORACLE_ADMIN/sql to your ORACLE_PATH (this is the search order use by sqlplus to locate SQL scripts) and add ORACLE_ADMIN/bin to your PATH. For Oracle 7.x users, change your SQLPATH variable instead on ORACLE_PATH, and upgrade your database.

When it comes to the file structure for Net8, I like to place the tnsnames.ora and sqlnet.ora files in the /etc directory. The biggest advantage to this is that these files are in a single location regardless of how many versions of Oracle you are running.

About the Author

James Giordano is an Oracle database administrator. He has been working with Oracle for about seven years, and also has experience with UNIX and PeopleSoft/Oracle financials.

For More Information


This was first published in February 2001

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.