Blogspot - arulselvaraj.blogspot.com - EXPLORING ORACLE
General Information:
Latest News:
ORA-27546: Oracle compiled against IPC interface version 3.2 found version 3.3 10 May 2011 | 01:22 pm
Background: Customer upgraded 10204 CRS and ASM to 11202 Grid Infrastructure. Customer upgraded his 10204 Databases to 11202 Database. Customer verified all the jobs and application to be working fin...
/etc/oratab & # line added by Agent 10 Feb 2011 | 12:15 pm
We upgraded our Oracle technology stack from 10204 to 11202. We are running Oracle Grid infrastructure 11202 on 4 node RAC, which has many 11202 database running it. We use /etc/oratab extensively on...
ORA-15186: ASMLIB error function = [asm_open], error = [1], mesg = [Operation not permitted] 8 Feb 2011 | 05:39 pm
Recently, I was involved in OS rolling upgrade for 3-node RAC running on 10204 with ASMLIB. I had performed quite a few OS rolling upgrades in past so I had my checklist or documentation handy on step...
DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS Failed with ORA-01408: such column list already indexed 18 Jan 2011 | 06:28 pm
Recently I was engaged in exercise to partition a table in a database. I was using a DBMS_REDEFINITION package to partition the online. As per documentation, There may be times when you want to over...
Drop tablespace waiting on 'reliable message' 14 Jan 2011 | 02:14 pm
Lats week, I droped a tablespace from production database. SQL> select count(*) from dba_segments where tablespace_name='TEST'; COUNT(*) ---------- 0 SQL> drop tablespace TEST including contents and ...
Watch out when using RMAN custom backup piece naming convention via FORMAT 14 Jan 2011 | 01:03 pm
Yesterday, I was asked to investigate the backup restore issue of production database for one off my client. Customer was taking incremental level 0 backups on Sunday and cumulative incremental level ...
ORA-31619: invalid dump file for IMPDP 18 Aug 2010 | 11:23 am
We had a EXPDP script to export the application schema on daily basis. We were writing data pump files to WINDOWS files system mounted to LINUX system with CIFS option. We used parallel=2 and generat...
How to Rollback failed Patchset via Flashback Database 29 Jul 2010 | 05:27 pm
Pre-Patch Enable Flashback -- SQL> alter database flashback on; Create Restore Point -- SQL> create restore point before_patch guarantee flashback database; Patch 1020n Shutdown DB -- SQL> shut...
Failed DB Patch Set - No need to Restore, Use Flashback Instead 29 Jul 2010 | 04:49 pm
Since last couple of weeks I have been working on a project to patch more than 50+ databases from 10203 to 10204. I never follwed the traditional approach of backing up of ORACLE_HOME and the databas...
After 10204 patch SRVCTL fails with srvctl: line 187: /bin/java: No such file or directory 26 Jul 2010 | 11:09 am
Last night I patched 10203 2-node RAC database to 102042. There were no issues with patching and all went well. However after patching, my srvctl command on node 2 started failing with "srvctl: line ...
