Interesting issue happened today, while creating index in database(running 11.2.0.4 DB on Linux), I got ORA-01450: maximum key length (6398) exceeded. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> CREATE INDEX […]
Few days back, I was applying OPatch on one of the database residing on windows server. I tried it multiple times without any luck as everytime when I tried applying patch, I was getting below error: OUI-67073:UtilSession failed: Prerequisite check “CheckActiveFilesAndExecutables” failed. This was due to some of the DLL […]
Yesterday I was trying to start DB services using SRVCTL on one of the new environment. I was able to start individual database instances using sqlplus, but it was giving issues for SRVCTL, I was able to start one of the two instances using SRVCTL, but not both, it was […]
Yesterday, application team informed us about production job failure with error: ORA-08103 Object no longer exists. It was simple select query on object with type VIEW. I tried rerunning query which ran without any issue. I tried to investigate, if the underlying objects have been dropped when job was running. […]
In this post, we are discussing about issue which I faced on fresh oracle software install. [oracle@test1.test.com ] Ora:TEST2 $ sqlplus “/ as sysdba” SQL*Plus: Release 11.2.0.4.0 Production on Mon May 30 12:30:31 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. ERROR: ORA-01031: insufficient privileges Normally this issue points […]
Scenario: Create database links owned by application user whose credentials are not shared with DBA In Reality: For creating private database link, you will need to connect to user & then create it. If you try to create it using SYS as <owner>.<db_link_name>, Oracle will create DB LINK with name <owner>.<db_link_name> under […]
From last two days, I have been getting “ORA-27054: NFS file system not mounted with correct options” error while running an RMAN backup to a Sun ZFS Storage Appliance. This error have been observed particularly, while taking controlfile backups. RMAN datafile or archivelog backups without controlfile were running fine. RMAN-08132: WARNING: […]
This post will help you to convert characterset of database from WE8ISO8859P15 to AL32UTF8 in 12C. From 12c you will need to use DMU tool for characterset conversion instead of traditional method of CSSCAN & CSALTER. DMU is the Database Migration Assistant for Unicode . It converts the NLS_CHARACTERSET of an existing […]
The WordPress.com stats helper monkeys prepared a 2015 annual report for this blog. Here’s an excerpt: The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 22,000 times in 2015. If it were a concert at Sydney Opera House, it would take about 8 […]
Few days back, I was working on a issue where in Clusterware was not coming up on UAT environment. Daemon ora.crsd was OFFLINE. I tried to start ora.crsd daemon using command “crsctl start res ora.crsd -init”, but failed giving following error: I tried searching about error on metalink and google […]
Adityanath's Oracle Blog 