Oracle Database 9i

Installation Guide on Linux for All Releases of Oracle Database

by Ed Chen
March 20, 2023February 15, 2023

In this post, we collect installation guides on Linux for all database releases. You may bookmark this page by pressing Ctrl + d to. There're… Read More »

AUDIT_FILE_DEST (ADUMP)

by Ed Chen
January 7, 2022October 22, 2022

Audit File Location The audit file location AUDIT_FILE_DEST, also known as ADUMP, is the parameter that specifies the destination of audit files in a database.… Read More »

How to Migrate 9i to 12c via DB Link

by Ed Chen
November 16, 2019December 10, 2022

Migrate 9i to 12c As I said in How to Resolve ORA-03134, you cannot directly access an Oracle 9i database from an Oracle 12c or… Read More »

How to Resolve Standby ORA-00600 [3020]

by Ed Chen
November 24, 2018December 12, 2022

ORA-00600 [3020] Found MRP shutdown with ORA-00600 [3020] in alert log of a standby database due to inconsistency of a newly created data file. Wed… Read More »

How to Resolve ORA-01516 Error Message

by Ed Chen
June 24, 2017March 14, 2023

ORA-01516: nonexistent log file, datafile, or temporary file There're two scenarios that throw ORA-01516 going to be introduced in this post. 1. Rename Tempfile I… Read More »

How to Resolve ORA-00001: unique constraint (PERFSTAT.STATS$SQL_SUMMARY_PK) violated

by Ed Chen
January 7, 2017August 27, 2021

STATSPACK ORA-00001 Login as PERFSTAT and took a snapshot like the following statement. But it failed with ORA-00001. SQL> exec statspack.snap(i_snap_level=>5); BEGIN statspack.snap(i_snap_level=>5); END; *… Read More »

How to Fix Broken Statspack Snapshot Jobs

by Ed Chen
December 30, 2016May 30, 2022
2 Comments

Saw a broken statspack snapshot job stopped working for several days. I tried to run the job on the spot but it still failed. So… Read More »

How to Set Password for Listener

by Ed Chen
September 29, 2010November 24, 2021

Earlier databases like 9i should set password for listeners, otherwise, they could be accidentally stopped by someone unknown. Here in this post, I will introduce… Read More »

How Oracle Enable ARCHIVELOG Mode

by Ed Chen
September 25, 2010December 11, 2022

What is Archivinglog Mode? The process of copying inactive redo log files into archived files is called archiving. Archiving is only effective on databases which… Read More »