Moving Statistics from One Database to Other Database
I had recently upgraded the Database from 10.1.0.4 to 10.2.0.4, I had saved the statistics in table sys.dictstattab. I want to test the statistics on the Test Database. There are …
Read MoreEvangelist – Philanthropist – Mentor
I had recently upgraded the Database from 10.1.0.4 to 10.2.0.4, I had saved the statistics in table sys.dictstattab. I want to test the statistics on the Test Database. There are …
Read Morealias abort=’echo shutdown abort|sqlplus -L -s / as sysdba’ alias alertvi=’vi $ORACLE_HOME/admin/ ORACLE_SID/bdump/alert_ORACLE_SID.log’ alias nomount=’echo startup nomount quiet|sqlplus -L -s / as sysdba’ alias ora=’cd $ORACLE_HOME’ alias pmon=’ps -ef | …
Read MoreYou lost the RMAN recovery catalog and controlfile. Restored controlfile from backup for example using dbms_backup_restore package and then restored and recovered the whole database with RMAN in nocatalog mode. …
Read More1. Stop your mid-tier $OHopmnbinopmnctl stopall Note: If the infrastructure and middle tier are installed on the same machine then ORACLE_HOME mentioned above is ORACLE_HOME of your mid-tier. 2. Stop …
Read MoreOracle Identity Management(OIM) How to reset OID cn=orcladmin password If you wonder what is the password for Oracle Internet Directory(OID) user cn=orcladmin after OIM installation, well, it is exactly the …
Read MoreOracle Locking Survival Guide —————————– Overview In multi-user systems, many users may update the same information at the same time. Locking allows only one user to update a particular data …
Read MoreOracle RMAN – Restore from any Disk Location RMAN looks for the backupfiles to restore within its catalog and therefore there is no RESTORE DATABASE FROM <Disk-Location> command. You can …
Read MoreCreate a Physical Standby 1. Perform a hot backup of the primary database. This can be done in several ways depending on what your current configuration is and where the …
Read MoreRaw Devices on RHEL 5 or OEL 5 Be aware that raw device technology had been deprecated in RedHat Linux 5 (RHEL5) and Oracle Enterprise Linux 5 OEL5). / Linux Kernel …
Read MoreInstalling Oracle 11g RAC on virtual servers using VMware. This post describes the installation of Oracle 11g RAC on virtual servers.Hardware The following hardware was used for the installation: Operating …
Read More