DATABASE CONFIGURATION ASSISTANTNOTE THAT THE THIRD PART OF THE PAT...

5. Database Configuration AssistantNote that the third part of the path will vary, depending on the name given to the Oracle Home at install time.To launch the DBCA on Linux, first set the environment variables that should always be set for any Linux DBA session: ORACLE_BASE, ORACLE_HOME, PATH, and LD_LIBRARY_PATH. This is an example of a script that will do this:

export ORACLE_BASE=/u02/app/db11g

export ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

Note that the Base and Home will vary according to choices made at install time. To launch the DBCA, run the dbca shell script, located in the $ORACLE_HOME/bin directory.TIP Be sure to have the $ORACLE_HOME/bin directory at the start of your search path, in case there are any Linux executables with the same name as Oracle executables. A well-known case in point is rman, which is both an Oracle tool and a SUSE Linux utility.Remember that (with one exception) every choice made at database creation time PART Ican be changed later, but that some changes are awkward and may involve downtime. It is not therefore vital to get everything right—but the more right it can be, the better.If the database to be created is going to use Enterprise Manager Database Control, there is an additional step that should be carried out before launching the DBCA: configuring a database listener. This requirement is because Database Control always connects to its database through a listener, and the DBCA checks whether one is available. The configuration is a simple task, described in detail in Chapter 4. For now, do this with the Net Configuration Assistant, accepting defaults all the way.To launch the Net Configuration Assistant on Windows, take the shortcut on the Start menu. The navigation path will be