Re: Ora 10.2.0.1, Error ORA-12514

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 02 Mar 2008 23:24:00 GMT
Message-ID: <kGGyj.59352$ov5.31324@newsfe15.phx>


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.
Received on Sun Mar 02 2008 - 17:24:00 CST

Original text of this message