[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 [...]

Hostname Change

In doing RAC Workshop, we use VMware to create a server named “rac1″ and then copy all the files as to another server “rac2″. The two servers are the same just after the copy process, including all the IP setting and hostname. We need to change the 2nd server with different hostname.
Change the hostname on [...]

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

Important Things When Installing Linux Server on USB Disk

To practice Dataguard on one machine. You can install two linux servers using VMware. The other settings during the Linux installation are the same. Only the IP addresses are different.
You can install one in C disk and another one using your USB disk. Make sure:

Your company has enough resources, both the CPU and the memory;
Your [...]

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 [...]

xhost setting problem for local users

$su – oracle
$env | grep DISPLAY
DISPLAY=:0.0
$xclock
Xlib: connection to “:0.0″ refused by server
Xlib: No protocol specified
Error: Can’t open display: :0.0
The problem is that the local users were not authorized to access control on xhost. To solve this problem, you need to make the authorization using “root”.
[root@localhost]# xhost
access control enabled, only authorized clients can connect
[root@localhost]# xhost +oracle
xhost:   [...]

Batch Mode Statspack Installation and Application

To install Statspack in batch mode, you must assign values to the SQL*Plus variables that specify the default and temporary tablespaces before running SPCREATE.SQL. The variables are:
* DEFAULT_TABLESPACE: For the default tablespace
* TEMPORARY_TABLESPACE: For the temporary tablespace
* PERFSTAT_PASSWORD: For the PERFSTAT user
For example, on UNIX:
SQL> CONNECT / AS SYSDBA
SQL> define default_tablespace=’TOOLS’
SQL> define [...]

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 [...]

RMAN: restore the spfile

$sqlplus /nolog;
SQL>connect / as sysdba;
SQL>startup nomount;
SQL>exit;
$rman target / nocatalog
RMAN>set dbid=147749264
RMAN>run
{
allocate channel d1 type disk;
set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘$ORACLE_BASE/oradata/rman_backup/control%F’;
Restore spfile from autobackup;
Release channel d1;
}
Here is the error info: RMAN-06564: rman must use the t0 clause when the instance is started with spfile
This error info implies that you were using default SPFILE [...]