Starting a second instance

[dohanlon]

Hi Folks,
I am just new to Oracle and could use some help with the following. I have created a new instance called ecms2 and I want only one user to access this. I have added the following to their .profile (I am running Oracle on HP-UX):
PATH=$PATH:/oracle/orasw/bin
export PATH
ORACLE_HOME=/oracle/orasw
export ORACLE_HOME
ORACLE_SID=ecms2
export ORACLE_SID
ORAENV_ASK=NO

Now, my question is, how do I start this instance so that this user can run sqlplus.
Thanks for your time/help.
dohanlon.

 

[lfoata]

Loggin as user oracle,
set ORACLE_SID
start server manager : svrmgrl
connect internal
startup (pfile=initSID.ora is optionnal)

You also will have to start a seconf listener or modify the existing one to listen for taht new instance.
To modify the existing one, modify listener.ora to add the new instance.
To add a listener, create a listener.ora (or copy the other one) in a different location and modify for the new instance. Set TNS_ADMIN to the directory containing the new listener.ora and then do : lsnrctl start