-
编辑 删除
RAC Debug开关修改工具
Oracle RAC是一个比较复杂的东西，拥有众多进程和组件，每个进程都会写入自己的日志文件。 对于这些日志文件，有一些开关，可以控制写入信息的详细程度，这些开关，在Oracle文档光盘里面并未提供，要修改这些开关，大致有三种方法：一、通过配置文件来修改二、通过环境变量来修改三、通过为每个组件设置debug等级来修改 以下介绍每一种和第三种方法，附件的脚本，是将第三种方法做了自动化，只需要按照以下方法使用，即可完成debug开关的修改：perl crs_debug_level.pl level=1 要禁用debug模式，则设置level为0：perl crs_debug_level.pl
-
编辑 删除
RAC: Frequently Asked Questions [ID 220970.1]
修改时间 08-MAR-2010 类型 FAQ 状态 PUBLISHED Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.1 - Release: 9.2 to 11.2PurposeFrequently Asked Questions for Real Application Clusters and Grid Infrastructure.Questions and AnswersGrid Computing / RACGeneral RACWhat is Cache Fusion and how does this affect applications? Is it difficult to transition (migrate) from Single Instance to Oracle RAC? What are the dependencies between OCFS and ASM in Oracle Database 10g ?
-
编辑 删除
How To Troubleshoot TNS: 12500 errors on Windows Platforms [ID 271072.1]
Applies to: Oracle Server - Enterprise Edition - Version: 7.3 to 9.2Microsoft Windows NT Terminal ServerMicrosoft Windows (32-bit)Oracle database instance, listener, clients attempting to connect via the listener. GoalThis document covers how to troubleshoot when the following errors are thrown to the client when it tries to connect from a client to the db instance running on Windows OS, via the listener -TNS-12500: TNS:listener failed to start a dedicated server processTNS-12540: TNS:internal l
-
编辑 删除
ORA-01031: insufficient privileges错误解决方法
问题产生：C:Documents and Settingsz9600261>sqlplus /nologSQL*Plus: Release 8.1.6.0.0 - Production on 星期三 5月 19 14:05:09 2010(c) Copyright 1999 Oracle Corporation. All rights reserved.SQL> connect sys/sys@orcl2.ap.enpad.org as sysdbaERROR：ORA-01031: insufficient privileges问题分析：以上使用远程SYSDBA连接管理数据库 ，所以必须满足2个条件1：remote_login_passwordfile=true2：正确创建密码文件orapwd FILE=$ORACLE_HOME/dbs/orapworclpassword=sys entries=20文件名称必须规范：orapwdSID[@more@]
-
编辑 删除
AWR:select output from table(dbms_workload_repository.awr_report_html( :dbid, * ERROR
... of the following errors: select output from table (dbms_workload_repository.awr_report_html (: Dbid, * ERROR at line 1: ORA-00904:: invalid identi . ...解决：sys用户授权grant all on dbms_workload_repository to perfstat;[@more@]
-
编辑 删除
How does ASM work with RAID where striping and mirroring are already built-in? [ID 330398.1]
How does ASM work with RAID where striping and mirroring are already built-in? [ID 330398.1] 修改时间 24-NOV-2008 类型 BULLETIN 状态 PUBLISHED In this Document Purpose Scope and Application How does ASM work with RAID where striping and mirroring are already built-in?Applies to: Oracle Server - Enterprise Edition - Version: 10.1 to 11.1Information in this document applies to any platform.. PurposeHow does ASM work with storage subsystems such as RAID where striping and mirroring are
