1 2 Previous Next 15 Replies Latest reply: Mar 21, 2013 7:27 AM by EdStevens RSS

    Listener configuration and other questions

    998276
      I have installed 2 database instances on the same database and under the same database home.
      The instances use the same listener. If i try to start enterprise manager in browser for both instances,
      the Enterprise Manager starts just for the last installed instance. I have edited the listener.ora file an
      added one more Description with another port number like folowing:

      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = fusion)(PORT = 1522))
      )



      to the following content:

      LISTENER_APPDB =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = fusion)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
      )

      now the file looks like following:


      LISTENER_APPDB =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = fusion)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      )
           (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = fusion)(PORT = 1522))
      )
      )

      ADR_BASE_LISTENER_APPDB = D:\app\oracle2

      SID_LIST_LISTENER_APPDB =
      (SID_LIST =
      (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\app\oracle2\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\app\oracle2\product\11.2.0\dbhome_1\bin\oraclr11.dll")
      )
      )

      i have also changed the port of one of the instances in the tnsnames.ora file from 1521 to 1522.
      Now it is possible to start Enterprise Manager for both instances. But after i connect to one of the
      instances with the Enterprise Manager the other instance logs of. Is it ok so??? Will i have problems
      with this configuration?? Should i do something different??

      Second question: After i have installed an instance, during the installation some patches where
      automaticaly installed. After that i have installed another instance. Do i have to patch this instance too???
      Are the patches installed for the whole DBMS or just for one instance???

      *Third question: If i have 2 instances how can i set the parameter btree_bitmap_plans for only*
      one of the instances ??? I have found the following code to do this:

      ALTER SYSTEM SET "_b_tree_bitmap_plans"=false SCOPE=SPFILE;

      but for wich instance the parameter will be set for both or just for one? Do i have to choose
      one of the instances?? How can i do that??

      Edited by: 995273 on 21.03.2013 02:49
        • 1. Re: Listener configuration and other questions
          Osama_Mustafa
          Now it is possible to start Enterprise Manager for both instances. But after i connect to one of the*
          instances with the Enterprise Manager the other instance logs of. Is it ok so??? Will i have problems
          with this configuration?? Should i do something different??
          You need to use Grid Control to do what you are asking for . but if you need to use enterprise you can logged in using linked provided to you
          emctl status dbconsole
          • 2. Re: Listener configuration and other questions
            Pavan DBA
            one listener cannot listen on two port numbers. you can use only one listener which can listen to n number of databases in a server.

            with same listener, you can configure enterprise manager for both databases. both will work at same time. you said if one EM is working other is not working. can you please let us know the error you are facing?

            regarding your last question, you don't need to do any patching again for secondly created database
            • 3. Re: Listener configuration and other questions
              998276
              Thanks for the reply.

              I have changed everything back, the content of listener.ora, tnsnames.ora and the port numbers. It seems to work now.
              I can browse for both adresses
              https://fusion:1158/em/console
              and
              https://fusion:5500/em/console
              both works.

              *Third question: If i have 2 instances how can i set the parameter btree_bitmap_plans for only*
              one of the instances ??? I have found the following code to do this:

              ALTER SYSTEM SET "_b_tree_bitmap_plans"=false SCOPE=SPFILE;

              but for wich instance the parameter will be set for both or just for one? Do i have to choose
              one of the instances?? How can i do that??

              Edited by: 995273 on 21.03.2013 03:36
              • 4. Re: Listener configuration and other questions
                998276
                D:\>emctl status dbconsole
                Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to da
                tabase unique name.

                Do i need this?? And what for do i need it??
                • 5. Re: Listener configuration and other questions
                  Pavan DBA
                  you can set that for only one instance. As you might be knowing that it is hidden parameter and you should use it only with the recommendation from oracle support.

                  if you want to use it for a specific database, just connect to that database and issue that alter command. To provide you steps, please tell us about OS version and DB version
                  • 6. Re: Listener configuration and other questions
                    Pavan DBA
                    now that your EM is working for both db's. command given by Osman is to check the status of EM
                    • 7. Re: Listener configuration and other questions
                      998276
                      Windows Server 2008 R2, Oracle Database is 11.2.0.3.
                      • 8. Re: Listener configuration and other questions
                        Pavan DBA
                        set oracle_sid=your_db_name

                        then in SQL use below command

                        ALTER SYSTEM SET "_b_tree_bitmap_plans"=false SCOPE=SPFILE;

                        Have you got any recommendation from Oracle Support to use it?
                        • 9. Re: Listener configuration and other questions
                          998276
                          In the Documentation it is sad set the parameter to FALSE. The Database is for Fusion Middleware.
                          Thanks for help!!!
                          • 10. Re: Listener configuration and other questions
                            Pavan DBA
                            you are welcome
                            • 11. Re: Listener configuration and other questions
                              Paul M.
                              one listener cannot listen on two port numbers.
                              Just for the precision : why not ?
                              $ lsnrctl stat snoopy
                              
                              LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 21-MAR-2013 12:37:39
                              
                              Copyright (c) 1991, 2011, Oracle.  All rights reserved.
                              
                              Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora11test)(PORT=1522)))
                              STATUS of the LISTENER
                              ------------------------
                              Alias                     snoopy
                              Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
                              Start Date                21-MAR-2013 12:37:12
                              Uptime                    0 days 0 hr. 0 min. 26 sec
                              Trace Level               off
                              Security                  ON: Local OS Authentication
                              SNMP                      OFF
                              Listener Parameter File   /opt/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
                              Listener Log File         /opt/app/oracle/diag/tnslsnr/ora11test/snoopy/alert/log.xml
                              Listening Endpoints Summary...
                                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora11test)(PORT=1522)))
                                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora11test)(PORT=1525)))
                                (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora11test)(PORT=1527)))
                              The listener supports no services
                              The command completed successfully
                              $
                              • 12. Re: Listener configuration and other questions
                                998276
                                good to know that.
                                Thank you for that reply!!!

                                Is it better to use different ports for different instances???

                                Edited by: 995273 on 21.03.2013 04:32
                                • 13. Re: Listener configuration and other questions
                                  Pavan DBA
                                  Oh! My bad.... in hurry I read and posted it wrong :-(

                                  I mean to say two listeners cannot use same port number, but I have written something different.

                                  Thank You Paul for correcting me
                                  • 14. Re: Listener configuration and other questions
                                    Paul M.
                                    Is it better to use different ports for different instances???
                                    Not necessary, mine was just an example. It might be useful if you need/want to selectively grant/deny access to databases : however, in this case it could be easier having more listeners.
                                    1 2 Previous Next