how to create database manually?sample script:
which method is suggestable for database creation (dbca/manual creation)?Manual creation is the best one.
May it help you
sample script: CREATE DATABASE "testdb" MAXLOGFILES 72 MAXLOGMEMBERS 2 MAXDATAFILES 120 MAXINSTANCES 1 CHARACTER SET "US7ASCII" NATIONAL CHARACTER SET "AL16UTF16" DATAFILE '/u01/app/oradatatestdb/testdb_system01.dbf' SIZE 500M REUSE EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE '/u01/app/oradatatestdb/testdb_sysaux01.dbf' SIZE 500M REUSE UNDO TABLESPACE UNDOTBS1 datafile '/u01/app/oradatatestdb/testdb_undotbs01.dbf' size 100M DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/app/oradatatestdb/testdb_temp01a.dbf' size 100M LOGFILE GROUP 1 ('/u01/app/oradatatestdb/testdb_redo101.log', '/u01/app/oradatatestdb/testdb_redo102.log') SIZE 50M, GROUP 2 ('/u01/app/oradatatestdb/testdb_redo201.log', '/u01/app/oradatatestdb/testdb_redo202.log') SIZE 50M; run some sql file connect / as sysdba @$ORACLE_HOME/rdbms/admin/catalog.sql @$ORACLE_HOME/rdbms/admin/catproc.sql @$ORACLE_HOME/rdbms/admin/dbmspool.sql @$ORACLE_HOME/rdbms/admin/catexp.sql @$ORACLE_HOME/rdbms/admin/catblock.sql @$ORACLE_HOME/sqlplus/admin/plustrce.sql
N Gasparotto wrote:Well, yes and no.
One of the "problem" I can see with dbca is that you have to apply on the database the PSU/CPU that you previously applied onto the ORACLE_HOME. It's not the case with manual db creation.
These instructions are for a database that is created or upgraded after the installation of this SPU patch.You must execute the steps in Section 126.96.36.199, "Loading Modified SQL Files into the Database" for any new database only if it was created by any of the following methods: