11 Replies Latest reply: Feb 26, 2013 10:19 PM by sb92075 RSS

    ORA-12514

    969526
      Hi experts,

      I my db version is 10.2.0.4 running on windows server 2008. It's a test server, I have 4 instance in this server and all are test instances. It runns fine till today morning
      But suddenly I'm getting the following error.
      Using set ORACLE_SID = sid_name I am able to connect the instance but when I am trying to connect using hoisting I'm getting the error. Using tnsping I check its pinging but I am getting the error. Please suggest some solution.


      ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
        • 1. Re: ORA-12514
          Sunny kichloo
          Share the output of

          lsnrctl status

          and

          tnsping <connect_descriptor>

          Also Read this blog link of edstevens.It will help

          http://edstevensdba.wordpress.com/2011/03/19/ora-12514/
          • 2. Re: ORA-12514
            TSharma-Oracle
            This error is very generic. This can be of lot of reasons. It can take a long time if you will try to find solution here. Please read the link below and see if this could help.

            Resolving The ORA-12514 Error [ID 77640.1]

            Also try;
            http://edstevensdba.wordpress.com/2011/03/19/ora-12514/
            • 3. Re: ORA-12514
              Rob_J
              Hi,

              Those links provided are great sources of information and you have a little more about the [url http://www.ora00600.com/articles/ora-12514-tns-listener.html]ORA-12514 error available, too, if you need it.

              Within all those docs you should be able to find the solution. Take a look at Ed Steven's point about dynamic registration if you have found that it's been working in the past and suddenly stopped working now without any other configuration changes.

              Rob
              • 4. Re: ORA-12514
                sb92075
                ORA-12514 ALWAYS only occurs due to a problem on DB Server system.
                One cause of this problem is when the Oracle database is down & needs to be started.
                A remote client send a request to the Listener asking to be connected to a specific service.
                If/when the listener does not know anything about that service, the listener responds with ORA-12514

                post results from the following two OS commands:
                lsnrctl status
                lsnrctl service

                Since every connection request to the listener gets logged, listener.log file will contain a line with 12514 as status code.

                This line contains valuable debugging details. So post this line & surrounding lines.

                for additional debugging suggestions read the URL below:
                http://edstevensdba.wordpress.com/2011/03/19/ora-12514/
                • 5. Re: ORA-12514
                  969526
                  The Out Put of Lsnrctl status And tnsping is as follows



                  C:\Users\dbadmin>lsnrctl status

                  LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 26-FEB-2013 18:33:12

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

                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                  STATUS of the LISTENER
                  ------------------------
                  Alias listener
                  Version TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Production
                  Start Date 26-FEB-2013 18:32:43
                  Uptime 0 days 0 hr. 0 min. 31 sec
                  Trace Level off
                  Security ON: Local OS Authentication
                  SNMP OFF
                  Listener Parameter File E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
                  Listener Log File E:\oracle\product\10.2.0\db_1\network\log\listener.log
                  Listening Endpoints Summary...
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
                  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=1521)))
                  Services Summary...
                  Service "PLSExtProc" has 1 instance(s).
                  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                  The command completed successfully

                  C:\Users\dbadmin>tnsping orcl_prod

                  TNS Ping Utility for 64-bit Windows: Version 10.2.0.4.0 - Production on 26-FEB-2013 18:33:18

                  Copyright (c) 1997, 2007, Oracle. All rights reserved.

                  Used parameter files:
                  E:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora


                  Used TNSNAMES adapter to resolve the alias
                  Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orclprod
                  OK (10 msec)

                  C:\Users\dbadmin>
                  • 6. Re: ORA-12514
                    sb92075
                    post results from the following two OS commands:
                    lsnrctl status
                    lsnrctl service

                    Since every connection request to the listener gets logged, listener.log file will contain a line with 12514 as status code.

                    This line contains valuable debugging details. So post this line & surrounding lines.
                    • 7. Re: ORA-12514
                      969526
                      sb92075 wrote:
                      post results from the following two OS commands:
                      lsnrctl status
                      lsnrctl service

                      Since every connection request to the listener gets logged, listener.log file will contain a line with 12514 as status code.

                      This line contains valuable debugging details. So post this line & surrounding lines.
                      C:\Users\dbadmin>lsnrctl status

                      LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 26-FEB-2013 19:02:59

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

                      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                      STATUS of the LISTENER
                      ------------------------
                      Alias listener
                      Version TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Production
                      Start Date 26-FEB-2013 18:57:57
                      Uptime 0 days 0 hr. 5 min. 4 sec
                      Trace Level off
                      Security ON: Local OS Authentication
                      SNMP OFF
                      Listener Parameter File E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
                      Listener Log File E:\oracle\product\10.2.0\db_1\network\log\listener.log
                      Listening Endpoints Summary...
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
                      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
                      Services Summary...
                      Service "PLSExtProc" has 1 instance(s).
                      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                      The command completed successfully

                      C:\Users\dbadmin>lsnrctl service

                      LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 26-FEB-2013 19:03:54

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

                      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                      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
                      The command completed successfully
                      • 8. Re: ORA-12514
                        sb92075
                        Since V10 every DB registers itself with the listener every 60 seconds

                        There is NO indication that you have any DB online & available NOW

                        See below from my listener which clearly shows available DB
                        [oracle@localhost ~]$ lsnrctl status
                        
                        LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 26-FEB-2013 19:06:21
                        
                        Copyright (c) 1991, 2010, Oracle.  All rights reserved.
                        
                        Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))
                        STATUS of the LISTENER
                        ------------------------
                        Alias                     LISTENER
                        Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
                        Start Date                21-FEB-2013 20:49:28
                        Uptime                    4 days 22 hr. 16 min. 53 sec
                        Trace Level               off
                        Security                  ON: Local OS Authentication
                        SNMP                      OFF
                        Listener Parameter File   /home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora
                        Listener Log File         /home/oracle/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
                        Listening Endpoints Summary...
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521)))
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=80))(PROTOCOL_STACK=(PRESENTATION=HTTP)(SESSION=RAW)))
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=21))(PROTOCOL_STACK=(PRESENTATION=FTP)(SESSION=RAW)))
                        Services Summary...
                        Service "orcl" has 1 instance(s).
                          Instance "orcl", status READY, has 2 handler(s) for this service...
                        Service "orclXDB" has 1 instance(s).
                          Instance "orcl", status READY, has 1 handler(s) for this service...
                        The command completed successfully
                        [oracle@localhost ~]$ 
                        • 9. Re: ORA-12514
                          969526
                          Contents of Listener.log since when error arises....

                          25-FEB-2013 20:21:27 * service_update * erpprod * 0
                          25-FEB-2013 20:22:12 * (CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-)(USER=ITL))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.123)(PORT=1056)) * establish * orcl * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 20:22:13 * service_update * orcldev * 0
                          25-FEB-2013 20:22:37 * service_update * erpdev * 0
                          25-FEB-2013 20:23:01 * service_update * orclprod * 0
                          25-FEB-2013 20:23:13 * service_update * orcldev * 0
                          25-FEB-2013 20:23:37 * service_update * erpdev * 0
                          25-FEB-2013 20:24:45 * (CONNECT_DATA=(SERVICE_NAME=erpprod)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-)(USER=ITL))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.123)(PORT=1059)) * establish * erpprod * 0
                          25-FEB-2013 20:24:45 * (CONNECT_DATA=(SERVICE_NAME=erpprod)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-)(USER=ITL))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.123)(PORT=1060)) * establish * erpprod * 0
                          25-FEB-2013 20:31:16 * service_update * orclprod * 0
                          25-FEB-2013 20:31:37 * service_update * erpdev * 0
                          25-FEB-2013 20:32:27 * service_update * erpprod * 0
                          25-FEB-2013 20:34:13 * service_update * orcldev * 0
                          25-FEB-2013 20:34:37 * service_update * erpdev * 0
                          25-FEB-2013 20:34:53 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-10006)(USER=ILFS))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1373)) * establish * orclprod * 0
                          25-FEB-2013 20:34:55 * service_update * orclprod * 0
                          25-FEB-2013 20:35:44 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-10006)(USER=ILFS))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1379)) * establish * orclprod * 0
                          25-FEB-2013 20:35:46 * service_update * orclprod * 0
                          25-FEB-2013 20:52:44 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50943)) * establish * orcldev * 0
                          25-FEB-2013 20:53:27 * service_update * erpprod * 0
                          25-FEB-2013 20:54:01 * service_update * orclprod * 0
                          25-FEB-2013 20:54:01 * service_update * erpdev * 0
                          25-FEB-2013 20:56:54 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program?Files\PLSQL?Developer\plsqldev.exe)(HOST=SOUBHAGYA-PC)(USER=SOUBHAGYA))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.15)(PORT=65117)) * establish * orcldev * 0
                          25-FEB-2013 20:56:55 * service_update * orcldev * 0
                          25-FEB-2013 20:56:56 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program?Files\PLSQL?Developer\plsqldev.exe)(HOST=SOUBHAGYA-PC)(USER=SOUBHAGYA))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.15)(PORT=65118)) * establish * orcldev * 0
                          25-FEB-2013 20:57:27 * service_update * erpprod * 0
                          25-FEB-2013 20:58:01 * service_update * orcldev * 0
                          25-FEB-2013 20:59:04 * service_update * orclprod * 0
                          25-FEB-2013 20:59:40 * service_update * erpdev * 0
                          25-FEB-2013 21:02:16 * service_update * orcldev * 0
                          25-FEB-2013 21:03:16 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program?Files\Common?Files\Microsoft?Shared\DevServer\9.0\WebDev.WebServer.EXE)(HOST=SOUBHAGYA-PC)(USER=SOUBHAGYA))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.15)(PORT=65233)) * establish * orcldev * 0
                          25-FEB-2013 21:03:16 * service_update * orcldev * 0
                          25-FEB-2013 21:03:30 * service_update * erpprod * 0
                          25-FEB-2013 21:04:04 * service_update * orclprod * 0
                          25-FEB-2013 21:04:40 * service_update * erpdev * 0
                          25-FEB-2013 21:05:04 * service_update * orclprod * 0
                          25-FEB-2013 21:08:16 * service_update * orcldev * 0
                          25-FEB-2013 21:09:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPPROD)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50944)) * establish * ERPPROD * 0
                          25-FEB-2013 21:09:21 * service_update * erpprod * 0
                          25-FEB-2013 21:10:40 * service_update * erpdev * 0
                          25-FEB-2013 21:11:04 * service_update * orclprod * 0
                          25-FEB-2013 21:11:19 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-IP31)(USER=ITL))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.128)(PORT=1049)) * establish * orcldev * 0
                          25-FEB-2013 21:11:19 * service_update * orcldev * 0
                          25-FEB-2013 21:11:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-IP31)(USER=ITL))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.128)(PORT=1050)) * establish * orcldev * 0
                          25-FEB-2013 21:11:40 * service_update * erpdev * 0
                          25-FEB-2013 21:13:38 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPPROD)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\imp.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50945)) * establish * ERPPROD * 0
                          25-FEB-2013 21:14:04 * service_update * orclprod * 0
                          25-FEB-2013 21:14:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPPROD)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\imp.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50946)) * establish * ERPPROD * 0
                          25-FEB-2013 21:14:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPPROD)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\imp.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50947)) * establish * ERPPROD * 0
                          25-FEB-2013 21:14:21 * service_update * erpprod * 0
                          25-FEB-2013 21:14:22 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPPROD)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\imp.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50948)) * establish * ERPPROD * 0
                          25-FEB-2013 21:14:24 * service_update * erpprod * 0
                          25-FEB-2013 21:14:48 * service_update * erpprod * 0
                          25-FEB-2013 21:14:54 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPPROD)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\imp.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50949)) * establish * ERPPROD * 0
                          25-FEB-2013 21:14:57 * service_update * erpprod * 0
                          25-FEB-2013 21:15:40 * service_update * erpdev * 0
                          25-FEB-2013 21:15:52 * service_update * orcldev * 0
                          25-FEB-2013 21:16:04 * service_update * orclprod * 0
                          25-FEB-2013 21:17:21 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program?Files\Common?Files\Microsoft?Shared\DevServer\9.0\WebDev.WebServer.EXE)(HOST=SOUBHAGYA-PC)(USER=SOUBHAGYA))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.15)(PORT=65513)) * establish * orcldev * 0
                          25-FEB-2013 21:17:22 * service_update * orcldev * 0
                          25-FEB-2013 21:20:40 * service_update * erpdev * 0
                          25-FEB-2013 21:21:04 * service_update * orclprod * 0
                          25-FEB-2013 21:22:16 * service_update * orcldev * 0
                          25-FEB-2013 21:24:04 * service_update * orclprod * 0
                          25-FEB-2013 21:24:43 * service_update * orcldev * 0
                          25-FEB-2013 21:24:58 * service_update * erpprod * 0
                          25-FEB-2013 21:25:11 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITLPC)(USER=itl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.86)(PORT=1521)) * establish * orcldev * 0
                          25-FEB-2013 21:25:12 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITLPC)(USER=itl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.86)(PORT=1522)) * establish * orcldev * 0
                          25-FEB-2013 21:25:13 * service_update * orcldev * 0
                          25-FEB-2013 21:25:16 * service_update * orcldev * 0
                          25-FEB-2013 21:26:07 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPPROD)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\imp.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50950)) * establish * ERPPROD * 0
                          25-FEB-2013 21:26:40 * service_update * erpdev * 0
                          25-FEB-2013 21:27:04 * service_update * orclprod * 0
                          25-FEB-2013 21:27:12 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPPROD)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\imp.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50951)) * establish * ERPPROD * 0
                          25-FEB-2013 21:27:13 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPPROD)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\imp.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50952)) * establish * ERPPROD * 0
                          25-FEB-2013 21:29:07 * service_update * erpprod * 0
                          25-FEB-2013 21:29:08 * service_update * erpprod * 0
                          25-FEB-2013 21:30:16 * service_update * orcldev * 0
                          25-FEB-2013 21:30:26 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program?Files\PLSQL?Developer\plsqldev.exe)(HOST=SOUBHAGYA-PC)(USER=SOUBHAGYA))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.15)(PORT=49345)) * establish * orcldev * 0
                          25-FEB-2013 21:30:28 * service_update * orcldev * 0
                          25-FEB-2013 21:30:59 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPPROD)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50953)) * establish * ERPPROD * 12528
                          TNS-12528: TNS:listener: all appropriate instances are blocking new connections
                          25-FEB-2013 21:32:07 * service_update * orclprod * 0
                          25-FEB-2013 21:32:29 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program?Files\PLSQL?Developer\plsqldev.exe)(HOST=SOUBHAGYA-PC)(USER=SOUBHAGYA))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.15)(PORT=49375)) * establish * orcldev * 0
                          25-FEB-2013 21:32:31 * service_update * orcldev * 0
                          25-FEB-2013 21:32:39 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPPROD)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50954)) * establish * ERPPROD * 12528
                          TNS-12528: TNS:listener: all appropriate instances are blocking new connections
                          25-FEB-2013 21:32:40 * service_update * erpdev * 0
                          25-FEB-2013 21:33:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-10006)(USER=ILFS))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1725)) * establish * orcldev * 0
                          25-FEB-2013 21:33:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-10006)(USER=ILFS))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=1726)) * establish * orcldev * 0
                          25-FEB-2013 21:33:25 * service_update * orcldev * 0
                          25-FEB-2013 21:33:28 * service_update * orcldev * 0
                          25-FEB-2013 21:33:31 * service_update * orcldev * 0
                          25-FEB-2013 21:36:55 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPDEV)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50957)) * establish * ERPDEV * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 21:37:51 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPDEV)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50958)) * establish * ERPDEV * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 21:38:07 * service_update * orclprod * 0
                          25-FEB-2013 21:38:31 * service_died * erpprod * 12547
                          TNS-12547: TNS:lost contact
                          TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                          25-FEB-2013 22:10:17 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPPROD)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=51089)) * establish * ERPPROD * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 22:11:57 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=51097)) * establish * orcldev * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

                          TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Production on 25-FEB-2013 22:13:13


                          TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                          25-FEB-2013 22:29:04 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPPROD)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=51169)) * establish * ERPPROD * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor

                          TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                          25-FEB-2013 22:36:25 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=51194)) * establish * orcldev * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 22:37:29 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-10006)(USER=ILFS))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=2686)) * establish * orcldev * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 22:37:32 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-10006)(USER=ILFS))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=2689)) * establish * orcldev * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 22:39:31 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * stop * 1190
                          TNS-01190: The user is not authorized to execute the requested listener command
                          25-FEB-2013 22:40:58 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ERPDEV)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=51212)) * establish * ERPDEV * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 22:42:08 * ping * 0
                          25-FEB-2013 22:42:14 * ping * 0
                          25-FEB-2013 22:42:20 * ping * 0
                          25-FEB-2013 22:42:26 * ping * 0
                          25-FEB-2013 22:42:33 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
                          25-FEB-2013 22:42:43 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * services * 0
                          25-FEB-2013 22:43:03 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=51226)) * establish * orclprod * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 22:48:38 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=51248)) * establish * orclprod * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 22:48:53 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * stop * 1190
                          TNS-01190: The user is not authorized to execute the requested listener command
                          25-FEB-2013 22:49:19 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
                          25-FEB-2013 22:49:22 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * stop * 1190
                          TNS-01190: The user is not authorized to execute the requested listener command
                          25-FEB-2013 22:55:07 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=51277)) * establish * orclprod * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 22:56:33 * ping * 0
                          25-FEB-2013 22:56:51 * ping * 0
                          25-FEB-2013 22:56:58 * ping * 0
                          25-FEB-2013 22:57:05 * ping * 0
                          25-FEB-2013 22:57:09 * ping * 0
                          25-FEB-2013 23:11:21 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=51345)) * establish * orclprod * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 23:13:51 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=51357)) * establish * orclprod * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 23:19:02 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-10006)(USER=ILFS))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=2962)) * establish * orcldev * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 23:20:35 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcldev)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-10006)(USER=ILFS))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=2974)) * establish * orcldev * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 23:23:27 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-10006)(USER=ILFS))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=2995)) * establish * orclprod * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          25-FEB-2013 23:23:33 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=C:\Program Files\PLSQL Developer\plsqldev.exe)(HOST=ITL-10006)(USER=ILFS))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.13)(PORT=2998)) * establish * orclprod * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                          25-FEB-2013 23:59:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * status * 0
                          25-FEB-2013 23:59:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * services * 0
                          26-FEB-2013 00:00:04 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50176)) * establish * orclprod * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          26-FEB-2013 00:02:39 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50185)) * establish * orclprod * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          26-FEB-2013 00:02:53 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50186)) * establish * orclprod * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          26-FEB-2013 00:04:30 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * status * 0
                          26-FEB-2013 00:18:21 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
                          26-FEB-2013 00:30:26 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
                          26-FEB-2013 00:30:36 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
                          26-FEB-2013 00:30:38 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
                          26-FEB-2013 00:31:07 * ping * 0
                          26-FEB-2013 00:31:11 * ping * 0
                          26-FEB-2013 00:31:17 * ping * 0
                          26-FEB-2013 00:31:21 * ping * 0
                          26-FEB-2013 00:32:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
                          26-FEB-2013 00:36:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * services * 0
                          26-FEB-2013 00:41:13 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
                          26-FEB-2013 00:45:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * reload * 1190
                          26-FEB-2013 00:48:18 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * reload * 0
                          26-FEB-2013 00:48:23 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
                          26-FEB-2013 01:11:03 * ping * 0
                          No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
                          No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=1521)))
                          Listener completed notification to CRS on stop
                          26-FEB-2013 01:17:43 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * stop * 0

                          TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                          26-FEB-2013 01:17:57 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * status * 0
                          26-FEB-2013 01:18:20 * ping * 0
                          26-FEB-2013 01:18:31 * ping * 0
                          26-FEB-2013 01:19:20 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50503)) * establish * orclprod * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          26-FEB-2013 01:19:44 * ping * 0
                          26-FEB-2013 01:20:42 * ping * 0
                          No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
                          No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=1521)))
                          Listener completed notification to CRS on stop
                          26-FEB-2013 01:24:59 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * stop * 0


                          TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                          26-FEB-2013 01:25:12 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * status * 0
                          26-FEB-2013 01:25:40 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=50535)) * establish * orclprod * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          26-FEB-2013 18:30:51 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
                          26-FEB-2013 18:31:47 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=reload)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * reload * 1190
                          TNS-01190: The user is not authorized to execute the requested listener command
                          No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
                          No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=1521)))
                          Listener completed notification to CRS on stop
                          26-FEB-2013 18:32:32 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * stop * 0

                          TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                          26-FEB-2013 18:32:45 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * status * 0
                          26-FEB-2013 18:33:01 * ping * 0
                          26-FEB-2013 18:33:12 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
                          26-FEB-2013 18:33:18 * ping * 0
                          26-FEB-2013 18:34:07 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orclprod)(CID=(PROGRAM=E:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=ITLSERVER)(USER=dbadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=54598)) * establish * orclprod * 12514
                          TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
                          No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
                          No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=1521)))
                          Listener completed notification to CRS on stop
                          26-FEB-2013 18:52:24 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * stop * 0

                          TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                          26-FEB-2013 18:52:42 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * status * 0
                          26-FEB-2013 18:56:36 * ping * 0
                          No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
                          No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=1521)))
                          Listener completed notification to CRS on stop
                          26-FEB-2013 18:56:40 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * stop * 0


                          TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                          26-FEB-2013 18:56:50 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * status * 0
                          No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
                          No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=1521)))
                          Listener completed notification to CRS on stop
                          26-FEB-2013 18:57:50 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * stop * 0

                          TNSLSNR for 64-bit Windows: Version 10.2.0.4.0 - Production on 26-FEB-2013 18:57:54

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

                          System parameter file is E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
                          Log messages written to E:\oracle\product\10.2.0\db_1\network\log\listener.log
                          Trace information written to E:\oracle\product\10.2.0\db_1\network\trace\listener.trc
                          Trace level is currently 0

                          Started with pid=7908
                          Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
                          Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.2)(PORT=1521)))
                          Listener completed notification to CRS on start

                          TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                          26-FEB-2013 18:57:59 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(ARGUMENTS=64)(SERVICE=listener)(VERSION=169870336)) * status * 0
                          26-FEB-2013 18:58:43 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
                          26-FEB-2013 19:02:59 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * status * 0
                          26-FEB-2013 19:03:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=dbadmin))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169870336)) * services * 0
                          • 10. Re: ORA-12514
                            969526
                            The following is my DB Status....




                            C:\Users\dbadmin>set ORACLE_SID=orclprod

                            C:\Users\dbadmin>sqlplus sys as sysdba

                            SQL*Plus: Release 10.2.0.4.0 - Production on Tue Feb 26 19:17:02 2013

                            Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

                            Enter password:

                            Connected to:
                            Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
                            With the Partitioning, OLAP, Data Mining and Real Application Testing options

                            SQL> select name,dbid,open_mode,log_mode from v$database;

                            NAME DBID OPEN_MODE LOG_MODE
                            --------- ---------- ---------- ------------
                            ORCLPROD 1605962721 READ WRITE ARCHIVELOG

                            SQL>
                            • 11. Re: ORA-12514
                              sb92075
                              My head hurts after looking at the listener.log file.

                              It shows it listens for MANY instances on many different hostnames & IP#s!

                              I have neither the time nor inclination to continue unravel this mystery.

                              When was the last time SQL*Net worked without errors?
                              What changed since then?