Oracle

The main goal of this document is serving as a base for SAP Basis Administrator who work with Oracle Databases and want to perform simple checks.

If you want to check or enable/disable oracle Archivelog Mode, you can do it thru 2 procedures.

How to stop and start the Log shipping? With this procedure, we can simulate a disaster crash at the main site.

Virtual index is a feature of Oracle 10 and Oracle 9. The purpose of virtual indexes is simulate the existence of an index, without actually building it, so you can explain plan as if the index existed.

When you want to relink Oracle, you get some errors like Command failed for target `libnmemso'

If you manage Oracle on Windows, you probably have wondered why it is so difficult to work out which Oracle instances are running and which ORACLE_HOMEs they use.

How to drop and recreate TEMP Tablespace in Oracle 9i/10g/11g

If you cloned a database and need to run both instances with the same db_name from one $ORACLE_HOME i.e.:

Following the update of the Oracle databse or running some oracle scripts, an error occurs ORA-27140: attach to post/wait facility failed

ORA-00376: file 17 cannot be read at this time and ORA-01110: data file 17: '/oracle/XXX/sapdata2/prd_14/prd.data14'

ORA-20000: index "SAPSR3"."/xxxxxxxxxxxx"  or partition of such index is in unusable state

How to rename a dataFile in Oracle.