| Database creation error [message #160208] |
Thu, 23 February 2006 21:50  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
I've problem with database creation.can anyone help me,how to solve the following problem.
The operating system is Windows XP.DBMS is Oracle 9i.
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.
|
|
|
|
|
|
| Re: Database creation error [message #160217 is a reply to message #160208] |
Thu, 23 February 2006 22:38  |
gajini
Messages: 262
Registered: January 2006
|
Senior Member |
|
|
Thanks
Now i found the error & database is created.But while running the script the SQL.BSQ,It's saying ORACLE not available,eventhough the database is in open state & it's asking,
1) Enter the value for LOGGING :
2) Enter the value for LOCKED :
1) Why it's asking values for those paramteters?
2) what is these two parameters?
3) what value i've to give them?
|
|
|
|
| Re: Database creation error [message #160220 is a reply to message #160217] |
Thu, 23 February 2006 22:48 |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
| gajini wrote on Fri, 24 February 2006 10:08 |
ORACLE not available,eventhough the database is in open state
|
Are you sure?
You can never get the error i.e. ORACLE not available if database is created and open.
Check through Sqlplus.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
