skip to main |
skip to sidebar
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;
System altered.
SQL> conn demo1/demo1
Connected.
SQL> conn demo1/Demo1
Connected.
SQL> conn demo1/DEMO1
Connected.
SQL>
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_USERS view 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;
USERNAME PASSWORD PASSWORD
------------------------------ ------------------------------ --------
SYS 10G 11G
DBSNMP 10G 11G
DEMO1 10G 11G
SYSTEM 10G 11G
OUTLN 10G 11G
WKSYS 10G 11G
OLAPSYS 10G 11G
SI_INFORMTN_SCHEMA 10G 11G
OWBSYS 10G 11G
FLOWS_030000 10G 11G
ORDPLUGINS 10G 11G
WKPROXY 10G 11G
XDB 10G 11G
ANONYMOUS
.
.
.
.
SQL>
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;
USERNAME
------------------------------
DIP
MDSYS
SPATIAL_WFS_ADMIN_USR
TSMSYS
WK_TEST
CTXSYS
OUTLN
OWBSYS
SPATIAL_CSW_ADMIN_USR
EXFSYS
ORACLE_OCM
.
.
.
.
SQL>
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:
vmlinux3-oracle-XXXX-/oracle/app/dev/dba/orapatch >cd 9114072/
vmlinux3-oracle-XXXX-/oracle/app/dev/dba/orapatch/9114072 >opatch napply -skip_subset -skip_duplicate
Invoking OPatch 11.2.0.1.1
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 ':
Return Code = 0
Execution of 'sh /oracle/app/dev/dba/orapatch/9114072/9114072/custom/scripts/pre -apply 9114072 ':
Return Code = 0
Applying patch 8306934...
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"
Patching component oracle.rdbms, 11.1.0.7.0...
ApplySession adding interim patch '8563946' to inventory
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"
Patching component oracle.rdbms, 11.1.0.7.0...
ApplySession adding interim patch '8855577' to inventory
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"
Patching component oracle.rdbms, 11.1.0.7.0...
ApplySession adding interim patch '9118622' to inventory
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.
UtilSession: N-Apply done.
OPatch succeeded.
vmlinux3-oracle-XXXX-/oracle/app/dev/dba/orapatch/9114072 >
Please refer to the "3.3.2 Post Installation Instructions" section in order to check if any more steps are requered.
Checking the installation:
vmlinux3-oracle-ATLASDEV-/oracle/app/oracle/product/11.1.0.7/cpu/view_recompile >opatch lsinventory
Invoking OPatch 11.2.0.1.1
Oracle Interim Patch Installer version 11.2.0.1.1
Copyright (c) 2009, Oracle Corporation. All rights reserved.
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/opatch2010-02-21_14-21-51PM.log
Patch history file: /oracle/app/oracle/product/11.1.0.7/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /oracle/app/oracle/product/11.1.0.7/cfgtoollogs/opatch/lsinv/lsinventory2010-02-21_14-21-51PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (3):
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
--------------------------------------------------------------------------------
OPatch succeeded.
vmlinux3-oracle-ATLASDEV-/oracle/app/oracle/product/11.1.0.7/cpu/view_recompile >
Lets check my installation results using SQLPlus.
SQL>
SQL>
SQL>
SQL> select * from v$version;
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
SQL>
And we are done!!
