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@]

http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html[@more@]

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

solaris # ndd /dev/NICNAME link_speedLinux # ethtool NICNAME|grep SpeedAIX # entstat -d NICNAME |grep SpeedHPUX # lanadmin -s CARDNumber[@more@]

Using Diagwait as a diagnostic to get more information for diagnosing Oracle Clusterware Node evictions [ID 559365.1][@more@]Using Diagwait as a diagnostic to get more information for diagnosing Oracle Clusterware Node evictions [ID 559365.1]

今天新装了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@]

GoalHow to check ASM login for Oracle Goldengate (OGG) ?SolutionIf ASM is in use, OGG must be able to connect to the ASM server via listener. The connection can be tested in the following (and other) manners: sqlplus sys/pwd@ASM1. Use the following statement to connect locally to an ASM instance using operating system authentication:sqlplus / AS SYSASM Use the following statement to connect locally using password authentication:sqlplus SYS AS SYSASMIf that connection test to the ASM server with

日志挖掘可以验证归档日志是否损坏。GoalEXTRACT is hung reading an archive log. OGG trace and o/s truss outputs show EXTRACT repeatedly accessing the next archive log but not progressing or generating an error. How can I verify that the log is not corrupted?SolutionTry processing that archive log using logminer and see if logminer can access the file header info:SQL> execdbms_logmnr.add_logfile('<path>/<arch file name>.arc');SQL> exec dbms_logmnr.start_logmnr;SQL> select count

源库一定要是force logging模式。可以从select force_logging from v$database 中看到。注意：force logging 和supplemental是两回事，这两个不是同一个东西。[@more@]

环境介绍：goldengate 目的端rep复制进程 遇到ora-00001 异常终止abend的血案源头oracle，1个extract进程，该的进程参数文件配置的是user.*源头oracle，2个进datapump进程（这是往2个不同目的端上的dp进程），第一个dp进程的参数文件配user.*第二个进程（以下简称dpww进程）的参数文件配置的是user.a; user.b;user.c;user.d;，也就是说，dpww进程是完成了部分表传输到目的地的trail文件中。目的端repww进程abended，看discard文件，如下所示： Current time: 2012-01-07 09:10:58Discarded record from action ABEND on error 1OCI Error

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

再见，2011时光荏苒，在每天的忙碌之中，在不经意之间，我走过了2011。2011，对我来说终生难忘，在2011年我当上了爸爸，抱着小宝宝的感觉真是很好。为了全家，努力去工作。加油！！！当然，工作不是生活的全部。[@more@]

http://blog.donews.com/cailiwen/archive/2007/11/27/1232048.aspx转帖：在/etc/hosts.allow输入 (其中192.168.10.88是你要允许登陆ssh的ip,或者是一个网段192.168.10.0/24) sshd:192.168.10.88:allow 在/etc/hosts.deny输入(表示除了上面允许的，其他的ip 都拒绝登陆ssh) sshd:ALL[@more@]

以下转自马主任的经验总结。安装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