We help IT Professionals succeed at work.
Get Started

I am getting below error on windows 7 oracle database

Skumar29oct
Skumar29oct asked
on
1,931 Views
Last Modified: 2014-05-14

Hi,

I am getting below error while connecting to my oracle database 11g on windows 7 after restarting my laptop. How ever I was able to connect before restart.
======
C:\Users\Sanjay.Kumar>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 3 17:51:06 2011

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

ERROR:
ORA-12560: TNS:protocol adapter error


Enter user-name:
=========


Additional information.

1. I have installed below software on the same laptop.
 A. 11g client with 32 bit OS.
 B. 11g DB (EE) with 64 bit OS.
 C. SQL Developer 32 bit
3. This laptop is also having ERStudio 32 bit.
===========

I have tried setting
 A. set oracle_sid=DB_NAME
 B. set local=DB_NAME

=======
I have checked listener is up and running.
------------
C:\Users\Sanjay.Kumar>lsnrctl status

LSNRCTL for 64-bit Windows: Version 11.1.0.6.0 - Production on 03-NOV-2011 17:50:58

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.1.0.6.0 - Production
Start Date                03-NOV-2011 16:19:09
Uptime                    0 days 1 hr. 31 min. 49 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   C:\app\Sanjay.Kumar\product\11.1.0\db_1\network\admin\listener.ora
Listener Log File         c:\app\sanjay.kumar\diag\tnslsnr\LONLT1098W\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LONLT1098W)(PORT=1521)))
Services Summary...
Service "sanjay" has 1 instance(s).
  Instance "sanjay", status READY, has 1 handler(s) for this service...
Service "sanjayXDB" has 1 instance(s).
  Instance "sanjay", status READY, has 1 handler(s) for this service...
Service "sanjay_XPT" has 1 instance(s).
  Instance "sanjay", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\Users\Sanjay.Kumar>sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 3 17:51:06 2011

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

ERROR:
ORA-12560: TNS:protocol adapter error

Comment
Watch Question
Commented:
This problem has been solved!
Unlock 12 Answers and 30 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE