Home » Developer & Programmer » Forms » ORA-12560: TNS: error with protocoladapter
ORA-12560: TNS: error with protocoladapter [message #185712] Thu, 03 August 2006 03:56 Go to next message
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 #186221 is a reply to message #185712] Mon, 07 August 2006 02:15 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search this forum for 'tnsnames.ora'. You have two Oracle 'homes' on your PC - SQL is using one successfully and Forms is using another, unfortunately, unsuccessfully. They have to be the same. Use the search term 'ifile' for the best solution.

David
Re: ORA-12560: TNS: error with protocoladapter [message #187698 is a reply to message #185712] Tue, 15 August 2006 00:42 Go to previous messageGo to next message
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

Re: ORA-12560: TNS: error with protocoladapter [message #188059 is a reply to message #187698] Wed, 16 August 2006 21:41 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You said "I tried copying all the .ora files". How many files was that? And if you did copy them, why is the tnsnames.ora different now?

What did you install first? Oracle DB or Develoepr Suite?

David

[Updated on: Wed, 16 August 2006 21:44]

Report message to a moderator

Re: ORA-12560: TNS: error with protocoladapter [message #188258 is a reply to message #188059] Thu, 17 August 2006 11:42 Go to previous message
snehaps
Messages: 4
Registered: August 2006
Junior Member
I added an entry for LOCAL in the default.env file(as suggested by you in one of your replies) and that worked.
Thanks.
-Sneha
Previous Topic: One form calling another connected to a different database.
Next Topic: Fill form after LOV
Goto Forum:
  


Current Time: Thu Dec 08 08:49:56 CST 2016

Total time taken to generate the page: 0.11336 seconds