Install Oracle 19c – RPM Package Mode

Simple and easy, as it should always be.

For years I wanted to witness this moment, install oracle database in a single, simple and fast method.

With the current CI-CD paradigm, continuous deployments, continuous delivery and continuous integration, Oracle really had to provide such a solution.

Through this methodology, which involves performing the installation and configuration of the database, in a simple and agile way, it can be part of a Jenkins process or TeamCity job.

We are going to review the steps that we are going to execute:

  • Configuration of the Operating System and Download Packages.
  • Installation of the database Software.
  • Install a Database, Oracle 19, Container and a PDB.
  • Install Listener and OS Services.

Hands On

Obtain the RPM file and configure the Operating System

On my case , I use Oracle Linux.

Oracle Linux Server release 7.2

I’m login as root , execute the yum commands.

Seguir leyendo «Install Oracle 19c – RPM Package Mode»

Oracle Database 19c, Now Available !

Oracle 19c

Hi Friends !

I’m come back to share the last recently news about the Oracle Databases.

Oracle Database 19c is the long-term support version of the Oracle Database 12c and 18c family of products, which is available to Premier and Extended Support customers through March 2023 and March 2026, respectively.

It is available on Linux, Windows, Solaris, HP / UX and AIX platforms, as well as Oracle Cloud.

Oracle Database 19c offers customers the best performance, scalability, reliability and security for all their analytical and operational workloads.

Oracle 19 c :

Creating an Oracle Profile

Administering users with different policies have the possibility of major security in oracle database that compliam with all security departments in each organization.

In Oracle 19, have the same way to create profiles as Oracle 12.1, 12.2 , 18 and 19.

   CPU_PER_CALL               3000 
   CONNECT_TIME               45 
   PRIVATE_SGA                15K
   COMPOSITE_LIMIT            5000000; 

Here, you have an small explanation about each parameter :

  1. SESSIONS_PER_USER: The user can have any number of concurrent sessions.
  2. CPU_PER_SESSION: In a single session, the user can consume an unlimited amount of CPU time.
  3. CPU_PER_CALL: A single call made by the user cannot consume more than 30 seconds of CPU time.
  4. CONNECT_TIME: A single session cannot last for more than 45 minutes.
  5. LOGICAL_READS_PER_SESSION: In a single session, the number of data blocks read from memory and disk is subject to the limit specified in the DEFAULT profile.
  6. LOGICAL_READS_PER_CALL: A single call made by the user cannot read more than 1000 data blocks from memory and disk.
  7. PRIVATE_SGA: A single session cannot allocate more than 15 kilobytes of memory in the SGA.
  8. COMPOSITE_LIMIT: in a single session, the total resource cost cannot exceed 5 million service units. The formula for calculating the total resource cost is specified by the ALTER RESOURCE COST statement.

Those are not the only paramters ,but this its a great example to start diferent tests.

How to RU Patch Deinstallation

Hello Guys !

I’m here again, to give an small explanation of why, we need know how to deinstall an Release Update.

Why ?

It’s depends, on my case, the last RU had some issues in the import datapump.

After review all cases and aply some workarounds, and debug and review all logs and traces with the ADRCI tool to stay sure of my desicion, deinstall.

Additional Documentation

I review the oracle document from MOS: Database 19c Release Updates and Revisions Bugs Fixed Lists (Doc ID 2523220.1)

Hands on

The first step is verificate the number of the RU, to start with the procediment:

select CON_ID,
TO_CHAR(action_time, 'YYYY-MM-DD') AS action_time,
order by CON_ID, action_time, patch_id;

This query help us, with the list of the number, to verified the last patch applied.

Seguir leyendo «How to RU Patch Deinstallation»

How to find your Exadata Machine Version

In some caso to buil a report or its necesary know the version on own exadata machine to take some desicion to increaze the storage, virtualized or apply an upgrade we can find this information in the file databasemachine.xml :


With this command line we know where to find the file :

[root@exa01dbadm01 ~]# locate databasemachine.xml | xargs ls -l

when knowing which is the date of the file, we know which is the last updated, and there we filter which is our XML file, in order to obtain the version of the computer equipment:

[root@exa01dbadm01 ~]# cat /EXAVMIMAGES/onecommand/linux_x64/DEPLOY-20-08-2019/cluster2_databasemachine.xml | grep -i MACHINETYPE

X6-2 Elastic Rack HC 8TB

It is important that we know what each of the acronyms HC or HP means:

HP => High Performance
HC => High Capcity

I hope it is useful for reporting or making decisions about your exadata database machine.

Oracle Golden Gate on Exadata | Configure OGG

In the previous article  Install OGG, we noticed that the installation of the software Oracle GoldenGate finished fine and could observe that the manager runs fine.

So, We need to start with the following steps to continue with the awaited moment, replication.

Also for easy administration and execution of the OGG command line, it recommends setting the environment variables.

Usually, I set the env variables to avoid issues.

export OGG_HOME=/ggate/OGG/11.2.0/<$ORACLE_SID>
export ORACLE_HOME=/u01/app/dbhome/

You can set it, on the .bash_profile or (I preferred using a simple env variable script on the user home) an script.

The config used in the previous step, avoid some error that will appear, for example:

./ggsci: error while loading shared libraries: cannot open shared object file

Keep in mind this check:

  • tnsnames
  • Define TNS_ADMIN
  • Create sub dirs [OGG_CONSOLE]
  • Prepare the Source Database
  • Configure Parameters on Source and Target Databases for Golden Gate.
  • Configure Users on Source and Target Databases.

Let’s start!

Seguir leyendo «Oracle Golden Gate on Exadata | Configure OGG»

Oracle Golden Gate on Exadata | Install OGG on ACFS

Well, once installed ACFS Cluster File system, continues installing to the graphical Oracle Golden Gate Product.

Before starting this task, I recommend that check the following links. Good, let’s start.

  • Download the software OGG.

  • Create the OGG paths.
cd /ggate
mkdir -p /ggate/OGG/11.2.0/$ORACLE_SID
mkdir -p /ggate/OGG/STAGE
  • Move the file to the shared file system and unzip the file.
mv /ggate/OGG/STAGE
cd /ggate/OGG/STAGE
  • Set the X variables and execute the OGG installation.
cd fbo_ggs_Linux_x64_shiphome
export $OGG_HOME=/ggate/OGG/11.2.0/$ORACLE_SID

Note Tip: You have the option to realize the silent mode installation. Check Here OGG Silent Mode

  • Select the Database Version Button (we choose the 11g, because we’ll replicate between 11g and 12c)

Remember, it depends on the site where you install the OGG binaries, you need to choose the adequate version supported by your database.

Seguir leyendo «Oracle Golden Gate on Exadata | Install OGG on ACFS»