| ORA-12560: TNS: error with protocoladapter [message #185712] |
Thu, 03 August 2006 03:56  |
The pirate
Messages: 1
Registered: August 2006
|
Junior Member |
|
|
Hi,
When I want to execute my file from Forms I get the message
ORA-12560: TNS: error with protocoladapter.
When I log in with SQL plus this error message does not appear.
Can somebody help me?
|
|
|
|
|
|
| Re: ORA-12560: TNS: error with protocoladapter [message #187698 is a reply to message #185712] |
Tue, 15 August 2006 00:42  |
snehaps
Messages: 4
Registered: August 2006
|
Junior Member |
|
|
Hi,
Even I am getting the same error.
I tried copying all the .ora files under newtwork/admin in the database directory to the Developer Suite's directory. It still doesn't work.
Could you fix this?
If yes, can you please help me out?
The contents of the tnsnames.ora files in Developer Suite is as follows:
# tnsnames.ora Network Configuration File: E:\DevSuiteHome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = user-4a1983b25a)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)
And in the database directory is as follows:
# tnsnames.ora Network Configuration File: E:\oracle\product\10.1.0\Db_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = user-4a1983b25a)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Kindly suggest any changes.
Thanks and Regards,
Sneha
[Updated on: Wed, 16 August 2006 21:43] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
