Home » RDBMS Server » Enterprise Manager » ORA-28547: connection to server failed, probable Oracle net admin error
icon9.gif  ORA-28547: connection to server failed, probable Oracle net admin error [message #254462] Thu, 26 July 2007 17:15 Go to next message
jhsong01
Messages: 7
Registered: July 2007
Junior Member
Hi there,

When I tried to connect to Oracle via oracle Enterprise Manager Console, I am getting following error.
ORA-28547: connection to server failed, probable Oracle net admin error

But using the same service name, I can connect to the server via sqlplus.

Any tips or solutions would be appreciated.

Thanks,
  • Attachment: listener.ora
    (Size: 0.65KB, Downloaded 1982 times)
Re: ORA-28547: connection to server failed, probable Oracle net admin error [message #254465 is a reply to message #254462] Thu, 26 July 2007 17:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
oerr ora 28547
28547, 0000, "connection to server failed, probable Oracle Net 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
//           Oracle Net 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 Oracle Net 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=).
//

[Updated on: Thu, 26 July 2007 17:26] by Moderator

Report message to a moderator

Re: ORA-28547: connection to server failed, probable Oracle net admin error [message #254473 is a reply to message #254462] Thu, 26 July 2007 18:37 Go to previous messageGo to next message
jhsong01
Messages: 7
Registered: July 2007
Junior Member
Thank for the info.

Based on the action items, my listener.ora and tnsnames.org seem OK.

The thing I can't understand is that why can't Enterprise Management Console connect to the server whereas sqlpus can?
Re: ORA-28547: connection to server failed, probable Oracle net admin error [message #254474 is a reply to message #254462] Thu, 26 July 2007 18:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>The thing I can't understand is that why can't Enterprise Management Console connect to the server whereas sqlpus can?
In some cases you can have multiple ORACLE_HOME directory trees.
Re: ORA-28547: connection to server failed, probable Oracle net admin error [message #254748 is a reply to message #254462] Fri, 27 July 2007 16:17 Go to previous messageGo to next message
jhsong01
Messages: 7
Registered: July 2007
Junior Member
Still I am having the problem.

Is there any suggestions?
Re: ORA-28547: connection to server failed, probable Oracle net admin error [message #254767 is a reply to message #254748] Sat, 28 July 2007 01:03 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Are you set Oracle_home env variable ?

Regards
Taj
Previous Topic: Oracle Join Schedules together
Next Topic: Email Notifications after reaching the desired size of my Tablespace:
Goto Forum:
  


Current Time: Tue Nov 26 16:54:27 CST 2024