dba installation

Did you forget to run

Not easy to detect, and depending on the product (agent/database), it may have only limited side effects.

Like external jobs not running, operating systems statistics not collected.

But it is not always easy to diagnose.

For instance if you patch from OMS 12cR2 to 12cR3, and you run the only in 12cR2, they are very few statistics missing (one is the OS_STORAGE_ENTITY).

Running the doesn’t generate a log file or an entry in the inventory.

To check if it was executed, check what it is supposed to do. It is a bit different in each version. One think it always does is changing the ownership to root and set the sticky bit for a few binaries. For the database, this is done in sub-scripts called (10g) or (11g/12c).

eval ls -l $(find $ORACLE_HOME -name "rootadd*sh" -exec awk '$1="$CHOWN"&&$2=="root"{print $3}' {} \;|sort -u)

-rwsr-x--- root dba .../product/11.2.0/db_4/bin/extjob
-rwsr-x--- root dba .../product/11.2.0/db_4/bin/jssu
-rws--x--- root dba .../product/11.2.0/db_4/bin/nmb
-rws--x--- root dba .../product/11.2.0/db_4/bin/nmhs
-rws--x--- root dba .../product/11.2.0/db_4/bin/nmo
-rwsr-x--- root dba .../product/11.2.0/db_4/bin/oradism
-rw-r----- root dba ...11.2.0/db_4/rdbms/admin/externaljob.ora

If the ownership is root, you definitely did run the

On the 12c agent, there is a FULL_BINARY_LIST variable that point to list of root binaries in sbin

cd $AGENT_HOME/../../sbin

-rws--x--- root dba nmb
-rws--x--- root dba nmhs
-rws--x--- root dba nmo

If all files exist and belong root, it looks like you did run the

dba installation

change Oracle installer language in Windows

setup -Duser.language=fr

It works also on UNIX

runInstaller -J-Duser.language=fr

Documented in Sap Note : 1431796

Enterprise Manager installation security

[alert] Oracle agents on AIX may not work in 2011 with OMS10g

Fuadar recently wrote : Grid Control AIX Alert

Basically, if you have an 10g oms Server (any OS / any release) and aix agents (any release), and according to Note 1171558.1, communication between [10g] Oracle Management Service and [AIX] Management Agents will break due to a default self-signed certificate expiring in 31 Dec 2010.

There is more than one way to solve this

1) you upgrade your oms to 11g. Good luck to do this before end of year…

2) You upgrade your oms to, apply patch 10034237 on your oms, create a new certificate, resecure all your agents. Pretty heavy stuff I promise.

3) You use a Third Party Certificate. This may work. I have not tested this for you.

4) You switch from https to http… this is of course not an acceptable workaround as the connection between the agent and the oms will be unsecure, but it may save your Silvester Party.

  • allow both secure and unsecure connections to the oms
  • on all your OMS instances

    opmnctl stopall
    emctl secure unlock
    opmnctl startall

  • switch all your agents to http
  • On all your AIX hosts with an agent installed

    emctl unsecure agent -omsurl http://omsserver:4890/em/*

    You can find the port for unsecure in your oms server in OMSHOME/sysman/config/ under oracle.sysman.emSDK.svlt.ConsoleServerPort.

Happy holidays !

11gR2 installation news support for win32 and win64

patch 10098816 is available for download

11gR2 installation for AIX and HPUX

patch 10098816 is available for download

dba installation news sql developer

SQL developer for dba

Historically and semantically, SQL Developer is a developer tool. There is very little comparison with TOAD for the dba.

But… Oracle is working on this! In the latest release, 3.0 EA1, you will be able to see Tablespaces, Redo logs and controlfile, finally.

Still no session browser, but I am delighted that the database administrators are not getting forgotten !

Thanks Surachart for spreading the news!

installation news support

I have read on Surachart Opun’s blog that is available, but also that the patchset is now a full installation.

In the past, if you wanted to have or, you needed to install both the base version, or and the patchset, or Very often the patchset itself was bigger and took more time than the base database installation.
According to Note 1189783.1, it is now possible to install without having to install both + a patchset.

if you are installing Oracle Database on a system without an existing Oracle Database installation, then you can simply install the release patch set

I like this 🙂

installation support

what’s up last weeks?

I just came back from diving, parasailing, safari and more fun in Egypt. On my blog I saw a comment from Nicolas regarding the availability of the terminal patchset for 10gR2

Note 161818.1: Oracle Database Releases Status Summary Patchset 8202632

11gR2 installation news

11.2 solaris x86_64

Released as announced for 2009Q4… database, 11.2 for Solaris x86_64

Still Oracle is suffering with European Union Commission who is still blocking the Sun deal.

google news about the deal

dba installation news is the latest patchset for 11gR1

You will get CPU and even PSU (Patch Set Updates are proactive cumulative patches comprised of recommended bug fixes that are released on a regular and predictable schedule)

But no more patchset. This the first time I see a release with only 1 pachset.

Well, if you use Linux, you can go to 11gR2. Otherwise you may better stick to for a few more months

Ref: 742060.1 is the last patch set for Release 11.1

11g installation news support

Oracle on Mac

I just read a post from Barry Mc Gillin about apex on MacOsX.

After having being using Vista for one year, I would really welcome a Mac as my next notebook. But what about Oracle Database on Mac OS X?

According to otn, the latest release as of today is a deprecated 10gR1 for the deprecated platform PowerPC.

However, according to metalink, a 10gR2 is planned for the first quarter of 2009 (sic)
Db 10gR2 on MacOS X Intel
And 11g is planned too Db 11gR1 on MacOS X Intel, Schedule to be announced.

11g Add new tag dba installation support

11g release 1 patchset 1

I just notice on Sven Blog that is available. I have recently upgraded my connection at home so it took a bit less than half an hour to download this 1.5G patchset

$ wget -O…
Connecting to||:80… connected.
HTTP request sent, awaiting response… 200 OK
Length: 1,613,366,248 (1.5G) [application/zip]

100%[==================================>] 1,613,366,248 891.73K/s

10:47:31 (879.89 KB/s) – `’ saved [1613366248/1613366248]

$ unzip
$ cd Disk1
$ ./runInstaller
Starting Oracle Universal Installer…
Preparing to launch Oracle Universal Installer from
Oracle Universal Installer, Version Production
Copyright (C) 1999, 2008, Oracle. All rights reserved.

$ su –
root’s password:
# /u00/app/oracle/product/11.1/db_1/
Running Oracle 11g script…
# exit
$ sqlplus / as sysdba
SQL*Plus: Release – Production on Sat Sep 20 11:10:35 2008

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup quiet migrate
ORACLE instance started.
Database mounted.
Database opened.
SQL> set time on
11:42:21 SQL> sho parameter sga_target

———————————— ———– ——————————
sga_target big integer 200M
11:42:25 SQL> alter system set sga_target=300m scope=spfile;

System altered.

11:42:28 SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
11:42:43 SQL> startup quiet migrate
ORACLE instance started.
Database mounted.
Database opened.
11:43:01 SQL> @?/rdbms/admin/catupgrd

11:54:03 SQL> Rem END catupgrd.sql
11:54:03 SQL> startup
ORACLE instance started.

Total System Global Area 313159680 bytes
Fixed Size 2159272 bytes
Variable Size 226495832 bytes
Database Buffers 79691776 bytes
Redo Buffers 4812800 bytes
Database mounted.
Database opened.
11:56:28 SQL> select comp_name,status,version from dba_registry;

———————————– ——– ———-
Oracle Ultra Search VALID
Oracle XML Database VALID
Oracle Text VALID
Oracle Expression Filter VALID
Oracle Rules Manager VALID
Oracle Workspace Manager VALID
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
JServer JAVA Virtual Machine VALID
Oracle Database Java Packages VALID

My first try with 200Mb sga target did not succeeded. But with 300Mb sga target it worked fine.

Add new tag Blogroll installation support aix

I just noticed is out. I started downloading 1,916,781 KB !

Add new tag Blogroll dba installation

Linux for x86_64 is out

While Linux x86_64 just came out, Unix Releases like HPUX, AIX and SunSolaris will probably not be available before third week of April.

Add new tag Blogroll installation

Linux for x86_64 is out

While Linux x86_64 just came out, Unix Releases like HPUX, AIX and SunSolaris will probably not be available before third week of April.

Add new tag Blogroll dba installation


Sven’s Technik-Blog » Blog Archive » Oracle für Linux x86 ist verfügbar…

Patchset 6810189 is now available for Download on Metalink.

select * from v$version;

Oracle Database 10g Enterprise Edition Release - Prod
PL/SQL Release - Production
CORE      Production
TNS for Linux: Version - Production
NLSRTL Version - Production
11g Blogroll dba installation

Oracle 11g Hot patching

Online Patching : you can apply or roll back online patches while the RDBMS instance is running

1) download an interim patch for 11g, f.ex. dummy patch 6198642
2) unzip
3) cd 6198642
4) $ORACLE_HOME/OPatch/opatch apply -silent -connectString LSC08 -runSql
Invoking OPatch

Oracle Interim Patch Installer version
Copyright (c) 2007, Oracle Corporation. All rights reserved.

Oracle Home : /opt/oracle/product/11/db_4
Central Inventory : /opt/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version :
OUI version :
OUI location : /opt/oracle/product/11/db_4/oui
Log file location : /opt/oracle/product/11/db_4/cfgtoollogs/

RollbackSession rolling back interim patch '6198642' from OH

Running prerequisite checks...

OPatch detected non-cluster Oracle Home from the inventory
and will patch the local system only.

Please shutdown Oracle instances running out of this
ORACLE_HOME on the local system.
(Oracle Home = '/opt/oracle/product/11/db_4')

Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files affected by the patch '6198642' for restore.
This might take a while...
Execution of 'sh /opt/oracle/product/11/db_4/.patch_storage/
scripts/pre -rollback 6198642 ':

Return Code = 0

Patching component oracle.rdbms,
Copying file to "/opt/oracle/product/11/db_4/cpu/CPUDummy2007/
RollbackSession removing interim patch '6198642' from inventory

This is a dummy patch for testing only
Execution of 'sh /opt/oracle/product/11/db_4/.patch_storage/
post -rollback 6198642 ':

Return Code = 0

Running the "apply" sql script "/opt/oracle/product/11/db_4/cpu/
CPUDummy2007/catcpu.sql" with reference to 'patchmd.xml' file
for the patch "6198642"...

The local system has been patched and can be restarted.

OPatch succeeded.

OPatch did run the necessary script (catcpu for Dummy2007) on the various instances (LSC08). It needed only one step and 34 seconds on my notebook. This patch is a dummy patch, let’s wait for CPU January to see if it is online applicable 😉

Application Server Blogroll content database installation

ContentDB installation

Yesterday I installed ContentDB. The installation is fairly straightforward.

Download and install Oracle Identity Management

  • OID
  • Install the Infrastructure, with the Identity Management and Repository, including Internet Directory, Single Sign-on, Delegated Administration Services and Directory provisioning

This will create a database. The default parameters are too low for contentDB.

alter system set

It is recommended to stop the application server infrastructure before restarting the database to make the parameters above effective.

$ $ORACLE_HOME/bin/emctl stop iasconsole
$ $ORACLE_HOME/opmn/bin/opmnctl stopall
$ sqlplus / as sysdba
SQL> shutdown immediate
SQL> startup
$ $ORACLE_HOME/opmn/bin/opmnctl startall
$ $ORACLE_HOME/bin/emctl start iasconsole

It is now possible to install ContentDB in this database. Of course the ContentDB could be installed in a separate database, it does not have to be the same as the infrastructure database.

Now, download and install Oracle ContentDB

  • Content Database
  • Install the ContentDB

That’s all. There now two application server instances, one for the infrastructure and one for the content database.

To launch the Content Database web interface, just go to the http server of the ContentDB installation, something like http://server:7779.

$ /app/oracle/product/10.1.2/cdb_1/bin/opmnctl status -l

Processes in Instance: CONTENTDB01.srv01
ias-component | status | ports
DSA | Down | N/A
HTTP_Server | Alive | http1:7779,http2:7202
LogLoader | Down | N/A
dcm-daemon | Alive | N/A
OC4J | Alive | ajp:12503,rmi:12403,...
WebCache | Alive | http:7778,invalidati...
WebCache | Alive | administration:9400
Content | Alive | node_dms_http:53900,...
Content | Alive | node_manager_locator...

Login with user ORCLADMIN and the password you specified for IAS_ADMIN.

ContentDB interface let you upload and download files. You can use it to keep your documentation in a single location. It has versioning capabilities too.


Add new tag Blogroll installation ldap oid

installing OID Preview 1

Download oracle-oid-
Download oracle-xe-univ-

Install the rpm
# rpm -i oracle-*.i386.rpm

In SLES 10, there is no /bin/cut, let’s create a link as root to avoid a mistake when running
# ln -s /usr/bin/cut /bin/cut

Run the configure script as root
# /etc/init.d/oracle-oid configure
That’s all folks! It created an Oracle XE 10gR2 database, and configured a running database. Excellent!

LDAP Server is running and configured.
$ ldapsearch cn=orcladmin dn
cn=orcladmin, cn=Users, dc=com

There is a nice video to run on linux : oracleauthenticationservices_demo.vvl
Save the file, set the display, then
$ chmod +x oracleauthenticationservices_demo.vvl
$ ./oracleauthenticationservices_demo.vvl

It shows also how to use Oracle LDAP Server OID to identify your Linux users with the preview of Oracle Authentication Service

Blogroll dba installation

create your database with dbca

With dbca you can fasten the procedure of creating databases in your company. You can also run this in silent mode and create exactly the database you want, with your redo/undo size, with your parameters settings. You create the template once, and use it many times. Fast and easy 😀

I have one database which I created with SQL*PLUS called LSC01.

1) Create template lsc-template
–> Manage Templates
–> Create a database template
–> from an existing database (structure as well as data)
–> LSC01
–> lsc-template
–> convert the file locations to use OFA structure

This takes some place on disk and will speed up database creation. Technically speaking, it is doing a compressed backup with RMAN that will be restore, and restore is way faster than create database

2) Create database LSC99 in silent mode or progressOnly mode.
dbca -silent -createDatabase -templateName lsc-template.dbc -gdbName

It took me only two minutes to create my database on my notebook !

Try it ! Of course I expect comments on this post :mrgreen:

Add new tag Blogroll installation is the terminal patchset

I just read on the General Notes For Oracle Database – Enterprise Edition in Metalink that is the terminal patchset for 10gR1

Blogroll dba installation


I just downloaded and installed the Critical Patch Update April 2007

$ lsnrctl stop 
The command completed successfully
$ sqlplus / as sysdba
SQL> shutdown immediate
ORACLE instance shut down.
SQL> quit
$ cd /tmp/5901891
$ ORACLE_HOME/OPatch/opatch apply
... Finish at Wed Apr 18 10:28:17 CEST 2007
$ lsnrctl start
The command completed successfully
$ sqlplus / as sysdba
SQL> startup
Database opened.
SQL> @?/cpu/CPUApr2007/catcpu
SQL> @?/rdbms/admin/utlrp

The logfile of opatch is $ORACLE_HOME/cfgtoollogs/opatch/opatchdate.log and the logfile of the catcpu is APPLY_sid_date.log. ORA-02303 can be safely ignored.

SQL> select * from dba_registry_history

18-APR-07 AM

SQL> select count(*) from dba_objects where status='INVALID';


Successfully applied 😎

installation linux security

xhost + is a huge security hole

Maybe you have a firewall in your company, only your PC can access the production server, only you have the root password in prod, and your company spend a lot of money in security, but you dare using xhost +.

This is a huge security hole, because it gives anyone access to your X resources, not only your display, but also your mouse and your keyboard, so anyone can read/modify/corrupt what you are typing/clicking. It is a bad habit to use xhost+. Even using xhost +localhost give access to your keyboard to anyone on localhost…

So what else could you use ?

The simplest is probably ssh tunnelling.

lsc@chltlxlsc1:$ ssh -X oracle@localhost
Last login: Fri Max 2 10:24:09 2007 from localhost
oracle@chltlxlsc1:$ if xterm -e true; then echo success; fi

Another way to do this is to use X cookies.

lsc@chltlxlsc1:$ xauth extract ~/my-x-cookie $DISPLAY< lsc@chltlxlsc1:$ setfacl -m u:oracle:r ~/my-x-cookie lsc@chltlxlsc1:$ su - oracle -c "DISPLAY=$DISPLAY bash" Password: oracle@chltlxlsc1:$ if xterm -e true; then echo success; fi Xlib: connection to ":0.0" refused by server Xlib: No protocol specified xterm Xt error: Can't open display: :0.0 oracle@chltlxlsc1:$ xauth merge ~lsc/my-x-cookie xauth: creating new authority file ~oracle/.Xauthority oracle@chltlxlsc1:$ if xterm -e true; then echo success; fi success

No need to type all. Here is my alias

alias oracle='
xauth extract $HOME/my-x-cookie $DISPLAY;
setfacl -m u:oracle:r $HOME/my-x-cookie;
su - oracle -c "export DISPLAY=$DISPLAY;
xauth merge $HOME/my-x-cookie;

Add new tag Blogroll installation

Critical Patch Update

The critical patch update for january is released. However, not for every version.

Already in CPU Oct 2006, many versions were delayed. The release date of 10gR1 Tru64 for example was Nov 15, but the note has not been updated for months. Linux was released so late (29 Dec), that the CPU2006OCT-9208 is considered to be CPU2007JAN (patch 5490859). For, there is no CPU2007JAN

I applied both 9208-cpu2006oct and 10105-cpu2007jan to my notebook database.

Both complained about not existing XDB schema, but I ignore those (I have no XDB schema). Otherwise it went fine.

I apply the CPU as soon as released for testing purpose. However, applying the CPU as soon as possible in PROD does not apply to most of my customers.

Add new tag Blogroll installation

8.1.7 desupport exceptions

In the Critical Patch Update 2007 January Pre-Release Announcement, you may wonder why there is a CPU patch.

The reason is, Oracle is still supported for some application supported by Oracle like Siebel, E-Business and Clinical.

Have a look at Metalink Note 148054.1

Add new tag Blogroll installation

Solaris 10gR2 patchset 2 is out patch is released for various plateforms, like Linux (x86,x86_64,Itanium), Windows (32bits/64bits), Solaris (64 bits) and Z/OS
Patch 5337014

Blogroll installation


I am in the process in installing Oracle 10gR2 patch 2 with response file. There is no plenty of disk available, but installing a patch does not require as much space as specified by the runInstaller.

when I start in silent mode, I get :

$ ./runInstaller -responseFile /home/oracle/10202.rsp -silent
Starting Oracle Universal Installer...
You may not have enough space on your drive for a successful install. Do you still want to continue?

Where should I answer yes? There is a secret parameter called -ignoreDiskWarning which does the trick. The parameter is not listed in ./runInstaller -help.

So I installed my + patch and still have 500Mb free. It is ok for Oracle Home. Check your diskspace before using this to avoid filesystem full.

Add new tag Blogroll installation

I successfully installed 10gR2 patchset 2 on my notebook :

SQL> select ACTION,VERSION,COMMENTS from registry$history;

------- ---------- ------------------------------
CPU CPUOct2006
UPGRADE Upgraded from

SQL> select COMP_NAME,VERSION,STATUS from dba_registry;
COMP_NAME                           VERSION    STATUS
----------------------------------- ---------- -----------
Oracle Expression Filter   VALID
Oracle Database Catalog Views VALID
Oracle Database Packages and Types VALID
Oracle Database Java Packages VALID
JServer JAVA Virtual Machine VALID
Oracle XDK                 VALID
Blogroll installation is huge

900M in size for a Linux patch is getting quite big. Expect 2G for HPUX/AIX5L, guess this 2G limit, if reached, is going to be a problem for many users !

Hint : use FileZilla to download software

Add new tag Blogroll installation

10gR2 patchset 2 is out

For Windows and Linux x86, Oracle Database is available


Add new tag Blogroll installation

apply CPUOct2006

I downloaded the CPUOct2006 patch for and applied it successfully to my database.

SQL> select action,id,comments from dba_registry_history;
------ ---------- ----------
CPU       5490848 CPUOct2006

in the logfile, apart from a few ignorable ORA-02303: cannot drop or replace a type with type or table dependents errors, everything went fine.

Applying the security patch shortly after they are released is in my opinion a good practice, because a fix could sometimes reverse-engineered to reveal the bug.

Tomorrow afternoon I flight via London to SF for OOW2006. I am quite unhappy about not taking my notebook, my phone, not even a book or a SuDoKu in the plane 🙁 Well, I hope BA will not refuse to serve me wine this time as Delta did last year