How to create a new instance in AIX?

Can some tell me how to create a second instance on AIX ?. I already have
one instance running need to create second one. I used to use oradim73.exe
on NT to create new instance. Is there a similar utility on UNIX ?.

Ans1:

Nope, you have to do it the 'hard' way
steps
- decide the SID
- edit /etc/oratab, adding the SID in format
SID $ORACLE_HOME directory autostart y/n
- run . oraenv, making sure $ORACLE_SID and $ORACLE_HOME are correct
- copy $ORACLE_HOME/dbs/init<oldsid>.ora to $ORACLE_HOME/dbs/init<newsid>.ora
- do the same with .../config<oldsid>.ora if you have one
- change the db_name (in the latter file if you have one) and the location of
control_files
(Make sure you use @ to refer to the SID and ? to refer to Oracle_home as much
as possible)
- write a create database script
- run svrmgrl and within svrmgrl the following
connect internal
startup nomount
spool anything
@<create database script>
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
@$ORACLE_HOME/rdbms/admin/catexp.sql
exit

This should be basically it.

Hth,

Sybrand Bakker, Oracle DBA

Ans2:

The previous message might be right as I've never used AIX. So this may be
totally off the mark.

On solaris you can use Oracle installer to create any number of instances. The
problem is the installer is a bit confusing. You have to (or at least go
through the process of) re-installing Oracle. Select that you want to create a
new database and then install Oracle 8 again. The new instance will be created
for you. Oracle 8 will not be re-installed.

Ans3:

There is a much easier way to create an instance in oracle on AIX. Go back
into the oracle installer (orainst.exe) and create an object. I normally
set a new ORACLE_SID parameter and delete all the old install log files
before going into the installer program.

Hosted by www.Geocities.ws