CSE Installation and Configuration › Prerequisites for CSE Configuration › Configuring Databases › UNIX with Oracle Database › For Oracle Only... Edit the /etc/oratab file

For Oracle Only... Edit the /etc/oratab file

To start the server databases at system boot time, edit the /etc/oratab file to allow Oracle to recognize the server databases. The server databases are identified through the Oracle System ID (SID). The default SID names are:

• Coordination Server—default = DBDIR
• Encyclopedia Server—default = DBCSE

Follow these steps:

1. Log in as the superuser using the account under which Oracle is installed:

   su <oracleid>
   

   For example, when the account is oracle, use this command:

   su oracle
   

2. Add the SID to the /etc/oratab file as in:

   <ORACLE_SID>:<ORACLE_HOME>:Y
   

   For example, when the Oracle SID is DBCSE, and Oracle home directory is /usr/oracle, use this command:

   DBCSE:/usr/oracle:Y
   

3. Save and close the file.
4. Log out from the Oracle account.
5. Set the following variables that are based on the UNIX shell you use:
   • Bourne Shell or Korn Shell, add the following values to .profile:

     ORACLE_HOME=<value>; export ORACLE_HOME
     PATH=$PATH:$ORACLE_HOME/bin; export PATH
     

   • C Shell, add the following values to .cshrc:

     setenv ORACLE_HOME <value>
     set path=( $path $ORACLE_HOME/bin )