I was faced with a very strange situation.
When using SETENV (ORACLE_SID = db01), replicat ABEND with OGG-00664 OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available
When using SETENV (ORACLE_HOME=/u01/app/oracle/product/126.96.36.199/dbhome_1), replicat starts without any issues.
I know what you are thinking, why not set both ORACLE_SID and ORACLE_HOME and you are correct since this is best practices.
The client already knows this and wanted to troubleshoot why it was failing?
Any ideas? (more...)
"There are other advantages," continued the child. "For instance, if one rat were cornered by nine cats,
on the average, each cat would be ten percent rat and the rat would be ninety percent cat. If you happened
to be a rat, you can see how much nicer it would make things."
-- Norton Juster, The Phantom Tollbooth
Recently an interesting question appeared on “Ask Tom” with regard to the ‘average’ between two dates. (more...)
Truthfully, I am feeling a little lazy to write a nice blog.
Configuring listener.ora and tnsnames.ora, varying names for database, connecting to database.
db_name string tmnt
db_unique_name string tmnt_a
instance_name string tmnt01
ADR Home /u01/app/oracle/diag/rdbms/tmnt_a/tmnt
Service "april" has 1 instance(s).
Instance "tmnt01", status READY, has 1 handler(s) for this service...
Service "tmnt" has 1 instance(s).
Instance "tmnt", status UNKNOWN, has 1 handler(s) for this service...
Service "tmnt_a" has 1 instance(s).
I’ve been using standby databases, on and off, since Oracle 8i. I first wrote about Data Guard for Oracle 9i. I’ve had an article on 11gR2 Data Guard for ages, but up until recently I’ve always used the manual setup.
We’ve got a project coming up that *may* use Data Guard and *may* be installed by a 3rd party, so I figured I better get up to speed with the Data Guard Broker, in case they (more...)
Just a quick note as I play with CDB/PDB.
No more triggers!
PDB State Management Across CDB
select con_name, instance_name, state from DBA_PDB_SAVED_STATES;
alter pluggable database PDB1 SAVE STATE;
alter pluggable database ALL SAVE STATE;
alter pluggable database ALL DISCARD STATE;
alter pluggable database ALL OPEN;
startup force mount exclusive restrict;
Drop database still does not clean up ADR.
SQL*Plus: Release 188.8.131.52.0 Production (more...)
How do you typically create database, using dbca or sqlplus?
I am still surprised with all the bloatware added for creating database using dbca.
Also, is there a reason to prefix PDB with pdb?
-rw-r--r--. 1 oracle oinstall 801 Jul 19 12:59 cr_cdb.sql
-rw-rw----. 1 oracle oinstall 1544 Jul 19 13:06 hc_tmnt.dat
-rw-r--r--. 1 oracle oinstall 216 Jul 19 12:48 inittmnt.ora
-rw-r-----. 1 oracle (more...)
So this week I've been doing some more stuff with cloud control 13c and came across a small issue when trying to use it with ie11.
With firefox everything was working fine but with ie i would just get a kind of generic error message that really told me nothing about what was actually wrong.
To confuse things we were running the browser with the remote app PaaS service from Oracle - for those of (more...)
As DBAs we are usually located in the middle between the IT (sysadmins, storage, network) and the development. Some of my best friends are sysadmins and developers (well, friends anyway), but I still want to dedicate this post to let off some steam about them. I hear many complaints from DBAs about sysadmins (and I […]
If you’ve not taken the plunge and upgraded to VirtualBox 5.1, you might be interested to know that VirtualBox 5.0.26 has been released.
Downloads and changelog are now listed under the old builds.
In case you are wondering, I’ve been running VirtualBox 5.1 on Mac, Windows 7 and Oracle Linux 6 hosts since its release. As yet, not problems.
was first posted on July 19, (more...)
Oracle DIRECTORY objects are very nice to handle access for external tables or other procedures.
It just can be challenging to enable proper access to those files for other users than the database user (I call it oracle
If there are any concerns to allow any access to the databases host (except for DBAs and OS admins) it get's tricky fast.
One possibility is to use a NFS mount and make the directory available (more...)
This is a small article on using UDev on RHEL 7. I have a virtual box with RHEL 7 and I am configuring ASM diskgroups.
Before we configure ASM diskgroups, we need to have disks/partitions available at OS level and those should be recognized by ASM. Oracle provides a utility called ASMLib which can be installed and used very easily to configure disk/partitions at OS level.
ASMLib stamps the header of partitions/disk at OS level (more...)
I have followed the steps in Oracle Documentation link: https://docs.oracle.com/cd/E63000_01/EMXIG/ch2_deployment.htm#EMXIG215 to configure Exadata Database Machine in OEM13c. If you want to configure your Exadata in OEM13c you have to follow the above mentioned link. In this post I will share the mandatory steps for configuration, and some of the issues which I faced while configuring the Exadata…
I have never delved into networking for GoldenGate since things just work. Due to security tightening, telnet is no longer available to verify opened port.
What’s to follow is a demo for ports being listened by GoldenGate when manager started and ports listened and when PUMP Extract is started as part using DYNAMICPORTLIST.
Also, how to test opened port using (nc – arbitrary TCP and UDP connections and listens)
Both source and target are running on the (more...)
I am starting Oracle 12c learning series, where I am planning to publish multiple articles on Oracle 12c new features. I hope these articles will be helpful to DBAs aspiring for OCP 12c certification and also others who are planning to implement these features in there databases.
This is a very long post about ADO – Automatic Data Optimization, which is one of the ILM strategy to manage aging data. So please be patient while reading this article. This article provides end-to-end details (more...)