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
You are right in saying that: But what is the solution to this issue and I get an error when i connect to the web iSQL plus - i do get the same error-
ERROR - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Results below from command prmpt:
=======================================
SQL> conn / as sysdba
Connected.
SQL> exit
Disconnected from Oracle Database 10g Release 10.2.0.1.0 - Production
C:\Documents and Settings\Nitesh>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 13 15:44:01 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys@orcl as sysdba
Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
==========================================
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.
If you try to explain me may be i will understand then. I know i cannot connect to isql plus when its shutdown. The error i get is when im connected not when im not??
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