Did you forget to run root.sh?

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 root.sh only in 12cR2, they are […]

[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 […]

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 […] 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 […]

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 p6890831_111070_Linux-x86-64.zip http://oracle-updates.oracle… –10:17:40– http://oracle-updates.oracle.com/ARUConnect/p6890831_111070_Linux-x86-64.. Resolving oracle-updates.oracle.com…, Connecting to oracle-updates.oracle.com||:80… connected. HTTP request sent, awaiting response… 200 OK […]


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

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 p6198642_111060_LINUX.zip 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 […]

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   processes=250 […]

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 config-oid.sh # 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, […]


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 […]


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… —————————————————————————– […]

I successfully installed 10gR2 patchset 2 on my notebook : SQL> select ACTION,VERSION,COMMENTS from registry$history; ACTION  VERSION    COMMENTS ——- ———- —————————— 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 […]

apply CPUOct2006

I downloaded the CPUOct2006 patch for and applied it successfully to my database. SQL> select action,id,comments from dba_registry_history; ACTION         ID COMMENTS —— ———- ———- 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 […]