Infrastructure at your Service

Category

Oracle

Petre Radut

Create a primary database using the backup of a standby database on 12cR2

By | Database Administration & Monitoring, Database management, Oracle | No Comments

The scope of this blog will be to show how to create a primary role database based on a backup of a standby database on 12cR2. Step1: We are assuming that an auxiliary instance has been created and started in nomount mode. rman target / restore primary controlfile from ‘backup_location_directory/control_.bkp’; exit; By specifying “restore primary” , will modify the flag into the controlfile, and will mount a primary role instance instead of a standby one….

Read More
Petre Radut

Recover a corrupted datafile in your DataGuard environment 11G/12C.

By | Database Administration & Monitoring, Database management, Development & Performance, Oracle | No Comments

On a DG environment, a datafile needs to be recovered on the STANDBY site, in two situations : when is deleted or corrupted. Below, I will explain  how to recover a corrupted datafile, in order to be able to repair the Standby database, without to be necessary to restore entire database. Initial situation : DGMGRL> connect / Connected to “PROD_SITE2” Connected as SYSDG. DGMGRL> show configuration; Configuration – CONFIG1 Protection Mode: MaxPerformance Members: PROD_SITE2 -…

Read More
Jérôme Dubar

ODA : Free up space on local filesystems

By | Database Administration & Monitoring, Oracle | No Comments

Introduction When you work on ODA you sometimes get struggled with local filesystem free space. ODA has terabytes of space on data disks, but local disks are still limited to a raid-1 array of 2x 480GB disks. And only few GB are dedicated to / and /u01 filesystems. You do not need hundreds of GB on these filesystems, but I think that you prefer to keep at least 20-30% of free space. And if you…

Read More
Nicolas Penot

Understand Oracle Text at a glance

By | Application integration & Middleware, Oracle | No Comments

What is Oracle Text? Oracle Text provides indexing, word and theme searching, and viewing capabilities for text in query applications and document classification applications. Oracle text activation for a user create user ORATXT identified by oratxt ; grant ctxapp to ORATXT ; grant execute on ctxsys.ctx_cls to ORATXT ; grant execute on ctxsys.ctx_ddl to ORATXT ; grant execute on ctxsys.ctx_doc to ORATXT ; grant execute on ctxsys.ctx_output to ORATXT ; grant execute on ctxsys.ctx_query to…

Read More
Joël Cattin

OEM Cloud Control 13c – Agent Gold Image

By | Database Administration & Monitoring, Database management, Oracle | No Comments

Introduction I am currently setting up a new “Base Image” virtual machine (Red Hat Enterprise Linux 7.6) which will be used to create 6 brand new Oracle database servers requested by a customer. Besides installing and configuring the OS, I also have to install 3 Oracle Homes and one Cloud Control Agent 13c. An OMS13c server already exists including an Agent patched with the EM-AGENT Bundle Patch 13.2.0.0.181031 (28680866) : [email protected]:/home/oracle/ [agent13c] opatch lsinventory |…

Read More
Thomas Rein

odacli create-database fails on ODA X7-2HA with java.lang.OutOfMemoryError

By | Database Administration & Monitoring, Oracle | No Comments

Today I was onsite at my customer and he told me: I can no longer create databases on my ODA X7-2HA, every time I try to use odacli create-database it fails, please help. Ok, let’s check what happens, the customer shares the Oracle Homes, he wants to create a 11.2.0.4 database: [[email protected] ~]# odacli list-dbhomes ID Name DB Version Home Location Status —————————————- ——————– —————————————- ——————————————— ———- 157bfdf4-4430-4fb1-878e-2fb803ee54bd OraDB11204_home1 11.2.0.4.180417 (27441052, 27338049) /u01/app/oracle/product/11.2.0.4/dbhome_1 Configured 2aaba0e6-4482-4c9f-8d98-4a9d72fdb96e…

Read More