Data Guard was configured a few days back at one of the customers site. An ORA-19527 error is continuously reported in the standby database alert.log (database name is changed) Errors in file /u01...
Recently I had to present at eProseed AnualTech conference in Luxembourg and I was requested to present a topic something about Oracle18c. Obviously I don't want to talk and repeat the same about Aut...
In one of the recent database migration & upgrade activities, I have migrated an Oracle EBS database 11.2.0.4 to a new DB host and upgraded to 12.1.0.2. After migration and post upgrade, an utlrp.sql ...
Oracle Database Vault was configured on RAC database v11.2.0.3 and appropriate permissions given to allow the regular duties, such as data pump export/import etc.However, when classical/traditional im...
As part of SSL configuration between WebLogic tier and DB tier, post sqlnet.ora settings and scan listener restart, we encountered an ORA-12545 error on a 3 node RAC database when using the SCAN liste...
For cost optimization and flexibility, its a good idea to go with Oracle Database backup cloud services. The Oracle Database Backup Cloud service can actually compliment with the existing backup strat...
Organizations treat their data as an asset. In this regards, the top priority for them is data availability and protection from all sorts of disasters. We have seen more and more organizations investi...
Had an interesting situation configuring a Data Guard setup of 7TB Oracle 12c database at one of the clients. After a long and rounds of discussions, considering the constraints and limitations, agree...
One of our DB teams from Europe highlighted the following issues while installation and configuring VM on Exadata X7. "Today we started X7-2 Exadata installation. But we faced some issues. First prob...
Had a very interesting and tricky scenario a few days ago. It was something I never encountered in my DBA career. Hence, thought of sharing the detail of there store here today. Challenge During m...
I was recently involved in a project to migrate an Oracle ERP database to an Exadata server. The ERP database was a non-RAC Oracle 12cR1 running on RHEL with Oracle EBusiness suite 12.1.3. The migrat...
As part of the Cloud Infrastructure services, Oracle offers below persistent I/O intensive block storage and high-throughput storage options, which is manageable through the console and by CLI: Oracl...
