ITPub博客

SQL> set linesize 150set pagesize 10000column table_name format a30column tablespace_name format a20column partitioned format a20SELECT table_name, tablespace_name, partitionedFROM dba_tablesWHERE table_name LIKE 'WR%'AND partitioned='YES'ORDER BY table_name;TABLE_NAME &nbsp...

In this DocumentSymptoms Cause Solution ReferencesApplies to: Enterprise Manager for Oracle Database - Version 10.1.0.2 to 12.1.0.2.0 [Release 10.1 to 12.1]Oracle Database - Enterprise Edition - Version 9.0.1.4 to 12.1.0.2 [Release 9.0.1 to 12.1]Oracle Database - Personal Edition -...

There are situations when the backup information between RMAN catalog and Tivoli Storage Manager (TSM) is not in sync. Hence there are backup pieces found in TSM catalog which are not available in RMAN catalog or vice versa. There is a need here to release the tapes for recycling by rem...

https://www.ibm.com/support/knowledgecenter/en/SSGSG7_7.1.0/com.ibm.itsm.db.orc.doc/r_dporc_util_tdposync.htmlIBM Tivoli Storage Manager for Databases, Data Protection for Oracle, Version 7.1

IBM Tivoli Data Protection for Oracle provides 3 utilities to troubleshoot the problems or issues faced during oracle backup/restore processes. You can use these utilities to configure and and also maintain Data Protection for Oracle. These utilities are located in the directory where Da...

tail -f -500 /data/oracle/SHPBLS/admin/diag/rdbms/shpbls_sb/SHPBLS/trace/alert_SHPBLS.log| grep 'ORA-|rror'tail -n 1000 alert_ahjcyl.log |grep ORA-cd /data/oracle/SHPBLS/admin/diag/rdbms/shpbls_sb/SHPBLS/trace/tail -n 1000 alert_*.logtail -n 1000 alert_*.log  | grep OR...

什么是OJVM PSU？CPU: Critical Patch UpdateOracle对于其产品每个季度发行一次的安全补丁包，通常是为了修复产品中的安全隐患。PSU: Patch Set UpdatesOracle对于其产品每个季度发行一次的补丁包，包含了bug的修复。Oracle选取被用户下载数量多的，并且被验证过具有较低风险的补丁放入到每个季度的PSU中。在每个...

https://updates.oracle.com/Orion/Services/download?type=readme&aru=21753493This document describes how you can install Patch 26925532 - Oracle JavaVM Component 11.2.0.4.180116 Database PSU on your Oracle Database 11g Release 2 (11.2.0.4.0).This patch is not Oracle RAC Rolling installab...

[oracle@slient ~]$ opatchOracle Interim Patch Installer version 11.2.0.3.4Copyright (c) 2012, Oracle Corporation.  All rights reserved.Syntax Error... No command specified. Usage: opatch [ -help ] [ -report ] [ command ]          &n...

SQL> set linesize 150column OWNER format a20column SEGMENT_NAME format a20column PARTITION_NAME format a20column SEGMENT_TYPE format a15column TABLESPACE_NAME format a18select OWNER,SEGMENT_NAME,PARTITION_NAME,SEGMENT_TYPE,TABLESPACE_NAMEfrom dba_extentswhere FILE_ID=9 and 885 between blo...

ORA-24247：网络访问被访问控制列表 (ACL) 拒绝开发编写了一个oracle 发送邮件的存储过程，之前是在10G 的版本运行使用，现在11.2.0.4 的版本使用，调试无法使用发现报错ORA-24247， 网上查询资料如下：1.需要先使用 DBMS_NETWORK_ACL_ADMIN.CREATE_ACL 创建访问控制列表（ACL），   BEG...

背景：数据库由10.2.0.4升级到11.2.0.3.6后发送邮件报错。原因：      For database users upgrading to Oracle Database 11g Release 1 (11.1), applications that depend on the PL/SQL network utility packages compile without any issues. However, at runtime the applications migh...

-- 创建 ACLBEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL (  acl          => 'email_server_permissions.xml',   description  => 'Enables network permissions for the&nbsp...