grep multuple patterns
cat test1 | egrep ‘TNS-|Client address’ | sed -e ‘s/^.*HOST/HOST/’
fuser to check who is using diretory
fuser -cu /directory_name
Unix command for system configuration
Seeing kernel version (32/64 Bit) on Unix flavors. -isainfo -kv on Solaris -lsconf on AIX -uname -a on Linux to See configuration -prtdiag on Solaris -lsconf on AIX -dmidecode on Linux Other useful Unix commands: Disk usage. # df -al Memory information. # free Network information. # ifconfig -a Installed Modules information. #lsmod Currently mounted…
Oracle Recommended Patches — Oracle Database ID 756671.1
Oracle Recommended Patches — Oracle Database Target Configurations Patch Availability Current Recommended Patches 11.2.0.2 Current Recommended Patches 11.2.0.1 Current Recommended Patches 11.1.0.7 Current Recommended Patches 11.1.0.6 Current Recommended Patches 10.2.0.5 Current Recommended Patches 10.2.0.4 Current Recommended Patches 10.2.0.3 Current Recommended Patches Conflict Resolution On Request Known Issues References Beginning with release 10.2.0.3, Oracle releases Recommended…
Read More “Oracle Recommended Patches — Oracle Database ID 756671.1” »
Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1
Applies to: Oracle Server – Enterprise Edition – Version: 10.2.0.4 to 11.2.0.1 – Release: 10.2 to 11.2 Information in this document applies to any platform. Oracle Server Enterprise Edition – Version: 10.2.0.4 to 11.2.0.1 Goal 1.Do you still need to apply Patch Bundles for a certain patchset level when Patch Set Update (PSU) for that…
Read More “Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1” »
Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1
Applies to: Oracle Server – Enterprise Edition – Version: 8.1.7.4 to 11.2.0.2 – Release: 8.1.7 to 11.2 Oracle Server – Standard Edition – Version: 8.1.7.4 to 11.2.0.2 [Release: 8.1.7 to 11.2] Information in this document applies to any platform. Oracle Server Enterprise Edition – Version: 8.1.7.4 to 11.2.0.2 Purpose The purpose of this document is…
Best approach for Oracle database patching sequence to latest/required patchset along with CPU/PSU/any-other-one-off patch ID 865255.1
Applies to: Oracle Server – Enterprise Edition – Version: 10.2.0.1 to 11.1.0.7 Information in this document applies to any platform. Goal This article helps to plan oracle database patching sequence to the latest/required patchset version with in the same release (ex: 10.2.0.1 to 10.2.0.4) along with CPU/PSU/One-off-patch installations. Solution Basically there are two entities in…
Oracle Support Metalink ID 161818.1
Oracle Database (RDBMS) Releases Support Status Summary [ID 161818.1] Oracle Database (RDBMS) Releases Support Status Summary Information here was last updated on 14-Sep-2010 This note shows the current main Oracle Database releases along with information about the support status of each release and its Patch Sets. To see the main support alerts and Patch Set…
AWR license
ref: http://blog.tanelpoder.com/2009/05/06/free-dba_hist-awr-views-in-11g/ When you access Oracle AWR (and other licensed features/tables/views) then these do show up in DBA_FEATURE_USAGE_STATISTICS. Exporting the contents is the same as accessing these with your SQL. All data dictionary views beginning with the prefix DBA_HIST_ are part of this pack, along with their underlying tables.The only exception are the views: DBA_HIST_SNAPSHOT,…
Oracle Material from OTN
Oracle Learning Library ======================= http://apex.oracle.com/pls/apex/f?p=9830:41:0::NO Getting Started with Oracle SQL Developer ========================================= http://st-curriculum.oracle.com/obe/db/11g/r2/prod/appdev/sqldev/sqldev_mngdb/sqldev_mngdb_otn.htm Using Source Code Control in Oracle SQL Developer ================================================= http://st-curriculum.oracle.com/obe/db/11g/r2/prod/appdev/sqldev/srccodexmlext/srccode_otn.ht