Re: Trouble creating second db

From: Marty Phee <martyphee_at_no_spmmm_earthlink.net>
Date: Wed, 10 Apr 2002 17:02:12 GMT
Message-ID: <oe_s8.5175$3P4.454631@newsread2.prod.itd.earthlink.net>

Thanks, that worked.

Today I have a new problem. oradim wouldn't create the pfile...

oradim -new -sid pipeprod
pfile="e:\oracle\admin\pipeprod\pfile\initPipeProd.oar"

And no pfile or directory.

I did work around it by using the db assistant to copy the files, and then before I clicked on abort I copied the directories. Now I'm running the scripts manually.

thanks for your help,

marty

Murali wrote:

> 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 - 12:02:12 CDT