add a database

[lwangf]

Hi. Does anyone know how to add a database to a machine where there are multi-database sitting there. Do I need to run the oracle installer again?

Thanks!

[marist89]

In 8.1, there is a GUI called dbassist that can help you.

[sreddy]

NT or Unix ? You can use GUI tools database assistant(NT)/dbassist on unix. OTHERWISE

Unix: Straight forward

step-1: set $oracle_sid and $oracle_home
step-2: run the create database script.

NT: Couple of more steps to start service names

step-1) C:\> oradim -new -sid xxxx -initpwd ***** -stratmode manual -pfile c:\xx\zz\pfile\initxxxx.ora
step-2) c:\>set ORACLE_SID=xxxx to make it default
step-3) Modify Oracle provided script build_db.sql from O_H/rdbms/admin location with your own configuration and run it from server manager.(check for service you created in step-1 is running. If not start it using 'net start oracleservicexxxx' )

thats about it.

[Edited by sreddy on 01-19-2001 at 01:07 PM]