Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Posts
    1

    Error while trying to retrieve text for error ORA-12514

    Hi,

    I'm trying to connect an oracle database from C++.When i use the

    env = Environment::createEnvironment("UTF8","UTF8");

    it is not connecting to Oracle database.It is giving error like
    "Error while trying to retrieve text for error ORA-12514 ".
    by using the same code i can able to connect some other database.I hope there is an problem with database only,Expeciay with the Listener.So Kindly help me out to solve the problem.

    may be some problem with the Listener i think so.Some of the things i tried in oracle May it will usefull to Know What my problem is?


    [root@localhost oracle]# lsnrctl services XE

    LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-OCT-2010 15:27:46

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhos t.localdomain)(PORT=1521))(CONNECT_DATA=(SERVER=DE DICATED)(SERVICE_NAME=XE)))
    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 "XE1" has 1 instance(s).
    Instance "XE", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0 state:ready
    LOCAL SERVER
    Service "XE1_XPT" has 1 instance(s).
    Instance "XE", status READY, has 1 handler(s) for this service...
    Handler(s):
    "DEDICATED" established:0 refused:0 state:ready
    LOCAL SERVER
    Service "XEXDB" has 1 instance(s).
    Instance "XE", status READY, has 1 handler(s) for this service...
    Handler(s):
    "D000" established:0 refused:0 current:0 max:972 state:ready
    DISPATCHER <machine: localhost.localdomain, pid: 24751>
    (ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain )(PORT=57599))
    The command completed successfully



    [root@localhost oracle]# lsnrctl status

    LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 06-OCT-2010 17:03:50

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_F OR_XE)))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER
    Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
    Start Date 06-OCT-2010 16:53:38
    Uptime 0 days 0 hr. 10 min. 12 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP OFF
    Default Service XE
    Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
    Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_F OR_XE)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhos t.localdomain)(PORT=1521)))
    Services Summary...
    Service "PLSExtProc" has 1 instance(s).
    Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Service "XE1" has 1 instance(s).
    Instance "XE", status READY, has 1 handler(s) for this service...
    Service "XE1_XPT" has 1 instance(s).
    Instance "XE", status READY, has 1 handler(s) for this service...
    Service "XEXDB" has 1 instance(s).
    Instance "XE", status READY, has 1 handler(s) for this service...
    The command completed successfully


    if possible mail me to the below address..

    Thanks in advance.
    Regards,
    Srinidhi.B
    srinidhpatel@gmail.com

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,647
    Code:
    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.
    It is NOT clear to this reader exactly how many different systems exist & what resides on each.

    It would be helpful if you posted the actual command that produced the posted error.

    Contrary to what some may think ORACLE_SID is CaseSensitive.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •