Home » RDBMS Server » Server Administration » ORA-01092: ORACLE instance terminated. Disconnection forced
| ORA-01092: ORACLE instance terminated. Disconnection forced [message #64373] |
Thu, 20 January 2005 01:01  |
Sachin Kalra
Messages: 1
Registered: January 2005
|
Junior Member |
|
|
Hi All,
I am having some problem creation of database on HP-UX 11.11 & Oracle
9206. Below are details of the error.
<snip-CreateDB.sh>
bash-2.02$ cat CreateDB.sh
sqlplus "/ as sysdba" <<EOF
connect SYS/change_on_install as SYSDBA
set echo on
startup force nomount pfile=/oracle/OraHome/dbs/initoracert.ora
CREATE DATABASE oracert
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
DATAFILE '/oradata/dbs/system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/oradata/dbs/undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/oradata/dbs/redo01.log') SIZE 102400K,
GROUP 2 ('/oradata/dbs/redo02.log') SIZE 102400K,
GROUP 3 ('/oradata/dbs/redo03.log') SIZE 102400K;
exit;
EOF
bash-2.02$ ./CreateDB.sh
SQL*Plus: Release 9.2.0.6.0 - Production on Wed Jan 19 09:12:58 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> Connected to an idle instance.
SQL> SQL> ORACLE instance started.
Total System Global Area 64131160 bytes
Fixed Size 737368 bytes
Variable Size 62914560 bytes
Database Buffers 204800 bytes
Redo Buffers 274432 bytes
SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 CREATE DATABASE oracert
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
</snip-CreateDB.sh>
Details of alert_oracert.ora:
<snip-alert_oracert.ora>
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
Wed Jan 19 06:15:43 2005
Errors in file /oracle/orahome/rdbms/log/oracert_ora_5340.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 2216 bytes of shared memory ("shared
pool","unknown object","KGLS heap","KGLS MEM BLOCK")
Wed Jan 19 06:15:43 2005
Errors in file /oracle/orahome/rdbms/log/oracert_ora_5340.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/rdbms/admin/sql.bsq' near line
1269
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 2216 bytes of shared memory ("shared
pool","unknown object","KGLS heap","KGLS MEM BLOCK")
Error 1519 happened during db open, shutting down database
USER: terminating instance due to error 1519
Instance terminated by USER, pid = 5340
ORA-1092 signalled during: CREATE DATABASE oracert
MAXINSTANCES 1
MAXLOGHISTO...
</snip-alert_oracert.ora>
Below are the trace file details:
<snip-oracert_ora_5340.trc>
Dump file /oracle/orahome/rdbms/log/oracert_ora_5340.trc
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
ORACLE_HOME = /oracle/orahome
System name: HP-UX
Node name: george
Release: B.11.11
Version: U
Machine: 9000/800
Instance name: oracert
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 5340, image: oracle@george (TNS V1-V3)
*** SESSION ID:(7.3) 2005-01-19 06:15:41.484
=================================
Begin 4031 Diagnostic Information
=================================
The following information assists Oracle in diagnosing
causes of ORA-4031 errors. This trace may be disabled
by setting the init.ora parameter _4031_dump_bitvec = 0
======================================
Allocation Request Summary Information
======================================
Current information setting: 00654fff
Dump Interval=300 seconds SGA Heap Dump Interval=3600 seconds
Last Dump Time=01/19/2005 06:15:41
Allocation request for: KGLS MEM BLOCK
Heap: c000000007b3c670, size: 2216
******************************************************
HEAP DUMP heap name="sga heap" desc=c000000008000030
extent sz=0xfe0 alt=200 het=32767 rec=9 flg=-126 opc=0
parent=0000000000000000 owner=0000000000000000 nex=0000000000000000 xsz=0x0
******************************************************
HEAP DUMP heap name="KGLS heap" desc=c000000007b3c670
extent sz=0x840 alt=32767 het=32 rec=0 flg=2 opc=2
parent=c000000008000030 owner=0000000000000000 nex=0000000000000000 xsz=0x1
Subheap has 15960 bytes of memory allocated
====================
Process State Object
====================
----------------------------------------
SO: c0000000068d0b70, type: 2, owner: 0000000000000000, flag: INIT/-/-/0x00
(process) Oracle pid=8, calls cur/top:
c00000000690d410/c00000000690ced0, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 4
last post received-location: kslpsr
last process to post me: c0000000068cf6f0 1 6
last post sent: 0 0 16
last post sent-location: ksasnd
last process posted by me: c0000000068cf6f0 1 6
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: c0000000068de480
O/S info: user: oracle, term: UNKNOWN, ospid: 5340
OSD pid info: Unix process pid: 5340, image: oracle@george (TNS V1-V3)
=========================
User Session State Object
=========================
----------------------------------------
SO: c0000000068e81c0, type: 4, owner: c0000000068d0b70, flag: INIT/-/-/0x00
(session) trans: c000000007170c20, creator: c0000000068d0b70, flag:
(41) USR/- BSY/-/-/-/-/-
DID: 0001-0008-00000024, short-term DID: 0000-0000-00000000
txn branch: 0000000000000000
oct: 34, prv: 0, sql: 80000001001af098, psql:
80000001001af098, user: 0/SYS
O/S info: user: oracle, term: , ospid: 5325, machine: george
program: sqlplus@george (TNS V1-V3)
application name: sqlplus@george (TNS V1-V3), hash value=0
last wait for 'control file sequential read' blocking sess=0x0 seq=372
wait_time=17
file#=0, block#=2a1, blocks=1
temporary object counter: 0
============================
Current Session State Object
============================
----------------------------------------
SO: c0000000068e8c50, type: 4, owner: c00000000690ced0, flag: INIT/-/-/0x00
(session) trans: c000000007170c20, creator: 0000000000000000, flag:
(100002) -/REC -/-/-/-/-/-
DID: 0000-0000-00000000, short-term DID: 0000-0000-00000000
txn branch: 0000000000000000
oct: 1, prv: 0, sql: 0000000000000000, psql:
0000000000000000, user: 0/SYS
temporary object counter: 0
...No current library cache object being loaded
...
</snip-oracert_ora_5340.trc>
I have set the kernel parameters also as per the Oracle 9i installation
guide. And also I tried the same with increasing the shared pool size
but of no help.
Can you please throw some light on this?
Thanks for your help in advance.
Regards,
Sachin
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri Jan 10 04:09:39 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
