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!
Printable View
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!
In 8.1, there is a GUI called dbassist that can help you.
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]