A fresh view on Oracle
Today I ran into an add-on for FireFox which can create a wget command from a download file dialog box. First thing that came in mind was; Will this work for Metalink / My Oracle Support? Yes is does!
The add-on is called ‘cliget’ and can be downloaded here: cliget add-on for FireFox.
[Read the rest of this entry...]
The Oracle Database version compatibility matrix and version support matrix are almost mandatory when installing or upgrading clients or servers.
Oracle calls this Client / Server Interoperability Support, Note ID 207303.1
Oracle calls this the Database Releases Support Status Summary, Note ID 161818.1
You will be redirected to Oracle Support and you must be registered to gain access to the pages. I did not include the matrices, because these change over time.
Yesterday, I came across a small problem with an Oracle RAC installation using ASM. After a restart of one of the three (Windows Server 2003) nodes, three of the five database instances did not start automatically…
Running ‘crs_stat’ showed status OFFLINE and target ONLINE for these instances, but strangely there was no entry in the alert log telling these instances did not start because of ’something’ was wrong. It even looked like that they did not got any signal to start at all! OK, so I checked the CRS log for any strange behavior and it showed ASM finishing after the database instances gave up starting.
A quick search on the ‘new and improved’ My Oracle Support (old Metalink), resulted in running ‘crs_stat -p’ and check for [REQUIRED_RESOURCES=] for each instance. It showed that for the particular node, ASM was not required for these three database instances. Modifying this with ’srvctl modify instance -d db1 -i node1 -s +ASM1′ (for example), did the trick.
I found this solution on Metalink: Doc ID: NOTE:276208.1 “CRS is not starting first the ASM instance”, although I can not imagine hitting this bug on 10.2.0.4.
Happy consulting!