1 2 Previous Next 16 Replies Latest reply on Sep 2, 2010 4:48 PM by EdStevens

    lsnrctl start/stop "message not found" errors

    448226
      When I installed 10g I selected a global database name of 'orcl.clearbean.com' and a sid of 'dev1'. Below are my environment variables, tnsnames.ora file and listener.ora file. I can connect and use the database, but I am getting errors messages when I do a lsnrctl stop/start. I am running Oracle and Apache together on a server running Fedora Core 4 (linux). Any help would be greatly appreciated.

      Supporting information:

      [oracle@emerson ~]$ env | grep ORA
      ORACLE_SID=dev1
      ORACLE_BASE=/u01/app/oracle
      ORACLE_TERM=xterm
      ORACLE_HOME=/u01/app/oracle/product/10.1.0/db_1
      [oracle@emerson ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora
      # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.1.0/db_1/network/admin/tnsnames.ora
      # Generated by Oracle configuration tools.

      ORCL =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = emerson.clearbean.com)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.clearbean.com)
      )
      )

      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
      )
      )

      [oracle@emerson ~]$ cat $ORACLE_HOME/network/admin/listener.ora
      # listener.ora Network Configuration File: /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
      # Generated by Oracle configuration tools.

      SID_LIST_LISTENER =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1)
      (PROGRAM = extproc)
      )
      )

      LISTENER =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = emerson.clearbean.com)(PORT = 1521))
      )
      )
      )

      [oracle@emerson ~]$ lsnrctl stop

      LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 07-OCT-2005 01:19:22

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

      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: 2: No such file or directory
      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
      [oracle@emerson ~]$ lsnrctl start

      LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 07-OCT-2005 01:19:30

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

      Message 1070 not found; No message file for product=network, facility=TNSTNSLSNR for Linux: Version 10.1.0.2.0 - Production
      Message 459 not found; No message file for product=network, facility=NL
      Message 279 not found; No message file for product=network, facility=NL
      Message 1073 not found; No message file for product=network, facility=TNSMessage 1073 not found; No message file for product=network, facility=TNS
      Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 not found; No message file for product=network, facility=TNSMessage 1022 not found; No message file for product=network, facility=TNSMessage 1023 not found; No message file for product=network, facility=TNSMessage 1026 not found; No message file for product=network, facility=TNSMessage 1034 not found; No message file for product=network, facility=TNSMessage 1024 not found; No message file for product=network, facility=TNSMessage 1025 not found; No message file for product=network, facility=TNSMessage 1040 not found; No message file for product=network, facility=TNSMessage 1033 not found; No message file for product=network, facility=TNSMessage 1028 not found; No message file for product=network, facility=TNSMessage 1415 not found; No message file for product=network, facility=TNS Message 1050 not found; No message file for product=network, facility=TNS
      Message 1050 not found; No message file for product=network, facility=TNS
      Message 1029 not found; No message file for product=network, facility=TNSMessage 1411 not found; No message file for product=network, facility=TNS
      Message 1408 not found; No message file for product=network, facility=TNS
      Message 1052 not found; No message file for product=network, facility=TNS[oracle@emerson ~]$
        • 1. Re: lsnrctl start/stop "message not found" errors
          277993
          Check where your TNS_ADMIN is pointing if you have set any

          echo $TNS_ADMIN

          If not set or looking at the wrong place then

          TNS_ADMIN=/u01/app/oracle/product/10.1.0/db_1/network/admin
          export TNS_ADMIN
          • 2. Re: lsnrctl start/stop "message not found" errors
            oradba
            Do you have an activated firewall? (Because of this mysterious Linux Error: 111: Connection refused)
            • 3. Re: lsnrctl start/stop "message not found" errors
              448226
              Thx for the feedback; however after defining TNS_ADMIN and turning of the firewall I am still getting the message errors. Any other suggestions?

              [oracle@emerson ~]$ ls $ORACLE_HOME
              admin emerson.clearbean.com_dev1 ldap oraInst.loc sqlj
              assistants flash_recovery_area lib ord sqlplus
              bin has md oui srvm
              cdata hs mesg owm sysman
              cfgtoollogs install mgw perl uix
              config install.platform network plsql ultrasearch
              css inventory nls precomp wwg
              ctx javavm oc4j racg xdk
              dbs jdbc olap rdbms
              demo jdk OPatch relnotes
              diagnostics jlib opmn root.sh
              dm jre oracore slax
              [oracle@emerson ~]$ ls $TNS_ADMIN
              listener.ora samples sqlnet.ora tnsnames.ora.orig
              listener.ora.orig shrept.lst tnsnames.ora
              [oracle@emerson ~]$ lsnrctl stop

              LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 07-OCT-2005 22:43:44

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

              Message 1053 not found; No message file for product=network, facility=TNSMessage 1052 not found; No message file for product=network, facility=TNS[oracle@emerson ~]$ lsnrctl start

              LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 07-OCT-2005 22:43:51

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

              Message 1070 not found; No message file for product=network, facility=TNSTNSLSNR for Linux: Version 10.1.0.2.0 - Production
              Message 459 not found; No message file for product=network, facility=NL
              Message 279 not found; No message file for product=network, facility=NL
              Message 1073 not found; No message file for product=network, facility=TNSMessage 1073 not found; No message file for product=network, facility=TNS
              Message 1053 not found; No message file for product=network, facility=TNSMessage 1020 not found; No message file for product=network, facility=TNSMessage 1021 not found; No message file for product=network, facility=TNSMessage 1022 not found; No message file for product=network, facility=TNSMessage 1023 not found; No message file for product=network, facility=TNSMessage 1026 not found; No message file for product=network, facility=TNSMessage 1034 not found; No message file for product=network, facility=TNSMessage 1024 not found; No message file for product=network, facility=TNSMessage 1025 not found; No message file for product=network, facility=TNSMessage 1040 not found; No message file for product=network, facility=TNSMessage 1033 not found; No message file for product=network, facility=TNSMessage 1028 not found; No message file for product=network, facility=TNSMessage 1415 not found; No message file for product=network, facility=TNS Message 1050 not found; No message file for product=network, facility=TNS
              Message 1050 not found; No message file for product=network, facility=TNS
              Message 1029 not found; No message file for product=network, facility=TNSMessage 1411 not found; No message file for product=network, facility=TNS
              Message 1408 not found; No message file for product=network, facility=TNS
              Message 1052 not found; No message file for product=network, facility=TNS[oracle@emerson ~]$
              • 4. Re: lsnrctl start/stop "message not found" errors
                448226
                I deleted my listner log and tried to restart the listener. Here are the log contents:

                [oracle@emerson log]$ cat listener.log

                TNSLSNR for Linux: Version 10.1.0.2.0 - Production on 07-OCT-2005 22:56:31

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

                Message 459 not found; No message file for product=network, facility=NL
                Message 279 not found; No message file for product=network, facility=NL
                Message 509 not found; No message file for product=network, facility=NL
                Message 510 not found; No message file for product=network, facility=NL

                Message 1081 not found; No message file for product=network, facility=TNSMessage 1073 not found; No message file for product=network, facility=TNSMessage 1073 not found; No message file for product=network, facility=TNSMessage 1097 not found; No message file for product=network, facility=TNS
                Message 1095 not found; No message file for product=network, facility=TNS
                [oracle@emerson log]$
                • 5. Re: lsnrctl start/stop "message not found" errors
                  448226
                  Just an additional note.... the database is functional. I can access it locally and use oci calls with PHP. Just do not understand what I keep getting the message errors.
                  • 6. Re: lsnrctl start/stop "message not found" errors
                    oradba
                    Can you now use the listener? I searched for the message numbers - from your last listener log - in the error messages manual and found these messages are informational messages, not really error messages. For example
                    TNS-01081: Started with pid=string
                    Cause: Listener starting message.
                    Action: None.
                    or
                    TNS-01097: TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                    Cause: Listener logging message.
                    Action: None.

                    It seems the sqlnet message files are missing from your installation for whatever reason.
                    • 7. Re: lsnrctl start/stop "message not found" errors
                      Kamal Kishore
                      Are your ORACLE_HOME and PATH environment variables pointing to the same oracle software directory?
                      what happens when you start the listener after you do this:
                      $ export PATH=${ORACLE_HOME}/bin:${PATH}
                      $ lsnrctl start
                      ?
                      • 8. Re: lsnrctl start/stop "message not found" errors
                        448226
                        I checked and $ORACLE_HOME/bin is in my PATH. Thx for the suggestion.
                        • 9. Re: lsnrctl start/stop "message not found" errors
                          Kamal Kishore
                          It may be that either you had some issues with your installation or that your environment is not setup correctly for the ORACLE_HOME that you are using. Did you check your installer log files to see if there were any errors/warnings?

                          See below, if for instance, I had my Oracle Home not set correctly, I get similar errors as you are getting:
                          $ lsnrctl

                          LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-OCT-2005 21:32:54

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

                          Welcome to LSNRCTL, type "help" for information.

                          LSNRCTL> exit
                          $
                          $ unset ORACLE_HOME
                          $
                          $ lsnrctl

                          LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 08-OCT-2005 21:33:05

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

                          Message 850 not found; No message file for product=network, facility=NL
                          LSNRCTL>
                          • 10. Re: lsnrctl start/stop "message not found" errors
                            309026
                            Dear sir
                            I found this stupid erro!!
                            if u r copy a oracle auto-start script below some where like me!
                            check this two command !!
                            Here is the demon($ORA_OWNR)

                            su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl start"
                            su - $ORA_OWNER -c $ORA_HOME/bin/dbstart

                            su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl stop"
                            su - $ORA_OWNER -c $ORA_HOME/bin/dbshut

                            #!/bin/sh
                            # oracle
                            # Set ORA_HOME to be equivalent to the ORACLE_HOME
                            # from which you wish to execute dbstart and
                            # dbshut
                            # set ORA_OWNER to the user id of the owner of the
                            # Oracle database in ORA_HOME

                            ORACLE_BASE=/opt/oracle
                            ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1
                            ORA_OWNER=oracle

                            case "$1" in
                            'start')


                            # Start the Oracle databases:
                            # The following command assumes that the oracle login will not prompt the

                            # user for any values
                            echo -n "Starting Oracle: "
                            su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl start"
                            su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
                            touch /var/lock/subsys/oracle
                            echo
                            ;;

                            'stop')

                            # Stop the Oracle databases:
                            # The following command assumes that the oracle login will not prompt the

                            # user for any values
                            echo -n "Shutting down Oracle: "
                            su - $ORA_OWNR -c "$ORA_HOME/bin/lsnrctl stop"
                            su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
                            rm -f /var/lock/subsys/oracle
                            echo
                            ;;

                            'restart')

                            # Restart the Oracle databases:
                            echo -n "Retarting Oracle: "
                            $0 stop
                            $0 start
                            echo
                            ;;

                            *)
                            echo "Usage: oracle { start | stop | restart }"
                            exit 1

                            esac
                            exit 0
                            • 11. Re: lsnrctl start/stop "message not found" errors
                              309026
                              forget the previous script! i made mistake again!
                              the work one in my server!
                              #!/bin/sh
                              # oracle
                              # Set ORA_HOME to be equivalent to the ORACLE_HOME
                              # from which you wish to execute dbstart and
                              # dbshut
                              # set ORA_OWNER to the user id of the owner of the
                              # Oracle database in ORA_HOME

                              ORA_BASE=/opt/oracle
                              ORA_HOME=$ORA_BASE/oracle/product/10.2.0/db_1
                              ORA_OWNER=oracle

                              case "$1" in
                              'start')


                              # Start the Oracle databases:
                              # The following command assumes that the oracle login will not prompt the

                              # user for any values
                              echo -n "Starting Oracle: "
                              su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
                              su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
                              touch /var/lock/subsys/oracle
                              echo
                              ;;

                              'stop')

                              # Stop the Oracle databases:
                              # The following command assumes that the oracle login will not prompt the

                              # user for any values
                              echo -n "Shutting down Oracle: "
                              su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop"
                              su - $ORA_OWNER -c $ORA_HOME/bin/dbshut
                              rm -f /var/lock/subsys/oracle
                              echo
                              ;;

                              'restart')

                              # Restart the Oracle databases:
                              echo -n "Retarting Oracle: "
                              $0 stop
                              $0 start
                              echo
                              ;;

                              *)
                              echo "Usage: oracle { start | stop | restart }"
                              exit 1

                              esac
                              exit 0
                              • 12. Re: lsnrctl start/stop "message not found" errors
                                617378
                                If you already set ORACLE_HOME.
                                Please try to set ORACLE_HOME_LISTNER as following before start listener:

                                ORACLE_HOME_LISTNER=$ORACLE_HOME
                                export ORACLE_HOME_LISTNER

                                Message was edited by:
                                user614375
                                • 13. Re: lsnrctl start/stop "message not found" errors
                                  684646
                                  Please check my post in

                                  http://kishantha.blogspot.com/2009/02/tns-listener-crashes-with-error.html

                                  the error is simply because the ORACLE_HOME environment variable or registry key got over written by some other application installed or is wrong.
                                  • 14. Re: lsnrctl start/stop "message not found" errors
                                    darrellhayward
                                    The ORACLE_HOME is not the bin directory. It is the parent of the bin directory.
                                    For instance, ORACLE_HOME=/d01/oracle/VIS/db/tech_st/10.2.0
                                    is the ORACLE_HOME, not ORACLE_HOME=/d01/oracle/VIS/db/tech_st/10.2.0/bin
                                    1 2 Previous Next