3 Replies Latest reply: Feb 13, 2013 4:26 AM by Paul M. RSS

    not able to connect to oracle database 11g from application server10g

    trusha
      Hello,

      I have installed oracle database 11g. We are using forms and report services through application server 10g. I have add required entries in tnsnames.ora file. But I am not able to connect to database. I am getting following error:

      ORA-12514-TNS:listener does not currently know of service requested in connect descriptor

      Please help me.

      Thanks
      Trusha
        • 1. Re: not able to connect to oracle database 11g from application server10g
          Paul M.
          ORA-12514-TNS:listener does not currently know of service requested in connect descriptor
          $ oerr ora 12514
          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.
          $
          Please post tnsnames.ora file from application server and, from database server, the result of "lsnrctl stat".
          • 2. Re: not able to connect to oracle database 11g from application server10g
            trusha
            lsnrctl status...

            oracle@orcl11gd:~> lsnrctl status

            LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 13-FEB-2013 09:16:06

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

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
            Start Date 11-FEB-2013 12:40:23
            Uptime 1 days 20 hr. 35 min. 42 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File /opt/oracle/product/11gR2/db/network/admin/listener.ora
            Listener Log File /opt/oracle/diag/tnslsnr/orcl11gd/listener/alert/log.xml
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl11gd.irma.ac.in)(PORT=1521)))
            Services Summary...
            Service "orcl11gd.irma.ac.in" has 1 instance(s).
            Instance "orcl11gd", status READY, has 1 handler(s) for this service...
            Service "orcl11gdXDB.irma.ac.in" has 1 instance(s).
            Instance "orcl11gd", status READY, has 1 handler(s) for this service...
            The command completed successfully
            oracle@orcl11gd:~>


            tnsnames.ora

            # tnsnames.ora Network Configuration File: /opt/oracle/OraBi/network/admin/tnsnames.ora
            # Generated by Oracle configuration tools.

            REP_ASDEMO_ORABI.IRMA.AC.IN =
            (ADDRESS = (PROTOCOL = tcp)(HOST = asdemo)(PORT = 1950))


            EXTPROC_CONNECTION_DATA =
            (DESCRIPTION =
            (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = asdemo.irma.ac.in)(PORT = 1521))
            )
            (CONNECT_DATA =
            (SERVICE_NAME = PLSExtProc)
            )
            )

            ORCLDEMO =
                 (DESCRIPTION =
                      (ADDRESS_LIST =
                           (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.11.80)(PORT = 1521))
                      )
                      (CONNECT_DATA =
                           (SERVICE_NAME = ORCLDEMO)
                           (SERVER = DEDICATED)
                      )
                 )
            ORCL11GD =
                 (DESCRIPTION =
                      (ADDRESS_LIST =
                           (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.100.180)(PORT = 1521))
                      )
                      (CONNECT_DATA =
                           (SERVICE_NAME = ORCL11GD)
                           (SERVER = DEDICATED)
                      )
                 )
            • 3. Re: not able to connect to oracle database 11g from application server10g
              Paul M.
              Service "orcl11gd.irma.ac.in" has 1 instance(s).

                             (SERVICE_NAME = ORCL11GD)
              In tnsnames.ora try changing ORCL11GD with orcl11gd.irma.ac.in .