Brian Peasland

Author's posts

Aug 01

PDB Unplug ORA-17528 Error

I am trying to remove a PDB in Oracle 19.3 that is no longer needed. I get the following error: SQL> alter pluggable database DEV_PDB close immediate instances=all; Pluggable database altered. SQL> alter pluggable database DEV_PDB unplug into ‘/tmp/DEV_PDB.xml’; alter pluggable database DEV_PDB unplug into ‘/tmp/DEV_PDB.xml’ * ERROR at line 1: ORA-17500: ODM err:Invalid argument …

Continue reading

Aug 01

19.3 PDB Close ORA-65107 ORA-16078

When closing a cloned PDB in 19.3, I am receiving the following errors: ORA-65107: Error encountered when processing the current task on instance:1ORA-16078: media recovery disabled This may exist in 12.2 or 18c, but I skipped those versions. If anyone has info if this is an issue in the versions I skipped, comment below. I …

Continue reading

Jul 30

ORA-01173 Opening PDB in Upgrade Mode

I am working on upgrading a Multitenant environment from Oracle 12.1.0.2 to Oracle 19c. I have 40 PDBs supporting all sorts of dev and test environments. We typically upgrade a few dev databases first and then follow with test databases before upgrading production. When production is upgraded, we like to keep a few dev databases …

Continue reading

Jun 11

Oracle Documentation

Oracle has changed their documentation, making it much harder to find the Oracle Database docs. To access the docs, go to http://docs.oracle.com. From there, you could click on the Database category. As it stands now, the only icons on the doc main page are all cloud-related. It took me a few minutes to figure out …

Continue reading

Apr 29

GI 19c RPM Package Manager Database

I am upgrading an Oracle 18c Grid Infrastructure cluster to the new Oracle 19c version, release for on-premises last week. The OUI pre-requisite checks finds two issues that need my attention. The first issue is that I am missing Patch 28553832 which should be easy to solve. Simply download the patch and apply it before …

Continue reading

Apr 15

Oracle DBA Mentor

My new book is now available from Apress. Oracle DBA Mentor is different from most other Oracle books. The others will teach you some great things and show you how Oracle works and how you should use it. This book teaches you to teach yourself. Where do you turn when those books do not contain …

Continue reading

Sep 07

ORA-65139: Mismatch between XML metadata file and data file

I was trying to plug a non-CDB into our new Multitenant environment as we make the move to Multitenant. I am going to create a golden image of our production non-CDB and then all dev and test databases will just be clones off the golden image. But first, I need to get the non-CDB plugged …

Continue reading

May 22

RAC Sequence Contention

I recently ran into a case where selecting the next value from a sequence was causing contention issues in Oracle RAC.  See this screen shot from Lighty (click on the image to see a larger picture) The wait events will look the same if viewed in Enterprise Manager’s performance screens, which does require one to …

Continue reading

May 21

PRVG-2027 Owner of file is inconsistent across nodes

I recently ran into an issue right after I applied the latest/greatest CPU to an Oracle RAC system. Both GI and RAC were patched. The GI alert log showed error messages like: 2018-05-13 22:03:01.121 [SRVM(32264)]CRS-10051: CVU found following errors with Clusterware setup : PRVG-2027 : Owner of file “/pkg/grid/crs12.1.0.2/lib/ libclntsh.so.12.1” is inconsistent across nodes. [Found …

Continue reading

Feb 06

Large .patch_storage

I received an alert from Enterprise Manager that one of my production databases was getting low on disk space. I tracked it down to $GRID_HOME/.patch_storage which was consuming 30GB of my 90GB drive. Yikes! The first thing I did was to run the opatch cleanup routine as I documented here back in 2013: http://www.peasland.net/2013/03/21/patch_storage/ Unfortunately, it …

Continue reading