Reinstall Oracle database
Pre-installation steps Check free space. For installation of oracle you will need at least following space: 4GB at $ORACLE_HOME (etc....
Tag: Oracle
Oracle bundle patch (SAP_102048_201107_HPUXIA64)
Pre-installation steps Check for any uncompiled or wrongly compiled objects that might cause problems during installation. Look at article Compilation...
Restore / Recovery (Previous incarnation)
Remove current password file Default password file location is under $ORACLE_HOME/dbs/orapw. To be on safe side instead of removing the...
Restore / Recovery (Current incarnation)
Remove current password file Default password file location is under $ORACLE_HOME/dbs/orapw. To be on safe side instead of removing the...
RMAN – Create a new catalog
You need to have a database where the catalog will be created. If you don’t have it, you can start...
Moving database files
Move control files Find current location Currently used control files can be found in view v$controlfile. To check, execute following...
Installation 10g – Patchset 4 (10.2.0.5)
Pre-installation steps You have to stop all SAP processes, all Oracle processes. Example of UNIX commands: stopsap all lsnrctl stop...
Installation 10g – Patchset 3 (10.2.0.4)
Pre-installation steps You have to stop all SAP processes, all Oracle processes. Example of UNIX commands: stopsap all lsnrctl stop...
Installation 10g
Pre-installation steps Check free space. For installation of oracle you will need at least following space: 4GB at $ORACLE_HOME (etc....
Duplicate database (Schema only)
Copying schemas w/o user passwords This scenario is used when different passwords are used in source and target databases and...