test

Sun Cluster Data Service for Oracle Application Server Guide for Solaris OS

ProcedureExample: 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