-
creating database manually
when i pass the following command in the nomount state it gives me an error
SQL> connect sys/sys@db1 as sysdba
Connected to an idle instance.
SQL> startup nomount pfile='e:\oracle\admin\ser\pfile\init.ora'
ORACLE instance started.
Total System Global Area 105672596 bytes
Fixed Size 282516 bytes
Variable Size 71303168 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
SQL> create database ser
2 datafile 'e:\oracle\oradata\ser\system01.dbf' size 100M
3 logfile group 1 ('e:\oracle\oradata\ser\redo01.log') SIZE 5M, GROUP 2 ('E:\oracle\oradata\ser\redo02.log') SIZE 5M;
create database ser
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
please help
thanks
-
What is your OS?. Why don't u create a script and run it?
Where is the Character set?
Last edited by akhadar; 06-21-2003 at 01:17 AM.
-
i have windows 2000 server.the same error occurs even after specifying the character set.
-
Why don't u use the DBA configuration asst. to create the database for U?
-
dbca is always there to create databases but if i were to use omf then i have to create it manually.
-
-
alert.log has not logged anything moreover it will not record since the db is in nomount state and we are creating a new db hence no point in logging in alert.log ( because it will log in which db file if there are more than one db)
-
can u post your init.ora file.
-
##############################################################################
# Copyright (c) 1991, 2001 by Oracle Corporation
##############################################################################
###########################################
# Cache and I/O
###########################################
db_block_size=4096
db_cache_size=31457280
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=E:\oracle\admin\ser\bdump
core_dump_dest=E:\oracle\admin\ser\cdump
timed_statistics=TRUE
user_dump_dest=E:\oracle\admin\ser\udump
###########################################
# Distributed, Replication and Snapshot
###########################################
db_domain=""
remote_login_passwordfile=EXCLUSIVE
###########################################
# File Configuration
###########################################
control_files=("E:\oracle\oradata\ser\control01.ctl", "E:\oracle\oradata\ser\control02.ctl", "E:\oracle\oradata\ser\control03.ctl")
###########################################
# Miscellaneous
###########################################
compatible=9.0.0
db_name=ser
###########################################
# Network Registration
###########################################
instance_name=ser
###########################################
# Pools
###########################################
java_pool_size=20971520
shared_pool_size=37748736
###########################################
# Processes and Sessions
###########################################
processes=150
###########################################
# Redo Log and Recovery
###########################################
fast_start_mttr_target=300
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
sort_area_size=524288
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS
-
comment out the UNDO.once the DB is created u can enable it.
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
|