| svrmgrl error [message #70918] |
Tue, 13 August 2002 19:12  |
tiger
Messages: 11
Registered: August 2002
|
Junior Member |
|
|
I installed Oracle 8.1.7. on Windows 2000. Then I tried to create an instance 'TESTDB' by running the following command:
set ORACLE_SID=TESTDB
oradim -new -sid TESTDB -intpwd oracle -startmode manual -pfile "E:TESTDBpfileinitTESTDB.ora"
I can tell from windows service that the instance was created and started. I also manually started listener. Then I tried to get into svrmgrl to create a database by typing > svrmgrl. I got the following error:
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
ORA-12560: TNS:protocol adapter error
SVRMGR>
Would any of you please help on this?
|
|
|
|
| Re: svrmgrl error [message #70921 is a reply to message #70918] |
Wed, 14 August 2002 09:40  |
denny
Messages: 9
Registered: August 2002
|
Junior Member |
|
|
Tiger
my experience has been that setting the SID through
command line prompt doesn't always change the SID
in the registry(i.e c:>set ORACLE_SID = "TestDB")
Try these 2 things:
c:> set ORACLE_SID = "TESTDB" (enclose in quotes)
or
go to the registry and change the SID in the
Oracle > HOMEO directory under HK_Local_Machine.
whatever Oracle Folder you find the Oracle_SID listed
you will see it on the right side of the registry. Highlight it > right click > modify > TESTDB
denny
|
|
|
|
|
|
| Re: svrmgrl error [message #70928 is a reply to message #70925] |
Thu, 15 August 2002 05:15 |
denny
Messages: 9
Registered: August 2002
|
Junior Member |
|
|
go to the Oracle Folder in the registry
HK_Local_Machine > Software > Oracle > SubFolders
look through each of these Folders to find which one
contains the ORACLE_SID reference.
(on my machine it's HOMEO, on yours it may be a
different folder)
If after looking through all the subfolders you find
no Oracle_SID then that is why you cannot connect
and get the 'Protocol Adapter Error'.
Let me know if you don't find the SID in the registry.
There is link that has a script to create the
SID in the registry...it will create it as "xxx" then
you can go in and change it to the correct SID name.
denny
|
|
|
|
|
|
| Re: svrmgrl error [message #70941 is a reply to message #70918] |
Fri, 16 August 2002 19:12 |
sunil bhola
Messages: 58
Registered: July 2002
|
Member |
|
|
first type
oradim -new -sid TESTDB -intpwd oracle -startmode manual -pfile "E:TESTDBpfileinitTESTDB.ora"
then
set oracle_sid=testdb
and then start the svrmgrl to pervent from the error ORA-12560: TNS:protocol adapter error
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
