Example: Verify Oracle Application Server

1. Verify the Oracle Application Server 10g Infrastructure.

   Vigor5# zlogin z1
   # su - oracle
   $ $ORACLE_HOME/bin/emctl status iasconsole
   TZ set to GB
   
   Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.0.2
   Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
   http://oas10g.uk.sun.com:1156/emd/console/aboutApplication
   Oracle Enterprise Manager 10g Application Server Control is running.
   ------------------------------------------------------------------
   Logs are generated in directory /ZFSoracle/oraInfra/sysman/log
   $ $ORACLE_HOME/opmn/bin/opmnctl status
   
   Processes in Instance: IAS.oas10g.uk.sun.com
   -------------------+--------------------+---------+---------
   ias-component      | process-type       |     pid | status
   -------------------+--------------------+---------+---------
   LogLoader          | logloaderd         |     N/A | Down
   dcm-daemon         | dcm-daemon         |    6135 | Alive
   DSA                | DSA                |     N/A | Down
   OC4J               | OC4J_SECURITY      |    4781 | Alive
   HTTP_Server        | HTTP_Server        |    4546 | Alive
   OID                | OID                |    4558 | Alive

2. Stop the 10g Infrastructure.

   Perform this step as user oracle in zone z1.

   $ $ORACLE_HOME/bin/emctl stop iasconsole
   $ $ORACLE_HOME/opmn/bin/opmnctl stopall

3. Stop the Oracle Database and Listener.

   Perform this step as user oracle in zone z1.

   $ $ORACLE_HOME/bin/lsnrctl stop
   $ $ORACLE_HOME/bin/sqlplus "/ as sysdba"
   SQL> shutdown immediate
   SQL> quit
   $ exit

4. Relocate the Oracle Application Server logical hostname to zone z2.

   Perform this step as user root in the global zone .

   Vigor5# ifconfig e1000g0 removeif oas10g
   Vigor5# ifconfig e1000g0 addif oas10g up zone z2

5. Relocate the ZFS pool to zone z2.

   Perform this step as user root in the global zone .

   Vigor5# zpool export -f HAZpool4
   Vigor5# zpool import -R /zones/z2/root HAZpool4

6. Start the Oracle Database and Listener in zone z2.

   Vigor5# zlogin z2
   # su - oracle-application-server-userid
   $ $ORACLE_HOME/bin/lsnrctl start
   $ $ORACLE_HOME/bin/sqlplus "/ as sysdba"
   SQL> startup
   SQL> quit

7. Start the Oracle Application Server Infrastructure in zone z2.

   Perform this step as user oracle in zone z2.

   $ $ORACLE_HOME/opmn/bin/opmnctl startall
   $ $ORACLE_HOME/bin/emctl start iasconsole

8. Verify the Oracle Application Server 10g Infrastructure.

   Perform this step as user oracle in zone z2.

   $ $ORACLE_HOME/bin/emctl status iasconsole
   TZ set to GB
   
   Oracle Enterprise Manager 10g Application Server Control Release 10.1.2.0.2
   Copyright (c) 1996, 2005 Oracle Corporation.  All rights reserved.
   http://oas10g.uk.sun.com:1156/emd/console/aboutApplication
   Oracle Enterprise Manager 10g Application Server Control is running.
   ------------------------------------------------------------------
   Logs are generated in directory /ZFSoracle/oraInfra/sysman/log
   $ $ORACLE_HOME/opmn/bin/opmnctl status
   
   Processes in Instance: IAS.oas10g.uk.sun.com
   -------------------+--------------------+---------+---------
   ias-component      | process-type       |     pid | status
   -------------------+--------------------+---------+---------
   LogLoader          | logloaderd         |     N/A | Down
   dcm-daemon         | dcm-daemon         |   14170 | Alive
   DSA                | DSA                |     N/A | Down
   OC4J               | OC4J_SECURITY      |   14054 | Alive
   HTTP_Server        | HTTP_Server        |   14012 | Alive
   OID                | OID                |   14017 | Alive

9. Setup Oracle Database Permissions.

   Perform this step as user oracle in zone z2.

   $ $ORACLE_HOME/bin/sqlplus "/ as sysdba"
   SQL> grant connect, resource to homer identified by springfield;
   SQL> alter user homer default tablespace system quota 1m on system;
   SQL> grant select on v_$sysstat to homer;
   SQL> grant select on v_$archive_dest to homer;
   SQL> grant create session to homer;
   SQL> grant create table to homer;
   SQL> exit;
   $ chmod 6751 $ORACLE_HOME/bin/oracle

10. Stop the Oracle Application Server 10g Infrastructure.

    Perform this step as user oracle in zone z2.

    $ $ORACLE_HOME/bin/emctl stop iasconsole
    $ $ORACLE_HOME/opmn/bin/opmnctl stopall

11. Stop the Oracle Database and Listener.

    Perform this step as user oracle in zone z2.

    $ $ORACLE_HOME/bin/lsnrctl stop
    $ $ORACLE_HOME/bin/sqlplus "/ as sysdba"
    SQL> shutdown immediate
    SQL> quit
    $ exit
    # exit

12. Unplumb the Infrastructure logical IP address .

    Perform this step as user root in the global zone .

    Vigor5# ifconfig e1000g0 removeif oas10g

13. Export the ZFS pool.

    Perform this step as user root in the global zone .

    Vigor5# zpool export -f HAZpool4