This error often strikes anytime then i list out what to do
1. Check networking wires
2. Check ping
3. Ensure listener is started
4.. Oracle variables configured correctly
In Windows OS:
---------------
C:\Users\Home>set ORACLE_HOME=F:\app\Home2\product\11.2.0\dbhome_1
C:\Users\Home>SET ORACLE_SID=ORCL
C:\Users\Home>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 3 23:32:18 2011
Copyright (c) 1982, 2010, 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\Home>oradim -start -sid XE
C:\Users\Home>sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Sun Dec 4 00:08:27 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 64086720 bytes
Fixed Size 137492 bytes
Variable Size 21313364 bytes
Database Buffers 41930400 bytes
Redo Buffers 556464 bytes
Database mounted.
Database opened.
SQL> conn sys@orcl as sysdba
Enter password:
Connected.
SQL>
Your suggestions and queries are always warm welcomed.
