1 2 3 4 Previous Next 46 Replies Latest reply: Sep 14, 2010 5:14 AM by User808563-Oracle RSS

    about listener mistake,please help me!!

    496990
      I installed oracle10g on RHEL4 successfuly(ship.db.lnx32.cpio).But I get errors when I execute lsnrctl:
      [oracle@biodb1 product]$ lsnrctl

      LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 09-MAR-2006 15:01:56

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

      Message 850 not found; No message file for product=network, facility=NL
      I checked the $ORACLE_HOME is alright,and the user's permission is enough.
      I am not sure how to fix them,please help me,thank you!
        • 1. Re: about listener mistake,please help me!!
          Paul M.
          Are you sure ORACLE_HOME is set correctly ?
          $ lsnrctl

          LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 09-MAR-2006 09:35:04

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

          Welcome to LSNRCTL, type "help" for information.

          LSNRCTL> exit
          $ export ORACLE_HOME=/something_else
          $ lsnrctl

          LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 09-MAR-2006 09:35:27

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

          Message 850 not found; No message file for product=network, facility=NL
          LSNRCTL>
          • 2. Re: about listener mistake,please help me!!
            496990
            yes,I am sure.There is the content of .bash_profile
            # .bash_profile

            # Get the aliases and functions
            if [ -f ~/.bashrc ]; then
            . ~/.bashrc
            fi

            # User specific environment and startup programs
            export ORACLE_BASE=/home/oracle
            export ORACLE_HOME=$ORACLE_BASE/product/10.1/db_1
            export ORACLE_SID=orcl
            export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
            export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
            export LC_CTYPE=en_US.UTF-8
            export ORA_NLS10=$ORACLE_HOME/nls/data
            export ORAENV_ASK=NO
            export LD_ASSUME_KERNEL=2.4.19

            unset USERNAME

            Message was edited by:
            user493987
            • 3. Re: about listener mistake,please help me!!
              Paul M.
              Do other Oracle products work (e.g. Sql*Plus) ?
              • 4. Re: about listener mistake,please help me!!
                496990
                sqlplus is ok,some other program else?
                • 5. Re: about listener mistake,please help me!!
                  Paul M.
                  No need of other programs, if sqlplus works, then it means that environment variables are correctly set .

                  When you get the error you should get the lsnrctl prompt too. What happens if you type "start" ?
                  • 6. Re: about listener mistake,please help me!!
                    496990
                    when I type start,errors below:
                    LSNRCTL> start
                    Message 1070 not found; No message file for product=network, facility=TNSTNSLSNR for Linux: Version 10.1.0.3.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 1074 not found; No message file for product=network, facility=TNSTNS-12542: Message 12542 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-00512: Message 512 not found; No message file for product=network, facility=TNS
                    Linux Error: 98: Address already in use

                    Message 1080 not found; No message file for product=network, facility=TNS
                    • 7. Re: about listener mistake,please help me!!
                      18622
                      Could it be that someone played with one of the Oracle error message files? I don't have access to Unix currently, but on Windows they are stored under network\mesg (for the networking-related error message files) and rdbms\mesg (for the database-related messages). It sounds like one of them got renamed, corrupted or deleted. If you have access to another server with the same OS and Oracle version, maybe you can compare the file names and sizes, to see if anything in these folders look different.

                      Daniel
                      • 8. Re: about listener mistake,please help me!!
                        164995
                        It is definitely a issue with ORACLE_HOME.

                        Check your $ORACLE_HOME

                        once logged in $echo $ORACLE_HOME
                        ls $ORACLE_HOME
                        • 9. Re: about listener mistake,please help me!!
                          496990
                          thank you Daniel
                          i have reinstalled oracle third times ,so i think the file should not be renamed,corrupted or deleted
                          do you have any other suggestions?
                          • 10. Re: about listener mistake,please help me!!
                            Hans Forbrich
                            Please do the following and paste the console session:

                            set | grep -i ora
                            • 11. Re: about listener mistake,please help me!!
                              496990
                              the content when i execute "set | grep -i ora":
                              HISTFILE=/home/oracle/.bash_history
                              HOME=/home/oracle
                              LD_LIBRARY_PATH=/home/oracle/product/10.1/db_1/lib:/usr/lib
                              LOGNAME=oracle
                              MAIL=/var/spool/mail/oracle
                              ORACLE_BASE=/home/oracle
                              ORACLE_HOME=/home/oracle/product/10.1/db_1
                              ORACLE_SID=orcl
                              PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:/home/oracle/product/10.1/db_1/bin
                              PWD=/home/oracle
                              USER=oracle
                              • 12. Re: about listener mistake,please help me!!
                                Paul M.
                                Linux Error: 98: Address already in use
                                That's strange. Could you post your listener.ora ?

                                If you use host name within listener.ora, you could try to change it to IP address.
                                • 13. Re: about listener mistake,please help me!!
                                  496990
                                  thank you,Paul,there is the content of listener.ora:
                                  [oracle@biodb1 admin]$ more listener.ora
                                  # listener.ora Network Configuration File: /home/oracle/product/10.1/db_1/networ
                                  k/admin/listener.ora
                                  # Generated by Oracle configuration tools.

                                  LISTENER =
                                  (DESCRIPTION =
                                  (ADDRESS = (PROTOCOL = TCP)(HOST = biodb1.bmi.ac.cn)(PORT = 1521))
                                  )
                                  i have changed HOST to ip address,the error is still exist.
                                  is there any problems about listener.ora?
                                  • 14. Re: about listener mistake,please help me!!
                                    Paul M.
                                    No, no problems with your listener.ora. It was just a thought, due to the error you get, but the problem is not there. Try to rename listener.ora (or move it to another directory) and start the listener : does it change something ?
                                    1 2 3 4 Previous Next