All posting here will be used for my own workshop. Whatever discussed on this blog is for my own point of views and not necessary match with others. So please if you are going to test my examples here, please check it first on your test environment. Thanks and good reading!
I've been reading about new features and one of them are the "Case Sensitive Passwords" as a default feature of newly oracle 11g version.
The SEC_CASE_SENSITIVE_LOGON initialization parameter gives us the control over case sensitive passwords.We can use the ALTER SYSTEM command to turn off this functionality.
SQL> show parameter sec_case_sensitive_logon
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sec_case_sensitive_logon boolean TRUE SQL> SQL> Now lets try it using some examples and creating a new user with a mixed case password. SQL> create user demo1 identified by demo1;
User created.
SQL> conn demo1/demo1 Connected. SQL> SQL> show user USER is "DEMO1" SQL>SQL> conn demo1/Demo1 ERROR: ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE. SQL> conn demo1/deMo1 ERROR: ORA-01017: invalid username/password; logon denied
SQL>
Ok, now let me switch the SEC_CASE_SENSITIVE_LOGON initialization parameter to FALSE and we are able to connect using both variations of the password. Lets try.
SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;
Just keep in mind that the original case sensitive password is retained, so it can be used if case sensitivity is subsequently enabled.
The DBA_USERSview includes a PASSWORD_VERSIONS column that indicates the database release in which the password was created or last modified.
SQL> desc DBA_USERS Name Null? Type ----------------------------------------- -------- ---------------------------- USERNAME NOT NULL VARCHAR2(30) USER_ID NOT NULL NUMBER PASSWORD VARCHAR2(30) ACCOUNT_STATUS NOT NULL VARCHAR2(32) LOCK_DATE DATE EXPIRY_DATE DATE DEFAULT_TABLESPACE NOT NULL VARCHAR2(30) TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30) CREATED NOT NULL DATE PROFILE NOT NULL VARCHAR2(30) INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30) EXTERNAL_NAME VARCHAR2(4000) PASSWORD_VERSIONS VARCHAR2(8) EDITIONS_ENABLED VARCHAR2(1)
SQL>
SQL> select username, password, password_versions from dba_users;
In this case it means both old and new-style hash values ar available for user DEMO1, the new hash value is stored in the USER$.SPARE4 column, as long as this remains NULL it means the password has not been changed since the migration and the user will have the old case insensitive password.
We can note above that the hash value is not visible anymore like in old Oracle versions. But we still can check this value using dictionary table named SYS.USER$.
SQL> select name,password from sys.user$ where name='DEMO1';
NAME PASSWORD ------------------------------ ------------------------------ DEMO1 DD9FD1922A0AFC29
SQL>
In addition one more interesting thing that we have in Oracle 11g is a new dictionary view named DBA_USERS_WITH_DEFPWD.This view help us to find users using "default" passwords and we must change them as soon as possible. SQL> select * from dba_users_with_defpwd;
Lets see how to apply the CPUJAN2010 on my database version 11.1.0.7 running on my Virtual Machine. The VM is running Enterprise Linux Enterprise Linux AS release 4 (October Update 4). First step is download the Patch "p9114072_111070_Linux-x86.zip" from Metalink as shown below and unzip the file into some temp directory on the server.
Lets see how to do this:
vmlinux3-oracle-XXXX-/oracle/app/dev/dba/orapatch >ls -ltr total 868 drwxrwxr-x 20 oracle dba 4096 Jan 6 09:14 9114072 -rw-r--r-- 1 oracle dba 877256 Feb 21 11:47 p9114072_111070_Linux-x86.zip
vmlinux3-oracle-XXXX-/oracle/app/dev/dba/orapatch >rm p9114072_111070_Linux-x86.zip vmlinux3-oracle-XXXX-/oracle/app/dev/dba/orapatch >lt total 4 drwxrwxr-x 20 oracle dba 4096 Jan 6 09:14 9114072
Use the opatch to apply the patch as the following example:
Oracle Interim Patch Installer version 11.2.0.1.1 Copyright (c) 2009, Oracle Corporation. All rights reserved.
UTIL session
Oracle Home : /oracle/app/oracle/product/11.1.0.7 Central Inventory : /oracle/app/oracle/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.1 OUI version : 11.1.0.7.0 OUI location : /oracle/app/oracle/product/11.1.0.7/oui Log file location : /oracle/app/oracle/product/11.1.0.7/cfgtoollogs/opatch/opatc
Patch history file: /oracle/app/oracle/product/11.1.0.7/cfgtoollogs/opatch/opatc
Invoking utility "napply" Checking conflict among patches... Checking if Oracle Home has components required by patches... Checking skip_duplicate Checking skip_subset Checking conflicts against Oracle Home... OPatch continues with these patches: 8306934 8342506 8563941 8563942 8563943 8563944 8563946 8563947 8563948 8855553 8855559 8855565 8855570 8855575 8855577 9114072 9118620 9118622
Do you want to proceed? [y|n] y User Responded with: Y
Running prerequisite checks... Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name:
You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
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 = '/oracle/app/oracle/product/11.1.0.7')
Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files affected by the patch 'NApply' for restore. This might take a while... Execution of 'sh /oracle/app/dev/dba/orapatch/9114072/8342506/custom/scripts/pre -apply 8342506 ':
ApplySession applying interim patch '8306934' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8306934' for rollback. This might take a while...
Patching component oracle.network.listener, 11.1.0.7.0... Updating archive file "/oracle/app/oracle/product/11.1.0.7/network/lib/libnlsnr11.a" with "network/lib/libnlsnr11.a/nsglgr.o" Updating archive file "/oracle/app/oracle/product/11.1.0.7/network/lib/libnlsnr11.a" with "network/lib/libnlsnr11.a/nsglro.o" ApplySession adding interim patch '8306934' to inventory
Verifying the update... Inventory check OK: Patch ID 8306934 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8306934 are present in Oracle Home.
Applying patch 8342506...
ApplySession applying interim patch '8342506' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8342506' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0... Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/view_recompile/recompile_precheck_jan2008cpu.sql" Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/view_recompile/view_recompile_jan2008cpu.sql" ApplySession adding interim patch '8342506' to inventory
Verifying the update... Inventory check OK: Patch ID 8342506 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8342506 are present in Oracle Home.
Applying patch 8563941...
ApplySession applying interim patch '8563941' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8563941' for rollback. This might take a while...
Patching component oracle.network.listener, 11.1.0.7.0... Updating archive file "/oracle/app/oracle/product/11.1.0.7/network/lib/libnlsnr11.a" with "network/lib/libnlsnr11.a/nsgcs.o" Updating archive file "/oracle/app/oracle/product/11.1.0.7/network/lib/libnlsnr11.a" with "network/lib/libnlsnr11.a/nsglsn.o" ApplySession adding interim patch '8563941' to inventory
Verifying the update... Inventory check OK: Patch ID 8563941 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8563941 are present in Oracle Home.
Applying patch 8563942...
ApplySession applying interim patch '8563942' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8563942' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0... Copying file to "/oracle/app/oracle/product/11.1.0.7/rdbms/admin/catmetx.sql" ApplySession adding interim patch '8563942' to inventory
Verifying the update... Inventory check OK: Patch ID 8563942 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8563942 are present in Oracle Home.
Applying patch 8563943...
ApplySession applying interim patch '8563943' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8563943' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0... Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/krvg.o" Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/knld.o" Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/prsc.o" Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/prsg.o" Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/prssz.o" ApplySession adding interim patch '8563943' to inventory
Verifying the update... Inventory check OK: Patch ID 8563943 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8563943 are present in Oracle Home.
Applying patch 8563944...
ApplySession applying interim patch '8563944' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8563944' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0... Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/kzrt.o" ApplySession adding interim patch '8563944' to inventory
Verifying the update... Inventory check OK: Patch ID 8563944 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8563944 are present in Oracle Home.
Applying patch 8563946...
ApplySession applying interim patch '8563946' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8563946' for rollback. This might take a while...
Patching component oracle.rdbms.rsf, 11.1.0.7.0... Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libcommon11.a" with "lib/libcommon11.a/ttcpip.o"
Verifying the update... Inventory check OK: Patch ID 8563946 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8563946 are present in Oracle Home.
Applying patch 8563947...
ApplySession applying interim patch '8563947' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8563947' for rollback. This might take a while...
Patching component oracle.sysman.console.db, 11.1.0.7.0... Updating jar file "/oracle/app/oracle/product/11.1.0.7/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/config/compare/CompareWizSecondConfigBean.class" ApplySession adding interim patch '8563947' to inventory
Verifying the update... Inventory check OK: Patch ID 8563947 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8563947 are present in Oracle Home.
Applying patch 8563948...
ApplySession applying interim patch '8563948' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8563948' for rollback. This might take a while...
Patching component oracle.sysman.console.db, 11.1.0.7.0... Updating jar file "/oracle/app/oracle/product/11.1.0.7/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/history/ConfigHistoryBean.class" Updating jar file "/oracle/app/oracle/product/11.1.0.7/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/history/ConfigHistoryController.class" Updating jar file "/oracle/app/oracle/product/11.1.0.7/sysman/jlib/emCORE.jar" with "/sysman/jlib/emCORE.jar/oracle/sysman/eml/ecm/history/ConfigHistorySearch.class" ApplySession adding interim patch '8563948' to inventory
Verifying the update... Inventory check OK: Patch ID 8563948 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8563948 are present in Oracle Home.
Applying patch 8855553...
ApplySession applying interim patch '8855553' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8855553' for rollback. This might take a while...
Patching component oracle.sdo.locator, 11.1.0.7.0... Copying file to "/oracle/app/oracle/product/11.1.0.7/md/admin/sdomigrt.sql" ApplySession adding interim patch '8855553' to inventory
Verifying the update... Inventory check OK: Patch ID 8855553 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8855553 are present in Oracle Home.
Applying patch 8855559...
ApplySession applying interim patch '8855559' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8855559' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0... Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/kzia.o" ApplySession adding interim patch '8855559' to inventory
Verifying the update... Inventory check OK: Patch ID 8855559 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8855559 are present in Oracle Home.
Applying patch 8855565...
ApplySession applying interim patch '8855565' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8855565' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0... Updating jar file "/oracle/app/oracle/product/11.1.0.7/rdbms/jlib/CDC.jar" with "/rdbms/jlib/CDC.jar/oracle/CDC/Purge.class" Updating jar file "/oracle/app/oracle/product/11.1.0.7/rdbms/jlib/CDC.jar" with "/rdbms/jlib/CDC.jar/oracle/CDC/PublishApi.class" ApplySession adding interim patch '8855565' to inventory
Verifying the update... Inventory check OK: Patch ID 8855565 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8855565 are present in Oracle Home.
Applying patch 8855570...
ApplySession applying interim patch '8855570' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8855570' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0... Copying file to "/oracle/app/oracle/product/11.1.0.7/rdbms/admin/prvtaqds.plb" Copying file to "/oracle/app/oracle/product/11.1.0.7/rdbms/admin/dbmsaqds.plb" Copying file to "/oracle/app/oracle/product/11.1.0.7/rdbms/admin/prvtaqiu.plb" ApplySession adding interim patch '8855570' to inventory
Verifying the update... Inventory check OK: Patch ID 8855570 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8855570 are present in Oracle Home.
Applying patch 8855575...
ApplySession applying interim patch '8855575' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8855575' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0... Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/kkxs.o" Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/kza.o" ApplySession adding interim patch '8855575' to inventory
Verifying the update... Inventory check OK: Patch ID 8855575 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8855575 are present in Oracle Home.
Applying patch 8855577...
ApplySession applying interim patch '8855577' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '8855577' for rollback. This might take a while...
Patching component oracle.rdbms.rsf, 11.1.0.7.0... Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libpls11.a" with "lib/libpls11.a/pkwrap.o"
Verifying the update... Inventory check OK: Patch ID 8855577 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 8855577 are present in Oracle Home.
Applying patch 9114072...
ApplySession applying interim patch '9114072' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '9114072' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0... Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/CPUJan2010/catcpu.sql" Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/CPUJan2010/catcpu_rollback.sql" Copying file to "/oracle/app/oracle/product/11.1.0.7/rdbms/admin/bundledata_CPU.xml" Copying file to "/oracle/app/oracle/product/11.1.0.7/rdbms/admin/catbundle.sql" Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/scripts/sdo_oct2009.sql"
Patching component oracle.rdbms.rsf, 11.1.0.7.0... Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/CPUJan2010/rollback_all.lst" Copying file to "/oracle/app/oracle/product/11.1.0.7/cpu/CPUJan2010/rollback_new.lst" ApplySession adding interim patch '9114072' to inventory
Verifying the update... Inventory check OK: Patch ID 9114072 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 9114072 are present in Oracle Home.
Applying patch 9118620...
ApplySession applying interim patch '9118620' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '9118620' for rollback. This might take a while...
Patching component oracle.rdbms, 11.1.0.7.0... Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libserver11.a" with "lib/libserver11.a/kzld.o" ApplySession adding interim patch '9118620' to inventory
Verifying the update... Inventory check OK: Patch ID 9118620 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 9118620 are present in Oracle Home.
Applying patch 9118622...
ApplySession applying interim patch '9118622' to OH '/oracle/app/oracle/product/11.1.0.7' Backing up files affected by the patch '9118622' for rollback. This might take a while...
Patching component oracle.network.rsf, 11.1.0.7.0... Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libnro11.a" with "lib/libnro11.a/ncrfgp.o" Updating archive file "/oracle/app/oracle/product/11.1.0.7/lib/libnro11.a" with "lib/libnro11.a/ncrfidsa.o"
Verifying the update... Inventory check OK: Patch ID 9118622 is registered in Oracle Home inventory with proper meta-data. Files check OK: Files from Patch ID 9118622 are present in Oracle Home. Running make for target itnslsnr Running make for target ioracle Running make for target client_sharedlib Running make for target client_sharedlib Running make for target iwrap
-------------------------------------------------------------------------------- ******************************************************************************** ******************************************************************************** ** ATTENTION ** ** ** ** Please note that the Security Patch Installation (Patch Deinstallation) is ** ** not complete until all the Post Installation (Post Deinstallation) ** ** instructions noted in the Readme accompanying this patch, have been ** ** successfully completed. ** ** ** ******************************************************************************** ********************************************************************************
Execution of 'sh /oracle/app/dev/dba/orapatch/9114072/9114072/custom/scripts/post -apply 9114072 ':
Return Code = 0
The local system has been patched and can be restarted.
Oracle Database 11g 11.1.0.6.0 Oracle Database 11g Examples 11.1.0.6.0 Oracle Database 11g Patch Set 1 11.1.0.7.0 There are 3 products installed in this Oracle Home.
Interim patches (18) :
Patch 9118622 : applied on Sun Feb 21 14:00:43 BRST 2010 Unique Patch ID: 12054869 Created on 23 Dec 2009, 08:14:47 hrs PST8PDT Bugs fixed: 9118622
Patch 9118620 : applied on Sun Feb 21 14:00:39 BRST 2010 Unique Patch ID: 12054869 Created on 23 Dec 2009, 08:18:01 hrs PST8PDT Bugs fixed: 9118620
Patch 9114072 : applied on Sun Feb 21 14:00:34 BRST 2010 Unique Patch ID: 12054869 Created on 23 Dec 2009, 12:13:30 hrs PST8PDT Bugs fixed: 9114072, 8836375, 8290478, 8534338
Patch 8855577 : applied on Sun Feb 21 14:00:29 BRST 2010 Unique Patch ID: 12054869 Created on 9 Sep 2009, 04:46:33 hrs PST8PDT Bugs fixed: 8855577
Patch 8855575 : applied on Sun Feb 21 14:00:24 BRST 2010 Unique Patch ID: 12054869 Created on 9 Sep 2009, 04:50:05 hrs PST8PDT Bugs fixed: 8855575
Patch 8855570 : applied on Sun Feb 21 14:00:11 BRST 2010 Unique Patch ID: 12054869 Created on 2 Sep 2009, 08:23:21 hrs PST8PDT Bugs fixed: 8306933, 8855570
Patch 8855565 : applied on Sun Feb 21 14:00:07 BRST 2010 Unique Patch ID: 12054869 Created on 2 Sep 2009, 08:16:23 hrs PST8PDT Bugs fixed: 8855565
Patch 8855559 : applied on Sun Feb 21 14:00:01 BRST 2010 Unique Patch ID: 12054869 Created on 9 Sep 2009, 04:48:57 hrs PST8PDT Bugs fixed: 8855559, 8563945
Patch 8855553 : applied on Sun Feb 21 13:59:55 BRST 2010 Unique Patch ID: 12054869 Created on 9 Sep 2009, 04:30:24 hrs PST8PDT Bugs fixed: 8855553
Patch 8563948 : applied on Sun Feb 21 13:59:52 BRST 2010 Unique Patch ID: 12054869 Created on 4 Jun 2009, 01:51:05 hrs PST8PDT Bugs fixed: 8563948
Patch 8563947 : applied on Sun Feb 21 13:59:31 BRST 2010 Unique Patch ID: 12054869 Created on 4 Jun 2009, 01:52:36 hrs PST8PDT Bugs fixed: 8563947
Patch 8563946 : applied on Sun Feb 21 13:58:46 BRST 2010 Unique Patch ID: 12054869 Created on 3 Jun 2009, 23:09:22 hrs PST8PDT Bugs fixed: 8563946
Patch 8563944 : applied on Sun Feb 21 13:58:40 BRST 2010 Unique Patch ID: 12054869 Created on 10 Jun 2009, 06:20:58 hrs PST8PDT Bugs fixed: 6870937, 8563944
Patch 8563943 : applied on Sun Feb 21 13:58:30 BRST 2010 Unique Patch ID: 12054869 Created on 3 Jun 2009, 08:31:45 hrs PST8PDT Bugs fixed: 8563943
Patch 8563942 : applied on Sun Feb 21 13:57:56 BRST 2010 Unique Patch ID: 12054869 Created on 3 Jun 2009, 23:33:55 hrs PST8PDT Bugs fixed: 8563942
Patch 8563941 : applied on Sun Feb 21 13:57:52 BRST 2010 Unique Patch ID: 12054869 Created on 3 Jun 2009, 06:48:40 hrs PST8PDT Bugs fixed: 8563941
Patch 8342506 : applied on Sun Feb 21 13:57:48 BRST 2010 Unique Patch ID: 12054869 Created on 18 Mar 2009, 04:38:31 hrs PST8PDT Bugs fixed: 8342506
Patch 8306934 : applied on Sun Feb 21 13:57:43 BRST 2010 Unique Patch ID: 12054869 Created on 13 Mar 2009, 04:56:47 hrs PST8PDT Bugs fixed: 8306934 --------------------------------------------------------------------------------
BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production PL/SQL Release 11.1.0.7.0 - Production CORE 11.1.0.7.0 Production TNS for Linux: Version 11.1.0.7.0 - Production NLSRTL Version 11.1.0.7.0 - Production
SQL>
SQL> select * from registry$history;
ACTION_TIME ACTION NAMESPAC VERSION ID COMMENTS BUNDLE_SERIES ------------------------------ ---------- -------- -------- ---------- ---------------------------------------- ------------- 21-FEB-10 01.09.04.839873 PM APPLY SERVER 11.1.0.7 4 CPUJan2010 CPU 21-FEB-10 01.14.26.308370 PM CPU 6452863 view recompilation
I am a Senior Oracle DBA with over 16 years of IT experience which also includes above 6 years of production Oracle DBA exposure. Presently I´m an Oracle 10g OCP DBA. I have been working with Oracle RAC environemnts with 4 node production, 2 node development/QA RAC on Solaris with EMC DMX SAN Storage. I am one of the contributor at Oracle forums and occasionally writes up at my blog. I am currently engaged in supporting Oracle production databases for IBM/Santander account.
