ITPub博客

一.引入问题今天在虚拟机上安装一个10g的Oracle，RedHat 6.2 64位的版本，不过Linux上基本都差不多，所以按照以前的步骤，迅速的操作起来，结果遇到N多以前没有遇到过的错误。  1.1 ins_ctx.mk 问题[oracle@xd logs]$ tail  installActions2012-05-05_01-20-00PM.log       ...

ORA-00600 3020 分析处理过程如下: ERROR:   Format: ORA-600 [3020] [a] [b] [c] [d] [e] VERSIONS: version 6.0 and aboveDESCRIPTION: This is called a 'STUCK RECOVERY'. There is an inconsistency between the information stored in the redo and the information stored...

环境:主库和备库形成oracle dataguard环境实施目标:利用scn增量备份来实现同步dataguard主要解决以下问题：The steps in this section can used to resolve problems of missing or corrupted archive log file, an unresolveable archive gap, or need to roll standby forward in time without applying a large n...

环境 oracle 9.2.0.7  rac + aix 安装完oracle 9i rac 在aix平台上后，用dbca建库或者手工建库都报以下错误:*** 2016-08-03 04:37:05.900ksedmp: internal or fatal errorORA-00603: ORACLE server session terminated by fatal errorORA-27504: IPC error creating OSD contextORA-27300: OS system dependen...

     环境:  oracle 9.2.0.7+aix 5.3     好久没有安装oracle 9i for aix 版本了，今天安装好软件后，用dbca建库，      报以下错误:    ORA-00603: ORACLE server session terminated by fatal errorORA-27504: IPC error creati...

What do the reasons given in v$SQL_SHARED_CURSOR meanIf you are unable to use that script then you can select the same information from the base views as illustrated in the examples below. Lets use the example above and take a look at what SQL we can use to see this in the shared pool. SCOT...

参考以下步骤:1) Identify the data file to be moved.2) Identify the diskgroup on to which the file has to be moved.3) Take the file offline.4) Copy the file to new diskgroup using Either RMAN or DBMS_FILE_TRANSFER.5) Rename the file to point to new location.6) Recover the file.7) Bring the f...

To modify SCAN listener port<br /><br />As grid user:<br /><br />1. Modify SCAN listener port:<br /><br />$GRID_HOME/bin/srvctl modify scan_listener -p &lt;new-SCAN-port&gt;<br /><br />Update 11gR2 database init.ora parameter: alter system set remote_listener='&lt;SCAN-name&gt;:&lt;new-port-...

&nbsp; 以下更改监听默认端口只针对11gR2 grid rac环境<br />1:&nbsp;srvctl config listener<br /><br /><br />&nbsp;&nbsp;&nbsp; 如要改成1529<br />2:srvctl modify listener -l LISTENER -p "TCP:&lt;new-listener-port&gt;"<br />&nbsp;&nbsp; <br />&nbsp;&nbsp; srvctl modify listener -l LISTENER -p "TCP...

The following procedure describe the steps to recreate the diskgroup where OCR and Voting disks are stored and restore the OCR data from a backup.1. List the backups of the OCR# $GI/bin/ocrconfig -showbackup2. Validate the integrity of the backup# $GI/bin/ocrdump -backupfile back...

  上次遇到一个案例：在客户现场11.2.0.4版本运行utlrp.sql 编译脚本时，出现以下错误:ORA-12801: error signaled in parallel query server P237ORA-12853: insufficient memory for PX buffers: current 84352K, max needed 13280400KORA-04031: unable to allocate 65560 bytes of shared memory (“large poo...

rman备份归档日志一开始想应该不会切换redo,除非是在rman 中指定 alter system archive log current或者是backup database plus archivelog  这两种情况下都会切换redo的以下是测试过程  会切换redo:C...

在一般恢复备份的控制文件,打开数据库都要用resetlogs 重置日志这种方式,这是因为备份的控制文件恢复后,没有最新的当前在线日志信息 ,而重建控制文件就可以用 NORESETLOGS  这种方式打开这是因为:备份的控...

       环境 oracle 10.2.0.4 rac+aix 5.3 +hacmp     今天在帮客户解决crs集群软件不能自动装载数据库的问题，按照oracle metalink文档説：In Oracle 9i...

The software requirements for HACMP 5.3 on 10gR2 are as follows:SoftwareVersion and other detailsAIX5.3 TL06 or newer (specifically bos.rte.lvm must be at least 5.3.0.60)HACMP5.3 SP5 and A...

从metalink 文档742060.1中，我们可以看到oracle 10.2.0.5 版本的大概发布时间oracle 10.2.0.5 for linux 已经发布，aix平台在2010年第二季度发布，也快了Current Oracle Database Release Schedule Pl...