- 浏览: 269593 次
- 性别:
- 来自: 北京
文章分类
- 全部博客 (220)
- oracle (45)
- extjs (2)
- jstl (8)
- tomcat (9)
- svn (2)
- 系统 (12)
- 工作日志 (4)
- flex (5)
- 乱码 (1)
- jsp (2)
- java (26)
- mysql (8)
- vmware (2)
- 其他 (4)
- acegi (1)
- yui (1)
- hibernate (1)
- javascript (10)
- Maven (2)
- 数据库 (3)
- html css (2)
- displaytag (6)
- 软件开发管理 (2)
- java模式 (2)
- springside (7)
- android (14)
- other (3)
- linux (1)
最新评论
-
yixiandave:
string2020 写道分布式应用 用户认证,应该是在统一的 ...
分布式应用注意简介 -
string2020:
分布式应用 用户认证,应该是在统一的一个地方验证吧
分布式应用注意简介 -
liusu:
1、listView 视图黑色 设置 cacheColorHi ...
android 注意 -
teamilk:
engine 是什么?怎么导呢,不会弄,请教下
H2 数据库数据导出 -
djb_daydayup:
哦,我看到源文件了!
How to use
Ver.2.00 ...
android screen monitor 手机屏幕共享
Oracle10g中每天晚上10点会进行自动搜集统计信息,数据库准时报下面这个错,已经忍它很久了,虽然对数据库没什么大影响,但是每天查日志看见也很不爽:
Tue Dec 19 22:00:03 2006
Errors in file /oracle/admin/shdt2/bdump/shdt2_j000_8466.trc:
ORA-12012: error on auto execute of job 8898
ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1344
ORA-06512: at "SYS.DBMS_SPACE", line 1560
Errors in file /oracle/admin/shdt2/bdump/shdt2_j000_8466.trc:
ORA-12012: error on auto execute of job 8898
ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1344
ORA-06512: at "SYS.DBMS_SPACE", line 1560
/oracle/admin/shdt2/bdump/shdt2_j000_8466.trc:
*** ACTION NAME:(AUTO_SPACE_ADVISOR_JOB) 2006-12-19 22:00:03.457
*** MODULE NAME:(DBMS_SCHEDULER) 2006-12-19 22:00:03.457
*** SERVICE NAME:(SYS$USERS) 2006-12-19 22:00:03.457
*** CLIENT ID:() 2006-12-19 22:00:03.457
*** SESSION ID:(487.15519) 2006-12-19 22:00:03.457
*** 2006-12-19 22:00:03.457
ORA-12012: error on auto execute of job 8898
ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1344
ORA-06512: at "SYS.DBMS_SPACE", line 1560
*** MODULE NAME:(DBMS_SCHEDULER) 2006-12-19 22:00:03.457
*** SERVICE NAME:(SYS$USERS) 2006-12-19 22:00:03.457
*** CLIENT ID:() 2006-12-19 22:00:03.457
*** SESSION ID:(487.15519) 2006-12-19 22:00:03.457
*** 2006-12-19 22:00:03.457
ORA-12012: error on auto execute of job 8898
ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1344
ORA-06512: at "SYS.DBMS_SPACE", line 1560
错误重现:
sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.2.0 - Production on Wed Dec 20 09:03:48 2006
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> exec dbms_space.auto_space_advisor_job_proc;
BEGIN dbms_space.auto_space_advisor_job_proc; END;
BEGIN dbms_space.auto_space_advisor_job_proc; END;
*
ERROR at line 1:
ORA-20000: Content of the tablespace specified is not permanent or tablespace
name is invalid
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1344
ORA-06512: at "SYS.DBMS_SPACE", line 1560
ORA-06512: at line 1
ERROR at line 1:
ORA-20000: Content of the tablespace specified is not permanent or tablespace
name is invalid
ORA-06512: at "SYS.PRVT_ADVISOR", line 1624
ORA-06512: at "SYS.DBMS_ADVISOR", line 186
ORA-06512: at "SYS.DBMS_SPACE", line 1344
ORA-06512: at "SYS.DBMS_SPACE", line 1560
ORA-06512: at line 1
原因是某个表空间删除以后,数据库还会对它进行统计,这时候就会报错了。DBA_AUTO_SEGADV_CTL表存储的是自动搜集统计信息的对象,把出错的表空间对象从这删除就可以了。先确定是哪个表空间:
SQL> desc DBA_AUTO_SEGADV_CTL
Name Null? Type
----------------------------------------- -------- ----------------------------
AUTO_TASKID NUMBER
TABLESPACE_NAME VARCHAR2(30)
SEGMENT_OWNER VARCHAR2(30)
SEGMENT_NAME VARCHAR2(81)
SEGMENT_TYPE VARCHAR2(18)
PARTITION_NAME VARCHAR2(30)
STATUS VARCHAR2(40)
REASON VARCHAR2(40)
REASON_VALUE NUMBER
CREATION_TIME TIMESTAMP(6)
PROCESSED_TASKID NUMBER
END_TIME TIMESTAMP(6)
Name Null? Type
----------------------------------------- -------- ----------------------------
AUTO_TASKID NUMBER
TABLESPACE_NAME VARCHAR2(30)
SEGMENT_OWNER VARCHAR2(30)
SEGMENT_NAME VARCHAR2(81)
SEGMENT_TYPE VARCHAR2(18)
PARTITION_NAME VARCHAR2(30)
STATUS VARCHAR2(40)
REASON VARCHAR2(40)
REASON_VALUE NUMBER
CREATION_TIME TIMESTAMP(6)
PROCESSED_TASKID NUMBER
END_TIME TIMESTAMP(6)
SQL> select distinct tablespace_name from DBA_AUTO_SEGADV_CTL;
TABLESPACE_NAME
------------------------------
SYSAUX
NEWHC
NEWHCINDEX
STRMADMIN
------------------------------
SYSAUX
NEWHC
NEWHCINDEX
STRMADMIN
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS
NEWHC
NEWHCINDEX
------------------------------
SYSTEM
UNDOTBS1
SYSAUX
TEMP
USERS
NEWHC
NEWHCINDEX
SQL> select count(*) from DBA_AUTO_SEGADV_CTL where tablespace_name='STRMADMIN';
COUNT(*)
----------
1
----------
1
SQL> select segment_owner, segment_name, status from DBA_AUTO_SEGADV_CTL where tablespace_name='STRMADMIN';
SEGMENT_OWNER SEGMENT_NAME STATUS
----------------------- ---------------------- ----------------------------------------
----------------------- ---------------------- ----------------------------------------
BEING_PROCESSED
SQL> delete DBA_AUTO_SEGADV_CTL where tablespace_name='STRMADMIN';
SQL> delete DBA_AUTO_SEGADV_CTL where tablespace_name='STRMADMIN';
1 row deleted.
SQL> commit;
Commit complete.
SQL> exec dbms_space.auto_space_advisor_job_proc;
PL/SQL procedure successfully completed.
结果到了晚上又报错,那条记录重新加到DBA_AUTO_SEGADV_CTL中去了,猜想可能是ts$中还保留着STRMADMIN表空间的信息,把ts$中的记录也删除就完全解决了。ts$中记录了从数据库建立以来所有的创建过的表空间信息。
发表评论
-
修改归档路径
2013-12-30 13:57 637修改 sql>alter system set log_ ... -
带数据库网站并发数
2011-04-08 16:50 883所以如果要设计一个1000并发的网站,需要一个数据库3个tom ... -
删除过期备份
2011-01-16 06:45 7641. 设置保留最近的3次备份 RMAN> con ... -
Oracle 数据库连接报错 ORA-12514
2010-09-16 13:49 969hosts文件中有一个用来标识网络上可以访问的计算机的IP地址 ... -
改redo重做日志大小
2010-06-16 14:57 10771、查重做日志详细内容select a.status, b.m ... -
oracle 查日志每分钟的连接数
2010-06-01 17:05 756cat listener.log | grep '30-MAY ... -
异机恢复oracle
2010-06-01 14:37 1266环境准备:a、数据库版本一样。(我的是oracle10.2.0 ... -
oracle listener.log 过大
2010-05-20 17:00 886lsnrctl set log_status off mv ... -
oracle 重装 后用rman恢复 转载收藏
2010-05-06 16:27 1219重新安装OS,ORACLEL软件用RMAN恢复数据 OS和or ... -
oracle redolog 文件丢失恢复 sqlplus
2010-05-06 10:45 1142好用: sqlplus /nolog 0、connect ... -
oracle 控制文件丢失恢复 rman
2010-05-06 10:33 7640、和恢复spfile一样数据库start nomount 状 ... -
oracle spfile 文件丢失 恢复 rman
2010-05-06 09:56 10451、进入rman : rman target / a、RMA ... -
oracle 口令文件丢失恢复 orapwd
2010-05-06 09:45 9501、一般oracle的口令文$ORACLE_HOME/dbs( ... -
oracle rnam 备份方案
2010-05-05 16:16 969oracle rnam 备份方案 周日晚上 oracle$& ... -
oracle rman
2010-05-04 13:48 10301、rman target / ... -
exp imp 移动数据 注意事项
2010-04-28 22:18 1129当 exp imp 移动数据时长时间未完成时,这时一定要看or ... -
oracle startup 错误诊断
2010-04-21 11:28 706oracle startup 错误大体诊断 1、startu ... -
oracle10g 归档日志文件夹设置
2010-04-20 11:00 13411、双归档备份。两份一样的规定。 alter system ... -
oracle9i 改归档模式
2010-04-18 12:56 703进入sqlplus重启动数据库到mount状态 a0 ... -
oracle9i 恢复 bad的回滚段导致的不能启动 备忘
2010-04-18 12:35 1039停电等意外关机会使orac ...
相关推荐
其中,1是执行权(Execute),2是写权限(Write),4是读权限(Read), 具体权限相当于三种权限的数相加,如7=1+2+4,即拥有读写和执行权。 另外,临时文件/目录的权限为rwt,可写却不可删,关机后自动删除;建临时目录...
<load-on-startup>2</load-on-startup> </servlet> <servlet-mapping> <servlet-name>JeeCmsFront</servlet-name> <url-pattern>*.jhtml</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>...
Usage: ora [-u user] [-i instance#] <command> [] General -u user/pass use USER/PASS to log in -i instance# append # to ORACLE_SID -sid <sid> set ORACLE_SID to sid -top # limit some large queries ...
ORA-00942:表或视图不存在 若在程序中执行该语句则会报异常,这就需要我们在删除表前先判断该表是否存在,若存在则删除. DECLARE num NUMBER; BEGIN SELECT COUNT(1) INTO num FROM USER_TABLES WHERE TABLE_NAME = ...
Oracle常见错误:ORA-01403 ORA-06512: 在 "MALL.PUB_YANG_LOGON_ORGAN", line 88 ORA-06512: 在 line 1 at com.yangcq.flow.processflow.ProcessflowFunction.execute(ProcessflowFunction.java:102) ...
值范围: Arabic Hijrah, English Hijrah, Gregorian, Japanese Imperial, Persian, ROC Official (Republic of China) 和 Thai Buddha。 默认值: Gregorian plsql_native_c_compiler: 说明: 指定用于将生成的 C ...
这个简单的工具用Java编写,可以处理,分析并返回查询和SQL命令的结果。 它支持:-基本SQL命令:... -PL / SQL语句:CREATE PROCEDURE,EXECUTE; -快捷方式:显示所有用户表,表中的所有行以及说明(DESC )中的列。
GRANT EXECUTE ON UTL_FILE_DIR TO a; 生成字典文件(新建表后要刷新) EXECUTE dbms_logmnr_d.build(dictionary_filename => 'orcldict.ora', dictionary_location => 'd:\temp'); 分析在线重作日志文件 ...
8_____vi /home/oracle/ora/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora 9_____/opt/lampp/lampp start 10_____/opt/lampp/lampp restart 11_____/opt/lampp/lampp stop 帮助 [root@...
execute:返回boolean类型的值,代表是否有结果集返回(如果执行select操作,是有ResultSet的,返回值为true) executeUpdate:返回int类型的值,代表的是,操作执行完成后,受影响的数据库的行计数(针对于insert,...
SQL> execute dbms_logmnr_d.build(dictionary_filename => 'dict.ora', dictionary_location => 'G:\oracle\logs'); ``` 创建数据字典文件后,需要创建要分析的日志文件列表,使用以下语句: ```sql SQL> execute ...
COMPUTE sum of sal comm on deptno SELECT empno,ename,job,hiredate,sal,comm,deptno from emp ORDER BY deptno,sal; SPOOL off /*终止SPOOL功能,关闭其文件。注意,此命令不可省,否则将建立空文件。 五、 ...
DELETE_CATALOG_ROLE, EXECUTE_CATALOG_ROLE,SELECT_CATALOG_ROLE这些角色主要用于访问数据字典视图和包。 EXP_FULL_DATABASE, IMP_FULL_DATABASE这两个角色用于数据导入导出工具的使用。 自定义角色 ...
将以下内容添加到/etc/init.d/Oracle中并添加可执行权限,chkconfig –add oracle添加到服务启动列表,chkconfig oracle on设置成开机启动 #!/bin/sh # chkconfig: 35 80 10 # description: Oracle auto start-...
6. <property name="url" value="jdbc:oracle:thin:@localhost:1521:ora9i"/> 7. 8. 9. 10. !-- Hibernate会话工厂配置 //--> 11. 12. class="org.springframework.orm.hibernate3.LocalSessionFactoryBean...
OraSQL 1. 6.1 ... * TNSNAMES.ORA 同 oracle 客户端一样的网络配置。 * Execute sql 执行SQL命令。 * Run sql script 执行一个脚本文件。 * Execute procedure 执行一个过程。 * Other... 其它。
[Q]执行exec dbms_logmnr_d.build('Logminer.ora','file 34 [Q]执行execute 34 第四部分、性能调整 35 [Q]如果设置自动跟踪 35 [Q]如果跟踪自己的会话或者是别人的会话 36 [Q]怎么设置整个数据库系统跟踪 36 [Q]怎么...