Q
Problem solve Get help with specific problems with your technologies, process and projects.

Error running a form in a browser

How do I resolve this error: 'ORA-12560:TNS protocol adapter error'. I receive this error when trying to run a form in browser. I have both the Oracle9i Personal Edition DB and the Oracle Developer Tools on my computer. Below is the info I have in the TNSnames file:

# TNSNAMES.ORA Network Configuration File: D:oracleora92networkadmintnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Stewart1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.localhost)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Stewart1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
**************************************
# TNSNAMES.ORA Network Configuration File: D:ORACLEORADEVnetworkadmintnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = Stewart1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.localhost)
    )
  )

The TNS-12560 error is very non-descriptive and generic. Metalink NOTE 117976.1 provides references to some common issues and adds this description of the 12560 error:

This is a high level error reporting that an error occurred in the transport layer. Since the 12560 is the end result of another problem and not necessarily the cause look at the accompanying errors in the error stack. To get an error stack, a SQL*Net trace should be obtained. Note 39774.1 describes how to set up SQL*Net tracing. Once you have the trace, you should be able to locate the other errors accompanying the 12560. Note 39662.1 shows the SQL*Net components that take part during a connection.

Other errors that may accompany this error will likely lead you to a root cause and solution. If you're not seeing additional errors, I would suggest enabling SQL*Net tracing and reviewing the trace outputs.

This was last published in April 2004

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close