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 the infrastructure tier (e.g. host is – ausable) using x-windows like Hummingbird. 2) Log on as user “oracle” – the user that did the install….
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 four basic steps to copy the statistics from one database to another database using DBMS_STATS: 1) Create a table in your database to hold the…
You 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. When you register the database in a new recovery catalog, old backups in the controlfile are now inaccessible using the new RMAN catalog. A: 1….
1. 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 EM Website $OHbinemctl stop Note: If the infrastructure and middle tier are installed on the same machine then stop Infrastructure EM, and if the infrastructure…
Oracle 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 same as ias_admin password specified during installation of OIM. If you really want to reset the password, use included utility resetiASpasswd.sh in $ORACLE_HOMEbin as follows:…
Oracle 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 block; another person cannot modify the same data. The basic idea of locking is that when a user modifies data through a transaction, that data…
Oracle 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 circumvent this constraint using the RMAN command CATALOG START WITH <Disk-Location>. The following example shows how to restore an Oracle database from any disk location….
Create 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 logical standby database will be placed. 2. Turn this backup of the primary database into a physical standby following a. Restore the backup to the…
Today 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. The following syntax is used while OS Authentication sqlplus / as sysdba 2. A SQLNET.AUTHENTICATION_SERVICES controls the operation system authentication. On unix platforms setting the…