Oracle 9i Database Administration in 10 Minutes

- Asim Abbasi (Author)

Chapter 6: Oracle 9i Database Design using DBCA

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19

Before even we start DBCA (Database Configuration Assistant) we have to set some of the OS environment variables. ORACLE_BASE describes the top most directory where Oracle software will be installed. In Windows environment we can set it using the SET command.

Step 1:

Let’s suppose the DOS prompt is C:\>.

C:\> SET ORACLE_BASE C:\Oracle

Figure 20: Before using DBCA we have to set certain OS environment variables.
________________________________________

Whereas in Unix we write the command as shown below.

% setenv ORACLE_BASE /Oracle

ORACLE_HOME specifies the directory that lies beneath ORACLE_BASE and its here where Oracle products reside. According to OFA (Optimal Flexible Architecture), this environment variable should to set to ORACLE_BASE/product/release#. Let’s suppose the DOS prompt is C:\>.

C:\> SET ORACLE_HOME C:\Oracle\database\9_2

Whereas in Unix we write the command as shown below.

% setenv ORACLE_HOME /Oracle/product/9_2

ORACLE_SID is the instance name or rather default instance name on the machine having Oracle installed. Let’s suppose the DOS prompt is C:\>.

C:\> SET ORACLE_SID test

Whereas in Unix we write the command as shown below.

% setenv ORACLE_SID test

PATH is the environment variable and its usually set to ORACLE_HOME/bin folder. The bin folder contains all the tools that shipped with Oracle.

Chapter 6: Oracle 9i Database Design using DBCA

Page #: 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19

Share with others:

products

books

FREE VB, ASP Projects

Oracle 9i Database Administration in 10 Minutes