Common lerlerac management commands

Welcome to the Oracle community forum and interact with 2 million technical staff. 1. You can configure some Oracle variables.

Welcome to the Oracle community forum and interact with 2 million technical staff> enter 1. you can configure the Oracle variable export ORACLE_BASE =/u01/app/oracle export ORACLE_HOME =/u01/app/oracle/product/11.1.0/db_1 export ORACLE_SID = NEWRAC2 ORACLE_HOSTNAME = "newrac01.hq. lumigen

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

1. Some Oracle variables can be configured

Export ORACLE_BASE =/u01/app/oracle

Export ORACLE_HOME =/u01/app/oracle/product/11.1.0/db_1

Export ORACLE_SID = NEWRAC2

ORACLE_HOSTNAME = "newrac01.hq.lumigent.int"

Export PATH =/u01/app/oracle/product/11.1.0/db_1/bin: $ PATH

Export ORA_CRS_HOME =/u01/app/crs/product/11.1.0/crs

Export PATH =/u01/app/crs/product/11.1.0/crs/bin: $ PATH

Export ORACLE_USER = orarac

2. crsctl, check crs

Crsctl check crs status

Crsctl start crs

Crsctl stop crs

Crsctl check crsd

Crs_stat-t

Etc. The/etc/init. d/init. crs stop/etc/init. d/init. crsd stop, etc. If

If you find that crs is not working properly, you can check and debug these scripts and check whether the process is normal.

The crs startup log can be found under $ ORA_CRS_HOME/log/client. If an error occurs, check the corresponding log.

3. srvctl start the database and instance

Srvctl start database-d NEWRAC start database named NEWRAC

View the status of the current database

[Root @ newrac02 ~] # Srvctl status database-d NEWRAC

Instance NEWRAC1 is running on node newrac01

Instance NEWRAC2 is running on node newrac02

Srvctl start instance-d NEWRAC-I newrac1 start an instance

4. Check the rac configuration file and find the database name.

/U01/oradata/NEWRAC/spfileNEWRAC. ora

/U01/app/oracle/admin/NEWRAC/pfile/init. ora.5302010204445

Additional articles found on the network:

Day-to-day management of Oraclehttp: // www.6api.com/day-to-day-management-of-oracle-10g-rac/

========================================================== ============

Day-to-day management of Oracle 10G RAC

CRS management

RnCRSCTL command control of the CRS Services local node (Oracle clusterware processes)

Rn stop CRS:

Rn $ crsctl stop crs or

Rn $/etc/init. crs stop or

Rn$ crs_stop-all

Rn start CRS:

Rn $ crsctl start crs or

Rn $/etc/init. crs start

Rn prohibited Clusterware restart automatically at system startup methods:

Rn $/etc/init. crs disable

Rn start Clusterware restart automatically at system startup methods:

Rn $/etc/init. crs enable

Rn view the status CRS Services

Rn $ crsctl check crs

RnOCR resource management

RnOCR resources, when the RAC cluster up and running successfully, you can use the instrument crs_stat see the following:

Rn $ ORA_CRS_HOME/bin/crs_stat

Rn general, the status of all resources shoshould be online. in addition, OCR will be four hours each to back up first. have some cases you can restore the OCR configuration file to restore problems OCR.

Rn such as the use of the following situations occur:

Rn$ crs_stat-t

RnCRS-0184: Cannot communicate with the CRS daemon.

Rn $ crsctl check boot

RnFailure 4 at procr_open_key with status 4.

The rnPROC-4: The cluster registry key to be operated on does not exist.

Rn $ crsctl check crs

RnFailure 1 contacting CSS daemon

RnCannot communicate with CRS

RnCannot communicate with EVM

Rn caused this error may be due to a lost OCR configuration. We can use this backup to restore the previous configuration.

[1] [2] [3] [4] [5]