From: davidstacks1964@netscape.net
Date: Wed Feb 09 2005 - 09:19:49 EST
We finally found a fix to the second instace of oracle not starting. See below. Again, thanks to all those who helped.
Here was the solution of the problem …
1. Login as the Oracle software owner and shutdown all database instances on all nodes in
the cluster.
2. cd $ORACLE_HOME/rdbms/lib
3. make -f ins_rdbms.mk rac_on
If this step did not fail with fatal errors then proceed to step 4.
4.. make -f ins_rdbms.mk ioracle
Query from Oracle:-
Why these files were needed to be recompiled. When the database was working fine before shutdown the servers then what probably could have happened all
of a sudden which created this problem. Pls suggest so that we can avoid this type of problems in future.
Reply from Oracle:-
_______________________________________________________________________________________________________
Deepender, I wonder if oracle user's profile has been setup so that oracle user's environment is
setup correctly after reboot, i.e. ORACLE_HOME, ORACLE_SID, etc.
Secondly, either somebody or some script to relink oracle with rac_off option so that the oracle rdbms
software is without RAC option.
In summary, the problem was caused by RAC option being not installed in oracle rdbms software .
Either oracle user's ORACLE_HOME didn't point to a correct ORACLE_HOME after reboot, i.e. it pointed to
a non-RAC oracle_home, or somebody relinked oracle without rac option before reboot, or some script
was run to relink oracle without rac option during reboot.
________________________________________________________________________________
davidstacks1964 wrote:
>Want to thank all those who responded with suggestions.
>
>After working with HP Support and Oracle Support, the problem has never been solved. We have found no configuration problems with the cluster, nor Oracle. Our DBA's are now looking at upgrading the oracle software.
>
>Again thanks to all.
>
>
>
>davidstacks1964 wrote:
>
>>Hello to all.
>>
>>
>>
>>I know this is related to Oracle, but am hoping someone has seen this problem before.
>>
>>
>>
>>I have a 2 node cluster using GS80 servers running Tru64 UNIX Version 5.1B and Oracle 9i RAC.
>>
>>
>>
>>The problem I am seeing started after the servers had been shutdown for a week because of the hurricane that went through New Orleans. After all was clear, the servers where brought back up, and minus having to replace the HSG80 batteries, all was well. Until, the DBA’s tried to start Oracle. The problem is that the second instance of Oracle will not start. Just hang’s. They can start Oracle on only one node, but not both. Starting on either node does not seem to matter.
>>
>>
>>
>>I have verified my kernel settings with Oracle 9i Real Application Cluster (RAC) on Compaq Tru64 UNIX Installation Guide, and all settings are correct.
>>
>>
>>
>>Then systems are not logging any errors, nor is Oracle logging any errors. If anyone has seen this happen before, please let me know.
>>
>>
>>
>>Also, is there a way to have the system log more information to the /var/adm/messages file?
>>
>>
>>
>>Thanks,
>>
>>
>>
>>David W. Stacks
>>
>>Entergy Services, Inc.
>>
>>Analyst - System Management
>>
>>External: 870-543-5436
>>
>>Internal: 8-760-5436
>>
>>dstacks@entergy.com
>>
>>
>>
>>
>>__________________________________________________________________
>>Switch to Netscape Internet Service.
>>As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
>>
>>Netscape. Just the Net You Need.
>>
>>New! Netscape Toolbar for Internet Explorer
>>Search from anywhere on the Web and block those annoying pop-ups.
>>Download now at http://channels.netscape.com/ns/search/install.jsp
>>
>
>__________________________________________________________________
>Switch to Netscape Internet Service.
>As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
>
>Netscape. Just the Net You Need.
>
>New! Netscape Toolbar for Internet Explorer
>Search from anywhere on the Web and block those annoying pop-ups.
>Download now at http://channels.netscape.com/ns/search/install.jsp
>
__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register
Netscape. Just the Net You Need.
New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:50:15 EDT