Monthly Archives: October 2012

How To Configure SSH for a RAC Installation /Oracle user equalance

To configure SSH you need to perform the following steps on each node in the cluster. $ cd $HOME $ mkdir .ssh $ chmod 700 .ssh  $ cd .ssh $ ssh-keygen -t rsa Now accept the default location for the … Continue reading

Posted in Oracle RAC | Leave a comment

Error while loading shared libraries: libpthread.so.0: cannot open shared object file: No such file or directory

executing roo@rac-node1 bin]#./vipca Error while loading shared libraries: libpthread.so.0 [root@rac3 bin]# cp vipca vipca1 edit vipca (in the CRS bin directory on all nodes) to undo the setting of LD_ASSUME_KERNEL. After the IF statement around line 120 add an unset command to … Continue reading

Posted in Oracle RAC | Leave a comment

Failed to upgrade Oracle Cluster Registry configuration

 Oracle 10gr2 RAC installation: [root@rac-node1 crs]# ./root.sh WARNING: directory ‘/u01/app/oracle/product/10.2.0’ is not owned by root WARNING: directory ‘/u01/app/oracle/product’ is not owned by root WARNING: directory ‘/u01/app/oracle’ is not owned by root WARNING: directory ‘/u01/app’ is not owned by root WARNING: … Continue reading

Posted in Oracle RAC | Leave a comment

How Do I Link Linux Files

  Create Folder Link: [oracle@DR-SERVER test]$ln -s /database/arch /home/oracle/test The above command will create link folder arch inside /home/oracle/test. [oracle@DR-SERVER test]$ ls -rlt total 0 lrwxrwxrwx 1 oracle oinstall 14 Oct 29 14:25 arch -> /database/arch [oracle@DR-SERVER test]$ pwd /home/oracle/test … Continue reading

Posted in Linux commands for DBA | 7 Comments

vipca error

Vipca is not opening new configuration window and is giving error [root@node1 bin]# ./vipca Error 0(Native: listNetInterfaces:[3]) [Error 0(Native: listNetInterfaces:[3])]   To resolve this issue Perform two steps [root@node1 bin]# ./oifcfg setif -global bond0/192.168.0.0:public [root@node1 bin]# ./oifcfg setif -global eth2/192.168.1.0:cluster_interconnect … Continue reading

Posted in Oracle RAC, rman | Tagged | Leave a comment

Rename tablespace in oracle 10g

Rename tablespace in oracle 10g SQL>CREATE SMALLFILE TABLESPACE “USERS02” DATAFILE’+DGROUP1′ SIZE 100M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; SQL> alter tablespace users02 rename to USERS; Tablespace altered. SQL> alter tablespace users rename to USER_SPACE02; Tablespace altered. SQL> ALTER … Continue reading

Posted in Database administration | Leave a comment

How To Add or Increase The Size Of Redo Log Files In Rac Environment

To add or resize redo logfiles in a RAC steps are spool log.lst set echo off set feedback off set linesize 120 set pagesize 35 set trim on set trims on set lines 120 col group# format 999 col thread# … Continue reading

Posted in Oracle RAC | Leave a comment