Topics of Interest

INSTALLATION

Oracle 10g database on linux all versions

Troubleshooting installation of Oracle 9.2 on Sun ...

Step by Step Installation of Solaris 8 OS

Step by step installation of Oracle 9.2 on Sun sol...

Oracle patch 9.2.0.6 on RAC

Oracle 9.2 on SUSE 9.3

Oracle 10gAS Forms n Reports

ORA ERRORS

ORA-01994: GRANT failed: cannot add users to publi...

ORA-00980: synonym translation is no longer valid

ORA-00979: not a GROUP BY expression

ORA-00997: illegal use of LONG datatype

ORA-04093:REFERENCES TO COLUMNS OF TYPE LONG ARE NOT ALLOWED IN TRIGGERS

ORA-04091: table is mutating, trigger/function ma...

RAC

Error while connecting to RAC database (TNS-12545...

COLD BACKUP OF RAW FILESYSTEM

Oracle RAC (Real Application Clusters)

Could not mount Database after restarting the clus...

ARCHIVE RMAN STANDBY

Standby archive apply throws error ORA-01152

Step by step Data guard for oracle 9i on windows

IMPORT EXPORT

Faster import export

How to export selective rows

DB ADMINISTRATION

Oracle DBA Checklist

Useful scripts for DBA

INTERVIEW QUESTIONS

Interview questions for Oracle DBA -Vol2

Interview questions for oracle DBA -Vol1

Interview questions vol3

OTHERS

ORA-04093:REFERENCES TO COLUMNS OF TYPE LONG ARE N...

Accidental deletion of parameter file

Multiblock read count

Monitoring rollback progress

Tracing network errors in oracle

Find difference between two dates in days,hrs,mins...

Online Table reorganisation

Oracle Data encryption package dbms_obfuscation_to...

Row movement in oracle

Drop all indexes in a SCHEMA

Creating a Data Guard Configuration on SUN cluster...

count(*) and count(1)

Database characterset migration

Select date in GMT format

Capturing machine name for users in oracle

How to create alpha numeric sequence.

How to Change the IAS_ADMIN password for Enterpris...