1 2 Previous Next 20 Replies Latest reply: Jan 24, 2014 7:15 PM by himmy Go to original post RSS
      • 15. Re: listener error
        Baris Yildirim

        Before starting listener, open another shell and issue below command

         

        the first shell

        tail -100f /u01/app/oracle/diag/tnslsnr/dba/listener/log/listener.log

         

        and then

         

        the second shell

        lsnrctl start

         

        and post the first shell's output

         

        regards

        • 16. Re: listener error
          sdba

          use ps -ef|grep -i tns command on shell

          and post the status

          • 17. Re: listener error
            EdStevens

            b40c1b16-6ffd-4d0b-b97a-ac65a0416239 wrote:

             

            [oracle@dba admin]$ cat listener.ora

            #Listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.ora

            # Generated by Oracle configuration tools.

             

             

            LISTENER =

              (DESCRIPTION_LIST =

                (DESCRIPTION =

                  (ADDRESS = (PROTOCOL = TCP)(HOST = dba.oracle.com)(PORT = 1521))

                )

              )

            SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=orcl) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2) ) )

            SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=prac) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2) ) )

            SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=mac) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2) ) )

             

             

            You should have only one SID_LIST_ section, with multiple SID_DESC sub-sections.

             

            But you'd probably be better of with no listener.ora at all.  With no listener.ora, the listener will happily start will all default values, and the multiple instances can each register themselves with the listener.

            • 18. Re: listener error
              Gayu0726

              You can register multiple instances to single listener. Try using below listener entry in  your file and restart your listener.

               

              LISTENER =

                (DESCRIPTION_LIST =

                  (DESCRIPTION =

                    (ADDRESS = (PROTOCOL = TCP)(HOST = dba.oracle.com)(PORT = 1521))

                  )

                )

              SID_LIST_LISTENER=

              (SID_LIST=

                (SID_DESC=

                (SID_NAME=orcl)

                (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2)

                )

                (SID_DESC=

                (SID_NAME=prac)

                (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2)

                )

                (SID_DESC=

                (SID_NAME=mac)

                (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2)

                )

              )

               

              If you face any issues try using Netca which is graphical user environment and helps you to create the listener.ora file.

              Please let us know, it works for you.

              • 19. Re: listener error
                EdStevens

                Gayu0726 wrote:

                 

                You can register multiple instances to single listener. Try using below listener entry in  your file and restart your listener.

                 

                LISTENER =

                  (DESCRIPTION_LIST =

                    (DESCRIPTION =

                      (ADDRESS = (PROTOCOL = TCP)(HOST = dba.oracle.com)(PORT = 1521))

                    )

                  )

                SID_LIST_LISTENER=

                (SID_LIST=

                  (SID_DESC=

                  (SID_NAME=orcl)

                  (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2)

                  )

                  (SID_DESC=

                  (SID_NAME=prac)

                  (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2)

                  )

                  (SID_DESC=

                  (SID_NAME=mac)

                  (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_2)

                  )

                )

                 

                If you face any issues try using Netca which is graphical user environment and helps you to create the listener.ora file.

                Please let us know, it works for you.

                WHich is what I was trying to get the OP to understand,  But I chose to leave the details as an exercise for the student, given the hint "only one SID_LIST section."

                • 20. Re: listener error
                  himmy

                  Just a small check

                  Can you check the ownership of the files if all are under same oracle owner through which db was installed

                  also can you verify if PATH and home variable are set

                   

                  Thanks

                  Himanshu

                  1 2 Previous Next