Re: Ora 10.2.0.1, Error ORA-12514

From: Arch <send.no_at_spam.net>
Date: Mon, 03 Mar 2008 02:01:33 GMT
Message-ID: <qdmms357m6a0v7vc904aaviah269vdb2dc@4ax.com>


On Sun, 02 Mar 2008 23:24:00 GMT, "Ana C. Dent" <anacedent_at_hotmail.com> wrote:

>PCarrilho <carrilho.paulo_at_gmail.com> wrote in news:ecc1f4ad-3199-46f2-8d4f-
>016b7051f9f5_at_i12g2000prf.googlegroups.com:
>
>> Hi,
>>
>> perhaps the error which I'm issuing is well known by you. I'm new
>> about DB Administration.
>>
>> I'm trying to install an Oracle Database version 10.2.0.1, Standard
>> Edition, on a XP SP2 Professional OS based machine.
>>
>> The installation process was successful, however when I try to connect
>> to the Database I get this error:
>>
>> (SQLPlus)
>>
>> SQL> CONNECT SYS/SADMIN_at_siebel AS SYSDBA
>> ERROR:
>> ORA-12514: TNS:listener does not currently know of service requested
>> in connect descriptor
>>
>> I've already "googled" it, with no satisfactory conclusion.
>>
>> These are my Database configuration files:
>>
>> ############
>> listener.ora:
>> ############
>>
>> # listener.ora Network Configuration File: D:\oracle\product
>> \10.2.0\db_1\network\admin\listener.ora
>> # Generated by Oracle configuration tools.
>>
>> SID_LIST_LISTENER =
>> (SID_LIST =
>> (SID_DESC =
>> (SID_NAME = PLSExtProc)
>> (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
>> (PROGRAM = extproc)
>> )
>> )
>>
>> LISTENER =
>> (DESCRIPTION_LIST =
>> (DESCRIPTION =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
>> )
>> )
>>
>>
>> ############
>> tnsnames.ora:
>> ############
>>
>> # tnsnames.ora Network Configuration File: D:\oracle\product
>> \10.2.0\db_1\network\admin\tnsnames.ora
>> # Generated by Oracle configuration tools.
>>
>> SIEBEL =
>> (DESCRIPTION =
>> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
>> (CONNECT_DATA =
>> (SERVER = DEDICATED)
>> (SERVICE_NAME = siebel)
>> )
>> )
>>
>> EXTPROC_CONNECTION_DATA =
>> (DESCRIPTION =
>> (ADDRESS_LIST =
>> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
>> )
>> (CONNECT_DATA =
>> (SID = PLSExtProc)
>> (PRESENTATION = RO)
>> )
>> )
>>
>>
>> ############
>> sqlnet.ora:
>> ############
>>
>> # sqlnet.ora Network Configuration File: D:\oracle\product
>> \10.2.0\db_1\network\admin\sqlnet.ora
>> # Generated by Oracle configuration tools.
>>
>> # This file is actually generated by netca. But if customers choose
>> to
>> # install "Software Only", this file wont exist and without the
>> native
>> # authentication, they will not be able to connect to the database on
>> NT.
>>
>> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>>
>> NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
>>
>> ########################################################################
>>
>>
>> The listener.log:
>>
>> ...
>> TNS-12514: TNS:listener does not currently know of service requested
>> in connect descriptor
>> 02-MAR-2008 22:38:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)
>> (USER=))(SERVICE_NAME=siebel)) * (ADDRESS=(PROTOCOL=tcp)
>> (HOST=127.0.0.1)(PORT=2497)) * establish * siebel * 12514
>> TNS-12514: TNS:listener does not currently know of service requested
>> in connect descriptor
>> 02-MAR-2008 22:38:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)
>> (USER=))(SERVICE_NAME=siebel)) * (ADDRESS=(PROTOCOL=tcp)
>> (HOST=127.0.0.1)(PORT=2499)) * establish * siebel * 12514
>> TNS-12514: TNS:listener does not currently know of service requested
>> in connect descriptor
>> 02-MAR-2008 22:38:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)
>> (USER=))(SERVICE_NAME=siebel)) * (ADDRESS=(PROTOCOL=tcp)
>> (HOST=127.0.0.1)(PORT=2500)) * establish * siebel * 12514
>> TNS-12514: TNS:listener does not currently know of service requested
>> in connect descriptor
>>
>>
>> which is always increasing with same messages.
>>
>>
>> Might you help me, please? What did I make wrong?
>>
>> The database should is named as SIEBEL.
>>
>> PS: I've 4 services running: OracleServiceSIEBEL,
>> OracleOraDb10g_home1TNSListener, OracleOraDb10g_home1iSQL*Plus,
>> OracleDBConsolesiebel
>>
>>
>
>I see two different areas which have me concerned.
>1) (HOST = localhost)
>I have always used a host name which resolves to a valid IP# or a valid IP#
>
>2) SQLNET.AUTHENTICATION_SERVICES= (NTS)
>This has caused many, many previous problems. Comment it out is my advice.
>If you comment it out then stop & start listener again
>
>
>use CUT & PASTE to show output from 2 following commands
>lsnrctl status
>lsnrctl service
>
>
>12514, 00000, "TNS:listener does not currently know of service requested in
>connect descriptor"
>// *Cause: The listener received a request to establish a connection to a
>// database or other service. The connect descriptor received by the
>listener
>// specified a service name for a service (usually a database service)
>// that either has not yet dynamically registered with the listener or has
>// not been statically configured for the listener. This may be a
>temporary
>// condition such as after the listener has started, but before the
>database
>// instance has registered with the listener.
>// *Action:
>// - Wait a moment and try to connect a second time.
>// - Check which services are currently known by the listener by
>executing:
>// lsnrctl services <listener name>
>// - Check that the SERVICE_NAME parameter in the connect descriptor of
>the
>// net service name used specifies a service known by the listener.
>// - If an easy connect naming connect identifier was used, check that
>// the service name specified is a service known by the listener.
>// - Check for an event in the listener.log file.

If the suggestions from Ana don't help you, I have one. I have been seeing a great deal of this exact problem with 10.2.0.x. It was not a problem with previous versions.

I use this solution only as a last resort, since the service is supposed to automatically register itself with the listener on startup. But, if you can't otherwise make it work, I have found that manually configuring the service with the listener almost always works.

Change your listener.ora like this:

 # listener.ora Network Configuration File: D:\oracle\product
 #  \10.2.0\db_1\network\admin\listener.ora
 # Generated by Oracle configuration tools.
 

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)

    )
    (SID_DESC =
      (SID_NAME = SIEBEL)
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      (SERVICE_DBNAME=SIEBEL)

    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))     )
  )  

Stop and restart the listener. I think you'll find this will make it work.

Hope this helps,

  • Arch
Received on Sun Mar 02 2008 - 20:01:33 CST

Original text of this message