[Pending] Oracle 10g RAC Reboot Problem

Sometimes one node would be reboot suddenly. Problem not solved…
Reference:
1. [Chinese] http://www.itpub.net/747833.html

CRS Management Commands

To check CRS resource status
$ORA_CRS_HOME/bin/crs_stat –t
For example:
[oracle@rac2 css]$ $ORA_CRS_HOME/bin/crs_stat -t
Name Type Target State Host
————————————————————
ora….CL1.srv application ONLINE ONLINE rac1
ora….CL2.srv application ONLINE ONLINE rac2
ora….TEST.cs application ONLINE ONLINE rac1
ora….L1.inst application ONLINE ONLINE rac1
ora….L2.inst application ONLINE ONLINE rac2
ora.ORCL.db application ONLINE ONLINE rac1
ora….SM1.asm application ONLINE ONLINE rac1
ora….C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application [...]

iSQLPlus in Oracle 10g

Start sqlplus.exe or sqlplusw.exe (windows GUI)
$isqlplusctl start
$isqlplusctl stop
In IE or Firefox:
http://<hostname.domain>:port/isqlplus
Port preset: 5560

Data Guard Workshop

The most important things for data guard configuration:

Listener control files are correctly set up;
Database parameter files are correctly set up;
All data files, control files and parameter files from Primary database are correctly transferred to Standby database.

Note:

It’s not necessary to create a database on Standby server.
On standby server, it only needs files in oradata and admin [...]

LogMiner Workshop

Step 0: LogMiner Tools Installation
Log in as sysdba,
1) create dbms_logmnr package to analyze log files;
SQL>@$ORACLE_HOME/rdbms/admin/dbmslm.sql
2) create dbms_logmnr_d package to create dictionary files.
SQL>@$ORACLE_HOME/rdbms/admin/dbmslmd.sql
Step 1: Edit Parameter File
If you startup database using pfile, edit pfile directly;
If you startup database using spfile,
SQL> create pfile from spfile;
Edit init<SID>.ora and put the following:
utl_file_dir=/u01/app/oracle/admin/<SID>/udump
Step 2: Verify utl parameter
SQL> connect / as [...]