11 Replies Latest reply: Apr 11, 2013 10:26 AM by user2993747 RSS

    ORA-12523: TNS:listener could not find instance appropriate for the client

    user2993747
      Problem
      ORA-12523: TNS:listener could not find instance appropriate for the client

      Spec
      DB: 11.2.0.3
      OS: Server 2012

      tnsnames.ora
      NWSAMPLE =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = nwsample)
      )
      )


      tnsping nwsample
      TNS Ping Utility for 64-bit Windows: Version 11.2.0.3.0 - Production on 10-Apr -2013 16:13:13
      Copyright (c) 1997, 2011, Oracle. All rights reserved.

      Used parameter files:
      C:\app\...\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 = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
      (SERVICE_NAME = nwsample)))
      OK (10 msec)

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

      Edited by: user2993747 on Apr 10, 2013 1:27 AM

      Edited by: user2993747 on Apr 10, 2013 1:29 AM