How to find out Schema Passwords in a 10gAS Application Server
There are two basic methods to find out the schema passwords in a Oracle 10gAS Application Server:- A) Steps (through the ODM tool):- 1) Log onto the host that hosts …
Read MoreEvangelist – Philanthropist – Mentor
There are two basic methods to find out the schema passwords in a Oracle 10gAS Application Server:- A) Steps (through the ODM tool):- 1) Log onto the host that hosts …
Read MoreI 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 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 MoreToday I tried to login as sysdba i was given this error “ORA-01031 Insufficeint Privilege”. So I thought to write troubleshooting tips for ORA-01031 Facts About Operating System Authentication 1. …
Read MoreSteps for Renaming Redo Log Members Shut down the database. 1. SHUTDOWN 2. Copy the redo log files to the new location.Operating system files, such as redo log members, must …
Read More