Infrastructure at your Service

Category

Oracle

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
Thomas Rein

DOAG 2018: OVM or KVM on ODA?

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

The DOAG 2018 is over, for me the most important topics were in the field of licensing. The insecurity among the users is great, let’s take virtualization on the ODA, for example: The starting point: The customer uses Oracle Enterprise Edition, has 2 CPU licenses, uses Dataguard as disaster protection on 2 ODA X7-2M systems and wants to virtualize, he also has 2 application servers that are also to be virtualized. Sure, if I use…

Read More