This discussion is archived
3 Replies Latest reply: Apr 5, 2012 8:31 AM by user392378 RSS

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

user392378 Explorer
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Explorer
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points