Ive recently installed Oracle 10g on my Windows XP and was able to connect. When i did a shutdown immediate and tried to connect again as a sysdba i get an error:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Did a few basic checks like Oracle services, listener and all seems up and running. As im studyin Oracle 10g currently, please explain me in simple language meand guide to what i should do to resolve this problem. Any help is much appreciated!
Below is my TNS, listener details for your reference
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
OK let me try
There is a process, called listener out of the database. It is responcible for getting u connected to the database. When the listener does not knows of about the database because it is down or still have not registered to it, the listener cannot connect u
On the other hand, when logged at the machine where the DB is installed, and u use SQL Plus to
conn / as sysdba
the listener is not used for connecting u. SQL PLus by itself gets to the oracle home directory and does what's necessary
However, if U use
conn sys/password@string as sysdba
the @string part points u to the listener and since listener do not knows of your database, the conn fails
iSQL plus allways goes trough the listener so no chance to pass trough SQL plus
I hope I have not missed many things and described it in a way u can understand