Block Browser and EDitor
Block Browser and EDitor building For 9i and 10g ~]$ cd $ORACLE_HOME/rdbms/liblib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbedlib]$ ./bbedPassword: blockeditBBED: Release 2.0.0.0.0 - Limited Production on Tue Mar 8 14:35:08 2022Copyright (c) 1982, 2007, Oracle. All rights reserved.************* !!! For Oracle Internal Use only !!! ***************BBED> For 11g and latest ~]$ curl -o /soft/bbed_10g_x64.tar.gz /assets/software/tools/bbed_10g_x64.tar.gz~]$ mkdir /soft/bbed_10g_x64...
Oracle OSWatcher Black Box
Oracle OSWatcher Black Box OSWatcher (oswbb) is a collection of UNIX shell scripts intended to collect and archive operating system and network metrics to aid support in diagnosing performance issues. OSWatcher operates as a set of background processes on the server and gathers OS data on a regular basis, invoking such Unix utilities as vmstat, netstat and iostat. Installing with TAR file RHEL 6/7 Upload the oswbbxxx.tar file. mkdir /u01/oswatchertar -xvf /soft/oswbb840.tar -C /u01/oswa...
Oracle Database DataPump EXPDP/IMPDP
Oracle Database DataPump EXPDP/IMPDP Create the datapump directory and grant privileges. -- Query datapump directory.set linesize 200 pages 100col privilege for a10col directory_path for a40select t.owner, privilege, directory_name, directory_path from user_tab_privs t, all_directories d where t.table_name(+) = d.directory_name order by 3, 2;select * from dba_directories;-- Create directory.create directory dpdir as '/home/oracle/dpdir';grant read,write on directory dpdir to sys,system;--...
p18370031_112040_Linux-x86-64
p18370031_112040_Linux-x86-64 ・ p18370031_112040_Linux-x86-64_README Record You must use the OPatch utility version 11.2.0.3.0 or later to apply this patch. $ <ORACLE_HOME>/OPatch/opatch version if not, patch p6880880. Validation of Oracle Inventory Before beginning patch application, check the consistency of inventory information for GI home and each database home to be patched. Run the following command as respective Oracle home owner to check the consistency. $ <ORACLE_HOME>...
p31718723_112040_Linux-x86-64
Patch 31718723 - Oracle Grid Infrastructure Patch Set Update 11.2.0.4.201020 p31718723_112040_Linux-x86-64 ・ p31718723_112040_Linux-x86-64_README Record
p20299014_10205_Linux-x86-64
Patch 20299014 - Database Patch Set Update 10.2.0.5.19 (Includes CPUJul2015) p20299014_10205_Linux-x86-64 ・ p20299014_10205_Linux-x86-64_README Record 操作系统版本 : CentOS Linux release 7.9.2009 (Core) 数据库版本 : Oracle 10.2.0.5.0 simple instance OPatch : p6880880_102000_Linux-x86-64.zip DB PSU : p20299014_10205_Linux-x86-64.zip 说明:p20299014 补丁包无 CRS 的补丁修复,所以直接打数据库 PSU 即可 Update OPatch [root@centos7 ~]# chmod 775 /soft/p6880880_102000_Linux-x86-64-opatch.zip[root@centos7 ~]# chown /soft/oracl...
p32226239_190000_Linux-x86-64
Patch 32226239 - GI Release Update 19.10.0.0.210119 p32226239_190000_Linux-x86-64 ・ p32226239_190000_Linux-x86-64_README Record
p34133642_190000_Linux-x86-64
Patch 34133642 - Database Release Update 19.16.0.0.220719 p34133642_190000_Linux-x86-64 ・ p34133642_190000_Linux-x86-64_README Record System Operation: RHEL 8.7 Database Software: 19.3.0.0.0 Single Instance CDB Check the current opatch version and patches. ~]# /u01/app/oracle/product/19.0.0/dbhome_1/OPatch/opatch versionOPatch Version: 12.2.0.1.17OPatch succeeded.~]$ $ORACLE_HOME/OPatch/opatch lspatches29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)29517242;Database Release Update :...
p34086870_190000_Linux-x86-64
Patch 34086870 - Oracle JavaVM Component Release Update 19.16.0.0.220719 p34086870_190000_Linux-x86-64 ・ p34086870_190000_Linux-x86-64_README Record
p34130714_190000_Linux-x86-64
Patch 34130714 - GI Release Update 19.16.0.0.220719 p34130714_190000_Linux-x86-64 ・ p34130714_190000_Linux-x86-64_README Record System Operation: RHEL 8.7 Database Software: 19.3.0.0.0 RAC with 3 nodes Update OPatch utility version to 12.2.0.1.30 or later. Patch 6880880_190000 - record 2 Validation of Oracle Inventory on each node. ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME Download and U...














