ORA-12560: TNS protocol adapter error in oracle 8i
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!!!
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
idle instance started
then i wrote:-
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