-
DB creation error
I've problem with database creation.can anyone help me,how to solve the following problem.
When i give
>STARTUP NOMOUNT pfile='c:\newdb\init.ora'
ORACLE instance started.
Total System Global Area 122755896 bytes
Fixed Size 453432 bytes
Variable Size 96468992 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
INIT.ORA File contents
db_block_size=8192 #8KB
db_cache_size=25165824 #24M
open_cursors=100
db_name=NEWDB
background_dump_dest=C:\oracle\admin\NEWDB\bdump
core_dump_dest=C:\oracle\admin\NEWDB\cdump
timed_statistics=TRUE
user_dump_dest=C:\oracle\admin\NEWDB\udump
control_files=("C:\oracle\oradata\NEWDB\CONTROL01.CTL", "C:\oracle\oradata\NEWDB\CONTROL02.CTL", "C:\oracle\oradata\NEWDB\CONTROL03.CTL")
instance_name=NEWDB
hash_join_enabled=TRUE
java_pool_size=25165824
large_pool_size=25165824
shared_pool_size=31457280 # 30M
processes=25
fast_start_mttr_target=300
remote_login_passwordfile=EXCLUSIVE
pga_aggregate_target=25165824
sort_area_size=524288 #512K
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDO
But when i run the create database script it gives the followin error,
SQL> create database NEWDB
2 controlfile reuse
3 logfile
4 GROUP 1 ( 'C:\oracle\oradata\newdb\log1a.rdo') SIZE 5M reuse,
5 GROUP 2 ( 'C:\oracle\oradata\newdb\log2a.rdo') SIZE 5M reuse,
6 GROUP 3 ( 'C:\oracle\oradata\newdb\log3a.rdo') SIZE 5M reuse
7 datafile 'C:\oracle\oradata\newdb\data01.dbf' SIZE 20M reuse
8 undo tablespace UNDO
9 datafile 'C:\oracle\oradata\newdb\undo01.dbf' SIZE 15M reuse
10 default temporary tablespace TEMP
11 tempfile 'C:\oracle\oradata\newdb\temp01.dbf ' SIZE 10M reuse
12 extent management local uniform size 64k
13 ;
create database NEWDB
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Why the ORACLE instance get terminated and Disconnection forced.Is there any problem with the parameter settings?
Please help me to get out of this problem.
-
Check Alert.log
Have you checked the alert.log file to have more detailed error message?
-
The alert log being C:\oracle\admin\NEWDB\bdump\alert_NEWDB.log
-
DB creation error
Thanks for all.I checked the Alert.Log & found out the error & the database is successfully created.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|