| ORA-01092: ORACLE instance terminated. Disconnection forced [message #53252] |
Sun, 08 September 2002 17:57  |
Sean Lin
Messages: 2
Registered: September 2002
|
Junior Member |
|
|
Hi Oracle experts,
In Oracle 9.2.0.1, when I tried to create database from shell script on solaris 8, I got ORA-01092.
Please give me help
SQL command:
create database ecperf
controlfile reuse
datafile '/vol2/homes/oracle9i/Oracle_Home/dbs/ecperf_db/sys_ecperf' size 150M reuse
UNDO TABLESPACE undotbs DATAFILE '/vol2/homes/oracle9i/Oracle_Home/dbs/ecperf_db/undotbs_ecperf' SIZE 100M REUSE
AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
logfile '/vol2/homes/oracle9i/Oracle_Home/dbs/ecperf_db/log1_ecperf' size 100M reuse,
'/vol2/homes/oracle9i/Oracle_Home/dbs/ecperf_db/log2_ecperf' size 100M reuse
maxdatafiles 100
parameter file:
db_name = ecperf
control_files = /vol2/homes/oracle9i/Oracle_Home/dbs/ecperf_db/cntrlecperf
compatible = 9.0.0.0.0
db_files = 256
db_block_buffers = 2000
db_block_size = 2048
dml_locks = 500
log_checkpoint_interval = 999999999
log_buffer = 32768
sessions = 70
processes = 50
transactions = 50
undo_management = AUTO
The error message in client side:
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
The message in alter file:
Sun Sep 8 17:43:19 2002
create tablespace SYSTEM datafile '/vol2/homes/oracle9i/Oracle_Home/dbs/ecperf_db/sys_ecperf' size 150M reuse
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
Sun Sep 8 17:43:29 2002
Completed: create tablespace SYSTEM datafile '/vol2/homes/or
Sun Sep 8 17:43:29 2002
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
Sun Sep 8 17:43:58 2002
CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/vol2/homes/oracle9i/Oracle_Home/dbs/ec
perf_db/undotbs_ecperf' SIZE 100M REUSE
AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
Sun Sep 8 17:44:06 2002
Created Undo Segment _SYSSMU1$
Created Undo Segment _SYSSMU2$
Created Undo Segment _SYSSMU3$
Created Undo Segment _SYSSMU4$
Created Undo Segment _SYSSMU5$
Created Undo Segment _SYSSMU6$
Created Undo Segment _SYSSMU7$
Created Undo Segment _SYSSMU8$
Created Undo Segment _SYSSMU9$
Created Undo Segment _SYSSMU10$
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Completed: CREATE UNDO TABLESPACE UNDOTBS DATAFILE '/vol2/ho
Sun Sep 8 17:44:42 2002
SMON: enabling tx recovery
Sun Sep 8 17:45:05 2002
Errors in file /homes.beta/oracle9i/Oracle_Home/rdbms/log/ecperf_ora_20371.trc:
ORA-00600: internal error code, arguments: [[525]], [[0x20E87C28]], [[4]], [[row cache o
bjects]], [[2]], [[0x20017ED4]], [[child cursor hash table]], [[]]
Sun Sep 8 17:45:25 2002
Errors in file /homes.beta/oracle9i/Oracle_Home/rdbms/log/ecperf_ora_20371.trc:
ORA-01501: CREATE DATABASE failed
ORA-00600: internal error code, arguments: [[525]], [[0x20E87C28]], [[4]], [[row cache o
bjects]], [[2]], [[0x20017ED4]], [[child cursor hash table]], [[]]
Sun Sep 8 17:45:25 2002
Error 600 happened during db open, shutting down database
USER: terminating instance due to error 600
Instance terminated by USER, pid = 20371
ORA-1092 signalled during: create database ecperf
controlfile reuse
The message in audit file:
Audit file /homes.beta/oracle9i/Oracle_Home/rdbms/audit/ora_19888.aud
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /homes.beta/oracle9i/Oracle_Home
System name: SunOS
Node name: beta
Release: 5.8
Version: Generic_108528-13
Machine: sun4u
Instance name: beta
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
19888
Sun Sep 8 17:32:23 2002
ACTION : 'CONNECT'
DATABASE USER: '/'
PRIVILEGE : SYSDBA
CLIENT USER: hlin
CLIENT TERMINAL: Not Available
STATUS: 0
Audit file /homes.beta/oracle9i/Oracle_Home/rdbms/audit/ora_19888.aud
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /homes.beta/oracle9i/Oracle_Home
System name: SunOS
Node name: beta
Release: 5.8
Version: Generic_108528-13
Machine: sun4u
Instance name: beta
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
19888
Sun Sep 8 17:32:24 2002
ACTION : 'STARTUP'
DATABASE USER: '/'
PRIVILEGE : SYSDBA
CLIENT USER: hlin
CLIENT TERMINAL: Not Available
STATUS: 0
The message in trc:
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [[525]], [[0x20E87C28]], [[4]], [[row cache o
bjects]], [[2]], [[0x20017ED4]], [[child cursor hash table]], [[]]
Current SQL statement for this session:
create database ecperf
controlfile reuse
datafile '/vol2/homes/oracle9i/Oracle_Home/dbs/ecperf_db/sys_ecperf' size
150M reuse
UNDO TABLESPACE undotbs DATAFILE '/vol2/homes/oracle9i/Oracle_Home/dbs/ec
perf_db/undotbs_ecperf' SIZE 100M REUSE
AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
logfile '/vol2/homes/oracle9i/Oracle_Home/dbs/ecperf_db/log1_ecperf' size
100M reuse,
'/vol2/homes/oracle9i/Oracle_Home/dbs/ecperf_db/log2_ecperf' size
100M reuse
maxdatafiles 100
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+248 CALL ksedst()+0 2B4BFE0 ? 2B4BFBC ? C ? 0 ?
FFBEBCEC ? 2B4C000 ?
kgeriv()+180 PTR_CALL 00000000 3 ? 3 ? 6 ? 0 ? 0 ? 20D ?
kgesiv()+108 CALL kgeriv()+0 2E22BC0 ? 2EFA33C ? 20D ? 6 ?
FFBEC378 ? 20017FB5 ?
ksesic6()+64 CALL kgesiv()+0 2E22BC0 ? 2EFA33C ? 20D ? 6 ?
FFBEC378 ? FFBEC6F1 ?
kslgetl()+1128 CALL ksesic6()+0 20D ? 2 ? 20E87C28 ? 0 ? 4 ?
1 ?
kghfrunp()+2944 PTR_CALL 00000000 20017ED4 ? 2 ? 214DD0BC ?
FDC ? 20E87C28 ? 2001EB2C ?
kghfnd()+1464 CALL kghfrunp()+0 2002282C ? 205421FC ?
205421E8 ? 2001EB0C ?
2002281C ? 0 ?
kghpmalo()+176 CALL kghfnd()+0 0 ? 2001F744 ? 0 ? 20015CAC ?
20015CAC ? 0 ?
kghalp()+336 CALL kghpmalo()+0 174 ? BC ? 2001EB0C ? FA0 ?
FA0 ? FFBEC5AC ?
...........
|
|
|
|
| Re: ORA-01092: ORACLE instance terminated. Disconnection forced [message #53253 is a reply to message #53252] |
Sun, 08 September 2002 21:05  |
Sean Lin
Messages: 2
Registered: September 2002
|
Junior Member |
|
|
Hi,
It is working now. According init.ora, I modified my parameter file, but I did not know the reason. This is my parameter file:
db_name=ecperf
db_files = 400 # MEDIUM
compatible = 9.0.0.0.0
db_file_multiblock_read_count = 16 # MEDIUM
db_block_buffers = 550 # MEDIUM
shared_pool_size = 5000000 # MEDIUM
log_checkpoint_interval = 10000
processes = 100 # MEDIUM
parallel_max_servers = 5 # SMALL
log_buffer = 32768 # SMALL
control_files = (/vol2/homes/oracle9i/Oracle_Home/dbs/ecperf_db/cntrl1.dbf, /vol2/homes/oracle9i/Oracle_Home/dbs/ecperf_db/cntrl2.dbf)
undo_management = AUTO
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
