ORA-12560: TNS:protocol adapter error"

I have 2 Oracle Instances on my host.
I want to install another instance using database config assistant.
During install it return a error:ORA-12560: TNS:protocol adapter error"

How can i resolv this error?
OS:2000
Version Oracle:8.1.7.0.0

Bensmail

Use your dbassist to create the database creation script and then run the scripts manually one by one to see exactly where the error is comming

HTH

Quote:

---

Originally posted by bensmail
I have 2 Oracle Instances on my host.
I want to install another instance using database config assistant.
During install it return a error:ORA-12560: TNS:protocol adapter error"

How can i resolv this error?
OS:2000
Version Oracle:8.1.7.0.0

Bensmail

---

set the registry value to the instance name u want to create.

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME...under this path u have a string value called ORACLE_SID....set this to the instance name u want to create.

then use DB config assist to create DB.

Abhay.

In the registry i h've ORACLE_SIDs of other Oracle homes.
How and where can i add other ORACLE_SID Key on Registry?


Bensmail

u have edit the Oracle_Sid to ur instance name under which oracle home u r creating ur DB.

say u have 2 homes...
1 for 7i series and other for 8i series...
then u wanted to create DB in 8i and presntly u have 1 instance running ... the Oracle_Sid under 8i home wud be the instance name of the running DB....u need to change this to the instance name u wish to create.....

this is required coz it makes the defualt instance as the name specified in registry....and DB assist dosent use connect string...so is required to make the changes...

u cud also achive this by chaging in environment variables to the SID name u wanted to create.

Abhay.

Quote:

---

Originally posted by abhaysk
u have edit the Oracle_Sid to ur instance name under which oracle home u r creating ur DB.

say u have 2 homes...
1 for 7i series and other for 8i series...
then u wanted to create DB in 8i and presntly u have 1 instance running ... the Oracle_Sid under 8i home wud be the instance name of the running DB....u need to change this to the instance name u wish to create.....

this is required coz it makes the defualt instance as the name specified in registry....and DB assist dosent use connect string...so is required to make the changes...

u cud also achive this by chaging in environment variables to the SID name u wanted to create.

Abhay.

---

The first step that dbassist does while creating the database is

set ORACLE_SID=SID_NAME

so it is not required to set the ORACLE_SID before database creation if you are using dbassist

Quote:

---

Originally posted by adewri
The first step that dbassist does while creating the database is

set ORACLE_SID=SID_NAME

so it is not required to set the ORACLE_SID before database creation if you are using dbassist

---

Thas correct Amar...i did face same kinda probs while creating DB using DB assist and when i changed registry value it worked..

rather environmental variables will also do....

some times windows sucks.

Abhay.