Friday, September 18, 2009

Oracle OEM 10g agent installation into Cluster nodes

There is not much resource available on the net that mentioned about the installation of Oracle 10g agent for grid control into a Cold Failover cluster.
CFC is generally a OS control cluster.

I would discuss about the setup that I have done.

Basically, this was an installation into a Solaris Sparc OS 9 two node using VCS cluster. Oracle Grid control version 10.2.0.5. Oracle Database Enterprise 10.2.0.3.

I installed through GUI using runInstaller.

I have tried about almost 10 times all in all until the last one manage to get it up monitored by OMS.

The trick is...

1. export ORACLE_HOSTNAME=logical-hostname

2. cd /source
where source is the installation files for oracle 10g agent 10.2.0.5

3.
Instead of just ./runInstaller

use this

./runInstaller -invPtrLoc /var/opt/oracle/oraInst.loc ORACLE_HOME=/u01/app/oracle/product/agent10g/ ORACLE_HOSTNAME=

This will enable the installation of 10g agent to be cluster-aware.

After installation, modify $ORACLE_HOME/sysman/config/emd.properties file
Set
AgentListenOnAllNICs=TRUE
to
AgentListenOnAllNICs=FALSE

Thursday, September 10, 2009

Remove files that is older thatn 7 days in Unix

find . -name "fullfiles*" -type f -mtime +7 -exec rm -f {} \;

where fullfiles is the name of the files (prefix) that you wish to remove

Wednesday, September 9, 2009

Oracle Grid Control 10g

I have setup the Oracle Grid Control 10.2.0.5 "successfully".

Thought everything was working until the notification email alerts is not responding to the metrics. Test email was able to sent out and received. Metrics will triggered and appearing in the "Alerts" of the grid control web page. However no email.

Finding resource in web found in metalink.
356774.1

SOLUTION
1. Log on to sqlplus as the SYSMAN user on the repository database and run the following commands:

SQL> exec emd_maintenance.remove_em_dbms_jobs -- to tidy up any broken jobs
SQL> exec emd_maintenance.submit_em_dbms_jobs

Presto!

Prior this I did downloaded the EMDiagkit (356774.1)
./repvfy verify notifications -level 9

OR

./repvfy verify -level 9

for all modules verification.


Cool!

Monday, September 7, 2009

Henderson waves

From hort park, we took a bridge walk upwards...Still another 2km (approx 30mins) for us to get to Henderson waves.

We parked our car at Kent Ridge Park B, started our journey there. Walked past a bridge downslope to Hort Park.

More info at http://www.visitsingapore.com/publish/stbportal/en/home/what_to_see/parks___nature_reserves/Southern_Ridges.html

There walked another 20mins to arrive the Alexandra Arch. (see pic).

From here upward moves, another 30mins or so before arriving Henderson waves...

X Windows

To enable X windows in my Windows XP connecting to a unix server, I did the following:-

1. Download Cygwin. It's a small setup.exe file. From there you configure the component that you required. In this case, the X windows and ssh.

2. After the installation has completed, click on Cygwin.exe

3. type > startx

4. In the terminal windows, ksh> xhost +

5. In your windows XP services, stop the firewall, else windows won't pop up.
Windows Firewall/Internet Connection Sharing (ICS)

6. export DISPLAY=IPaddress:0.0

IPaddress: is your local ip

eg: export DISPLAY=10.1.1.1:0.0

7. ssh to the remote box and launch the GUI.

Presto!

Saturday, September 5, 2009

Toyota Borneo motors leng kee service

Booked for my vios 10K km service in leng kee today for the 11am slot.  Arrived there at 1045. Was told by the service lady that mine is not an express service as I did not  choose for the express service online. 

I can't recall whether if I have chose express or not but isn't the normal usual 10000km service shd be an express one?  Then to further delay, she said between 12 till 1pm no service as it is lunch hour.  Which means the service only starts aft 1pm.  And I might only able to collect my car then. 

Had I known this I would have booked an earlier slot or won't take up the 11 slot.    

Sent from my iPhone


Friday, September 4, 2009

Oracle 10g 10.2.0.5 Grid Control

To install Oracle 10g Grid Control 10.2.0.5, the latest at this point of writing, one has to install the base version 10.2.0.1 and upgrade to 10.2.0.5 later.

I have tried using GUI tool ./runInstaller

The sequence is to install base, this will create a OMS, repository, and agent

Next, upgrade to 10.2.0.5 for the base (this take abt 2 hours). Then upgrade agent.

A tip is to turn off archive logs while performing installation.