Re: Help on multi-Instance on a server

To create a second instance on NT:

1. Copy init[sid].ora file to init[new_sid].ora
2. Change the following in init[new_sid].ora db_name=[new database name] control_files=[new_control file] * very important to change this*
3. Go to instance manager (Not the OEM version) and press new button change name of database. Set password.
4. From DOS prompt type SET ORACLE_SID=[new_sid]
5. SVRMGR23 connect internal/ password
6. Startup pfile=init[new_sid].ora
7. Edit LISTENER.ORA to reflect [new_sid]
8. LSNRCTL STOP
9. LSNRCTL START
10. Edit TNSNAMES.ORA to reflect [new_sid]
11. Create tablespaces, rbs and all other fun stuff.

I did this yesterday and it worked fine. It was preformed on the server not over the network.

John Steinbach

mouyang_at_hotmail.com wrote:

> Hi,
> I used NT instance manager create an instance and database, and the
> serveice of that can start but I cannot start up the instance. How
> should I do?
> And , after setting the sql*net, I cannot conect to the new instance,
> it tells me "tns:listener could not resolve SID given...", I think
> I hvae set the SID in sql*net conf rightly. What's the reason?
> Thanks for any help.
>
> Ming Ouyang
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
Received on Thu Oct 16 1997 - 00:00:00 CDT