Re: Trouble creating second db

Marty Phee <martyphee_at_no_spmmm_earthlink.net> wrote in message news:<jFFs8.3124$3P4.252628_at_newsread2.prod.itd.earthlink.net>...
> They are setup correctly. I can't even connect to the working database
> with svrmgrl. I get the same 12560.
>
> I'm able to create an instance using oradim, connect to it with sqlplus,
> and then load it with nomount within sqlplus. But, I still can't connect
> to it with svrmgrl.
>
> >> I'm trying to create a second database instance on the machine with the
> >> "Database Configuration Assistant", but it keeps erroring out with
> >> ora-12560.
> >>
> >> I've tried to set the ORACLE_SID both in the environment, and the
> >> registry but with no luck.
> >>
> >> I don't know what else to try?

Are you connecting to the Windows machine using Terminal Services Client ? This method is unsupported and most of the database assistant programs will fail to work properly. Here's what I do to create a new database over Terminal Services.
Use the database configuration assistant to generate the db creation scripts. Then in the yoursid.bat file add this environment variable before creating the instance and running the sql files - set LOCAL=yoursid

Then run the bat file to create the database. You should also be able to connect to the first database using svrmgrl by setting the variable LOCAL to that instance name.

If you are not using Terminal Services, then I am not sure about the cause of the 12560 error.

Murali Received on Wed Apr 10 2002 - 10:11:01 CDT