Here is the create.sql file
create database michdev2
character set "WE8ISO8859P1"
NATIONAL CHARACTER SET AL16UTF16
size 250M reuse autoextend on next 10240K maxsize unlimited
extent management local
DEFAULT TEMPORARY TABLESPACE TEMP
size 100M autoextend on next 20M MAXSIZE UNLIMITED
UNDO TABLESPACE UNDO_TS
SIZE 200M reuse autoextend on next 5120K maxsize unlimited
GROUP 1 ('/u01/oradata/michdev2/michdev2_redo1a.dbf',
GROUP 2 ('/u02/oradata/michdev2/michdev2_redo2a.dbf',
GROUP 3 ('/u03/oradata/michdev2/michdev2_redo3a.dbf',
GROUP 4 ('/u04/oradata/michdev2/michdev2_redo4a.dbf',
First i would like to know on which platform u r creating ur oracle database. I could see that u r having oracle db 9.2. (R-2). The platform is necessary for me to know.
I also faced the same issue & i was creating it on SUN Solaris (SPARC) 5.8 OS. We faced exactly the same issue..and it was issue of a database parameter i.e. my INIT.ORA. We were using pfile for creating database.
Just for ur reference, the culprit parameter was RESOURCE_MANAGER_PLAN=SYSTEM_PLAN. It was having some conflict with OS resource manager.
The parameter will not be supported thru. pfile. For that you have to create your database by using spfile and then you can alter your database for this parameter. That is, you may then set this parameter with appropriate scope.
Hope, it helps you. In case anything more is needed, pls. do let me know.
#new in 9i pga_aggregate_target set size and workarea_size_policy
workarea_size_policy = auto
pga_aggregate_target = 100M
log_checkpoint_interval = 10000
log_checkpoint_timeout = 0
processes = 100
open_cursors = 500
# new 9i cursor_sharing (similar, force, exact) how much alike do the cursors ha
ve to be to share?
cursor_sharing = similar
# THis is for the auto on the UNDO with 9i
undo_management = auto
undo_tablespace = (undo_tbs0, undo_tbs1, undo_tbs2)
undo_retention = 500
# default undo_retention is 900
#undo_supress_errors = True
db_file_multiblock_read_count = 8
parallel_max_servers = 5
#dml_locks = 200
audit_trail = False
#timed_statistics = False
#new in 9i statistic_level (ready, off, or on)
#statistic_level = ready
#Uncommenting the line below will cause automatic archiving
#if archiving has been enabled using
#ALTER DATABASE ARCHIVELOG;
#If using public rollback segments, define how many rollback segments each insta
nce will pick up
#using the formula, number of rollback segments = transactions/ transactions_per
#In this example each instance will grab 40/5 = 8;
# transactions = 40
# transactions_per_rollback_segment = 5
#Uncomment the following line if you wish to enable the Oracle Trace product
#to trace server activity. This enables scheduling of server collections
#from 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
#The following parameters are needed for the Advanced
# job_queue_processes = 2
# job_queue_interval = 10
# open_links = 4
#The PLSQL_V2_COMPATIBILITY is by default set to true,
#must set this to false to run the $ORACLE_HOME/dbms/admin/utlip.sql package
# which includes STANDARD and DBMS_STANDARD. IF these pkgs do not
# run, then PL/sQl statements do not run.
#Parameter added by Data Migration Assistant
compatible = 8.1.6
db_domain = world
query_rewrite_enabled = true