Monday, May 31, 2021

Erman Arslan's Oracle Forum -- May 2021 - "Questions and Answers Series"

Question: How much time do you spend/lose?

Answer: Well, how much time I gain? :) 

Remember, you can ask questions and get remote support using my forum.
Just click on the link named "Erman Arslan's Oracle Forum is available now.
Click here to ask a question", which is available on the main page of Erman Arslan's Oracle Blog 
-- or just use the direct link:


Come on, let's see what we've been up to in May .
Do not forget to read the blog posts too :)


May 2021 Issues:

·     logminer read rate downstream DB by Roshan

·        Upgrade Java Version on Oracle APPS R 12.0 by Brian Hogantara

·        logminer read rate by Roshan

·        open files by Roshan

·        How do I set db_unique_name properly in CDB.env file? by SriCheb

·        Concurrent manager for Alert Notification by big

·        Creating materialized view based on OEBS editionables by ANIETO

·        Oracle datbase is generating lot and lot of .trc and .trm files by Mohammed Hamed

·        EBS Database performance degraded after upgrade to 19c by soumya

·        Failure of server APACHE bridge by big

·        vmstat by Roshan

·        Dblink from Linux to windows by satish

·        Order of modules during conversion by Kalyana Chakravarthy

·        Bursting program errors by Sri

·        Migration of EBS R12.2.4 from Redhat 6 to Redhat 7 by Tabrez

·        shared NFS performance issue by Roshan

·        rapidwiz failed during installation 12.2 on 2 node rac environment. by raiq1

·        regarding forms by shafi

·        Adstpall.sh is exiting with status 3 by Mohammed Hamed

·        runcluvfy failed continuously by raiq1

·        Rac to Rac Cloning by dbaappadmin

·        Oracle indexes --in Turkish by sami çelik

·        Re: R12.2.4 Failed to execute FMW pre-requisite check by abdul

·        Replication/ updation of Patch on eBS by Zaheer

·        R12.2.4 Failed to execute FMW pre-requisite check by abdul

·        shareplex by Roshan

·        Monitor MV by Roshan

·        configuring psqlodbc-13.00.0000 in RHEL7 64bit by satish

·        OHS 12.2.1.4 config issue by Zaheer

·        DBlink from oracle to postgresql -DG4ODBC by satish

·        SQL Monitoring Report - Estimated Rows by DBAS

·        Dblink from oracle to PostgreSQL by satish

·        Long running concurrent programs - in Turkish by serdar

Sunday, May 30, 2021

Exadata X8M-2 & PCA X8-2 -- Part 2 Installation / Exadata X8M-2 installation (Imaging, install.sh steps, insights, notes and so on)

Let's take a look at Exadata X8M-2 installation process.. Actually, It is a standard procedure that we follow for installing all the Exadata versions.. 

This time we have ROCE and PMEM inside the machine (in addition to the standard Exadata hardware), but these components don't make any difference while imaging the machine.. We just be sure that they are working properly after the imaging and before installing the GRID & RDBMS software..

In this post, I will give you an overview about the process, some clues and some experiences real life..

Let's start with the installation method; 

Well... The installation/imaging is done remotely due to pandemic.

Basically, we need a shell that allows remote copy-paste for during installation process.

Shared Shell does that job ->  https://www.oracle.com/support/shared-shell.html

Only the java must be installed on the client computer that runs the shell.

The installations are done from a NFS share. So, we put all the required installation files into the NFS share and make the installation by using them..

The installation process is similar to the method that we follow for installing the earlier versions of Exadata.

We connect to the ILOM interfaces of the nodes using SSH.

We first install the CELL nodes, then the DB nodes.. Actually it doesn't matter which node we start with , but we prefer installing the CELL nodes first.. 

The steps for imaging/re-imaging is similar both for DB and CELL nodes.. We just use different ISO images..

Before the imaging, we need to have the NFS shares be accessable from the ILOMs of the Exadata nodes. This is caused of the configuration we do, we basically tell ILOMs to reach the NFS and boot from there.

So, we connect the first CELL using ILOM through SSH and we start the /SP/console. (start /SP/console)

We check the current image version of the CELL using imageinfo.

We set the ISO using the set server_URI command. (set server_URI=nfs://nfs_ip/directory/cellblabla.iso) 

Note that, we mustunzip the cell image zip file before that.

Then, we use "set /SP/services/kvms/host_storage_device/ mode=remote", and tlater set the boot device to cdrom. (set boot_device=cdrom)

We reboot/hard reset.. the node ->  "reset /SYS"  and then we run the command "start /SP/console" (to follow the boot process) -- The node boots itself using the new iso placed in the NFS.. So reimaging starts taking place here..

We watch the first boot of the first cell node we are imaging and see if there are any problems or not.. If everything works as expected, we repeat the same process for all the remaining CELL nodes in parallel..

When the boot process is completed, we check the image version with the imageinfo command and expect to see the image version we used for the installation/imaging/reimaging process.

Once we complete reimaging the CELL nodes, we use the same installation method for the DB nodes.. Remember, only the ISO image is different for the DB nodes. ( so we set the correct Image using the set server_URI)

Once the imaging is completed, we expect to see that all the interfaces are up & running. The interfaces with re prefix (re*) are ROCE interfaces.. eth0,bondeth0, re1, re2.. all of the must be up.

Note that, in our case, in one of the CELL nodes, the ROCE interfaces were not present.. We reimaged that CELL multiple times but this didn't solve the issue. 

We even check the system by following the MOS Note: Verify RoCE Cabling on Oracle Exadata Database Machine X8M-2 and X8M-8 Servers (Doc ID 2587717.1), but no fix.. 

That CELL node couldn't see the ROCE interfaces at all.. So we made a dummy replacement.(reseat the cards and cables) , rebooted the machine and it worked! Of course we created an SR and ordered the new ROCE interfaces, but this move saved the day and we could at least proceed with the software installation.

One important note; in these kinds of issues that we identify during the installation, any issues like hardware issues , ILOM alerts, blinking Service led and so on, we create a SR to Oracle Support and solve the issue by following that SR.

Note that, we had Service led blinking in one of the Cell nodes as well.. This time for PMEM.. Well,.. We did that dummy replacement trick and reseated the failing card.  It worked for this issue too :) Again, we still ordered the new parts...

We also had a LACP issue in the DB nodes.. The LACP client interfaces were up but not pingable .. We investigated the issue in the Linux side but everyting seemed okay.. Then the customer corrected the configuration in the switch side and LACP interfaces started working properly.. So, if you encounter problems with the LACP - (for the client interfaces), make the customer check the switch configuration and cabling in the first place! :)

Link Aggregation Control Protocol (LACP) on Exadata (Doc ID 2198475.1)

We continue with the software installation; (GRID, Database and all that) 

We put the files listed in OEDA output into the nfs share. ( or into a local directory on the first database node) Note that, we don't put the ISO images that we used for the imaging process into the NFS share.

Before starting the software installation, we check all the nodes and ensure that, their network interfaces are up, their dates are correct and sync, their gateways are correct and pingable.. (we do all the environment checks including nslookup actually...) We also check the passwordless ssh connectivity between the nodes ( for root)

Then, we run the install.sh Example:install.sh -cf OEDA_xml-s1 ... In order to run this command, the OEDA itself should be there in the node as well.. Ofcourse OEDA xml too should be there.

Note that, we need to use the same version of OEDA, which we used to create the OEDA xml. If we use a different version of OEDA during the software installation, we may get errors while performing the install steps. So, if we use a newer version of OEDA for the installation, then we need to rebuild our OEDA xml using that newer version of OEDA.. ( We open the newer OEDA, we import the OEDA xml and we save it.. This way, we get our OEDA xml generated with our new version ODEA)

Note that, one of the steps of install.sh updates the environment as 1/8 rack. (if we are performing a 1/8 installation). Install.sh uses OEDA xml as input. So in this step, install.sh decrease the cores and it implements the Capacity on Demand if we choosed that in OEDA. For instance, it decreases the core count of the second db node to 8 and reboot that node.. Then , it decrease the core count of first db node and reboot the node.. After the reboot, we continue with the next step of install.sh.

So we complete all the steps (that we find necessary to be implemented.. For instance ,we don't execute the step named Resecure Machine in some of the installations, as very tight security becomes a problem in some customer sites.) and finish the software installation.. 

Once the installation is completed, exachk is executed and lastly we get our installation report.. 

That 's it.. After completing the steps in install.sh, we get ourselves an up&running, ready Exadata X82-M..

You can check my previous Exadata installation-related blog posts about this install.sh process but it is mostly straight forward..

Next post in this series (Part3) will be about on PCA configuration.. I mean configuring the virtual environment in PCA. Stay tuned ! Happy weekend.

Tuesday, May 4, 2021

Erman Arslan's Oracle Forum -- April 2021 - "Questions and Answers Series"

Question: How much time do you spend/lose?

Answer: Well, how much time I gain? :) 

Remember, you can ask questions and get remote support using my forum.
Just click on the link named "Erman Arslan's Oracle Forum is available now.
Click here to ask a question", which is available on the main page of Erman Arslan's Oracle Blog -- or just use the direct link:



Come on, let's see what we've been up to in April.
Do not forget to read the blog posts too :)

Sunday, May 2, 2021

Exadata X8M-2 & PCA X8-2 -- Part 1 Pre Installation / the process, my experiences and quick notes

Dealing with a new project, a big replatforming.. The target systems are 2 x Exadata X8M-2 (1 for primary site and 1 for disaster recovery site) and a PCA X8-2. This project involves installation, migration (readiness, SOPs , Runbooks, Project Management and execution) and improvements done during or after migration.
Just starting it and couldn't get my hands on yet, at least couldn't get my hands on Erman Arslan mode :), as we are currently in the pre-installation phase. But! I feel already excited, as these are the latest tech. enginereed systems of Oracle and although I did several projects (installation, upgrade, migration and so on) on engineered system like Exadata and ODA, PCA is a new engineered system for me and Exadata X8M-2 is the latest generation for the leading Engineered System of Oracle. 
Besides, we have ROCE (RDMA over Converged Ethernet) and PMEM on this new generation "M" model of Exadata. Note that that "m "in the X8M-2 is there for imlpying the changes in the memory (think about the persistent memory, the advantages it brings).

Remember, 

In 8th generation of Exadata, we have actually 2 main models. One of them is Exadata X8-2 and the other one is X8M-2, which has a brighter future.So if you decide to use X8M-2 on your POC, you'd better do your POC with Oracle Database 19C.
This is because; only 19.3 or greater has full support for the persistent memory commit accelerator. For instance; 18c will not directly use PMEM. It will send a message to the CellSrv, and this will find data in PMEM, so PMEM acts as an extra level of cache. On the other hand; 19c can access PMEM directly via RDMA.
So I think you know what I mean.. This is not a must, but in fact, this is necessary to unleash the performance of Exadata X8M-2.

Well, I want to share my experiences along this project, and we are just starting it with Part 1 - pre installation..

Let's first see the machines : 


You already know Exadata.. It is for Oracle Databases only. 
PCA, on the other hand; can be considered as a new engineered system for most of you, and it is basically the application machine.. We consolidate the applications and the middleware on PCA and get the countless benefit of it. 
We don't position ODA or Exalogic here.. Reason? 
Please see> https://ermanarslan.blogspot.com/2020/10/oda-as-weblogic-appliance-or-is-it.html (ODA as a Weblogic Appliance ? Or is it better to consider PCA?)

Okay, we start with the installation.. My part starts here.. Actually I have several responsibilites in this project, local installation coordination, tech lead for database migration , tech lead for application migration & consolidation and so on.

So the first part is the installation.
We have 2 different machines types and we have 2 different approaches for deploying them.

Let's start with Exadata X8M-2.. Actually the installation process is similar to the earlier generation of Exadata.. So it is a traditional installation method for those who have done Exadata installation.

Basically, we start by making some mettings with the customer and explain them the installation process. Then a coordinator is assigned to the installation process and he/or she makes the coordination globally (partners, ACS , HW team , Customer side and son).. Basically, coordination for HW installation and then software installation and so on :)

As the first thing, we start filling OEDA. (Oracle Exadata Deployment Assistant)
For the new Exadata customers, this is a little tricky.. So we help them.. We actually complete the OEDA process by taking the necessary inputs from the customer..

At this point, I want to mention the latest version of OEDA, because I liked it :) 

For the ones, who are not familiar with Exadata installation process; OEDA is a java tool to be used for gathering the information needed to deploy Exadata.


Once we download it, we unzip and run the installOedaServer.cmd (Note that, I prefer running the tool from a Windows client)

Once the command is executed, OEDA server starts running (Jetty and HTTP Sever), and we reach the OEDA interface by using our browser .. The url is : http://localhost:7002/oeda

It is web based now and it is quite stable.. (free from the most of the bugs)



Ofcourse, we will fill the OEDA with the information we gather from the customer . During the way, we give advices and we guide the customer through the form and finally we get our OEDA ouputs later to be used in the software installation.. 

We do that by leveraging our expertise and by reviewing the customer's order.. (what network card did they order? any memory expansion? how many cores -- considering capacity on demand / COD and so on)

Those OEDA outpus should be validated though. For this, we have a checkip script and we run it on a machine which has all the grants to reach the IP addresses used in the OEDA form.. That machine should reach NTP servers, DNS and etc..  (Note that, we have the option to directly execute the checkip from OEDA as well)

Before running the checkip script, we should be sure that all the requirements are met according to our inputs.. I mean those IP Addresses which are planned to be given to the Exadata nodes should be available, NTP and DNS servers should be reachable, hostname-ip definitions must be there and so on..

One more thing which should be ready before the installation is the network and power cables. These should be ready before the installation and a site visit can be done to check the customer site if necessary.

As we are having hard days because of pandemic, we work remotely.. Even in the case of an Exadata deployment.. Ofcourse for the hardware related part of the installation, we go there to the data center but after that we do the installation/reimaging/or reconfiguration remotely.. 

All we need is a remote connection (maybe a zoom session) and a NFS share which host the installation files to be used in the installation.

--Already curios about the installation? Can not wait for Part 2? Then search my blog with the keywords -> "Exadata installation", I have several articles about it..

Anyways; those installation files are easy to get.
We just make sure that the customer downloaded  "Appendix B: Required Files and Patches" patches and distributions. We also ask the customer to download the screen utility to avoid network connectivity issue which could impact on software installation process.

https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/screen-4.1.0-0.26.20120314git3c2946.el7.x86_64.rpm

An example of the list of installation files used in Exadata X8M-2 deployment:

V982063-01.zip

V982068-01.zip

linuxamd64_12102_database_1of2.zip

linuxamd64_12102_database_2of2.zip

p32067171_190000_Linux-x86-64.zip

p32119956_121020_Linux-x86-64.zip

p32131231_121020_Linux-x86-64.zip

p32226239_190000_Linux-x86-64.zip

p32289783_1910000OCWRU_Linux-x86-64.zip

p32301133_1910000DBRU_Linux-x86-64.zip

p6880880_180000_Linux-x86-64.zip

ahf_setup (Autonomous Health Framework setup file)

download Autonomous Health Framework (AHF) setup file from My Oracle Support using patch number 30166242

Well, we make the customer download them and put them in a NFS share.. DVD ISO images/grid infrastructure/RDBMS files....

Some important notes here;

* We can place some inactive third party parts in Exadata Rack.. (such as patch panels) -- We still need to get approval from the Engineered System team.
* We should create at least one database from each Oracle Home that we specified in OEDA.. If we specify Oracle Homes and not specify any databases which should be created from them, this could lead unpredictable OEDA behaviors.
*Capacity on Demand installation requires something which can be used for remote monitoring.. Platinum Support Gateway for instance..  I said someting for remote monitoring.. This is my opinion, but there is a requirement like that..
* We don't need to use COD if we have the licenses required to support all the core that we have on Exadata nodes.. For instance, if we have 48 core database license for the machine, and if we are on a Exadata X82M-2 1/8, then we disable the COD and use the machine full core.. No need to enable COD and choose 24/24 cores per node.
* Core counts that we specify on OEDA are per node.
* Actually, it is better to use the latest Exadata Iso images (other than the one given in OEDA Appendix B). In order to do that;

we go to https://edelivery.oracle.com/

"All Categories" > "Download package": Exadata Storage Server Software 20.1.8.0.0 ( currently it it the latest version) -> then click search
"View items" -> "continue"




Well, after filling and validating the OEDA, having the data center ready, dowloading the installation
files and preparing the requirements for remote software installation, we can plan the hardware (HW) and software (SW) installation.. HW installation is a straight forward process, so I don't get into the details about it here, but SW installation is a little tricky, so I will explain it in the next blog post on this topic -- Part 2 -Installation..

As we are okay with the Exadata side, let's look at the PCA's pre installation phase.
PCA doesn't have a process like Exadata, I mean no OEDA and validation scripts, just a HW installation and provisioning.

After the provising I expect to have a VM Manager weui url and I also plan to register it with an Enterprise Manager and use these tools to create Virtual machines and etc.. 

PCA is quite new for the environment that I'm currently in. I mean for Turkey :) 
So we will see it once we get our hands dirty.. But it is basically a clustered Oracle VM Server environment for us.. We will use the VM Manager (and maybe EM) to configure our VM hosts on this new PCA and then migrate our applications mostly in as-is manner.. 
Details about the provisioning and managing the PCA will be on the next blog posts, especially on Part 2 ..

One thing about the PCA installation is that, the customer should review the following document and ensure the network is ready for the PCA installation ->