RAC ons cannot be started

 

The ONS process in the RAC environment of a friend in the DBA group cannot be started. The platform is RedHat 5.3 64bit.

 

ONS log is as follows:

 

09:42:11. 384: [racg] [3041022624] [16815] [3041022624] [ora. rac1.ons]: clsrcexecut: ENV oracle_config_home =/u01/Oracle/product/10.2.0/crs_1

 

09:42:11. 384: [racg] [3041022624] [16815] [3041022624] [ora. rac1.ons]: clsrcexecut: cmd =/u01/Oracle/product/10.2.0/crs_1/bin/racgeut-E _ usr_ora_debug = 0 540/u01/Oracle/product/10.2.0/crs_1/bin/onsctl stop

 

09:42:11. 384: [racg] [3041022624] [16815] [3041022624] [ora. rac1.ons]: clsrcexecut: rc = 99, time = 540.630 s

 

10:55:44. 720: [racg] [1604653728] [18288] [1604653728] [ora. rac1.ons]: Timeout: killed the spawned process

 

10:55:44. 721: [racg] [1604653728] [18288] [1604653728] [ora. rac1.ons]: clsrcexecut: ENV oracle_config_home =/u01/Oracle/product/10.2.0/crs_1

 

10:55:44. 721: [racg] [1604653728] [18288] [1604653728] [ora. rac1.ons]: clsrcexecut: cmd =/u01/Oracle/product/10.2.0/crs_1/bin/racgeut-E _ usr_ora_debug = 0 540/u01/Oracle/product/10.2.0/crs_1/bin/onsctl start

 

10:55:44. 721: [racg] [1604653728] [18288] [1604653728] [ora. rac1.ons]: clsrcexecut: rc = 99, time = 540.410 s

 

10:59:12. 517: [racg] [1604653728] [18288] [1604653728] [ora. rac1.ons]:/u01/Oracle/product/10.2.0/crs_1/bin/onsctl: Line 81: 31584 terminated $ onsadmin Ping

ONS is not running...

 

10:59:12. 517: [racg] [1604653728] [18288] [1604653728] [ora. rac1.ons]: clsrcexecut: ENV oracle_config_home =/u01/Oracle/product/10.2.0/crs_1

 

10:59:12. 517: [racg] [1604653728] [18288] [1604653728] [ora. rac1.ons]: clsrcexecut: cmd =/u01/Oracle/product/10.2.0/crs_1/bin/racgeut-E _ usr_ora_debug = 0 540/u01/Oracle/product/10.2.0/crs_1/bin/onsctl Ping

 

10:59:12. 517: [racg] [1604653728] [18288] [1604653728] [ora. rac1.ons]: clsrcexecut: rc = 1, time = 207.800 s

 

10:59:12. 517: [racg] [1604653728] [18288] [1604653728] [ora. rac1.ons]: End for resource = ora. rac1.ons, Action = start, status = 1, time = 748.230 s

 

10:59:13. 781: [racg] [1366147744] [1357] [1366147744] [ora. rac1.ons]: onsctl: Shutting Down ons daemon...

/U01/Oracle/product/10.2.0/crs_1/bin/onsctl: line 118: 1362 terminated $ onsadmin Shutdown

Onsctl: shutdown of ONS failed!

 

 

 

Crsd. log information is as follows:

 

Timeout for ora. rac1.ons timeout = 600

Start resource error for ora. rac1.ons error code =-2

 

 

The error indicates that the connection times out. In addition, RAC runs normally, but ons processes are large and occupy a large amount of CPU resources, resulting in 100% CPU consumption. This is the production database, so proceed with caution. Add the beans in the dba1 group to the discussion group, which has rich experience in RAC.

 

The Oracle RAC process is sometimes inexplicably abnormal, and the Oracle factory cannot tell. After a friend restarts the server of Node 1, ONS starts normally, and then restarts the node. 2. The friend suspected that the network policy was changed, which has an impact on the system.

 

After the problem is solved, we will talk about it. One of the topics is backup. Backup is more important to databases than anything else. Back up the database, control file, and spfile. These files are important for recovery. Only valid backups can minimize the loss.

 

 

 

 

 

 

------------------------------------------------------------------------------

Blog: http://blog.csdn.net/tianlesoftware

Online Resources: http://tianlesoftware.download.csdn.net

Video: http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx

Dba1 group: 62697716 (full); dba2 group: 62697977 (full)

Dba3 group: 62697850 super DBA group: 63306533;

Chat group: 40132017

-- Add the group to describe the relationship between Oracle tablespace and data files in the remarks section. Otherwise, the application is rejected.