Oracle Proxy Users

If you have required privileges, it’s possible to connect as a user account without knowing or changing his password. This is called proxy connection. To authorize a user account to connect using a proxy account, use the GRANT CONNECT THROUGH clause of the ALTER USER statement. Consider, we have a Application User called ‘APPUSR‘ and […]

Read More

ORA-00600: internal error code, arguments: [kwqitnmphe:ltbagi]

Recently started seeing this error on few of the RAC environments.

As per metalink this is a known Bug 20987661 – Doc ID 20987661.8

This works until the database is restarted i.e. we’ll have to execute it every time, we restart the database. I’ve seen this in 11204 and 12102 both. As per […]

Read More

ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver]

On an Oracle 11204 restart environment, ASM spfile creation failed with error ora-600

Fixed the problem, by adding the disk in ASM diskgroup

Post this change, I was able to create spfile without any issue. Metalink Doc ID 2096227.1

Read More

ORA-00600: internal error code, arguments: [kzsrgpw]

Recently I started getting ORA-00600 error, while I was trying to connect to SQLPlus

This was caused due to a corrupt password file. Re-creating password file fixed the issue.

Metalink Doc ID 1073283.1

Read More

HugePages for Oracle

If you run a Oracle Database on a Linux Server with more than 16 GB physical memory and your System Global Area (SGA) is greater than 8 GB, you should configure HugePages. For large SGA sizes, HugePages can give substantial benefits in virtual memory management. Without HugePages, the memory of the SGA is divided into […]

Read More

Enabling Flashback Database in Oracle

Oracle Flashback Database, allows to quickly recover the entire database from logical data corruptions or user errors. It is very similar to PITR (Point In Time Recovery) which puts back the database to a state at a particular time in recent past. 1. Place your database in mount stage.

2. Set DB_FLASHBACK_RETENTION_TARGET to the requried […]

Read More

Enable Archive Log Mode In Oracle RAC

1. stop the database service.

2. start the database in mount state.

3. enable archive log mode.

4. Restart the database service (using srvctl)

5. set the archive destination to a ASM DISK

Read More

Recreate Oracle Central Inventory

Inventory is the index for the oracle installation. All the details about the ORACLE_HOME including different utility versions, patch details etc. If you do a fresh Oracle installation the inventory will be updated. But if you copy the ORACLE binaries from some other location and if you are not updating the inventory, we cannot read […]

Read More

Amount of redo generated during user-managed backup

I must thank my fellow DBA Franky Weber Faust for his publication in his blog. Introduction: –  In this article, we have a quick journey on redo log during user-managed backup. RMAN is the most recommended tool for performing backup and recovery of an Oracle database, but we know that this is not always the case and many […]

Read More

Oracle and it’s different Versions

Oracle Database Technology – the Oracle  server versioning  Oracle Version 2 – first commercial RDBMS Oracle Version 3 – rewritten in the  C programming language Oracle Version 4 – improved query performance Oracle Version 5 – added a networking stack for client-server computing Oracle Version 6 – OLTP improvements, Oracle parallel server Oracle Version 7 – first “Modern” Oracle New security model […]

Read More