ITPub博客

本文转自：http://blog.xb668.com/?action=show&id=24 感谢原作者。请以root用户权限执行： 1) # snap -r 回答Y（如果以前未做过snap,系统会报错说明没有可清理的内容,显示“nothing to clean up”）， 完成后继续 2) 2) # snap -gbc 完成后,通过ftp (用binary方式,在命令行下执行:bin) 取得/tmp/ibmsupt/snap.pax.* 文件 (snap.pax.Z 或者snap.tar.Z) 然后执行 #errpt -a > /tmp/errpt.txt[@more@]

linux --sysreport ，还有一个dmidecode，不过dmidecode输出的信息都是些硬件的信息。aix--prtconf 或者snapwindows --msinfo32.exe 其实就是系统信息窗口。里边"文件"-"导出" 可以导出为txt文本格式hpux 有啥？[@more@]

检查定时任务的脚本发现：export ORACLE_SID= orcl注意，orcl前面多了个空格，把空格去掉即可。export ORACLE_SID=orcl[@more@]

Selects Against ALL_SYNONYMS Perform Badly on 10g Release 10.2 [ID 377037.1] 修改时间 01-DEC-2010 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2Information in this document applies to any platform. Symptoms In some cases queries against the ALL_SYNONYMS vi

DBA_LOGSTDBY_NOT_UNIQUE displays all tables that have no primary and no non-null unique indexes. Most of the tables displayed by this view are supported because their columns contain enough information to be maintained in a logical standby database. Some tables, however, cannot be supported because their columns do not contain the necessary information. Unsupported tables usually contain a column defined using an unsupported datatype.Column Datatype NULL Description OWNER

关于oracle在linux系统下安装后，如何在系统重启的情况下让服务自动启动起来，网上有很多的教程和现成的脚本，这里只是个人工作中的一点经验。 以redhat as4和oracle 10g为例。单机在安装过程依照oracle官方的文档一步步下来，只要设置好参数、安装好必要的包，一般不会出什么问题。安装好了以后系统重 启，oracle重启服务，网上很多人建议自己写脚本（其实脚本也很简单），这里讲的是用oracle本身的脚本实现，当然不可避免最后还要写一点点的。 1、配置dbstart和dbshut 在$ORACLE_HOME/bin中，有dbstart和dbshut这两个脚本，

Do I Need To Disable The GoldenGate DDL Trigger Before An Oracle DB Upgrade or PSU patching? [ID 971222.1] 修改时间 15-APR-2011 类型 HOWTO 状态 PUBLISHED In this Document Solution References Applies to: Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]Information in this document applies to any platform. Solution Issue: If you are performing any Oracle database upgrades, for

MMAN (Memory Manager) is a background process that manages the dynamic resizing of SGA memory areas as the workload increases or decreases. This process was introduced in Oracle 10g. [@more@]

What are the 'PSP0' and 'LNS1' Background Processes Running In 10g Release 2? [ID 331000.1] 修改时间 22-DEC-2009 类型 BULLETIN 状态 PUBLISHED In this Document Purpose Scope and Application What are the 'PSP0' and 'LNS1' Background Processes Running In 10g Release 2? References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1Information in this document applies to any platform. New back

What are the 'PSP0' and 'LNS1' Background Processes Running In 10g Release 2? [ID 331000.1] 修改时间 22-DEC-2009 类型 BULLETIN 状态 PUBLISHED In this Document Purpose Scope and Application What are the 'PSP0' and 'LNS1' Background Processes Running In 10g Release 2? References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1Information in this document applies to any platform. New back

oracle 11690 1 0 15:52 ? 00:00:00 ora_pmon_leifsoracle 11692 1 0 15:52 ? 00:00:00 ora_psp0_leifsoracle 11694 1 0 15:52 ? 00:00:00 ora_mman_leifsoracle 11696 1 0 15:52 ? 00:00:00 ora_dbw0_leifsoracle 11698 1 0 15:52 ? 00:00:00 ora_lgwr_leifsoracle 11700 1 0 15:52 ? 00:00:00 ora_ckpt_leifsoracle 11702 1 1 15:52 ? 00:00:00 ora_smon_leifsoracle 11704 1 0 15:52 ? 00:00:00 ora_reco_leifsorac

V$TEMPSEG_USAGE This view describes temporary segment usage. Column Datatype Description USERNAME VARCHAR2(30) User who requested temporary space USER VARCHAR2(30) This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in USERNAME. SESSION_ADDR RAW(4 | 8) Address of shared SQL cursor SESSION_NUM NUMBER Serial number of session SQLADDR RAW(4 | 8) Address of SQL statement

1.表的大小select segment_name, sum(bytes)/1024/1024 MByte FROM dba_segments WHERE 1=1 AND owner ='LC0049999' GROUP BY segment_name2.表的建立时间dba_objects[@more@]

select name, state from v$asm_diskgroup此视图在asm实例和db 实例中都能查询到。在这两个视图中看到的state是不一样的。asm实例 中state 返回MOUNTED db 实例 中state 返回 CONNECTED 对此视图的解释：In an Automatic Storage Management instance, V$ASM_DISKGROUP displays one row for every disk group discovered by the Automatic Storage Management instance. In a database instance, V$ASM_DISKGROUP displays one row for every Automatic Storage Management disk group mounted by the local Automatic Storage Managemen

ORA-15018 ORA-15003 Unable To Create/Mount Diskgroup [ID 437081.1] 修改时间 24-DEC-2009 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3Information in this document applies to any platform. ***Checked for relevance on 24-Dec-2009*** Symptoms In Non- RAC system, while trying to create the diskgroup, foll

ASM Diskgroups are not mounted with spfile on ASM on next startup with crsctl command in 11gR2. [ID 1059856.1] 修改时间 04-MAY-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause Solution Applies to: Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later [Release: 11.2 and later ]Information in this document applies to any platform. Symptoms 1. 11gR2 Grid Infrastr

TROUBLESHOOTING - ASM disk not found/visible/discovered issues [ID 452770.1] 修改时间 28-APR-2010 类型 TROUBLESHOOTING 状态 PUBLISHED In this Document Purpose Last Review Date Instructions for the Reader Troubleshooting Details References Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.6 - Release: 10.1 to 11.1Information in this document applies to any platform. ***Check

ASM Is Unable To Detect SCSI Disks On Windows. [ID 880061.1] 修改时间 10-SEP-2009 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 Microsoft WindowsMicrosoft Windows XP (64-bit Itanium)Microsoft Windows Server 2003 (64-bit Itanium)Microsoft Windows XP (64-bit AMD64 and Intel EM6

看了老熊的帖子http://www.laoxiong.net/tns_admin_and_oem_caused_accident.html发现遵守良好的操作规范是多么的重要。David.Guo所描述的操作规范很值得遵守： David.Guo Says: 1月 23rd, 2009 at 2:03 下午 1：管理的混乱是造成这种问题的根本，首先，开发库和生产库密码相同； 2：开发环境有到生产主机的tns 3：删除用户这样的权限给到了开发使用的用户 说说这样的问题在我们这怎么管理吧： 1：开发数据库和生产数据库的用户密码完全没有联系，且生产保密； 2：非生产网段不能使用生产用户登录数据库；

RMAN> catalog adssfdfs RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "identifier": expecting one of: "archivelog, bac kup, backuppiece, controlfilecopy, clone, datafilecopy, device, db_recovery_file _dest, reco