Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Trouble creating second db

Re: Trouble creating second db

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 10 Apr 2002 23:37:52 +0200
Message-ID: <vfs8bugle95g7hs4o9jk0533fq1lt6fg65@4ax.com>


On 10 Apr 2002 08:11:01 -0700, oraclems_at_hotmail.com (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

According to Metalink this has been acknowledged as a bug and been resolved in 9i

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Apr 10 2002 - 16:37:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US