Amazon books

Sunday, January 30, 2011

Configuring a parallel backup in RMAN with RAC

In order to make the most use of your RAC environment you can parallel your backups simply by changing the following parameters:

RMAN> configure default device type to sbt;
RMAN> configure device type sbt parallelism 3;
RMAN> configure channel device type sbt connect='sys/passwd@MYDB';

Best Regards,
Paulo Portugal

Create an ASM instance in Silent mode using DBCA

Use the command below to create an ASM instance using dbca in Silent mode.

dbca -silent -nodelist node1,node2 -configureASM -asmSysPassword manager -diskString /dev/sd* -diskList /dev/sda2,/dev/sdb2 -diskGroupName DG_DATA -redundancy EXTERNAL

Best Regards,
Paulo Portugal

Thursday, January 27, 2011

How to find where is my OCR and Voting Disk devices

--For OCR get the value in ocr.loc file
[oracle@host1]/etc/oracle> cat /etc/oracle/ocr.loc
ocrconfig_loc=/dev/rlv_OCR1
ocrmirrorconfig_loc=/dev/rlv_OCR2
local_only=FALSE

OR use ocrcheck:

[oracle@host1]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 1048100
Used space (kbytes) : 3848
Available space (kbytes) : 1044252
ID : 865433463
Device/File Name : /dev/raw/raw4
Device/File integrity check succeeded

Device/File not configured

Cluster registry integrity check succeeded



--For voting use the command below:

[oracle@host1]/etc/oracle> crsctl query css votedisk
0. 0 /dev/rlv_VOTE1
1. 0 /dev/rlv_VOTE2
2. 0 /dev/rlv_VOTE3


Best Regards,
Paulo Portugal

Wednesday, January 26, 2011

How to Convert Single Instance to RAC Using rconfig - Summary

1-Edit ConvertToRAC.xml file that can be found at $ORACLE_HOME/assistants/rconfig/sampleXMLs directory.
2-Run the command below:
rconfig single_to_rac.xml

3-We can chose to only verify if the convertion will be OK using the option: Convert verify="ONLY".

4-To not check pre-req user Convert Verify="NO" otherwise use Convert verify="YES"

Best Regards,
Paulo Portugal

Tuesday, January 25, 2011

How to change ADMIN Oracle Apex Password

In order to change ADMIN password for your APEX run the command below:

SQL> conn / as sysdba
SQL> @apxxepwd.sql
Session altered.

...changing password for ADMIN
Enter value for 1: manager
Enter value for 1: manager

PL/SQL procedure successfully completed.


Commit complete.

Best Regards,
Paulo Portugal

Sunday, January 16, 2011

SSH with password in background NOHUP

Create a shell script to copy big files and run in background informing password inside scripts like that:

[hostname]$ cat cp_datafiles.sh
echo 'password_user_f2c' | scp f2c@10.1.0.7:/ocfs03/oradata/PEBS/data/* .


Best Regards,
Paulo Portugal

Friday, January 7, 2011

Reinstall SSH Linux - Error "Value too large for defined data type"

If getting error like below:

[appprdts@f2c04 Stage]$ ls -la
ls: bkp_appl_Prod110105_1909.cpio: Value too large for defined data type

--Remove SSH
yum remove openssh-server

--Install
yum install openssh-server

Best Regards,
Pauo Portugal