Re: Oracle database

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 24 Apr 2005 16:44:20 +0200
Message-ID: <8sbn615eq48beu0q1dmt83pl4o70r19g44@4ax.com>

On 24 Apr 2005 07:19:03 -0700, "Youcandoit" <databasecreate_at_yahoo.com> wrote:

comments added embedded by the Oracle comments signs

>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 -- pretty small. Bump it to 200M
>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 -- why on earth a 7-bit characterset? Should be WE8ISO8859P15 on *Nix and WE8MSWIN1252 on Winblows
>NATIONAL CHARACTER SET AL16UTF16
>LOGFILE GROUP 3 ('/ora2/oradata/eqdev_9i/redo03.log') SIZE 10M, -- everything on 1 file system, and non-multiplexed. You will get performance issues and what if your filesystems blows?
>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

• THE ENVIRONMENT VARIABLE ORACLE_SID HAS NOT BEEN SET
• THIS IS WHY YOUR CREATE DATABASE FAILS, as it CAN"T FIND THE PASSWORD FILE

>#############################################
>
>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

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Apr 24 2005 - 09:44:20 CDT