DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, December 22, 2016

Ora-12560: TNS: protocol adapter error


Ora-12560: TNS: protocol adapter error
************************************************

 Make sure that you have set the correct ORACLE_SID:

C:\>sqlplus system/manager@orcl
SQL*Plus: Release 11.2.0.2.0 Production
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
C:\>set ORACLE_SID=orcl
C:\>sqlplus system/manager@orcl
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

SQL> startup
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size                  1388352 bytes
Variable Size             620757184 bytes
Database Buffers          444596224 bytes
Redo Buffers                4591616 bytes
Database mounted.
Database opened.

SQL>
If the above method doesn’t work, may be the OracleService for the database is not running. Check for the service, if it is not running then starts the service. If it is running then restart the service.

C:\>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Sat Dec 17 22:34:24 2016
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Enter user-name:  / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
Now restart the service using below method.

Start > Run > Type Services.msc

Start/Restart both Oracle service & listener service- OracleServiceORCL & OracleorclTNSListener

C:\>sqlplus
SQL*Plus: Release 11.2.0.2.0 Production on Sat Dec 17 22:41:30 2016
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size                  1388352 bytes
Variable Size             620757184 bytes
Database Buffers          444596224 bytes
Redo Buffers                4591616 bytes
Database mounted.
Database opened.


SQL>

No comments: