| Creating new database manually...! [message #135284] |
Tue, 30 August 2005 15:26  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai ,
here we are using a 9i database under Windows NT.we need to create one more database manually using the script as follows.
---------------------------
create database "test"
datafile 'd:\oracle\oradata\system01.dbf'
size 10M reuse
maxdatafiles 254
maxinstances 8
maxlogfiles 32
logfile
Group1 ('d:\oracle\oradata\redo1.log') size 1M,
Group2 ('d:\oracle\oradata\redo2.log') size 1M,
Group3 ('d:\oracle\oradata\redo3.log') size 1M,
undo tablespace undotbs
datafile 'd:\oracle\oradata\undo.dbf' size 1M
default temporary tablespace temp tempfile
'd:\oracle\oradata\temp.dbf' size 1M
character set US7ASCII
national character set AL16UTF16
set time_zone='Asia\Calcutta';
------------------------------------
this is the script i used to create a new database manually.
steps i did.
1.shutdown the running database.
2.connect / as sysdba
3.startup nomount pfile='path'
4.executed the script.
finally ora-01092 is thrown i.e oracle instance terminated -disconnection forced.
where i am stuck.
eventhough we are having the DBCA , i want to know how to be created manually.plz help out.
regards
bala
|
|
|
|
|
|
| Re: Creating new database manually...! [message #135434 is a reply to message #135290] |
Wed, 31 August 2005 09:53  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
this is the pfile i used.
-------------------------
db_name = test
instance_name = test
service_names = test
db_files = 1024
control_files = ("d:/oracle/oradata/control01.ctl", "d:/oracle/oradata/control02.ctl", "d:/oracle/oradata/control03.ctl")
open_cursors = 1500
max_enabled_roles = 30
db_file_multiblock_read_count = 8
db_block_buffers = 1000
shared_pool_size = 1286400
large_pool_size = 6400
java_pool_size =1286400
#added 03/19/01
java_soft_sessionspace_limit = 201520
log_checkpoint_interval = 100000
log_checkpoint_timeout = 180000
processes = 1500
#parallel_max_servers = 5
log_buffer = 3280
#audit_trail = true # if you want auditing
#timed_statistics = true # if you want timed statistics
max_dump_file_size = 1240 # limit trace file size to 5M each
# Uncommenting the line below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true log_archive_dest_1 =
# "location=C:\mnt\ora_system\oracle\oradata\tcms\archive"
# log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
log_archive_start = true
log_archive_dest =d:/oracle/oradata/test/
log_archive_format = "test_%s_%t.ARC"
# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
#rollback_segments = ( Rbs1, RBS2,RBS3,RBS4,RBS5,RBS6)
# Global Naming -- enforce that a dblink has same name as the db it connects to
global_names = true
# Uncomment the following line if you wish to enable the Oracle Trace product
# to trace server activity. This enables scheduling of server collections
# from the Oracle Enterprise Manager Console.
# Also, if the oracle_trace_collection_name parameter is non-null,
# every session will write to the named collection, as well as enabling you
# to schedule future collections from the console.
# oracle_trace_enable = true
oracle_trace_collection_name = ""
# define directories to store trace and alert files
background_dump_dest = d:/oracle/admin/test/bdump
#Uncomment this parameter to enable resource management for your database.
#The SYSTEM_PLAN is provided by default with the database.
#Change the plan name if you have created your own resource plan.# resource_manager_plan = system_plan
user_dump_dest = d:/oracle/admin/test/udump
core_dump_dest = d:/oracle/admin/test/cdump
db_block_size = 8192
remote_login_passwordfile = exclusive
#remote_login_passwordfile =none
os_authent_prefix = ""
#distributed_transactions = 10
#mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
# Uncomment the following line when your listener is configured for SSL
# (listener.ora and sqlnet.ora)
# mts_dispatchers = "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"
compatible = 8.1.7
sort_area_size = 262144
sort_area_retained_size = 262144
#added 04/30/02
job_queue_processes = 5
#ADDED ON 01/25/02 ON ORACLE SUPPORT REQUEST:
#event="10061 trace name context forever, level 10"
#added 05/14/02
utl_file_dir= d:/oracle/admin/test/bdump
O7_DICTIONARY_ACCESSIBILITY=TRUE
# Added on 6/27/2003 by Raj for Spotlight.
#for upgrade
#optimizer_mode=choose
-----------------------------
the error in alert_log is ora-01092-oracle instance terminated.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
)