Oracle database

From: Youcandoit <databasecreate_at_yahoo.com>
Date: 24 Apr 2005 07:19:03 -0700
Message-ID: <1114352342.991068.125470@g14g2000cwa.googlegroups.com>

crdb1.sql

connect SYS/change_on_install as SYSDBA
set echo on
spool /app/oracle/product/9.0/assistants/dbca/logs/CreateDB.log startup nomount pfile="/app/oracle/admin/eqdev_9i/scripts/init.ora"; CREATE DATABASE eqdev_9i
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
DATAFILE '/ora2/oradata/eqdev_9i/system01.dbf' SIZE 80M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED UNDO TABLESPACE "RBS" DATAFILE '/ora2/oradata/eqdev_9i/rbs01.dbf' SIZE 50M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED CHARACTER SET US7ASCII
NATIONAL CHARACTER SET AL16UTF16

LOGFILE GROUP 3 ('/ora2/oradata/eqdev_9i/redo03.log') SIZE 10M,
GROUP 2 ('/ora2/oradata/eqdev_9i/redo02.log') SIZE 10M,
GROUP 1 ('/ora2/oradata/eqdev_9i/redo01.log') SIZE 10M;

spool off
exit;

crdb2.sql

connect SYS/change_on_install as SYSDBA
set echo on
spool /app/oracle/product/9.0/assistants/dbca/logs/CreateDBFiles.log CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE '/ora2/oradata/eqdev_9i/temp01.dbf' SIZE 20M REUSE AUTOEXTEND OFF NEXT 640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "INDX" LOGGING DATAFILE '/ora2/oradata/eqdev_9i/indx01.dbf' SIZE 15M REUSE AUTOEXTEND OFF NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "USERS" LOGGING DATAFILE '/ora2/oradata/eqdev_9i/users01.dbf' SIZE 15M REUSE AUTOEXTEND OFF NEXT 1280K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
CREATE TABLESPACE "TOOLS" LOGGING DATAFILE '/ora2/oradata/eqdev_9i/tools01.dbf' SIZE 10M REUSE AUTOEXTEND OFF NEXT 320K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL;
spool off

spool /app/oracle/product/9.0/assistants/dbca/logs/CreateDBCatalog.log
@/app/oracle/product/9.0/rdbms/admin/catalog.sql;
@/app/oracle/product/9.0/rdbms/admin/catexp7.sql;
@/app/oracle/product/9.0/rdbms/admin/catblock.sql;
@/app/oracle/product/9.0/rdbms/admin/catproc.sql;
@/app/oracle/product/9.0/rdbms/admin/catoctk.sql;
@/app/oracle/product/9.0/rdbms/admin/catobtk.sql;
@/app/oracle/product/9.0/rdbms/admin/caths.sql;
@/app/oracle/product/9.0/rdbms/admin/owminst.plb;
connect SYSTEM/manager
@/app/oracle/product/9.0/sqlplus/admin/pupbld.sql;
connect SYSTEM/manager
set echo on
spool /app/oracle/product/9.0/assistants/dbca/logs/sqlPlusHelp.log
@/app/oracle/product/9.0/sqlplus/admin/help/hlpbld.sql helpus.sql;
spool off
spool off
exit;

crdb3.sql

connect SYS/change_on_install as SYSDBA
set echo on
spool /app/oracle/product/9.0/assistants/dbca/logs/postDBCreation.log shutdown immediate;
startup pfile="/app/oracle/admin/eqdev_9i/scripts/init.ora"; exit;

rem NEW DB, CREATE PASSWORD FILE FIRST OR REMOVE REMOTE_LOGIN FROM INIT.ORA

rem **************************************************************
rem ########################################

rem ORA-01501: CREATE DATABASE failed
rem ORA-01990: error opening password file '/app/oracle/product/9.0/dbs/orapw'
rem ORA-27037: unable to obtain file status rem SVR4 Error: 2: No such file or directory

#############################################

undo_management=AUTO
db_name=eqdev_9i
db_block_size=4096
instance_name=eqdev_9i
shared_pool_size=52428800
core_dump_dest=/app/oracle/admin/eqdev_9i/cdump open_cursors=300
dispatchers="(PROTOCOL=TCP)"
sort_area_retained_size=524288
java_pool_size=4194304
background_dump_dest=/app/oracle/admin/eqdev_9i/bdump db_domain=fmr

control_files=("/app/oracle/oradata/eqdev_9i/control01.ctl",
"/app/oracle/oradata/eqdev_9i/control02.ctl",
"/app/oracle/oradata/eqdev_9i/control03.ctl")

compatible=9.0.0
resource_manager_plan=SYSTEM_PLAN
processes=150
user_dump_dest=/app/oracle/admin/eqdev_9i/udump sort_area_size=524288
large_pool_size=1048576
timed_statistics=TRUE
db_cache_size=41943040
remote_login_passwordfile=EXCLUSIVE
undo_tablespace=RBS

db_block_checking=true
db_block_checksum=true Received on Sun Apr 24 2005 - 09:19:03 CDT