Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Closed TopicStart new topic
> ORA-01092: ORACLE instance terminated. Disconnection forced.
Munchun Singh
post Mar 29 2012, 01:42 PM
Post #1


Newbie
*

Group: Members
Posts: 5
Joined: 5-March 12
Member No.: 46,875



Hi,

I create a manual database "jaimaa" on windows 7 as

Microsoft Windows [Version 6.1.7600]
Copyright © 2009 Microsoft Corporation. All rights reserved.

C:\Users\SARASWATIMAA>SET ORACLE_SID=JAIMAA

C:\Users\SARASWATIMAA>SQLPLUS

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 29 23:19:31 2012

Copyright © 1982, 2005, Oracle. All rights reserved.

Enter user-name: SYS AS SYSDBA
Enter password:
Connected to an idle instance.

SQL>
SQL> STARTUP NOMOUNT
ORACLE instance started.

Total System Global Area 117440512 bytes
Fixed Size 1247588 bytes
Variable Size 58721948 bytes
Database Buffers 50331648 bytes
Redo Buffers 7139328 bytes
SQL>
SQL>
SQL> SELECT NAME FROM V$DATABASE;
SELECT NAME FROM V$DATABASE
*
ERROR at line 1:
ORA-01507: database not mounted


SQL> ED
Wrote file afiedt.buf

1 CREATE DATABASE JAIMAA
2 LOGFILE
3 GROUP 1('C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_A1.LOG' , 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_A2.LOG'
) SIZE 240M,
4 GROUP 2('C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_B1.LOG' , 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_B2.LOG'
) SIZE 240M,
5 GROUP 3('C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_C1.LOG' , 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_C2.LOG'
) SIZE 240M
6 DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\SYSTEM_A1.DBF' SIZE 320M
7 SYSAUX DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\SYSAUX_A1.DBF' SIZE 320M
8* DEFAULT TEMPORARY TABLESPACE TEMP_TABLESPACE TEMPFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\TEMP_TABLESPACE.TEMP
' SIZE 240M
SQL> /
CREATE DATABASE JAIMAA
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


SQL>

------ And I check alert log ALERT_JAIMAA as per below------------


Thu Mar 29 23:19:47 2012
Adjusting the default value of parameter parallel_max_servers
from 40 to 25 due to the value of parameter processes (40)
Thu Mar 29 23:19:47 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as C:\oracle\product\10.2.0\db_2\RDBMS
Autotune of undo retention is turned off.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
control_files = C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\CONTROL_A1, C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\CONTROL_A2, C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\CONTROL_A3
db_block_size = 8192
compatible = 10.2.0.1.0
instance_name = JAIMAA
audit_file_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JAIMAA\ADUMP
background_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JAIMAA\BDUMP
user_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JAIMAA\UDUMP
core_dump_dest = C:\ORACLE\PRODUCT\10.2.0\ADMIN\JAIMAA\CDUMP
db_name = JAIMAA
PMON started with pid=2, OS id=3800
PSP0 started with pid=3, OS id=472
MMAN started with pid=4, OS id=556
DBW0 started with pid=5, OS id=4016
LGWR started with pid=6, OS id=2280
CKPT started with pid=7, OS id=1244
SMON started with pid=8, OS id=2856
RECO started with pid=9, OS id=3904
MMON started with pid=10, OS id=960
MMNL started with pid=11, OS id=848
Thu Mar 29 23:20:48 2012
CREATE DATABASE JAIMAA
LOGFILE
GROUP 1('C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_A1.LOG' , 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_A2.LOG') SIZE 240M,
GROUP 2('C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_B1.LOG' , 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_B2.LOG') SIZE 240M,
GROUP 3('C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_C1.LOG' , 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_C2.LOG') SIZE 240M
DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\SYSTEM_A1.DBF' SIZE 320M
SYSAUX DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\SYSAUX_A1.DBF' SIZE 320M
DEFAULT TEMPORARY TABLESPACE TEMP_TABLESPACE TEMPFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\TEMP_TABLESPACE.TEMP' SIZE 240M
Thu Mar 29 23:20:49 2012
Database mounted in Exclusive Mode
Thu Mar 29 23:21:04 2012
Successful mount of redo thread 1, with mount id 3703500432
Assigning activation ID 3703500432 (0xdcbeee90)
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_A1.LOG
Current log# 1 seq# 1 mem# 1: C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_A2.LOG
Successful open of redo thread 1
Thu Mar 29 23:21:04 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Mar 29 23:21:04 2012
SMON: enabling cache recovery
Thu Mar 29 23:21:04 2012
create tablespace SYSTEM datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\SYSTEM_A1.DBF' SIZE 320M

default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online

Thu Mar 29 23:21:07 2012
Completed: create tablespace SYSTEM datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\SYSTEM_A1.DBF' SIZE 320M
default storage (initial 10K next 10K) EXTENT MANAGEMENT DICTIONARY online
Thu Mar 29 23:21:07 2012
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)

Completed: create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Thu Mar 29 23:21:08 2012
Errors in file c:\oracle\product\10.2.0\admin\jaimaa\udump\jaimaa_ora_1100.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 2208 bytes of shared memory ("shared pool","unknown object","KGLS heap","KGLS MEM BLOCK")

Thu Mar 29 23:21:08 2012
Errors in file c:\oracle\product\10.2.0\admin\jaimaa\udump\jaimaa_ora_1100.trc:
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '%ORACLE_HOME%\RDBMS\ADMIN\SQL.BSQ' near line 1212
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 2208 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
Thu Mar 29 23:21:08 2012
Errors in file c:\oracle\product\10.2.0\admin\jaimaa\bdump\jaimaa_pmon_3800.trc:
ORA-01519: error while processing file '' near line

Thu Mar 29 23:21:08 2012
Errors in file c:\oracle\product\10.2.0\admin\jaimaa\bdump\jaimaa_reco_3904.trc:
ORA-01519: error while processing file '' near line

Thu Mar 29 23:21:08 2012
Errors in file c:\oracle\product\10.2.0\admin\jaimaa\bdump\jaimaa_smon_2856.trc:
ORA-01519: error while processing file '' near line

Thu Mar 29 23:21:08 2012
Errors in file c:\oracle\product\10.2.0\admin\jaimaa\bdump\jaimaa_ckpt_1244.trc:
ORA-01519: error while processing file '' near line

Thu Mar 29 23:21:08 2012
Errors in file c:\oracle\product\10.2.0\admin\jaimaa\bdump\jaimaa_psp0_472.trc:
ORA-01519: error while processing file '' near line

Thu Mar 29 23:21:08 2012
Errors in file c:\oracle\product\10.2.0\admin\jaimaa\bdump\jaimaa_lgwr_2280.trc:
ORA-01519: error while processing file '' near line

Thu Mar 29 23:21:08 2012
Errors in file c:\oracle\product\10.2.0\admin\jaimaa\bdump\jaimaa_mman_556.trc:
ORA-01519: error while processing file '' near line

Thu Mar 29 23:21:08 2012
Errors in file c:\oracle\product\10.2.0\admin\jaimaa\bdump\jaimaa_dbw0_4016.trc:
ORA-01519: error while processing file '' near line

Instance terminated by USER, pid = 1100
ORA-1092 signalled during: CREATE DATABASE JAIMAA
LOGFILE
GROUP 1('C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_A1.LOG' , 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_A2.LOG') SIZE 240M,
GROUP 2('C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_B1.LOG' , 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_B2.LOG') SIZE 240M,
GROUP 3('C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_C1.LOG' , 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\LOG_C2.LOG') SIZE 240M
DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\SYSTEM_A1.DBF' SIZE 320M
SYSAUX DATAFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\SYSAUX_A1.DBF' SIZE 320M
DEFAULT TEMPORARY TABLESPACE TEMP_TABLESPACE TEMPFILE 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\JAIMAA\TEMP_TABLESPACE.TEMP' SIZE 240M...

I have to also attach INITJAIMAA.txt initislization parameter
but we get an error as

ORA-01092: ORACLE instance terminated. Disconnection forced.
Attached File(s)
Attached File  INITJAIMAA.TXT ( 816bytes ) Number of downloads: 1
Attached File  INITJAIMAA.TXT ( 816bytes ) Number of downloads: 0
 
Go to the top of the page
 
+Quote Post
burleson
post Mar 29 2012, 04:36 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,333
Joined: 26-January 04
Member No.: 13



Please read:

http://www.dba-oracle.com/t_ora_01092_orac..._terminated.htm


Errors in file c:\oracle\product\10.2.0\admin\jaimaa\bdump\jaimaa_dbw0_4016.trc:


**********************************

>> ORA-04031: unable to allocate 2208 bytes of shared memory


You do not have enough RAM on this server to support your pool sizes.


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 30th July 2014 - 02:12 PM