Database Networking (MOSC)

MOSC Banner

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

edited Jun 23, 2014 10:34AM in Database Networking (MOSC) 5 commentsAnswered

I have an 11g database p1150va on a windows 2008r2 server (DB04)

I used Net Configuration Assistant on the DB04 server to create a tns entry p1150va on the db04 server.  I can connect thru sqlplus on db04 server to the p1150va server with no problem.

i have oracle 11g client installed on an app server (windows 2008r2 server) named pvm16.

I used Net Configuration Assistant on pvm16 to add tns entry for p1150va db on db04.   it works fine except when I test connection I get ora-12523: tns:listener could not find instance appropriate for the client connection.  so I created the tns entry and tnsnames.ora file exists.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center