Oracle Faq

Hi All,

I would like to discuss the most common error which is encountered by many people who are new to oracle database on Windows systems.This error is

  ORA-12560: TNS:protocol adapter error

The above error occurs whenever you try to start the database on windows without starting the Oracle Service of that particular database as shown

C:\>set oracle_sid=test

C:\>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 15 11:59:37 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:

So, To solve the above error and to start the database on windows try to follow the following steps

1) Start the Oracle services for database from the windows service panel. To open the services panel go to start–> Run–> type services.msc and press enter

 2) Once the services is started you can open the command prompt and start the database as shown

 C:\>set oracle_sid=test

C:\>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 15 12:33:28 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  289406976 bytes
Fixed Size                  1248600 bytes
Variable Size             100663976 bytes
Database Buffers          184549376 bytes
Redo Buffers                2945024 bytes
Database mounted.
Database opened.

Share This