Sunday, 26 May 2013

TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS

problem: 
             Message 1053 not found; No message file for product=network, facility=TNSTNS-12541:         Message 12541 not found; No message file for product=network, facility=TNS
           TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
          TNS-00511: Message 511 not found; No message file for product=network, facility=TNS
         Linux Error: 111: Connection refused

solution: 
              set below variable on OS  level :
    #export ORACLE_SID=<oracle db name>
    #export ORACLE_HOME=<oracle_home> <take oracle home location from /etc/oratab file>
    #export PATH=/usr/sbin:$PATH
     #export PATH=$ORACLE_HOME/bin:$PATH 
   
          then run the command which giving the error after execution.

  
 

3 comments:

  1. Thanks a ton Ravindra. I was struggling for last 12 hours and tried many things. Setting PATH for /usr/sbin worked for me. After listener configuration, listener was not coming up. I was seeing below error when tring to start the listener:

    TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS


    Many Many thanks for the help. :) :)

    ReplyDelete
  2. thank you so much, you save my semester

    ReplyDelete