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 […]
Few days back, I was working on one of the UAT environments so as to drop columns from 2 tables which were already set to unused as per request from one of my application team. Note: For identifying unused columns for any table, you need to query dba_tab_cols view as […]
One of the biggest challenges for DBAs is the lack of disk space especially for the backups. Two days before, I came across the situation where I was need to do export/import schema from UAT to DEV, but none of the mount points on filesystem were having sufficient space available […]
Adityanath's Oracle Blog 