Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I have installed Oracle 11g on my Window7 computer; whenever I try to create a connection in Oracle SQL developer I get this error TNS:listener does not currently know of SID given in connect descriptor and after Googling I found that I have first to run this command:

C:\Users\Chris>lsnrctl services

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 22-APR-2012 13:28
:16

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1522)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   32-bit Windows Error: 61: Unknown error

And I also tried to run this command :

C:\Users\Chris>lsnrctl start

LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 22-APR-2012 13:30
:43

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

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Message 279 not found; No message file for product=NETWORK, facility=NL
Message 1074 not found; No message file for product=NETWORK, facility=TNSTNS-125
42: Message 12542 not found; No message file for product=NETWORK, facility=TNS
 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facili
ty=TNS
  TNS-00512: Message 512 not found; No message file for product=NETWORK, facilit
y=TNS
   32-bit Windows Error: 48: Unknown error
    NL-08014: Message 8014 not found; No message file for product=NETWORK, facil
ity=NL     [No valid ADR Base to use
]
     NL-08013: Message 8013 not found; No message file for product=NETWORK, faci
lity=NL

Listener failed to start. See the error message(s) above...

Can anybody help me to fix the problem?

share|improve this question
1  
'No message file' often indicates that your ORACLE_HOME isn't set correctly - either not at all, or pointing to a different installation than the binary you're running from your PATH. Can you check and post the Oracle-related environment? – Alex Poole Apr 22 '12 at 21:10
Do you mean 'tnsnames.ora' file ? – Xris Apr 22 '12 at 23:36
Do you have more than one oracle installations on your computer? – miracle173 Apr 23 '12 at 4:06

migrated from stackoverflow.com Apr 23 '12 at 2:52

1 Answer

up vote 0 down vote

From you command prompt do

echo %ORACLE_HOME%

Windows will list all environment variables. Verify to have ORACLE_HOME set and verift that correctly point to your oracle installation directory. If not (supposed by the error) do:

set ORACLE_HOME=C:\mydir\oracle_inst_dir

Oracle installation dir is the directory where you nistalled oracle. Inside it you will find many directories, as:

apex/
bin/
network/
oui/

(the total number of dirs may vary, anyway they are about 30). For future set directly the oracle home directory inside Win7 user variables or system variables. To have Oracle working you need at least:

ORACLE_HOME
ORACLE_SID
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.