RAC 11g with vmware
http://www.oracle-base.com/articles/11g/OracleDB11gR1RACInstallationOnOEL5UsingVMware.php
oracle 11g RAC on vmware
http://startoracle.com/2007/09/30/so-you-want-to-play-with-oracle-11gs-rac-heres-how/
OEM-troubleshooting on 20-MAY-08
FROM TUNINGDB21 (Target) =============== tuningdb21*-/db1/home/oracle/paresh ==>ping 10.180.1.144 10.180.1.144 is alive tuningdb21*-/db1/home/oracle/paresh ==>ping oem2k.1800flowers.int ping: unknown host oem2k.1800flowers.int tuningdb21*-/db1/home/oracle/paresh ==>nslookup 10.180.1.144 *** Can’t find server name for address 127.0.0.1: Unspecified error *** Default servers are not available tuningdb21*-/db1/home/oracle/paresh ==>nslookup oem2k.1800flowers.int *** Can’t find server name for address 127.0.0.1: Unspecified error *** Default servers are not available…
normal maintenance for exp-imp and renaming table
exp userid=vivek file=ats_florist_zips_20MAY08.dmp log=ats_florist_zips_20MAY08.log grants=N indexes=N tables=ats.ats_florist_zips triggers=N statistics=None feedback=5000 imp userid=vivek file=ats_florist_zips_20MAY08.dmp log=imp_ats_florist_zips_20MAY08.log buffer=20971520 grants=N indexes=N fromuser=ats touser=5049 commit=Y constraints=N feedback=5000 statistics=None alter table “5049”.ATS_FLORIST_ZIPS rename to ats_florist_zips_05_20_2008;
Guide to Linux System Command Mastery
An introduction to system commands for newcomers to Linux In “Guide to Linux File Command Mastery,” we covered the basic information needed to take advantage of the most essential and commonly used Linux file commands. In this article, I’ll do the same with Linux system commands. As we learned in the previous article, everything is…
setting prompt display with .profile
PS1=” `hostname`*${ORACLE_SID}-${PWD} ==>”
OEM-Commnds
D:oracle_homesagent10gBIN> emctl status agent D:oracle_homesagent10gBIN> emctl start agent D:oracle_homesagent10gBIN> emctl stop agent yantradevdb-YANTRAD> emctl getemhome yantradevdb-YANTRAD> emctl upload
V$ROLLSTAT status is Full
Problem Description: ==================== You receive the following error: ORA-01562: “failed to extend rollback segment number %s” Cause: Failure occurred when trying to extend rollback segment Action: This is normally followed by another error message that caused the failure. You may take the rollback segment offline to perform maintainence. Use the alter rollback segment offline command…
Rman Notes -1
A flash recovery area is a disk location in which the database can store and manage files related to backup and recovery. Some features of Oracle database backup and recovery, such as Oracle Flashback Database and guaranteed restore points, require the use of an FRA. However, having an FRA for use by these features does…
Rman Notes -1
#—-Flash Recovery Area (FRA)——#