ORA-28547: 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.




    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=).





Commercial
Forum Messages
16-MAY-2008 15:26:56DicasANTONIO TADEU RODRIGUES Reply
Como fa?o? fui conectar pl/sql deu erro justamente ORA-28547?
Grato
: ->  16-MAY-2008 15:39:40Pleas post the tnsnames entryDbMotive Reply
Can you please post the tnsnames entry you are using for you Heterogeneous connection?

03-JUL-2008 07:33:12Error while entering through SQLplusdevesh mamtani Reply
Hi,

I installed Oracle Database 10g Express Edition in my machine. As per the getting started instructions, I need to go to database homepage but when i do this I get an error saying page cannot be displayed.

I have done nothing except installing Oracle Database 10g Express Edition on my machine
Add your message for ORA-28547
Name:email:
Validation Code:xzuc335tcxz8whe0o
Enter Code above:
Title:
State your problem: