Re: Ora 10.2.0.1, Error ORA-12514

From: PCarrilho <carrilho.paulo_at_gmail.com>
Date: Mon, 3 Mar 2008 11:44:16 -0800 (PST)
Message-ID: <508beaa9-cbaa-473e-9408-67cfd6af3446@e23g2000prf.googlegroups.com>


On 2 Mar, 23:24, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> PCarrilho <carrilho.pa..._at_gmail.com> wrote in news:ecc1f4ad-3199-46f2-8d4f-
> 016b7051f..._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.- Ocultar texto citado -
>
> - Mostrar texto citado -

Hi there,

many thanks it just works. Meanhile, the data you requested:

D:\oracle\product\10.2.0\db_1\BIN>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03- MAR-2008 19:39
:28

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ALPHA) (PORT=1521)))
STATUS of the LISTENER


Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version
10.2.0.1.0 - Produ
ction
Start Date                03-MAR-2008 19:28:30
Uptime                    0 days 0 hr. 10 min. 58 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF

Listener Parameter File D:\oracle\product\10.2.0\db_1\network\admin \listener.o
ra
Listener Log File D:\oracle\product\10.2.0\db_1\network\log \listener.log

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ALPHA)(PORT=1521))) Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "siebel" has 1 instance(s).
  Instance "siebel", status READY, has 1 handler(s) for this service...
Service "siebelXDB" has 1 instance(s).
  Instance "siebel", status READY, has 1 handler(s) for this service...
Service "siebel_XPT" has 1 instance(s).
  Instance "siebel", status READY, has 1 handler(s) for this service...
The command completed successfully

D:\oracle\product\10.2.0\db_1\BIN>lsnrctl service

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03- MAR-2008 19:40
:46

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ALPHA) (PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:0 refused:0
         LOCAL SERVER

Service "siebel" has 1 instance(s).
  Instance "siebel", status READY, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:32 refused:0 state:ready
         LOCAL SERVER

Service "siebelXDB" has 1 instance(s).
  Instance "siebel", status READY, has 1 handler(s) for this service...

    Handler(s):

      "D000" established:0 refused:0 current:0 max:1002 state:ready
         DISPATCHER <machine: ALPHA, pid: 2636>
         (ADDRESS=(PROTOCOL=tcp)(HOST=ALPHA)(PORT=2194))
Service "siebel_XPT" has 1 instance(s).
  Instance "siebel", status READY, has 1 handler(s) for this service...

    Handler(s):

      "DEDICATED" established:32 refused:0 state:ready
         LOCAL SERVER

**********************************************************************
**********************************************************************

It the Enterprise Manager webpage (I'm using it to manage the DB), I've the following message in the top of the page:

Error

java.lang.Exception: Number of responses does not match queries

This message comes out at the Home Page of the Manager of "Database Instance: siebel", I'm logged with the user SYS.

Even though is everything ok?

Best Regards,
And Thank You one more time Received on Mon Mar 03 2008 - 13:44:16 CST

Original text of this message