Thursday, August 8, 2024

Oracle On Windows - ORA-12560: TNS:protocol adapter error

Oracle On Windows - ORA-12560: TNS:protocol adapter error


Issue: 

Unable to connect to database getting error ORA-12560: TNS:protocol adapter error


C:\Users\Administrator>set ORACLE_HOME=E:\app\mallik\product\19.0.0.0\dbhome_1
C:\Users\Administrator>set ORACLE_SID=ORA19C

C:\Users\Administrator>E:\app\mallik\product\19.0.0.0\dbhome_1\bin\sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Jul 31 23:00:31 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
C:\Users\Administrator>

Cause:

Windows service will be down -  OracleServiceORA19C


Solution or Fix:

Verify the windows service status for Oracle and restart them 


No comments:

Post a Comment

Running SQL and O/S Commands Within RMAN

Running SQL and O/S Commands Within RMAN Sometimes you may want to run an SQL statement from within RMAN. Use RMAN’s sql command to do this....