| TNS issue [message #541337] |
Mon, 30 January 2012 10:29  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
