This is a quick and dirty note to self about Doc ID 1387859.1 which may be incorrect for Single Instance Database with Oracle Restart.
Please share if you have configuration for Single Instance Database with Oracle Restart using DataGuard Broker and listener registered from Grid – TIA.
Oracle Data Guard Broker and Static Service Registration (Doc ID 1387859.1)
+++ DO NOT BELIEVE THIS TO BE CORRECT - FAILED FOR TEST CASE.
Single Instance Database with Oracle Restart
I was troubleshooting backup from standby databases and encountered an oddity which I wanted to verify.
Backing Up Archived Redo Logs with RMAN
Before beginning the backup, RMAN switches out of the current redo log group, and archives all online redo logs that have not yet been archived, up to and including the redo log group that was current when BACKUP command with any of the following clauses:
ARCHIVELOG FROM …
Learning new things by actually reading the log files.
$ srvctl status home -o /u01/app/oracle/product/184.108.40.206/db_1 -s ~/statushome.txt -n rac01; cat ~/statushome.txt
Service emu_svc is running on node rac01
Database emu is running on node rac01
$ srvctl stop home -o /u01/app/oracle/product/220.127.116.11/db_1 -s ~/stophome.txt -n rac01 -t immediate -f
PRKO-3244 : The -s option value "/home/oracle/stophome.txt" already exists
$ rm -f (more...)
I have been patching a lot lately and started to wonder if this is a simpler way to check for patch conflict.
Reviewing the log from running opatch auto shows opatch auto does perform check; hence, why do we need to check this manually?
What about creating scripts to do this? Done this as well and will required modifications when requirements are changed.
If the post name did not give it away or if you (more...)
For later creation of containers as needed in the deployment process we have first to build docker images whenever we do not find suitable one in docker hub.
For most of my development I need a oracle database. On the internet you can find a lot of Dockerfile’s for this, but no ready image. This is because for running a database you have to accept a license and this happens when you download the installation (more...)
A new version 4.23 of the XPLAN_ASH utility is available for download.As usual the latest version can be downloaded here.
This version comes only with minor changes, see the change log below.
Here are the notes from the change log:
- Finally corrected the very old and wrong description of "wait times" in the script comments, where it was talking about "in-flight" wait events but that is not correct. ASH performs a "fix-up" (more...)
Why you might want to think twice about using INSERT ALL.
One of those things I knew and then forgot.
So, let’s say you’ve got three tables or a partitioned table or something like that.
Let’s use regional tables for simplicity.
drop table t1_r1;
drop table t1_r2;
drop table t1_r3;
create table t1_r1
(col1 varchar2(2) not null
,col2 number not null
,check( col1 in ('R1')));
create table t1_r2
(col1 varchar2(2) not null
,col2 number not (more...)
If you need TranslationHub (Windows only) for your forms and reports development and plan to move to one of the following
- 12c Database for your TranslationHub repository
- 12c Forms/Reports (only available for 64 bit Windows)
- higher version of 64 bit 11g Forms/Reports
then please immediately stop! None of this combination works with TranslationHub!
For the last point I had created enhancement request 14155931 back in June 2012!
For the first point I had created a service request (more...)
I was contacted by Dev team to look into Development database where Oracle queue size kept on increasing. As per them messages were not getting cleared.They were running count on Queue table and the count kept increasing. To find out exact cause I included the msg_state in the query and found out that there were…
iAdvise presented the APEX 5.0 roadshows in the first half of 2015. Besides the presentation about the new features, we provided 3 tutorials which helped the visitors to explore Oracle Application Express 5.0. Now we offer these tutorials through our blog. In this article the second tutorial is presented.
This tutorial helps you step by step through the process of migrating an application to the Universal Theme
of Oracle Application Express 5.0
. In this tutorial we talk about (more...)
A rather not so great post about an ORA-00600 error i faced on a standby database. Environement was 18.104.22.168 on Sun Super Cluster machine. MRP process was hitting ORA-00600 while trying to apply a specific archive log.
The error message was something like this
MRP0: Background Media Recovery terminated with error 600
Errors in file /u01/app/oracle/product/22.214.171.124/diag/diag/rdbms/xxxprd/xxxprd1/trace/xxxprd1_pr00_6342.trc:
ORA-00600: internal error code, arguments: , , , , , , , (more...)
While trying to run pre_upgrade_status.sql script for DB upgrade (10.2.0.4 to 126.96.36.199), we got following error @pre_upgrade_status.sql ERROR at line 1: ORA-01873: the leading precision of the interval is too small ORA-06512: at line 8 On debugging further , found out that it was due to limit imposed on "INTERVAL DAY TO SECOND" datatype. By…
Recently we came across a issue where our DB crashed with ORA-00338 error . Errors in file /oracle/diag/rdbms/orcl11g/orc11g/trace/orc11g_lgwr_24118.trc: ORA-00338: log 2 of thread 1 is more recent than control file ORA-00312: online log 2 thread 1: '/oracle/oradata/orcl11g/redo02.log' LGWR (ospid: 24118): terminating the instance due to error 338 DB couldn't be restarted as it gave same errors…
Permission issues is one of the key error , while setting up Hadoop Cluster, while debugging some error found below table on http://hadoop.apache.org/ . It’s a good scorecard to keep handy.
Permissions for both HDFS and local fileSystem paths
The following table lists various paths on HDFS and local filesystems (on all nodes) and recommended permissions:
Readers of an earlier post on this blog
will know about my latest forays into the world of Direct NFS. Part of that means stumbling over configuration hiccups or slamming into brick walls when you find new bugs.
To quickly re-set the table, my organization purchased the Oracle ZFS Storage Appliance (ZFSSA) 7420
. Oracle sold us on the Infiniband connectivity as a way to make a possible future transition to Exadata easier. However the pre-sales (more...)
I just uploaded my DOAG 2013 presentation “Best of Oracle Security 2013“.
This presentation shows how to bypass Oracle Data Redaction, become DBA using CREATE ANY INDEX, Hide information from Oracle Auding using VPD and more…
SQL> select * from scott.credit_card where 1=ordsys.ord_dicom.getmappingxpath((card_id),user,user);
At Derbycon 3.0, László Tóth and Ferenc Spala gave a a new presentation “What’s common in Oracle and Samsung? They tried to think differently… ” (Video). The main focus of the presentation was the Samsung encryption and a new framework called sandy but there was also a small (more...)