SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-24-2008, 12:53 PM
| ||||
| ||||
 Oracle database 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      |
|
02-24-2008, 12:53 PM
| |||
| |||
| Re: Oracle database "Youcandoit" <databasecreate@yahoo.com> wrote in message news:1114352342.991068.125470@g14g2000cwa.googlegr oups.com... > crdb1.sql > > 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 > ############################################# did you create a password file? |
|
02-24-2008, 12:53 PM
| ||||
| ||||
| Re: Oracle database On 24 Apr 2005 07:19:03 -0700, "Youcandoit" <databasecreate@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 |
Linear Mode
