3 Replies Latest reply: Apr 5, 2012 10:31 AM by user392378 RSS

    AIX 64 Bit - Oracle 11.2.0.3 Installation/Upgrade - 10.2/11.1

    user392378
      AIX 64 Bit
      Oracle 11gR2 - 11.2.0.3

      As part of the 11gR2 install, you are asked to select DBA and DBOPER owners. How is this determined/verified selected properly?

      Also, migrating DB's: Ran the dbupgdiag.sql and utlu112i_3.sql

      Should we enable 11.2 listener first?

      or

      Should we migrate all DB's, then do listener or can we try one DB with new listener then move the rest and then change to the 11.2.0.3 LSNR?

      Is there a best practice here?
        • 1. Re: AIX 64 Bit - Oracle 11.2.0.3 Installation/Upgrade - 10.2/11.1
          orafad
          JHodges0529 wrote:
          As part of the 11gR2 install, you are asked to select DBA and DBOPER owners. How is this determined/verified selected properly?
          Do you mean OSDBA and OSOPER groups?
          Documented in the Installation guides.
          http://www.oracle.com/pls/db112/portal.portal_db?selected=11&frame=


          It might be a good idea to put your other question about upgrade in a different thread, maybe in the {forum:id=583} forum.
          • 2. Re: AIX 64 Bit - Oracle 11.2.0.3 Installation/Upgrade - 10.2/11.1
            Helios-GunesEROL
            Hi;
            As part of the 11gR2 install, you are asked to select DBA and DBOPER owners. How is this determined/verified selected properly?
            Its already mention at installation guide. What is purpose of those groups, what you should choose etc.
            Also, migrating DB's: Ran the dbupgdiag.sql and utlu112i_3.sql
            Should we enable 11.2 listener first?
            or
            Should we migrate all DB's, then do listener or can we try one DB with new listener then move the rest and then change to the 11.2.0.3 LSNR?
            You should go wiht first db upgrade. Than you can go wiht listener. As suggestion here by orafad that issue is related wiht db upgrade soo make post on related forum site

            Regard
            Helios
            • 3. Re: AIX 64 Bit - Oracle 11.2.0.3 Installation/Upgrade - 10.2/11.1
              user392378
              Yes, we upgraded 3 DB's so far, added a second listener in the new home and moving forward.

              However, DBUA adds LISTENER_SID to initSID.ora and TNSNAMES.ora.

              After the upgrade we have to shutdown the DB, change the initSID.ora and remove/remark out the TNSNAMES.ora with the correct Listener (say LISTENER2).

              INITSID.ORA

              local_listener=listener_listener2 - DBUA adds =listener_SID

              TNSNAMES.ORA

              LISTENER_SID....info

              remove this because:

              LISTENER_LISTENER2....info is already there.

              I can make this a new thread if needed.