随笔分类 -  Error Resolve

摘要:http://blog.csdn.net/jianxinmail01/article/details/6411205 阅读全文
posted @ 2013-07-14 10:10 ArcerZhang 阅读(174) 评论(0) 推荐(0) 编辑
摘要:ORA-39006: internal error ORA-39068: invalid master table data in row with PROCESS_ORDER=-3 ORA-01658:unable to create INITIAL extent for segment in tablespace CC_TBLSPORA-39097: Data Pump job encountered unexpected error -1658導出數據時,DATADUMP在導出schema下創建並使用默認名'SYS_EXPORT_SCHEMA_01’作為JOB名。在導出數據之前, 阅读全文
posted @ 2013-07-09 15:46 ArcerZhang 阅读(2646) 评论(0) 推荐(0) 编辑
摘要:http://www.cnblogs.com/killkill/archive/2010/12/20/1911172.html以上语句有可能会遇到如下错误:?1234alter database commit to switchover to physical standby*ERROR at line 1:ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected 这是由于一些连接还没有释放所致的,将前端应用关闭后如果还出现这种情况,可以用以下语句确认一下有哪些连接: 阅读全文
posted @ 2013-07-08 19:30 ArcerZhang 阅读(410) 评论(0) 推荐(0) 编辑
摘要:http://www.it165.net/os/html/201206/2436.html 阅读全文
posted @ 2013-07-06 09:49 ArcerZhang 阅读(1005) 评论(0) 推荐(0) 编辑
摘要:执行/runcluvfy.sh stage -pre crsinst -n 11grac1,11grac2 -fixup -verbose出错误点:Checking consistency of file "/etc/resolv.conf" across nodesChecking the file "/etc/resolv.conf" to make sure only one of domain and search entries is definedFile "/etc/resolv.conf" does not have 阅读全文
posted @ 2013-07-06 09:47 ArcerZhang 阅读(3296) 评论(0) 推荐(0) 编辑
摘要:PING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 16191.Fri Jul 05 14:18:27 2013Error 1031 received logging on to the standbyPING[ARC2]: Heartbeat failed to connect to standby 'phydb'. Error is 1031.Fri Jul 05 14:22:09 2013在解决这个问题的时候,尝试过很多办法;老师讲的,网上查的;都不管用;后来自己摸索出了 阅读全文
posted @ 2013-07-05 14:58 ArcerZhang 阅读(4486) 评论(0) 推荐(0) 编辑
摘要:Repository base is listed more than once in the configurationRepository updates is listed more than once in the configurationRepository addons is listed more than once in the configurationRepository extras is listed more than once in the configurationRepository centosplus is listed more than once in 阅读全文
posted @ 2013-07-02 14:17 ArcerZhang 阅读(787) 评论(0) 推荐(0) 编辑
摘要:Login as sysman user to the database and execute the following :execute MGMT_USER.MAKE_EM_USER('ARCER');//标红处为需要导出导入权限的用户的用户名备注:假如你没有开启SYSMAN用户,自行开启; 阅读全文
posted @ 2013-06-06 18:32 ArcerZhang 阅读(857) 评论(0) 推荐(0) 编辑
摘要:安装Oracle的时候碰到也是这样的问题,刚好在网上搜到了一篇很好的文章。转载在这里,给方便自己以后学习。 原文链接:http://www.iteye.com/problems/62745好像从oracle10开始,就没有enterprise console manager(有没有写错?)这个东西了,只能通过类似http://localhost:5500/em打开,于是打开http://localhost:5500/em,打不开,想到dbconsole可能没起动,于是在服务中启动,结果启动不了。于是做如下操作希望能启动。1、在cmd下,照网上资料:在命令行下输入 emctl start dbc 阅读全文
posted @ 2013-06-06 09:51 ArcerZhang 阅读(3199) 评论(0) 推荐(0) 编辑
摘要:sqlplus以管理员方式接入数据库,启动时出现报错,如下:> sqlplus "/as sysdba"SQL> startup......ORA-01157: cannot identify/lock data file 8 - see DBWR trace fileORA-01110: data file 8: '/tmp/test.dbf'查看数据库日志文件alert_$ORACLE_SID.log,存在对应报错信息:Errors in file ....../aix85_psp0_454886.trc:查看此trc文件中记录信息:*** 阅读全文
posted @ 2013-06-05 23:45 ArcerZhang 阅读(663) 评论(1) 推荐(0) 编辑
摘要:今天一个同学问的一个有关数据库的问题,我看了一下alert日志,发现有以下报错信息。现记录下来,以备后用ORA-19815: WARNING: db_recovery_file_dest_size of 5218762752 bytes is 100.00% used, and has 0 rema... 阅读全文
posted @ 2013-06-03 23:13 ArcerZhang 阅读(1152) 评论(0) 推荐(0) 编辑
摘要:问题描述:在sys用户下直接授权grant create job to U3/grant create any job to U3,执行成功后,切换到U3用户后,执行dbms_scheduler.create_chain('my_chain1');会报权限不足的错误.不知道为什么?begin dbms_scheduler.create_chain('my_chain1');end;/ 4 begin*ERROR at line 1:ORA-01031: insufficient privilegesORA-06512: at "SYS.DBMS_ISC 阅读全文
posted @ 2013-05-30 07:33 ArcerZhang 阅读(554) 评论(1) 推荐(0) 编辑
摘要:SQL> drop table t;drop table t *ERROR at line 1:ORA-55610: Invalid DDL statement on history-tracked table情况分析置于Flashback data archive中的table的一些限制追踪表(Tracked table),也就是指定将历史数据保存到某个flashback data archive中的table,不能执行DDL操作(add column除外)。NING@11g>drop table test;drop table test*ERROR at line 1:... 阅读全文
posted @ 2013-05-28 09:04 ArcerZhang 阅读(1129) 评论(0) 推荐(0) 编辑
摘要:C:\Users\MaryHu>exp ARCER/ARCER@DB234 FILE=E:\FGPS_20130528.dmp statistics=noneExport: Release 11.2.0.1.0 - Production on Tue May 28 08:04:54 2013Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 6 阅读全文
posted @ 2013-05-28 08:10 ArcerZhang 阅读(2369) 评论(0) 推荐(0) 编辑
摘要:前言:一个礼拜没有搭理我的数据库服务器,回来查看发现如下问题,经过多方查找,发现解决方案,特此收集整理一下,以备后用.文章参考来源:http://space.itpub.net/15843490/viewspace-580677ORA-38760: This database instance failed to turn on flashback database 今天重启数据库的时候,发现如下错误:ORA-38760: This database instance failed to turn on flashback database 数据库环境:linux64x86 +oracle10 阅读全文
posted @ 2013-05-27 09:26 ArcerZhang 阅读(424) 评论(0) 推荐(0) 编辑
摘要:1、查看oracle server NLS_LANG参数信息;以SYSDBA身份登录view nls_parametersSQL> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';PARAMETER VALUE------------------------------ ------------------------------NLS_CHARACTERSET AL32UTF82、修改环境变量export NLS_LANG# .bash_... 阅读全文
posted @ 2013-05-03 23:42 ArcerZhang 阅读(289) 评论(1) 推荐(0) 编辑
摘要:connection as sysdbaSQL> grant select any dictionary to user_name; 阅读全文
posted @ 2013-05-03 11:43 ArcerZhang 阅读(458) 评论(0) 推荐(0) 编辑
摘要:ORA-00257: archiver error. Connect internal only, until freed.Oracle 10g数据库物理空间管理方式与以前Oracle发生了变化,对归档日志所在的Flash_Recovery_Area空间进行了另外限制 Flash_Recovery_Area空间缺省安装时比较小,只有2GB,容易用完解决过程 根据数据库目前可用存储空间情况、FLASH_RECOVERY_AREA空间为2GB的实际情况,把FLASH_RECOVERY_AREA的空间修改为20GB()。 SQL> alter system set DB_RECOVERY_FI 阅读全文
posted @ 2013-04-20 00:20 ArcerZhang 阅读(287) 评论(0) 推荐(0) 编辑
摘要:Thread 1 cannot allocate new log,sequence 1466checkpoint not completecurrent log# 3 seq# 1465 mem#0:/home/ora10g/oradata/ora10g/redo03.log一般情况下,出现上述错误,基本上是由与日志被写满了,所造成的;解决方案:Provide enough groups to prevent waiting. 扩大联机重做日志文件组。 设置联机重做日志的大小. 阅读全文
posted @ 2013-04-02 11:54 ArcerZhang 阅读(147) 评论(0) 推荐(0) 编辑
摘要:1、问题描述将Oracle LOCK_SGA参数设置为TRUE之后,报错;SQL> show parameter LOCK_SGA;NAME TYPE VALUE------------------------------------ ----------- ------------------------------lock_sga boolean FALSESQL> alter system set LOCK_SGA=TRUE SCOPE=SPFIL... 阅读全文
posted @ 2013-04-01 16:54 ArcerZhang 阅读(1413) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示