Database Administration (MOSC)

MOSC Banner

ORA-28547: connection to server failed, probable Oracle Net admin error but works after reboot

I get the above error every so often when attempting to connect to oracle (12.1.2) using sqlplus (but sqldeveloper does the same). This tends to happen when the client machine I'm using has been up for a long time:

sqlplus USER/PASSWORD@DBNAME

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

Note: DBNAME is the TNS alias

TNS:

DBNAME=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=database.address.com)(PORT=1544)                                                                                                                     )
            (CONNECT_DATA=
                (SERVICE_NAME=DBNAME)
                (INSTANCE_NAME=DBNAME)
            )
        )

The strange thing is if I then reboot to the client machine, the connection works fine again! Anyone know what could be causing this? I'd rather not have to reboot daily!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center