This discussion is archived
11 Replies Latest reply: Apr 11, 2013 8:26 AM by user2993747 RSS

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

user2993747 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points