Installation guide
12
To create an instance, use a command similar to the following command:
$ srvctl add instance -d 10gdb -i 10gdb1 -n pl-adc.amd15
4. Set the ORACLE_SID environment variable for one of the database instances
in the environment.
For the Bash or Korn shell:
$ ORACLE_SID=10gdb1; export ORACLE_SID
For the C shell:
% setenv ORACLE_SID 10gdb1
5. Export the server parameter file (SPFILE) to a text initialization parameter
file as follows:
SQL> CREATE PFILE = '$ORACLE_HOME/dbs/init10gdb1.ora' FROM SPFILE =
'/dev/raw/raw2';
6. Edit the text initialization parameter file to update path names to point to the
Linux x86-64 Oracle home directory along with any other required changes.
Then re-create the SPFILE as follows:
SQL> CREATE SPFILE = '/dev/raw/raw2' FROM PFILE =
'$ORACLE_HOME/dbs/init10gdb1.ora';
7. Directories listed in the SPFILE must exist before you start the database.
Create these directories, ensuring that they have write permissions for the
oracle user and dba groups.
8. Add a listener name for the database that listens on all cluster nodes to the
$ORACLE_HOME/network/admin/tnsnames.ora file. Also add an entry
for each instance. The following is an example of the entries:
LISTENERS_10gdb.US.ORACLE.COM =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = server1-vip) (PORT = 1521)
(ADDRESS = (PROTOCOL = TCP) (HOST = server2-vip) (PORT = 1521)
LISTENERS_10gdb1.US.ORACLE.COM =
(ADDRESS = (PROTOCOL = TCP) (HOST = server1-vip) (PORT = 1521)
LISTENERS_10gdb2.US.ORACLE.COM =
(ADDRESS = (PROTOCOL = TCP) (HOST = server2-vip) (PORT = 1521)
9. Create the password file using the orapwd utility. Use a command similar to
the following:
$ orapwd file=$ORACLE_HOME/dbs/orapwd10gdb1 entries=10 password=manager
10. Start the database without mounting it, using SQL commands similar to the
following where lnx_x86-64_path is the location of the Linux x86-64
Oracle home:
SQL> STARTUP NOMOUNT;
CREATE CONTROLFILE REUSE DATABASE "SAMPLE" NORESETLOGS
MAXLOGFILES 32
Note: If the cluster database does not start in EXCLIUSIVE MODE,
mark all the entries with cluster-database as comments in the SPFILE.