Please can anyone help me. I'm facing the task of putting a second database next to a production database.
I'm familiar with this on a NT-platform, but not on a Novell-platform.
I am intending to:
Add a new SID name to the listener in LISTENER.ORA.
Setup a new service name in TNSNAMES.ORA that uses the IPC protocol.
Create a new parameter file in the ORACLE_HOME\DATABASE directory of the form initSID.ora.
making sure that the control_file parameter specifies a new control file name, and the db_name points to the newdatabase name.
Start Server Manager
LOAD SVRMGR
Connect as INTERNAL.
SVRMGR>CONNECT INTERNAL/
Start up the database with the new instance:
SVRMGR>STARTUP PFILE=%ORACLE_HOME%DATABASE\INITSID.ORA
And then running the necesarry scripts.
If this is not the correct procedure, please help me.
I'd appreciate any help.
Thnx in advance.
