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 […]
Yesterday I was recreating DR database with production database backup, when restore database command failed with error: ORA-19693 RMAN> restore database; Starting restore at 05-AUG-15 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to G:\OPDB\REPOSITORY\DATABASE112_SE_X64\ORADATA\OPDB\SYSTEM01.DBF […]
Two days before while starting our UAT database using SRVCTL, I received following error: [oracle@srv-uat-db-gen1 ~] Ora:BIIBDPRD $ srvctl start database -d BIIBDPRD PRCR-1079 : Failed to start resource ora.biibdprd.db ORA-12547: TNS:lost contact CRS-5017: The resource action “ora.biibdprd.db start” encountered the following error: ORA-12547: TNS:lost contact . For details refer […]
Adityanath's Oracle Blog 