Oracle ACE

Vor zwei Jahren als Oracle ACE Associate gestartet, wurde ich nun zum Oracle ACE „befördert“.  Vielen Dank

Two years ago I started as Oracle ACE Associate and now I was „promoted“ to the Oracle ACE status. Many Thanks

 

 

 

 

 

 

Advertisements

CFP für Exaday 2017 gestartet

exaday_2017-banner_468x180

Es geht los bis zum 13.2.2017 können Vorträge für den Exaday 2017 rund um das Thema Oracle Engineered Systems eingereicht werden

Ich freue mich auf viele spannende Vorträge …

http://exaday.doag.org/de/home/

Der Exaday 2017 findet dieses Jahr am 20. Juni 2017 in Frankfurt – Mörfelden statt

 

The Call for Paper is opened until 13.2.2017

Please submit for the Exaday 2017 all around the topic Oracle Engineered Systems

http://exaday.doag.org/de/home/

The Exaday 2017 will be this year on the 20 June 2017 in Frankfurt – Mörfelden (near by the airport)

 

 

 

 

Exadata EM 12c agent error after Upgrade to OL6 „unable to create new native thread“

cluster_patch

Recently we did some patching activity on our Exadata machines.

One part is the Upgrade of the DB Nodes which includes the upgrade to Oracle Linux 6.

This works fine but afterwards we had a problem starting our the Cloud Control agent.

We saw the following error message: „unable to create new native thread“

[oragrid@db1 ~]$ emctl start agent

Oracle Enterprise Manager Cloud Control 12c Release 5

Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.

Starting agent .................................................................... started but not ready.

[oragrid@db1 ~]$ emctl status agent

Oracle Enterprise Manager Cloud Control 12c Release 5

Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.

---------------------------------------------------------------

unable to create new native thread

[oragrid@db1 ~]$ emctl status agent

Oracle Enterprise Manager Cloud Control 12c Release 5

Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.

---------------------------------------------------------------

The problem will be fixed by the following MOS Note and action

EM 12c : Agent Restarts Due To Out Of Memory Exception “ unable to create new native thread“ Out Of System Resources (Doc ID 1499576.1)

For OEL6.x /RHEL 6.x
vi /etc/security/limits.d/90-nproc.conf

* soft nproc 1024

root soft nproc unlimited

Change TO

* soft nproc 65536

Restart the agent:

$<AGENT_INST>/bin/emctl stop agent

$<AGENT_INST>/bin/emctl start agent

 After restarting the agent everything works fine.

 

 

Deinstallation von Oracle 11.2.0.X Software

Im normalen Betrieb kommt es selten vor, dass Oracle Software deinstalliert wird. Ich konnte mich auch nicht daran erinnern wann ich das letzte Mal RDBMS Software deinstalliert habe, aber jetzt liegt die Anfrage vor und zwar im Zusammenhang mit einer Teststellung.

Nach Abschluss der Teststellung für ein neues Produkt kam die Anfrage, dass die Software inklusive der dafür installierten Oracle Software gelöscht werden soll. Also dachte ich kein Problem starte doch einfach den runInstaller aus dem entsprechenden ORACLE_HOME und der „räumt“ dann auf.

Gesagt getan startet ich den Installer aus dem ORACLE_HOME  und dann kam direkt ein Pop-Up Window mit dem Hinweis man solle doch aus dem jeweiligen ORACLE_HOME das Programm „deinstall“ aufrufen.Gut also setzte ich die Umgebung und starte das deinstall Tool allerdings zuerst im „–precheck“ Modus.

Parallel schaute ich zur Sicherheit noch mal im Metalink nach und fand den Hinweis, dass Oracle ab der Release 11.2 empfiehlt die Software nicht mehr per Universal Installer zu deinstallieren. Vielmehr gibt es pro Oracle 11.2 Release ein separates deinstall Tool.

Dies ist in der der „Doc ID 1363753.1: Behaviour of the Oracle De-install/Deinstall/Uninstall Utility in 11gR2” ausführlich beschrieben.

So ging ich auf OTN und startete nun den Download the Software für die Release 11.2.0.4

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

deinstall_tool

Nach dem Download wird zuerst das Tool in einem Verzeichnis außerhalb vom eigentlichen ORACLE_HOME ausgepackt.

Ich führte die Installation da es sich um einen RAC – Cluster auf dem ersten Clusterknoten durch.


<strong>/u01/app/oracle/deinstall</strong>

rw-r--r-- 1 root root 119521122 Nov  5 13:42 linux.x64_11204_deinstall.zip

unzip linux.x64_11204_deinstall.zip

Achtung! Das „deinstall“ Tool löscht nicht nur die Oracle Software mit sämtlichen Komponenten, sondern auch alle dazugehörigen Datenbanken, Konfig-Dateien auf dem Betriebssystem. Daher empfiehlt es sich vorher ein Backup durchzuführen.

Im Folgenden der Start des deinstall Tools und Output der Verarbeitung


$./deinstall -home /u01/app/oracle/product/11.2.0/dbhome_4



location of logs /u01/app/oraInventory/logs/

############ ORACLE DEINSTALL & DECONFIG TOOL START ############

######################### CHECK OPERATION START #########################

## [START] Install check configuration ##

Checking for existence of the Oracle home location /u01/app/oracle/product/11.2.0.4/dbhome_4

Oracle Home type selected for deinstall is: Oracle Real Application Cluster Database

Oracle Base selected for deinstall is: /u01/app/oracle

Checking for existence of central inventory location /u01/app/oraInventory

Checking for existence of the Oracle Grid Infrastructure home /u01/app/12.1.0.2/grid

The following nodes are part of this cluster: s96db1,s96db2

Checking for sufficient temp space availability on node(s) : 's96db1,s96db2'

&nbsp;

## [END] Install check configuration ##

Network Configuration check config START

Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_check2015-11-05_02-31-29-PM.log

Network Configuration check config END

Database Check Configuration START

Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_check2015-11-05_02-31-34-PM.log

Use comma as separator when specifying list of values as input

Specify the list of database names that are configured in this Oracle home []:

Database Check Configuration END

Enterprise Manager Configuration Assistant START

EMCA de-configuration trace file location: /u01/app/oraInventory/logs/emcadc_check2015-11-05_02-35-33-PM.log

Enterprise Manager Configuration Assistant END

Oracle Configuration Manager check START

OCM check log file location : /u01/app/oraInventory/logs//ocm_check_2015-11-05_02-35-33-PM.log

Oracle Configuration Manager check END

######################### CHECK OPERATION END #########################

####################### CHECK OPERATION SUMMARY #######################

Oracle Grid Infrastructure Home is: /u01/app/12.1.0.2/grid

The cluster node(s) on which the Oracle home deinstallation will be performed are:s96db1,s96db2

Oracle Home selected for deinstall is: /u01/app/oracle/product/11.2.0.4/dbhome_4

Inventory Location where the Oracle home registered is: /u01/app/oraInventory

No Enterprise Manager configuration to be updated for any database(s)

No Enterprise Manager ASM targets to update

No Enterprise Manager listener targets to migrate

Checking the config status for CCR

s96db1 : Oracle Home exists with CCR directory, but CCR is not configured

s96db2 : Oracle Home exists with CCR directory, but CCR is not configured

CCR check is finished

Do you want to continue (y - yes, n - no)? [n]: y

A log of this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2015-11-05_02-31-23-PM.out'

Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2015-11-05_02-31-23-PM.err'

######################## CLEAN OPERATION START ########################

Enterprise Manager Configuration Assistant START

EMCA de-configuration trace file location: /u01/app/oraInventory/logs/emcadc_clean2015-11-05_02-35-33-PM.log

Updating Enterprise Manager ASM targets (if any)

Updating Enterprise Manager listener targets (if any)

Enterprise Manager Configuration Assistant END

Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_clean2015-11-05_02-36-13-PM.log

&nbsp;

Network Configuration clean config START

Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_clean2015-11-05_02-36-13-PM.log

De-configuring Listener configuration file on all nodes...

Listener configuration file de-configured successfully.

De-configuring Naming Methods configuration file on all nodes...

Naming Methods configuration file de-configured successfully.

&nbsp;

De-configuring Local Net Service Names configuration file on all nodes...

Local Net Service Names configuration file de-configured successfully.

&nbsp;

De-configuring Directory Usage configuration file on all nodes...

Directory Usage configuration file de-configured successfully.

De-configuring backup files on all nodes...

Backup files de-configured successfully.

The network configuration has been cleaned up successfully.

Network Configuration clean config END

Oracle Configuration Manager clean START

OCM clean log file location : /u01/app/oraInventory/logs//ocm_clean_2015-11-05_02-35-33-PM.log

Oracle Configuration Manager clean END

Setting the force flag to false

Setting the force flag to cleanup the Oracle Base

Oracle Universal Installer clean START

Oracle Universal Installer clean START

&nbsp;

Detach Oracle home '/u01/app/oracle/product/11.2.0.4/dbhome_4' from the central inventory on the local node : Done

Delete directory '/u01/app/oracle/product/11.2.0.4/dbhome_4 on the local node : Done

The Oracle Base directory '/u01/app/oracle' will not be removed on local node. The directory is in use by Oracle Home '/u01/app/oracle/product/11.2.0.4/dbhome_1'.

Detach Oracle home '/u01/app/oracle/product/11.2.0.4/dbhome_4 from the central inventory on the remote nodes 's96db2' : Done

Delete directory '/u01/app/oracle/product/11.2.0.4/dbhome_4' on the remote nodes 's96db2' : Done

&nbsp;

Oracle Universal Installer cleanup was successful.

Oracle Universal Installer clean END

### [START] Oracle install clean ##

Clean install operation removing temporary directory '/tmp/deinstall2015-11-05_02-31-23PM' on node 's96db1'

Clean install operation removing temporary directory '/tmp/deinstall2015-11-05_02-31-23PM' on node 's96db2'

## [END] Oracle install clean ##

######################### CLEAN OPERATION END #########################

&nbsp;

&nbsp;

####################### CLEAN OPERATION SUMMARY #######################

Cleaning the config for CCR

As CCR is not configured, so skipping the cleaning of CCR configuration

CCR clean is finished

Successfully detached Oracle home '/u01/app/oracle/product/11.2.0.4/dbhome_4' from the central inventory on the local node.

Successfully deleted directory '/u01/app/oracle/product/11.2.0.4/dbhome_4 on the local node.

Successfully detached Oracle home '/u01/app/oracle/product/11.2.0.4/dbhome_4' from the central inventory on the remote nodes 's96db2'.

Successfully deleted directory '/u01/app/oracle/product/11.2.0.4/dbhome_4' on the remote nodes 's96db2'.

Oracle Universal Installer cleanup was successful.

Oracle deinstall tool successfully cleaned up temporary directories.

#######################################################################

############# ORACLE DEINSTALL & DECONFIG TOOL END #############

[oracle@s96db1 deinstall]$

Die Deinstallation lief ohne Probleme und löschte auf beiden Clusterknoten die Software und die dazugehörige Dateien, Datenbanken und Konfigurationsdateien.

Abschließend prüfte nochmal das  zentrale Inventory. Dort wird das gelöschte ORACLE_HOME als „REMOVED“ gekennzeichnet.


<strong>Check of central inventory File</strong>

cd /u01/app/oraInventory/ContentsXML

<HOME NAME="OraDb11g_home6" LOC="/u01/app/oracle/product/11.2.0.4/dbhome_4" 
TYPE="O" IDX="10" <strong><strong>REMOVED</strong></strong>="T"/>

 

Oracle verlängert kostenfreien „Extended Support“ für Oracle Database 11gR2 bis Mai 2017

Das ist eine sehr gute Meldung für alle Kunden, die aktuell in Migrationsprojekten auf Release 12c „stecken“.

Durch die Verlängerung des Extended Support, bleibt den Kunden mehr Zeit Ihre aktuellen Systeme auf das neue Release anzuheben.

http://www.doag.org/home/aktuelle-news/article/oracle-verlaengert-kostenfreien-extended-support-fuer-oracle-database-11gr2-bis-mai-2017.html

 

Setup and Testing the ZFS Simulator

zfs_storage

ZFS Storage is a great hardware and an excellent platform for example to do disk based Oracle backups. To get a feeling how this technology works it is a good idea to do a setup with the ready to run Virtualbox ZFS Appliance.

You find the complete Software and Setup documentation here

http://www.oracle.com/technetwork/server-storage/sun-unified-storage/downloads/sun-simulator-1368816.html

Please follow the documentation for the setting up the ZFS simulator.

Personal note: Per default the network setup is done via “host only” interface inside the virtualbox. I use in my own Virtualbox World only fixed IP-Addresses, so I changed the default interface to “network bridge” and give the host a fixed IP-Address. So it was very easy to integrate the Virtualbox in my environment.  The second comment is about the installed Firefox Version. I started with Firefox Version 31 and get a lot of SSL errors during the start via https://zfs.localdomain:215/. So I did a update to Firefox 38 and then the browser could easily handle the SSL connect.

ZFS Simulator is up and running what’s next:

Start the Browser User Interface (BUI) to create a new share on the ZFS unit. The share is actually created independently of the protocol, so it gives more flexibility to interact with this share via NFS, and also FTP and Samba is possible.

ZFS_Setup_Project

Overview about the Share

ZFS_OraBackup

Next I start the NFS services on my the Linux Server


chkconfig service nfs

service status nfs

service nfs start

Here I create a mountpoint  and change the fstab on the Linux Server


mkdir –p /mnt/OraBackup

/etc/fstab
zfs.localdomain:/export/OraBackup /mnt/OraBackup nfs rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,vers=3,timeo=600    1 2

That’s it. Finally I mount the filesystem.

mount /mnt/OraBackup

Now I start to do some tests with the ZFS simulator and do a rman backup from my 12c database


oracle@srv1 ~]$ rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Thu Aug 27 17:09:14 2015
Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.
connected to target database: CDB (DBID=1975575730)
RMAN> run
2> {
3> allocate channel c1 device type disk format '/mnt/OraBackup/%U';
3> backup as compressed backupset database;
4> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=53 device type=DISK
Starting backup at 27-AUG-15
channel c1: starting compressed full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/oradata/CDB/sysaux01.dbf
input datafile file number=00001 name=/u01/oradata/CDB/system01.dbf
input datafile file number=00004 name=/u01/oradata/CDB/undotbs01.dbf
input datafile file number=00006 name=/u01/oradata/CDB/users01.dbf
channel c1: starting piece 1 at 27-AUG-15
channel c1: finished piece 1 at 27-AUG-15
piece handle=/mnt/OraBackup/1cqflpvg_1_1 tag=TAG20150827T171008 comment=NONE
channel c1: backup set complete, elapsed time: 00:01:55
channel c1: starting compressed full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00007 name=/u01/oradata/CDB/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u01/oradata/CDB/pdbseed/system01.dbf
channel c1: starting piece 1 at 27-AUG-15
channel c1: finished piece 1 at 27-AUG-15
piece handle=/mnt/OraBackup/1dqflq33_1_1 tag=TAG20150827T171008 comment=NONE
channel c1: backup set complete, elapsed time: 00:01:15
channel c1: starting compressed full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00009 name=/u01/oradata/CDB/PDB1/sysaux01.dbf
input datafile file number=00008 name=/u01/oradata/CDB/PDB1/system01.dbf
input datafile file number=00010 name=/u01/oradata/CDB/PDB1/PDB1_users01.dbf
channel c1: starting piece 1 at 27-AUG-15
channel c1: finished piece 1 at 27-AUG-15
piece handle=/mnt/OraBackup/1eqflq5e_1_1 tag=TAG20150827T171008 comment=NONE
channel c1: backup set complete, elapsed time: 00:01:15
channel c1: starting compressed full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00012 name=/u01/oradata/CDB/PDB2/sysaux01.dbf
input datafile file number=00011 name=/u01/oradata/CDB/PDB2/system01.dbf
input datafile file number=00013 name=/u01/oradata/CDB/PDB2/PDB2_users01.dbf
channel c1: starting piece 1 at 27-AUG-15
channel c1: finished piece 1 at 27-AUG-15
piece handle=/mnt/OraBackup/1fqflq7p_1_1 tag=TAG20150827T171008 comment=NONE
channel c1: backup set complete, elapsed time: 00:01:15
channel c1: starting compressed full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00015 name=/u01/oradata/CDB/PDB3/sysaux01.dbf
input datafile file number=00014 name=/u01/oradata/CDB/PDB3/system01.dbf
input datafile file number=00016 name=/u01/oradata/CDB/PDB3/PDB3_users01.dbf
channel c1: starting piece 1 at 27-AUG-15
channel c1: finished piece 1 at 27-AUG-15
piece handle=/mnt/OraBackup/1gqflqa4_1_1 tag=TAG20150827T171008 comment=NONE
channel c1: backup set complete, elapsed time: 00:01:16
Finished backup at 27-AUG-15

During the backup I start the  “Status Overview” of the ZFS

ZFS_Backup_Overview

That is a powerful overview about the ZFS appliance and you can also create custom worksheets.

In summary, the ZFS Simulator virtual box is a very good environment to get a feeling for this technology and also to do some tests and training with the ZFS technology.

Next I would like to create an Oracle database on the ZFS by using dnfs hope it works. So stay tuned.

 

tfactl configuration for „repositorydir“

tfactl125

After a system crash Oracle Support asked for a tracefile collection with the option „-all“.

Yes this will be a huge file because the required analysis runs over a few days.

In the default configuration the tfactl repository is under  the Oracle base structure normally „/u01/app/oracle“.

The Filesystem „/u01“ has actually only 20 GB freespace and the collection which has to be done for the cluster generates files of minimum 18 GB.

This means freespace for „/u01“ is very scarce.I need a temporary solution and after a while and reading the tfactl users guide I found a solution.

With the following command „SET REPOSITORYDIR“ it is possible to change the location temporary or permanently.

/u01/app/12.1.0.2/grid/bin/tfactl set repositorydir=/mnt/gi12102_sr

Successfully changed repository

.------------------------------------------------------------.

| Repository Parameter      | Value                          |

+---------------------------+--------------------------------+

| Old Location              | /u01/app/oracle/tfa/repository |

| New Location              | /mnt/gi12102_sr                |

| Current Maximum Size (MB) | 10240                          |

| Current Size (MB)         | 0                              |

| Status                    | OPEN                           |

'---------------------------+--------------------------------'

I started the tfactl and the data collection works fine. Here the comand.

tfactl diagcollect -from "Aug/20/2015 12:00:00" -to "Aug/22/2015 19:00:00"

After the data colection I changed the directory back to the old location.

/u01/app/12.1.0.2/grid/bin/tfactl set repositorydir=/u01/app/oracle/tfa/repository

For more details take a look to MOS note: TFA Collector – Tool for Enhanced Diagnostic Gathering ( Doc ID 1513912.2 )