Friday, January 01, 2010

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...
  • Custom Search