Solution 1 ) Error 980 during db open is causing the shut down of the database 2 ) Need to create the Dual Table to resolve the issue (which was not possible in the mount stage) Workaround ========= 3 ) Set the following parameter in the init.ora replication_dependency_tracking = FALSE 4 ) Startup the database 5 ) Create the Dual Table and Dual Public Synonym CREATE TABLE "SYS"."DUAL" ( "DUMMY" VARCHAR2(1) ) PCTFREE 10 PCTUSED 4; Insert Into Dual Values ('X'); Commit; Grant Select On Dual To Public; 6 ) Remove the above parameter and restart the database Note :- Dual table should not be dropped in any case , as it can lead to serious problems Errors[@more@]
SYS@HUIYI>drop table dual; Table dropped. SYS@HUIYI>startup force; ORACLE instance started. Total System Global Area 143727516 bytes Fixed Size 453532 bytes Variable Size 109051904 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes Database mounted. ORA-01092: ORACLE instance terminated. Disconnection forced @>startup mount; ORACLE instance started. Total System Global Area 143727516 bytes Fixed Size 453532 bytes Variable Size 109051904 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes Database mounted. @>create pfile from spfile; File created. -- 修改參數文件加上replication_dependency_tracking = FALSE …… -- 啟動數据庫 SYS@HUIYI>shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down. SYS@HUIYI>startup pfile=G:A9Idatabaseinithuiyi.ora; ORACLE instance started. Total System Global Area 143727516 bytes Fixed Size 453532 bytes Variable Size 109051904 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes Database mounted. Database opened. -- 創建dual 表 SYS@HUIYI>create table sys.dual 2 ( 3 dummy varchar2(1) 4 ) 5 pctfree 10 pctused 4; Table created. SYS@HUIYI>insert into dual values('X'); 1 row created. SYS@HUIYI>commit; Commit complete. SYS@HUIYI>grant select on dual to public; Grant succeeded. SYS@HUIYI>startup force; ORACLE instance started. Total System Global Area 143727516 bytes Fixed Size 453532 bytes Variable Size 109051904 bytes Database Buffers 33554432 bytes Redo Buffers 667648 bytes Database mounted. Database opened. SYS@HUIYI>select sysdate from dual; SYSDATE ------------------ 07-Mar-07 10:26:15
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8799875/viewspace-903154/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8799875/viewspace-903154/