on 03-06-2012 1:01 PM
Hi All
We are trying to connect to other oracle database from SAP.
We have maintained the DBCO connection details and also the TNSNAMES.ORA file is also properly editied
Following is the TNSNAMES.ORA details and it is edited in the following folder (oracle/ED1/102_64/network/admin)
devdb.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.10.212) (PORT = 1521:devdb)
)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = devdb.world)
)
)
When we test using the program "ADBC_TEST_CONNECTION", we are getting the following error
"ORA-12154: TNS:could not resolve the connect identifier specified"
Any suggestions for the same
Regards
Madhan D
Madhan,
Can you try to execute a command in prompt "tnsping devdb.world"? I think your TNSNAMES.ORA isn´t properly edited, or the LISTENER.ORA isn´t properly edited too.
You can try remove from TNSNAMES.ORA (PORT = 1521:devdb) and to use (PORT = 1521) only.
I hope help.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.