Re: Multiple instances on one DB

I am only new too, I have 2 weeks oracle experience, correct me if I am wrong.
make sure in listener.ora file your 2 sids in SID_LIST_LISTENER() after you startup the oppm. disconnect and try to connect to tism eg
>connect internal_at_tismInterface (where tismInterface is the interface you created with sql easy config)
supply the password then try to startup with pfile=initFile command eg startup pfile=c:\orant\inittism.ora

I 've done all this under nt hope it is the same for unix.

oh, to make sure that you actually listening to 2 sid start up lsnrctl programs and type status it should list your 2 sid if not your listerner is not working.

goodluck
"Nebojsa Petrovic" <nebacar_at_eunet.yu> wrote:

>Hello,
>
>
>I have Installed Oracle 7.3.2. on IBM unix (AIX) and I have
>two databases (oppm and tism) on one computer. I configured
>listener with two instances.
>
>I want create two instances, oppm and tism, one for each
>database which will running together in the same time.
>How can I do it?
>
>
>I start Server manager and connect as internal and startup
>instance and open db oppm without any problems. After that
>when I want create instance tism, Server manager respond to
>me that I must first shutdown oracle !?
>
>
>In book Oracle Parallel Server (OPS) I founded about one
>database and multiple instance. But I don't want it. I want
>one instance on one database but more databases on one
>Oracle.
>
>
>
>Thanks, Nebojsa
>
>nebacar_at_eunet.yu
>
>
>
Received on Mon Jul 13 1998 - 01:42:02 CDT