CODEWITHSUNDEEP
oracle-databaseoracle11g
user957654
user957654

Reputation:

Oracle 11 g listener wont start

A few hours earlier I posted this question here that I can't connect my java application to Oracle database , no solutiuon so far.

But after some research I found that the listener is not started , I mean it gives me an error when I try to start the listener through LSNCTRL that says : 

 Message 1070 not found; No message file for product=NETWORK, facility=TNSTNS-125
 60: Message 12560 not found; No message file for product=NETWORK, facility=TNS
 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility
 =TNS

And when I try to see the status of the Listener it says : 

Message 1053 not found; No message file for product=NETWORK, facility=TNSTNS-125
41: Message 12541 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-00511: Message 511 not found; No message file for product=NETWORK, facilit
y=TNS
 32-bit Windows Error: 61: Unknown error

So can someone tell me whats wrong ?

Upvotes: 2

Views: 20371

Answers (2)

malajisi
malajisi

Reputation: 2243

According to @Hankuna Matata's guide. If you run oracle on CentOS or other linux Try to set ORACLE_HOME in user oracle .bash_profile. My .bash_profile located at /home/oracle. Append following lines:

export ORACLE_BASE=/home/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=orcl

Then run the command with user oracle in terminal

$ source .bash_profile
$ lsnrctl start

If you see lines end with "The command completed successfully" instead error message, you got it!

Upvotes: 0

Hakuna Matata
Hakuna Matata

Reputation: 132

Most of these Message not found error due to not setting the ORACLE_HOME properly. Set the ORACLE_HOME properly and see if you still getting this error.

Upvotes: 3

Related Questions