impdp with parameter „cluster and parallel“ for a RAC Cluster

For using the „parallel“ parameter during an import (impdp) on a Oracle RAC Cluster you need to prepare your environment.

The „parallel“ parameter works correctly when you do the following:

– mount point were the export dump resides must be available on ALL cluster members

– create a Service on the database for the impdp job

srvctl add service -s impdp_service -d xdb1 -pdb xpdb1 -preferred xdb11,xdb12 -available xdb13

srvctl start service -s impdp_service -d xdb1

– Check that the service is running

srvctl status service -s impdp_service -d xdb1

Now you are ready to use the impdp „parallel“ parameter

Here an example with „cluster=y parallel=6

impdp system@xpdb1 directory=dump dumpfile=full_%u.dmp schemas=DB1 cluster=y parallel=6 service_name=impdp_service status=180 logfile=imp_xpdb1.log METRICS=Y logtime=all

impdp Log Parameter which are really helpful for analyzing are:

METRICS=Y

logtime=all

Extract from the Logfile

You see that there are detailed informations about the worker process for example W-1 = Worker 1

W-1 Completed by worker 1 757 TABLE objects in 38 seconds
W-1 Completed by worker 2 764 TABLE objects in 37 seconds
W-1 Completed by worker 3 765 TABLE objects in 48 seconds
W-1 Completed by worker 4 765 TABLE objects in 53 seconds
W-1 Completed by worker 5 766 TABLE objects in 34 seconds
W-1 Completed by worker 6 765 TABLE objects in 44 seconds

W-5 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

Worker 5 is processing TABLE_DATA

For analyzing the impdp process you get so detailed informations try the next time.

Depending on your hardware you can also use different integer values for the „parallel“ parameter but a large number will not help in every situation.

Have fun with impdp on your RAC Cluster….

 

 

 

 

Werbeanzeigen

12.2 Grid Patching lesson learned

What happend?

During the last month I updated manually the TFA Software.

I  do this update while the TFA release installed via the Patchset is an older Version. This happens while Oracle Support adds the TFA release which is available while they create the Patchset.

Last weekend I start Patching GI Software 12.2 to RU Oct 2018 on a 4 Node Exadata Cluster

As best practice I do the installation manually and not via opatchauto.

First activity is:

/u01/app/12.2.0.1/grid/crs/install/rootcrs.sh -prepatch

This ends with the following error message:

2019/03/09 13:36:12 CLSRSC-46: Error: ‚/u01/app/12.2.0.1/grid/suptools/tfa/release/tfa_home/jlib/jdev-rt.jar‘ does not exist
2019/03/09 13:36:12 CLSRSC-152: Could not set ownership on ‚/u01/app/12.2.0.1/grid/suptools/tfa/release/tfa_home/jlib/jdev-rt.jar‘
Died at /u01/app/12.2.0.1/grid/crs/install/crsutils.pm line 7573.
The command ‚/u01/app/12.2.0.1/grid/perl/bin/perl -I/u01/app/12.2.0.1/grid/perl/lib -I/u01/app/12.2.0.1/grid/crs/install /u01/app/12.2.0.1/grid/crs/install/rootcrs.pl -prepatch‘ execution failed

The following Doc ID 2409411.1 describes how to fix this by modifying two files. I should be fixed in Grid Release 18. 

$GRID_HOME/crs/sbs/crsconfig_fileperms.sbs
$GRID_HOME/crs/utl/<node>/crsconfig_fileperms

remove the following two entries.
unix %ORA_CRS_HOME%/suptools/tfa/release/tfa_home/jlib/jdev-rt.jar %HAS_USER% %ORA_DBA_GROUP% 0644
unix %ORA_CRS_HOME%/suptools/tfa/release/tfa_home/jlib/jewt4.jar %HAS_USER% %ORA_DBA_GROUP% 0644

I made the changes but it did not fix the problem. So I can’t go on with the Patching. For me it looks like a problem with the file permissions.

So next research on MOS and I found this important Doc ID 1931142.1:

„How to check and fix file permissions on Grid Infrastructure environment“

Yes, this was the solution :-)

cd /u01/app/12.2.0.1/grid/crs/install/

./rootcrs.sh -init

Using configuration parameter file: /u01/app/12.2.0.1/grid/crs/install/crsconfig_params

As an add on in the note you can check after the „-init“ the complete GI Installation with the following cluvfy command.

cluvfy comp software -n all -verbose

Verifying Software home: /u01/app/12.2.0.1/grid …2894 files verified
Verifying Software home: /u01/app/12.2.0.1/grid …PASSED

Verification of software was successful.

CVU operation performed: software
Date: Mar 11, 2019 10:10:11 AM
CVU home: /u01/app/12.2.0.1/grid/
User: oracle

This is very helpful. Finally I start the GI Patching without any problems

Lesson learned

„It is a good idea to check from time to time the status of the Software via cluvfy.“

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

exachk 18.4 does not run 12.2.0.1 database

For all of you who use exachk and have updated to exachk Version 18.4. There is a known Bug on Oracle databases 12.2.0.1.

While running exachk as root user the program try to connect to the database and this will no work.

You saw the following message:

„OS authentication is not enabled so please enter sysdba privileged user name for <User name>:- sys

Enter password for sys@<User name>:-

SELECT 1 FROM DUAL

*

ERROR at line 1:

ORA-01012: not logged on

Process ID: 0

Session ID: 0 Serial number: 0“

 

The workaround is to use „-shell“ option when calling exachk

# ./exachk -a -o v -shell

 

 

 

 

 

 

Arbeitsgruppen Treffen „Engineered Systems“ in Nürnberg

Wie jedes Jahr trifft sich die Arbeitsgruppe „Engineered Systems“

am Vorabend der Konferenz.

Termin: Montag, den 19.11.2018, um 17:00 Uhr

Ort: Nürnberg, ConventionCenter Ost Messezentrum, 90471 Nürnberg

Der Raum befindet sich im Zwischengeschoss

Wir haben spannende Themen auf der Tagesordnung und das Oracle Exadata und ODA Product-Management ist ebenfalls vor Ort.

Es wird wie immer interessant mit vielen Neuigkeiten rund um die Engineered Systems

Das Networking kommt natürlich auch nicht zu kurz

Wir sehen uns in Nürnberg :-)

 

 

exachk 18.2.0_20180518 released

Oracle released the new Version of exachk. The version is shown as 18.2.0_2018052018 so far so good. The next sentence in the Note is: „What’s new in exachk 12.2.0.1.4 may be found in the „What’s New in 12.2.0.1.4″ section of the User’s Guide available here..“

The new Release model from Oracle is really confusing. From my point of view it makes no sense that you download a Version as 18.2.0 and then the Documentation has a Version 12.2.0.1.4.

 

 

 

 

 

Exadata troubleshooting easy with GetExaWatcherResults.sh

If you have for example a performance problem or a crash on your Exadata Machine and you need an overview about the machine then use the very powerful tool „GetExaWatcherResults.sh“ which based on the data of Exawatcher.

GetExaWatcherResults.sh give you a details about:

  • CPU utilization and details
  • IO Summary
  • and more

GetExaWatcherResults.sh will generate very good graphics and that is what I will show now.

How is the way to get these graphs?


Login as "root"

cd /opt/oracle.ExaWatcher

GetExaWatcherResults.sh --from 02/23/2018_08:00:00 --to 02/23/2018_13:00:00 --resultdir /tmp/exawatcher_230218


Next step



cd /tmp/exawatcher_230218

bunzip2 the archive and un tar it

tar xvf ExaWatcher_exa31_2018-02-23_08_00_00_5h00m00s.tar

 

Change to the newly created directory and you find the following files


index.html
exa31.net_cpu.html
exa31.net.html
exa31.net_iodetail.html
exa31.net_iosummary.html
exa31.net_menu.html
exa31.net_mp.html

 

Start a Browser on the Server or copy the files to your notebook and start analyzing


open the "index.html" files

here the details

 

 

It is easy to answer questions like

  • What is the CPU usage on Friday between 09:00 an 14:00 o’clock?
  • Where do we have a CPU peek during the business hours?

No problem with „GetExaWatcherResults.sh“ and if needed go deeper with other tools for example „awr – report“ on the database itself or an „ash-report“

Try it. It’s very helpful :-)

 

 

 

 

Secure Erase of an Exadata System

What has to be done when the Lifecycle of an Exadata System comes to the end.

You need to do an secure erase of DB and Storage nodes.

By the way you can also secure erase the Switches and PDU, etc. but this is not described in this article.

Documentation

https://docs.oracle.com/cd/E80920_01/DBMSQ/exadata-secure-erase.htm#DBMSQ-GUID-DE6BBDF7-6BCB-412B-AD1E-E0FFEEFCC3AA

and  My Oracle Support Doc ID 2180963.1

Steps to do

I use the method via bootable USB Stick

Download Boot Image via Patch 25470974

You need a complete list of all DB and Storage node names including all IP addresses of each ILOM Server

Tip: Before you start reset the password on each Server for example „welcome1“

Prepare USB Stick

I use my Mac book and do a „dd“ to copy the image to the USB Stick

dd if=image_diagnostics_12.2.1.1.0_LINUX.X64_170126.2-1.x86_64.usb of=/dev/disk2

Start a ILOM Web Console Login for the first Server

In parallel start a ILOM terminal console session to do a restart of the first Server

While the reset is running the Web  Console came up with the BIOS Splash screen. Please  enter


<CTRL+P>

It takes a while and you see the boot menu

Select the USB Stick and press enter to start

the Boot Screen appears

Now it is time to check the output on the ILOM terminal console. You will see after a while a „login:“ prompt


Login as "root" password "sos1exadata" or "sos1Exadata"

If the password doesn’t work contact Oracle Support for help

Weiterlesen „Secure Erase of an Exadata System“

Oracle Essential Support Tools im Exadata Umfeld

Mein DOAG Vortrag zum Thema

„Oracle Support wie gehe ich vor und welche Tools setze ich im Exadata Umfeld ein“

Exadata_Oracle_Support_V1.1

Hinweis:

In der Zwischenzeit hat Oracle eine neue Version den Trace File Analyzer bereitgestellt die man dann auch einsetzen sollte. Einfach über die Doc-ID suchen.

TFA Collector – TFA with Database Support Tools Bundle (Doc ID 1513912.1)

Noch eine Anmerkung für alle die gerade PSU’s etc. eingespielt haben. Leider stellt Oracle Support nicht die oben genannte TFA Version 12.2.1.3.0 mit dem letzten PSU zur Verfügung.  Die Installation des Trace File Analyzer muss separat durchgeführt werden.