Monday, October 13, 2008

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

Error Description
This problem occurs on windows machine. Whenever you login as a user of windows domain group then in the database all connections both local and remote, including SYSDBA, fail with an ORA-28547.

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

Cause of the Problem
Oracle Native Authentication Services is failing.

Solution of the Problem
Way 1:
Disable Oracle Native Authentication Services. In the server machine inside sqlnet.ora change the parameter value of SQLNET.AUTHENTICATION_SERVICES from (NTS) to (NONE).

Way 2:
Change the database service to run as a user who is a member of the Domain Admin group. Because in order to connect using native authentication service oracle Log on user must be a privileged user to allow it to correctly authenticate the client user for Native Authentication.

To do so,
1.Go to Services. Right click on My computer>Select Manage>Select Services and Application> Select Services> On the right side From a list Scroll to your OracleService$ORACLE_SID
You will search for your database name instead of $ORACLE_SID of OracleService$ORACLE_SID.

2. Right click on the service and click the properties of the database service, select the LogOn tab.

3. Select "This Account" and add you domain admin account details and Ok

4. Shutdown the database

5. Stop and restart the service

2 comments:

  1. Hi,

    I am getting this error while testing the connection through Oracle Net Manager. Connection testing fails with this error. I am able to connect to the database locally and even remotely as well.

    AB

    ReplyDelete
  2. HI

    I changed the sqlnet.ora file on my client:

    old:
    SQLNET.AUTHENTICATION_SERVICES= (NTS)
    new:
    SQLNET.AUTHENTICATION_SERVICES= (NONE)

    After that it works fine without ORA-28547.

    GP

    ReplyDelete