Wednesday, October 20, 2010

set your ORACLE_SID to an ASM instance
using asmcmd locate the directory that contains the archive log files. for example..

ASMCMD> cd +POC2FLASH/POC2DWH/ARCHIVELOG
using 'rm' command you can delete the directory.

But don't forget to remove the archive log details from the control file or the RMAN catalog
For this you need to connect to the target database using rman
rman target sys/ nocatalog
rman>crosscheck archivelog all
rman>delete expired archivelog all

Monday, October 18, 2010

DHCP hostname.

Set the hostname: `# hostname `
Add ‘HOSTNAME=’ to ‘/etc/sysconfig/network’ (makes the change permanent).
Add ‘DHCP_HOSTNAME=’ to ‘/etc/sysconfig/network-scripts/ifcfg-eth0′
Restart the networking service: `# service network restart`