两个client
分别显示不同的error code Oracle-01552 cannot use system rollback segment for non-system tablespace 'A_TAB_TABLES'Oracle-00600 interal error code , arguments [][][][][][][][]
分别显示不同的error code Oracle-01552 cannot use system rollback segment for non-system tablespace 'A_TAB_TABLES'Oracle-00600 interal error code , arguments [][][][][][][][]
解决方案 »
- 请教基础知识
- 一台电脑访问局域网中的另一台电脑的oracle怎么配置啊,两台都装了oracle
- 我是菜鸟,不要笑话我啊。pls-00201 是编译错误还是运行时错误
- 寻找Linux下强制重启oracle数据库的方法
- 一个关于oracle问题!!!在线等待高手!
- 对分区表有深刻理解的高手请进
- 在一个字符串里所不是汉字的字符全去掉,怎么弄!!!!
- 数据库用imp导入失败的问题
- 事关饭碗,求助7.3.4 连接 9i 数据库怎么创建 db_link
- 在NLS_LANG=WE8ISO8859P1,数据库字符集为UTF16的环境下用Oralce OLEDB操作汉字的朋友吗?
- 为何表分区后却很慢了?
- 下面有oracle的习题,那个大哥帮忙做下,我把习题和表都贴到上边去了
ORA-01552: cannot use system rollback segment for non-system tablespace 'string'
Cause: Tried to use the system rollback segment for operations involving non-system tablespace. If this is a clone database then this will happen when attempting any data modification outside of the system tablespace. Only the system rollback segment can be online in a clone database.
Action: Create one or more private/public segment(s), shutdown and then startup again. May need to modify the INIT.ORA parameter rollback_segments to acquire private rollback segment. If this is a clone database being used for tablspace point in time recovery then this operation is not allowed. If the non-system tablespace has AUTO segment space management, then create an undo tablespace. 600的错误比较复杂, 先看01552的。 顺便检查下alert log里面的错误。Oracle 自动段空间管理(ASSM:auto segment space management)
http://blog.csdn.net/tianlesoftware/archive/2009/12/13/4958989.aspxOracle undo 回滚段管理
http://blog.csdn.net/tianlesoftware/archive/2009/11/30/4901666.aspx------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
不像大多数ORA-00600那样让人望而生畏。应该是你系统仅有SYSTEM表空间上的UNDO段,而没有专门的UNDO表空间。
解决办法有二:
1 使用自动管理回退段的方式,手工创建UNDO表空间,如UNDOTBS1并指定初始化参数:
undo_management='AUTO'
undo_tablespace='UNDOTBS1' 2 使用手工管理回退段的方式
create rollback segment …2没有在10g上测试过,ORACLE强烈推荐1!!!!!
2 undo_management='AUTO'启动前,是否创建专门的UNDO TABLESPACE?
undo_tablespace参数是否设置?
undo_management='AUTO'
undo_tablespace='UNDOTBS1'
undo_management='AUTO'
undo_tablespace'UNDOTBS1'
设置后,
SQL> startup pfile='/qscora/admin/arial/pfile/initarial.ora';
ORACLE instance started.Total System Global Area 353857616 bytes
Fixed Size 737360 bytes
Variable Size 134217728 bytes
Database Buffers 218103808 bytes
Redo Buffers 798720 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL>show parameter undo仔细检查你的参数。
select * from v$datafile;
select * from v$tablespace;看看具体的表空间及数据文件状态。
undo_tablespace'UNDOTBS1' ,少了=最关键是的是检查UNDOTBS1表空间是否存在!PS:参数值不要有空格或其他乱七八糟的特殊字符!!!
------------------------------------ ----------- ------------------------------
undo_management string MANUAL
undo_retention integer 900
undo_suppress_errors boolean TRUE
undo_tablespace string
SQL> select * from v$tablespace; TS# NAME INC
---------- ------------------------------ ---
0 SYSTEM YES
1 ROLLBACK YES
2 TEMP YES
3 TOOLS YES
4 USERS YES
5 ARIA_TAB_TABLES_TOPN YES
6 ARIA_TAB_TABLES_LARGE YES
7 ARIA_TAB_TABLES YES
8 ARIA_TAB_INDEX_TOPN YES
9 ARIA_TAB_INDEX_LARGE YES
10 ARIA_TAB_INDEXES YES TS# NAME INC
---------- ------------------------------ ---
11 ARIA_TAB_TEMP YES
undo_management='MANTUL'
这样配可以吗?
undo_tablespace'UNDOTBS1'
设置后,
SQL> startup pfile='/qscora/admin/arial/pfile/initarial.ora';
ORACLE instance started. Total System Global Area 353857616 bytes
Fixed Size 737360 bytes
Variable Size 134217728 bytes
Database Buffers 218103808 bytes
Redo Buffers 798720 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
仔细看看文档吧,你看看你的v$tablespace,有name='UNDOTBS1'的表空间吗?不报错,是ORACLE的错!undo_tablespace='ROLLBACK'
undo_management='AUTO' 也只是猜想而已。试试。别undo_management='MANTUL',后果很严重……
GOOGLE不晓得哪天就不能用了,总有一天,我们应该记得,有一只搜索引擎,叫GOOGLE………
undo_management='AUTO'是这样设置吗?
设置后,
SQL> startup pfile='/qscora/admin/arial/pfile/initarial.ora';
ORACLE instance started. Total System Global Area 353857616 bytes
Fixed Size 737360 bytes
Variable Size 134217728 bytes
Database Buffers 218103808 bytes
Redo Buffers 798720 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced v$tablespace,没有name='UNDOTBS1'的表空间,怎么添加表空间呢?
DATAFILE '……' SIZE 100M REUSE AUTOEXTEND ON;红色部分自己设置。
undo_tablespace='UNDOTBS1'
undo_management='AUTO'
后,
SQL> startup
Oracle not available.
所以不能执行
SQL> show parameter undo
SQL> select * from v$tablespace;
SQL> shutdown immediate;设置
undo_tablespace='UNDOTBS1'
undo_management='AUTO' SQL> startup pfile='/qscora/admin/arial/pfile/initarial.ora'; 请问是这样的顺序吗?
再请问下如果undo_tablespace='ROLLBACK'SQL> CREATE UNDO TABLESPACE ROLLBACK DATAFILE '……' SIZE 100M REUSE AUTOEXTEND ON;
如果undo_tablespace='ROLLBACK' 不配置了,对应的还需要删除吗?怎么删除表空间呢? 谢谢