Home » RDBMS Server » Networking and Gateways » TNS issue (11gR2 Linux)
TNS issue [message #541337] Mon, 30 January 2012 10:29 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member

Hi ,

My environment is setup like this.

+ASM instance and 3 DB instance.
DB_US
DB_Aus
DB_Gulf

there is just single listener running from +ASM binary handoff connection to databases .

i have individual tnsnames.ora for each DB $TNS_ADMIN.

- this query work from server ,since i have REMOTEDB tns in DB_US $TNS_ADMIN.

SCOTT:DB_US> select sysdate from dual@REMOTEDB;

-- same query fails from a remote client.eg laptop.

SCOTT:DB_US> select sysdate from dual@REMOTEDB;
select sysdate from dual@REMOTEDB
                         *
ERROR at line 1:
ORA-12154: TNS:could not resolve the connect identifier specified


-- issue is resolved when i add REMOTED tns entry to +ASM tnsnames.ora

now question is , Can i make any config change in +ASM side so that if it dont find a tns in its TNS_ADMIN, it should look for it in DB_US $TNS_ADMIN . eg : multiple TNS_ADMIN path, or ifile etc..

Can someone pls advice. thanks
Re: TNS issue [message #541345 is a reply to message #541337] Mon, 30 January 2012 12:22 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
in my opinion, you have THREE to many tnsnames.ora files.
Previous Topic: Listener support no services
Next Topic: Not able to connect to database
Goto Forum:
  


Current Time: Fri Mar 29 02:23:37 CDT 2024