Thursday, February 20, 2014

Thursday, February 13, 2014

Solaris !0: How to start oracle11g with SPFILE in vcs main.cf

Below are task need to be performed.

1.       Edit cvs config file main.cf

Remove parameter Pfile from ORA_oraserver resources

Pfile = /opt/oracle/10.2.0.4_EE/dbs/initDS.ora


2.       Start vcs agent on node1. Clear any FAULT flags on resources.
3.       Start vcs agent on node2.

4.       Perform vcs failover test

bBy default if no pfile defined, vcs will look into $ORACLE_HOME/dbs ffor file below in sequence

  • SPFILEsid.ora
  • SPFILE.ora
  • initSID.ora


FFYI. hastop -all -force was already ran prior this activity

from

        Oracle ORA_server (
                Sid = DS
                Owner = oracle
                Home = "/opt/oracle/11.2.0.3_EE"
                Pfile = "/opt/oracle/11.2.0.3_EE/dbs/initDS.ora"
                EnvFile = "/tmp/env.sh"
                MonScript = "/opt/VRTSagents/ha/bin/Oracle/SqlTest.pl"

                )

to

        Oracle ORA_server (
                Sid = DS
                Owner = oracle
                Home = "/opt/oracle/11.2.0.3_EE"
                EnvFile = "/tmp/env.sh"
                MonScript = "/opt/VRTSagents/ha/bin/Oracle/SqlTest.pl"

                )

remember to run
#hacf -verify .

f







UNIX: How to print column nicely using printf

[user@hostfwnms1-oam tmp]# cat b.sh printf "%-26s %-19s %-8s %-8s %-s %-s\n" HOSTNAME IP PING SNMPWALK 0-ok 1-fail for i in `cat n...