UPGRADE CATALOG
UPGRADE CATALOG作用:升级catalog数据库到客户端的版本UPGRADE CATALOG command to upgrade a recovery catalog schema from an older version to the version required by the RMAN client....
Linux oracle 10g 直接使用LUN创建ASM DISKGROUP
Linux oracle 10g 直接使用LUN创建ASM DISKGROUP版本信息:OS: Red Hat Enterprise Linux as 5.6Oracle:10.2.0.4.0在/etc/rc.local文件加入如下内容### asm disk ##############chown orac...
How To : OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE)
OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE) [ID 428681.1] Modified 23-SEP-2011 Type HOWTO Status PUB...
DataGuard ORA-01119 ORA-27054错误解决
DataGuard ORA-01119 ORA-27054错误解决环境信息:主库使用裸设备备库使用file system现象:DataGuard异常select process,status,sequnece#,thread# from v$managed_standby查不MRP进程 standby alter l...
RAC实验 新增节点
一.新增节点前的准备工作1. tar -xzvf os.tar.gzos.tar.gz:为VMWare操作系统安装完成并修改OS kernel,创建oracle安装用户及群组后的备份 2. 安装asm安装:rpm -ivh *.rpm配置:/etc/init.d/oracleasm con...
RAC Failover测试及VIP漂移观察
1. 连接到数据库C:\>sqlplus system/password@oakdb SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 11月 5 11:05:41 2010 Copyright (c) 1982, 2005, Oracle....
RAC客户端连接测试
客户端环境:OS:Windows 2003 + ORACLE 10G 1. 在C:\WINDOWS\system32\drivers\etc\hosts加入下面内容:10.182.4.31 rac110.182.4.35 &n...
asm:ORA-00600: internal error code, arguments: [kfgFinalize_2]
LInux VMWare RAC ASM实例启动无法启动[oracle@RAC1 ~]$ ORACLE_SID=+ASM1[oracle@RAC1 ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Sat Oct 30 16:52:54 2010Copyright (c) 1982, 200...
清除10g RAC CRS的方法
注:在Linux 4U7下验证可行如果在安装clusterware的过程报错,需要重新安装时,必须先清除已经安装的cluserware,否则可能会影响到下次安装。一般情况下,只需要在各节点上运行目录$ORA_CRS_HOME/install/下的脚本ro...
Where条件导致查询不走索引的情况
创建测试用表:test,test2,test3SQL> create table test as select object_id, owner, object_name, created from dba_objects;Table createdSQL >create table test2 as select * from test where owner in ('SYS'...
install JAccelerator (NCOMP) on RedHat Linux AS4.8 64-bit
数据库从10.2.0.1.0升级到10.2.0.4.0,升级报告警告如下:Warnings DBUA has detected that the JAccelerator(NCOMP) is not Installed.Please refre to the Post-installation Tasks chapterin ther Oracle Databa...
Tomcat-----JFreeChart例子
最近想用柱状图表示oracle表空间的每日增长量,在网上搜索后从JFreeChat和JQuery插件之间选择了JFreeChart,终于实现,拿出与大家分享(并不完美)。1.在web.xml中加入下面的内容:<servlet> <servlet-name>Di...
expdp:ORA-31634: job already exists
expdp:ORA-31634: job already exists 使用数据泵进行全备,由于空间不足导致备份失败,清理空间后再次进行备份报如下错误: With the Partitioning, OLAP and Data Mining options...
ORA-31626 ORA-4063 Package Body DBMS_INTERNAL_LOGSTDBY Has Errors
今天同事让帮忙处理一问题,将物理standby转换为逻辑standby失败,expdp/impdp无法使用,DBMS_JOB无法建立新的JOB.expdp详细错误信息如下:ORA-31626: job does not existORA-04063: package body "SYS.DBMS_INTERNAL...
Getting ORA-44003 in the alert log. [ID 605025.1]
Getting ORA-44003 in the alert log. [ID 605025.1] -------------------------------------------------------------------------------- Modified 15-JUL-2008 Type P...
我的JOB执行时间,我说了算
我的JOB执行时间,我说了算如果JOB的interval直接用sysdate指定,如: sysdate + 5/1440,oracle自动生成的下一次的执行时间,会有几秒的延迟.下面是一个测试:1.创建表test_job_a,用于记录JOB开始执行时间和结束时间S...
通过impdp导入用户的JOB
通过impdp导入用户的JOB [oracle@ecard admin]$ impdp INCLUDE=SCHEMA_EXPORT/JOB network_link=job directory=dump logfile=job.log Import: Release 10.2.0.1.0 - Production on Sunday, 10 J...
Linux安装64 bit orace后,启动级别为3,本机无法登录
OS版本:uname -aLinux fyinplan 2.6.9-22.ELsmp #1 SMP Mon Sep 19 18:00:54 EDT 2005 x86_64 x86_64 x86_64 GNU/Linux 数据库版本:SQL> select * from v$version; BANNER----------------...
nls_date_format参数设置问题
环境:OS: Red Hat Enterprise Linux AS release 4 (Nahant Update 2)DB: 10.2.0.1.0关于nls_date_format的说明:NLS_DATE_FORMAT specifies the default date format to use with the TO_CHAR and TO_DATE functi...
ORA-00332: archived log is too small - may be incompletely archived
今天早上一班就发现一DB standby出了问题查看standby主机各process是否正常时发现MRP不存在.SQL> alter database recover managed standby database disconnect from session;SQL> select process, status, seque...