A Quick Guide To Creating An Oracle Database

Environment

• SuSE Linux 8.0 Professional Edition
• Kernel 2.4.18-4GB
• Oracle 9i Release 2 Enterprise Edition

Assumptions

• Your ORACLE_HOME is /u01/oracle/OraHome1
• Your ORACLE_SID is TEST
• The database name is TEST
• You have the following directory structure in place for this example, modify as you wish
  • /u01/oracle/OraHome1/admin/TEST/bdump
  • /u01/oracle/OraHome1/admin/TEST/cdump
  • /u01/oracle/OraHome1/admin/TEST/udump
  • /u02/oracle/archives/TEST
  • /u03/oracle/archives/TEST
  • /u01/oracle/dbs/TEST
  • /u03/oracle/dbs/TEST
  • /u02/oracle/dbs/TEST/redo
  • /u04/oracle/dbs/TEST/redo
• These may be created as: mkdir -p /u02/oracle/dbs/TEST/redo for example

GUI Tools

• Database Configuration Assistant $ORACLE_BIN/dbca
  
• and Network Configuration Assistant $ORACLE_BIN/netca
  
• If you are under a MicroSoft Windows Environment these tools are in your start menu...
  
  • Database Configuration Assistant
    
    
  
  
  • Network Configuration Assistant
    
    

1. Set your Oracle Home directory appropriately
2. Set your ORACLE_SID as you would need to
3. Here is a sample initTEST.ora
4. You will alse need a password file: $ORACLE_HOME/dbs/orapwTEST
   • To Create: orapwd file=$ORACLE_HOME/dbs/orapwTEST password=CHANGE_ON_INSTALL entries=10

1. cd $ORACLE_HOME/dbs
2. In another session, "spool $ORACLE_HOME/admin/TEST/bdump/alert_TEST.log
3. sqlplus "/ as sysdba"
4. SQL> startup nomount pfile=initTEST.ora
5. SQL> @CreateDB.sql

1. This script CreateDBCatalog.sql would create the database data dictionary and other vital structures

• Oracle's Network Configuration Tool... $ORACLE_BIN/netca ... or .... Look at the example files below....
  

1. Server Side....
   • $ORACLE_HOME/network/admin/sqlnet.ora
   • $ORACLE_HOME/network/admin/listener.ora
2. Client Side....
   • $ORACLE_HOME/network/admin/sqlnet.ora
   • $ORACLE_HOME/network/admin/tnsnames.ora