Error-ORA-12560

[RajeshSingh]

I wants to create database manaually. I have oracle8i(8.1.5.0.0) and win2000 professional version.The steps i have taken are as follows.

1)Prepare O/S by creating the directory like udump,bdump, control for control file etc.
2) Prepare initialization parameter file.
3)prepare password file.
4)Create service through oradim utility.

After successfull completion of these steps when i was trying to start the instance by giving the statement conn sys\password (as specified in passwordfile) as sysdba in sql prompt a error was occured.The error code and message is given below.

ORA-12560: TNS:PROTOCOL ADAPTER ERROR

Pls give kind attention to this problem.
Thanks
RAJESH

[adewri]

Originally posted by RajeshSingh
I wants to create database manaually. I have oracle8i(8.1.5.0.0) and win2000 professional version.The steps i have taken are as follows.

1)Prepare O/S by creating the directory like udump,bdump, control for control file etc.
2) Prepare initialization parameter file.
3)prepare password file.
4)Create service through oradim utility.

After successfull completion of these steps when i was trying to start the instance by giving the statement conn sys\password (as specified in passwordfile) as sysdba in sql prompt a error was occured.The error code and message is given below.

ORA-12560: TNS:PROTOCOL ADAPTER ERROR

Pls give kind attention to this problem.
Thanks
RAJESH

o check your service is up.
o set ORACLE_SID.

[Alchemy]

Try this:
c:>set oracle_sid = name
c:>sqlplus /nolog
sql>connect username/password
sql>from here you would either type the create command or run all creation scripts you might have.

[RajeshSingh]

It is still not working and same error and message occured.
Pls tell me all other necessary environment variables setting in win2k for manaually database creation.

[mzahid]

Verify ORACLE_SID entry in registry.
Do you have multiple Oracle instances on this system?
If yes, then please remove old entries from the registry.
If problem still exist then try using database alias specified for this instance in tnsnames.ora file.

Hope this helps.

[abhaysk]

I wonder if your Service is started
Check the status from below code...

Net Start | Find "OracleService"

If it returns the service then the service is up and running else no..

Abhay.

[vishal sood]

Try TNSPING