title: ORA-12514 error after restarting the server
body: <p>I have oracle 11g installed on server and .Net oracle clients will access the database.<br>
  Till yesterday i was connecting from clients using this connection string:  </p>
  
  <pre><code>User ID=dbcplas;Password=pwd123;Data Source=(DESCRIPTION = (ADDRESS =(PROTOCOL = TCP)(HOST = 172.17.26.7)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl.cplas3.com)))  
  </code></pre>
  
  <p>Till yesterday I was able to use Oracle SQL Developer in the same client.<br>
  Today morning we restarted the server for maintanance. After restarting the server, I cannot able to login from client .Net application or sqldeveloper.<br>
  <strong>I can able to log-in thru sql plus of server system.</strong><br>
  Apart from that i cannot able to log in by any other means.<br>
  Server side sql-developer also not working.<br>
  I have give below details from the server:  </p>
  
  <p><strong>lsnrctl services:</strong>    </p>
  
  <pre><code>    C:\Users\Administrator&gt;lsnrctl services
  
  LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 07-JAN-2014 15:
  :45
  
  Copyright (c) 1991, 2010, Oracle.  All rights reserved.
  
  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.26.7)(PORT=1521
  )
  Services Summary...
  Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
      Handler(s):
        "DEDICATED" established:0 refused:0
           LOCAL SERVER
  The command completed successfully
  </code></pre>
  
  <p><strong>lsnrctl status:</strong>  </p>
  
  <pre><code>C:\Users\Administrator&gt;lsnrctl status
  
  LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 07-JAN-2014 15:20
  :42
  
  Copyright (c) 1991, 2010, Oracle.  All rights reserved.
  
  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.26.7)(PORT=1521))
  )
  STATUS of the LISTENER
  ------------------------
  Alias                     LISTENER
  Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
  ction
  Start Date                07-JAN-2014 13:17:40
  Uptime                    0 days 2 hr. 3 min. 7 sec
  Trace Level               off
  Security                  ON: Local OS Authentication
  SNMP                      OFF
  Listener Parameter File   E:\app\administrator\product\11.2.0\dbhome_1\network\a
  dmin\listener.ora
  Listener Log File         e:\app\administrator\diag\tnslsnr\cplas3\listener\aler
  t\log.xml
  Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.17.26.7)(PORT=1521)))
  Services Summary...
  Service "CLRExtProc" has 1 instance(s).
    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
  The command completed successfully  
  </code></pre>
  
  <p><strong>LISTENER.ORA</strong>  </p>
  
  <pre><code># listener.ora Network Configuration File: E:\app\administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
  # Generated by Oracle configuration tools.
  
  SID_LIST_LISTENER =
    (SID_LIST =
      (SID_DESC =
        (SID_NAME = CLRExtProc)
        (ORACLE_HOME = E:\app\administrator\product\11.2.0)
        (PROGRAM = extproc)
        (ENVS = "EXTPROC_DLLS=ONLY:E:\app\administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
      )
    )
  
  LISTENER =
    (DESCRIPTION_LIST =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.26.7)(PORT = 1521))
      )
    )
  
  ADR_BASE_LISTENER = E:\app\administrator  
  </code></pre>
  
  <p><strong>SQLNET.ORA</strong> </p>
  
  <pre><code># sqlnet.ora Network Configuration File: E:\app\administrator\product\11.2.0\dbhome_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)
  
  
  TNSFILES.ORA
  
      # tnsnames.ora Network Configuration File: E:\app\administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
      # Generated by Oracle configuration tools.
  
      ORACLR_CONNECTION_DATA =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
          )
          (CONNECT_DATA =
            (SID = CLRExtProc)
            (PRESENTATION = RO)
          )
        )
  
      ORCL =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.26.7)(PORT = 1521))
          (CONNECT_DATA =
            (SERVER = DEDICATED)
            (SERVICE_NAME = orcl.cplas3.com)
          )
        ) 
  </code></pre>
  
  <p><strong>tnsping results - orcl.cplas3.com</strong>  </p>
  
  <pre><code>C:\Users\Administrator&gt;tnsping orcl.cplas3.com
  
  TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 07-JAN-2
  014 15:30:44
  
  Copyright (c) 1997, 2010, Oracle.  All rights reserved.
  
  Used parameter files:
  E:\app\administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
  
  TNS-03505: Failed to resolve name
  </code></pre>
  
  <p><strong>tnsping results - orcl</strong>  </p>
  
  <pre><code>C:\Users\Administrator&gt;tnsping orcl
  
  TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 07-JAN-2
  014 15:31:22
  
  Copyright (c) 1997, 2010, Oracle.  All rights reserved.
  
  Used parameter files:
  E:\app\administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
  
  
  Used TNSNAMES adapter to resolve the alias
  Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.2
  6.7)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.cpl
  as3.com)))
  OK (1560 msec)
  </code></pre>
  
  <p>Errors:<br>
  From .Net Application:<br>
  ORA-12514 TNS:Listener does not currently know of service request in connect descriptor.  </p>
  
  <p>Why <code>lsnrctl status</code> not showing the status of orcl??<br>
  I tried starting the orcl services. But its saying already started..<br>
  What may be the problem??</p>