Take the 2-minute tour ×
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.

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
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
comments disabled on deleted / locked posts

migration rejected from stackoverflow.com Dec 18 '13 at 12:25

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Jack Douglas Dec 18 '13 at 12:25

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Jack Douglas
If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

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
add comment