Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-28547 error with OCILogon

Re: ORA-28547 error with OCILogon

From: HansF <News.Hans_at_telus.net>
Date: Sat, 27 Aug 2005 01:49:44 GMT
Message-Id: <pan.2005.08.27.01.53.52.886457@telus.net>


First thing I'd check is 'can you get there from here'? Can you (tnsping dev) and (sqlplus scott/tiger_at_dev) from the same machine?

Note that the problem starts at the client side, and therefore has little or nothing to do with the Listener on the server, at least initially.

Oracle has a real handy little document, called the "OracleŽ Database Net Services Administrator's Guide", part III of which goes into a lot of detail in troubleshooting. Check it out at docs.oracle.com (and specifically the list of books for 10g Release 1 is at http://otn.oracle.com/pls/db10g/portal.portal_demo3?selected=3#index-NET)

The BIG question - how did these files get created? I'd encourage you to fire up Oracle's Network Manager to check the syntax of the TNSNAMES.ora (netmgr)

For reference ... the error message (as provided in the docco) is

ORA-28547: connection to server failed, probable Net8 admin error

Cause: A failure occurred during initialization of a network

    connection from a client process to the Oracle server: The connection     was completed but a disconnect occurred while trying to perform     protocol-specific initialization, usually due to use of different     network protocols by opposite sides of the connection. This usually is     caused by incorrect Net8 administrative setup for database links or     external procedure calls. The most frequent specific causes are: --     The connection uses a connect string which refers to a Heterogeneous     Services agent instead of an Oracle server. -- The connection uses a     connect string which includes an (HS=) specification.

Action: Check Net8 administration in the following ways: -- When

    using TNSNAMES.ORA or an Oracle Names server, make sure that the     client connection to the ORACLE server uses the correct service name     or SID. -- Check LISTENER.ORA on the connection end point's host     machine to assure that this service name or SID refers to the correct     server. -- Confirm in TNSNAMES.ORA or the equivalent service     definition that the connect string does NOT contain (HS=).

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***
Received on Fri Aug 26 2005 - 20:49:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US