ITPub博客

LOG_ARCHIVE_MIN_SUCCEED_DESTProperty Description Parameter type Integer Default value 1 Modifiable ALTER SESSION, ALTER SYSTEM Range of values 1 to 10 if you are using LOG_ARCHIVE_DEST_n 1 or 2 if you are using LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST Basic No LOG_ARCHIVE_MIN_SUCCEED_DEST defines the minimum number of destinations that must succeed in order for the online logfile to be available for reuse. If you are using the LOG_ARCHIVE_D

v$bgprocess --解释oracle db 后台进程作用的视图[@more@]

前几天有个客户问我，有个业务用户改密码后，很快就被锁定了。db是oracle10g的，问我有啥办法能看到是谁在尝试用这个用户登录，我想了想，对他说，可以用日志挖掘。后来做了一个实验，oracle10.2,min补充日志模式，尝试用错误的用户密码登录，之后，用日志挖掘却看不到相关的登录信息，即：logmnr_contents表中没有这一行记录。看来只能是开数据库审计了。注：能从监听日志中看出个大概。。。[@more@]ri

今天新装了oracle 打开pl/sql时报出了这个错误SQL*Net not properly installed OracleHomeKey:SOFTWAREORACLE PL/SQL Developer - (Not logged on) --------------------------- Initialization error SQL*Net not properly installed OracleHomeKey: SOFTWAREORACLE OracleHomeDir:[@more@]

Oracle9i: Data Guard Switchover and Failover Best Practices [ID 271448.1]Oracle10g: Data Guard Switchover and Failover Best Practices [ID 387266.1][@more@]

sqlplus / as sysdba 遇到ora-01012 no logged on 16G物理内存， processes 为300 ，aix上执行ps -ef |grep LOCAL=NO | wc -l 反馈 270个。前台plsql-dev工具也是有时候能登录，有时候就报ORA-12519: TNS:no appropriate service handler found 此时，正在跑建立mv的语句。估计是建立mv导致的。[@more@]

Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 and later [Release: 10.1 and later ]Information in this document applies to any platform. Goal The goal of this document is to demonstrate how a running Datapump job can be stopped.Suppose a session has started a Datapump export operation using the following UNIX command: $ nohup expdp parfile=test.par &The example in the document demonstrates how to stop this job from further processing. The same principles a

以下转自马主任的经验总结。安装11GR2 RAC会碰到INS-20802错误 只要确认scanip可以ping通就可以忽略掉 。[@more@]

rac不可用的排错步骤:1.获得rac是由几个nodes 组成：询问客户方技术人员或者使用命令查询srvctl config database2.各个nodes之间的date 时间是否同步3.各个nodes之间的网卡的逻辑名是否一致。4.各个nodes之间，private 网卡是否是用网线直接连接的（oracle官方要求网线通过交换机连接，不能是网线直接相连）5.各个nodes之间，使用private ip是否可以相互ping通6.各个存储空间(本地文件系统和共享存储)是否还有空闲空间: df -g 或者df -h 或者asmcmd下的lsdg 或者v$asm_diskgroup 疑问：对于使用共享存储使用裸设备的rac，怎么看裸设备中

oracle 10.2.0.1 rac 升级到10.2.0.4 rac时，dbua升级的组件列表，此表摘自dbua运行时的界面。performing pre upgradeupgrade oracle serverupgrade jserver java virtual machineupgrade oracle xdk for javaupgrade oracle java packagesupgrade oracle Textupgrade oracle xml databaseupgrade real application clustersupgrade oracle workspace managerupgrade oracle data miningupgrade olap analytic workspaceupgrade olap catalogupgrade oracle olap apiupgrade oracle intermediaupgrade spatialupgrade expression filterup

Oracle Server - Enterprise Edition - Version: 11.2.0.2 to 11.2.0.2 - Release: 11.2 to 11.2Information in this document applies to any platform. Purpose The FAQ will include information on adding a voting disk to an ASM diskgroup when using external redundancy. Questions and Answers Can you create a second voting disk in a different ASM diskgroup when using External Redundancy in 11.2?You cannot create more than 1 voting disk in the same or on another/different diskgroup disk when using

Gather_stats_job 调用dbms_stats.gather_database_stats_job_proc过程来收集statistics 的信息。 该过程收集对象statistics的条件如下： （1）对象的统计信息之前没有收集过。 （2）当对象有超过10%的rows 被修改，此时对象的统计信息也称为stale statistics。 在Oracle 10g中，在查询表时，如果没有统计分析，那么会采用动态采样。[@more@]

The Oracle Rules Manager Component Is Invalid After Upgrade To 10.2.0.4 [ID 748699.1]Solution 1. To upgrade "Rules Manager" component, please run the following script: $ORACLE_HOME/rdbms/admin/rulpatch.sql 2. Verify if the "Rules Manager" component is upgraded/valid: SQL> Select comp_name, version, status from dba_registry;值得注意的是，运行类似这样的升级sql，在正常的open 状态下是不行的。必须在upgrade 下才能执行这些升级sql[@more@]

impdp 时遇到ORA-02368 file string is not valid for this load operation Datapump Import Fails To Start With Error ORA-02368 [ID 735625.1]Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.2This problem can occur on any platform. Symptoms Getting the following error when starting datapump import: ORA-31694: master table "RECOVERED"."SYS_IMPORT_FULL_01" failed to load/unload ORA-02354: error in exporting/importing data ORA-02368: file i

oracle 10.2.0.4 expdp全库导出 导出语句：D:oracleproduct10.2.0db_1BINexpdp system/aaaaaa dumpfile=all_1124.dmp DIRECTORY=dmpdir full=y导出时，形成的export.log文件：;;;Export: Release 10.2.0.4.0 - Production on Thursday, 24 November, 2011 9:14:17Copyright (c) 2003, 2007, Oracle. All rights reserved.;;;Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsFLASHBACK automatically enabled to p

C:>D:oracleproduct10.2.0db_1BINsqlplus / as sysdba @c:startup.sqlSQL*Plus: Release 10.2.0.4.0 - Production on Thu Nov 24 09:10:33 2011Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to an idle instance.ORACLE instance started.Total System Global Area 612368384 bytesFixed Size 1298160 bytesVariable Size 138412304 bytesDatabase Buffers 465567744 bytesRedo Buffers 7090176 bytesDatabase mounted.Database opened.Disconnected fro

Oracle Database High Availability Solutions for Unplanned Downtimehttp://download.oracle.com/docs/cd/E11882_01/server.112/e17157/unplanned.htm#HAOVW11825[@more@]

ASM Diskgroup Can Not Be Shown When Creating Database With DBCA[@more@]

Windows: Save Application Log and System Log as txt files Using Event ViewerLinux: /var/log/messagesSun: /var/adm/messagesHP-UX: /var/adm/syslog/syslog.logTru64: /var/adm/messagesIBM: /bin/errpt - a (redirect this to a file called messages.out or something similar)[@more@]

To create a grid installation owner account where you have an existing system privileges group (in this example, dba), whose members you want to have granted the SYSASM privilege to administer the Oracle ASM instance, enter a command similar to the following: # /usr/sbin/useradd -u 1100 -g oinstall -G dba grid In the preceding command: The -u option specifies the user ID. Using this command flag is optional, as you can allow the system to provide you with an automatically genera