Re: 2nd instance with 7.2 on AIX

Edit the /etc/oratab file, include the new SID, and appropiate ORACLE_HOME (probably the already existing one)
now change your session to the new SID by running . oraenv (the .<space> combination is vital, or it will change in the child process only)
now issue
sqldba
startup nomount

You now should be ready to create the database by issuing a create database statement
(which you should have in a script file) and running $ORACLE_HOME/rdbms/admin/catalog.sql and $ORACLE_HOME/rdbms/admin/catproc.sql

This should be everything

Hth,

Sybrand Bakker, Oracle DBA

yannickk wrote:

> Hello everybody
>
> I have to create a second instance on an AIX server whith Oracle Sever
> 7.2.
> What are the essentials points to check and how configuring the system
> to create the second instance (users, environment variables, ...)
>
> Thanks

Received on Fri Dec 11 1998 - 02:41:19 CST