Oracle数据库升级日志
刚才把数据库从10.2.0.1.0升级到10.2.0.5.0,启动数据库,报错:ORA-01092: ORACLE 例程终止,强制断开。查看alert文件,显示ORA-00704: bootstrap process failureORA-39700: database must be opened with UPG...
ORA-01102: cannot mount database in EXCLUSIVE mode
在STARTUP一数据库时,发生如下错误:SQL> startupORACLE instance started.Total System Global Area 536870912 bytesFixed Size 1322944 by...
在ORLE5.4上安装Grid Control 10.2.0.3时遇到OUI-25031错误
今天在ORLE5.4上安装Grid Control 10.2.0.3时到OMS配置时,遇到错误:Configuration assistant "OMS Configuration" failed -------------------------------------------------------------...
安装gc时遇到"Please specify a Unique Oracle Base directory ..."错误
在安装gc时提示"Please specify a Unique Oracle Base directory..."的错误,在网上查了下,可能是inventory的问题,尝试修改inventory,并成功安装:方法如下:使用root用户身份,修改/etc/oraInst.loc 文件,#vi /et...
hosts中机器名与IP不匹配引起EM配置错误
今天在用dbca创建数据库时,自动配置EM时报错,通过安装日志文件查看,发现以下错误:Mar 25, 2011 4:52:03 PM oracle.sysman.emcp.EMConfig performCONFIG: Stack Trace: oracle.sysman.emcp.exception.EMCo...
时区不匹配导致EM无法正常启动
今天在启动EM时报如下错误:[oracle@cfbtest ~]$ emctl start dbconsoleOracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2005 Oracle Corporation. All rig...
Linux下Oracle Dataguard配置方法
配置物理standby配置环境Oracle:Enterprise Edition Release 10.2.0.1.0 - 64bit机器名:CFBDB1CFBDB2IP:192.168.0.188192.168.1.188Net_Namelscfb1lscfb2SIDdgtestdgtestD...
用Authid Current_User 定义的建表过程,过程放在JOB中不能正常运行
在布署一个历史数据迁移的job时,遇到job无法正常运行的问题。后来查了下原因权限的问题:create or replace procedure p_cb Authid Current_Useras begin execute immediate 'create tabl...
identifier 'SYS.DBMS_LOCK' must be declared错误处理方法
用户在执行延时语句dbms_lock.sleep(5); 时报PLS-00201: identifier 'SYS.DBMS_LOCK' must be declared错误。解决办法:请用GRANT EXECUTE ON SYS.DBMS_LOCK TO <用户>;
NAUTILUS CAN'T BU USED NOW,DUE TO AN UNEXPECTED ERROR错误处理方法
今天重启两台Linux服务器登录到X时,报nautilus can't bu used now,due to an unexpected error错误,桌面区域内容无法显示,鼠标动作也失效,具体详细信息如下:Nautilus can't be used now, due to an unexpected...