ORA-12560: TNS protocol adapter error in oracle 8i

[nitin garg]

Hello

I am a beginner in oracle ...i installed oracle 8i on win xp(128 mb RAM).I connected to Oracle for the first time using username:scott and password:tiger .but now when i try to connect to oracle using same password/username, it displays mme the following error:-

ORA-12560: TNS protocol adapter error

Please tell me as to what to do??? I will be really thankful to you...Please help me!!!

Nitin

[davey23uk]

you need to start the service (or create a database if you havent done so already)

[Tarry]

If you're a beginner and living in 2005, Try starting with atleast version 9i. There's already a version 10G Release 2 BTW.

For connections as Davey said
do
--tnsping database name

[dbarajib]

hi if u are facing that problem then just create a database or start the oracle database service... the problem is related to your database.....

and most probably u have not created the database...

so create it...

[nitin garg]

Hello

Thanks everybody for ur reply!!! I connected to oracle 8i through the following steps:(from command prompt)-

sqlplus>connect sys/change_on_install as sysdba

it displayed:-

idle instance started

then i wrote:-

startup

and through this , instance got started and i was able to work in sql*plus editor...........but i want to ask whether i have to do this every time i want to connect to Oracle??? Is not there a way out by which instance gets automatically started...do i need to make any change in registry???
actually when i tried to connect to Oracle(via 'scott/tiger' combination) after turning my PC on....it displayed me the following error:-

ORA-01034:ORACLE not available

that's when i tried to connect to Oracle thru command prompt via "sys/change_on_install" combination in sysdba mode(as described above in this post) and it was successful attempt.

so please tell me how will this instance get started automatically???
thanx once again

Nitin

[davey23uk]

just set the service to start automatically from control panel -> services

[dbarajib]

first go to services option from controlpanel-->administrative tools

then right click on the database service what u r concern...

then change the value of startup from manual to automatic ....

and now enjoy .....

[nitin garg]

I did wat u said...but when i restarted my PC and tried to cnnect to Oracle(via scott/tiger combination), it again displayed me:-

ORA-01034:ORACLE not available

and moreover in the services section in control panel...i changed from manual to automatic but then its status is always "starting" and not "started"....even when i have connected to oracle through:

sqlplus>connect sys/password as sysdba
startup

so my problem is not solved....

nitin

[Aljaz]

What is the content of sqlnet.ora file?

[mrchrispy]

As Tarry said, 8i is soooo 1990's.
you'll be better served learning 10g .