While shutting down the oracle database , i have encountered the ora-00600 error. I checked “ps -ef | grep ora_” and found no oracle process are running. I got confused ..
SQL> shutdown immediate
Database closed.
Database dismounted.
ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
And i serached in web for the error and i […]
Execess redolog generation during hot backup
What happens during tablespace begin backup?
When a tablespace is in backup mode, datafile’s header belonging to the tablespace will be freezed rather than the datafile.So checkpoint happens and update the datafile header with checkpoint SCN and there after it is freezed until we take tablespace out of backup mode.
Since […]
There are many ways to troubleshoot the performance Issues in oracle database. Here you can find some methods to troubleshoot performance Issues.
Scenario 1:
Users are complaining that Application is slow.
DBMS_CRYPTO package provides an interface to encrypt and decrypt stored data. For example, the table CUST_MASTER has three columns ACNO,NAME,BALANCE and you wish to encrypt the column NAME and BALANCE. Using the dbms_crypto.ENCRYPT functions,you can create your function to encrypt data.
Example:
Create a table CUST_MASTER .
The SYSAUX tablespace is the new feature introduced in Oracle Database 10g. It serves as an auxiliary tablespace to the SYSTEM tablespace. Because it is the default tablespace for many Oracle Database features and products that previously required their own tablespaces.
The RMAN Environment
There are 9 RMAN components available out of 2 components are required for performing backup and recovery.
List of Components
Target Database
The control files, datafiles, and optional archived redo logs that RMAN is in charge of backing
up or restoring. RMAN uses the target database control file to gather metadata about the
VERITAS CLUSTER FUNDAMENTALS
Cluster Definition
Cluster Setup
VCS and Its Advantages
Disadvantages of VCS
Hardware Setup and Requirments
VCS Communication
GAB
LLT
I/O Fencing
HAD
Sample DataCenter Setup
Oracle Service Group
VCS AGENT
Veritas Cluster Commands
I had struggled in the earlier to get the information about oracle certification. Even oracle provide this info, I search and figure it out. Couple of my friends were keep on asking me how to apply, terms and so many informations about certification.
I keep on telling them the following informations. So I decided to post […]
This post you can find 3 useful links for Oracle 11g.
Very first you can find all the new features about Oracle 11g, next is installations steps and finally you can get the download link.
Oracle 11g New FeaturesOracle enhances its features in version by version. what’s hot?
Many new change assurance features in Oracle database 11g bring […]
Brief of Incremental Backup
RMAN incremental backup option backs up blocks that have changed since the last incremental backup at the same level or below. For instance, a full backup (level_0) is taken on day 1 and two incrementals of level_1 are taken on days 2 and 3. The latter two merely back up the changed […]
