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
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!
Edit: DBNAME is TNS alias. TNS entry:
DBNAME= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=database.address.com)(PORT=1544) ) (CONNECT_DATA= (SERVICE_NAME=DBNAME) (INSTANCE_NAME=DBNAME) ) ) Related questions 2 Unreliable Oracle connection (intermittent error "Connect failed because target host or object does not exist") 7 How come sqlplus not connecting? 0 ORA-01017 error in sqlplus 12.1, can connect with same credentials in other applications Related questions 2 Unreliable Oracle connection (intermittent error "Connect failed because target host or object does not exist") 7 How come sqlplus not connecting? 0 ORA-01017 error in sqlplus 12.1, can connect with same credentials in other applications 27 sqlplus remote connection giving ORA-21561 2 Unable to connect to Oracle DB - ORA-01033: ORACLE initialization or shutdown in progress 1 Can't connect to Oracle DB ORA-12560 error 2 Can not connect ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 3 ERROR: ORA-12154: TNS:could not resolve the connect identifier specified 0 unable to connect to DB using sqlplus: ORA-12154: TNS:could not resolve the connect identifier specified 0 ORA-12154 Oracle DB Windows Can't Connect SQLPlus Load 7 more related questions Show fewer related questions
Reset to default
