Shulou(Shulou.com)06/01 Report--

Oracle 10g rac uses service guide as the cluster foundation software

Related catalog information:

ORA_CRS_HOME=$ORACLE_BASE/10.2/crs

Ocr Information: / dev/vgdata/rrac_ocr_1 640 root:dba

One of the nodes, two disks were damaged, took the mirror made by a hard disk from the other node, changed the host name, and found that the database crs could not be started after IP

Check the crs log

No log is generated, which proves that it did not initiate an operation on crs.

Second, try to start crsctl start crs manually, report an error, crsctl check crs process, find that you can't communicate, check os process, ps-ef | grep-I d.bin, no valuable information, enter / sbin/init.d start

Attempting to start CRS stackFailure at scls_scr_create with code 1Internal Error Information: Category: 1234 Operation: scls_scr_create Location: mkdir Other: Unable to make user dir Dep: 2

Sh-x / sbin/iinit.d start

Check the operating system log:

/ var/adm/messages/sbin/init.d/init.cssd [537]: / var/opt/oracle/scls_scr/rqtmsdb2/root/c***un: Cannot create the specified file.Startup will be queued to init within 30 seconds.

This error is more meaningful, if a file does not exist, then check the directory, it really does not exist, set it up manually

Three, start crs again

Crsctl start crs crsctl check crsCSS appears healthyCRS appears healthyEVM appears healthy

Crs,evmd,cssd started, but listening, database failed to start

Fourth, you can guess the latter reason, because it is mirror, all the node information related to 1 has to be changed to 2, which is more complicated later.

Check alert_jkweb2.log:

Syslog: Cluster Ready Services waiting on dependencies. Diagnostics in / tmp/crsctl

Modify the log file directory under $ORA_CRS_HOME, start crs again, but listen, the database still cannot be started.

Check the listening parameter file: $ORACLE_HOME/network/admin/listener.ora

Manually modify monitoring parameter files, database password files, parameter files

Manually pull up the database

Restart the host and crs cannot be started again. Check service guide:

Cmrunnode-v

Found that pkg1 did not start, manually pull up the package

Cmrunpkg-v-n jkweb1 pkg1

Check:

Cmviewcl checks crs status: cd $ORA_CRS_HOME/bin./crs_stat-t-v

Check the database status:

Srvctl status database-d db_name

Everything's fine. Call it a day.

Sometimes I think service guide is a good thing.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.