Before a database is created, the UNIX environment must be configured and the Oracle9i server must have already been installed. Four environment variables must be set: ORACLE_HOME, ORACLE_SID, PATH, LD_LIBRARY_PATH. ORACLE_HOME is the full path to the top directory in which the Oracle9i Server is installed. The directory for ORACLE_HOME should be supplied by the person who installed the server, usually the UNIX administrator or the DBA. ORACLE_SID is a user-definable name assigned to an instance of a database. The ORACLE_SID (system identifier) is used by the operating system to distinguish different database instances running on the machine. PATH defines the directories the. | How to Create an Oracle9i Database in a UNIX Environment Introduction Steps to Create a Database There are six steps to creating a useable database: three steps to create the database and three additional steps to make it usable. Set the operating system environment variables ORACLE_HOME, ORACLE_SID, PATH, and LD_LIBRARY_PATH. Edit/Create an parameter file. Execute the CREATE DATABASE command in SQL*Plus. Run the required and scripts. Run the script. Create a tablespace for user data and any other tablespaces that might be required to meet the needs of the database. Note: The contents of this document are written with the assumption that the Oracle9i Server has been installed in an ORACLE_HOME. Installation of the Oracle9i Server is not covered in this appendix. Setting the Environment Before a database is created, the UNIX environment must be configured and the Oracle9i server must have already been installed. Four environment variables | How to Create an Oracle9i Database in a UNIX Environment Introduction Steps to Create a Database There are six steps to creating a useable database: three steps to create the database and three additional steps to make it usable. Set the operating system environment variables ORACLE_HOME, ORACLE_SID, PATH, and LD_LIBRARY_PATH. Edit/Create an parameter file. Execute the CREATE DATABASE command in SQL*Plus. Run the required and scripts. Run the script. Create a tablespace for user data and any other tablespaces that might be required to meet the needs of the database. Note: The contents of this document are written with the assumption that the Oracle9i Server has been installed in an ORACLE_HOME. Installation of the Oracle9i Server is not covered in this appendix. Setting the Environment Before a database is created, the UNIX environment must be configured and the Oracle9i server must have already been installed. Four environment variables must be set: ORACLE_HOME, ORACLE_SID, PATH, LD_LIBRARY_PATH. ORACLE_HOME is the full path to the top directory in which the Oracle9i Server is installed. The directory for ORACLE_HOME should be supplied by the person who installed the server, usually the UNIX administrator or the DBA. ORACLE_SID is a user-definable name assigned to an instance of a database. The ORACLE_SID (system identifier) is used by the operating system to distinguish different database instances running on the machine. PATH defines the directories the operating system searches to find executables, such as SQL*Plus. The Oracle9i executables are located in $ORACLE_HOME/bin and must be added to the PATH variable. LD_LIBRARY_PATH defines the directories in which required library files are stored. Example Bourne or Korn shell: $ ORACLE_HOME=/u01/oracle9i/product/; export ORACLE_HOME $ ORACLE_SID=db01; export ORACLE_SID $ PATH=/usr/bin:/usr/ccs/bin:$ORACLE_HOME/bin; export PATH $ .
