ora-12523: TNS:listener could not find instance appropriate for the client
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.