The second possibility is to create database manually.
1. Create a init.ora for the new database in the $ORACLE_HOME/dbs directory.
Here, the minimal init.ora, I have used to start the database:
db_name=ocm11g
db_block_size=8192
undo_management=auto
undo_tablespace=undotbs
diagnostic_dest='/oracle/admin'
db_cache_size=80M
shared_pool_size=100M
java_pool_size=25M
2. Now, you can start the instance.
sqlplus "/as sysdba"
startup nomount;
3. When the instance is started, you can create the database:
sqlplus "/as sysdba"
create database ocm11g
user sys identified by ********
user system identified by ***********
maxlogfiles 3
maxlogmembers 3
maxdatafiles 20
character set al32utf8
logfile group 1 ('/oracle/oradata/redo1_1.log','/oracle/oradata/redo1_2.log') size 50M blocksize 512,
group 2 ('/oracle/oradata/redo2_1.log','/oracle/oradata/redo2_2.log') size 50M blocksize 512,
group 3 ('/oracle/oradata/redo3_1.log','/oracle/oradata/redo3_2.log') size 50M blocksize 512
datafile '/oracle/oradata/system.dbf' size 500M extent management local
sysaux datafile '/oracle/oradata/sysaux.dbf' size 500M
undo tablespace undotbs datafile '/oracle/oradata/undotbs.dbf' size 200M
default temporary tablespace temp tempfile '/oracle/oradata/temp.dbf' size 200M uniform size 1M;
If all the paths are OK, the new database will be created and opened.
4. Now, you have to run some sql scripts to create a catalog an procedures:
sqlplus "/as sysdba"
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
sqlplus system/***********
@?/sqlplus/admin/pupbld.sql
5. Now restart the database and create a default tablespace for users:
sqlplus "/as sysdba"
shu immediate
startup
create tablespace user s datafile '/oracle/oradata/users.dbf' size 20M;
alter database default tablespace users;
The database is in noarchivelog mode, so you can change it when needed.
Here, the minimal init.ora, I have used to start the database:
db_name=ocm11g
db_block_size=8192
undo_management=auto
undo_tablespace=undotbs
diagnostic_dest='/oracle/admin'
db_cache_size=80M
shared_pool_size=100M
java_pool_size=25M
2. Now, you can start the instance.
sqlplus "/as sysdba"
startup nomount;
3. When the instance is started, you can create the database:
sqlplus "/as sysdba"
create database ocm11g
user sys identified by ********
user system identified by ***********
maxlogfiles 3
maxlogmembers 3
maxdatafiles 20
character set al32utf8
logfile group 1 ('/oracle/oradata/redo1_1.log','/oracle/oradata/redo1_2.log') size 50M blocksize 512,
group 2 ('/oracle/oradata/redo2_1.log','/oracle/oradata/redo2_2.log') size 50M blocksize 512,
group 3 ('/oracle/oradata/redo3_1.log','/oracle/oradata/redo3_2.log') size 50M blocksize 512
datafile '/oracle/oradata/system.dbf' size 500M extent management local
sysaux datafile '/oracle/oradata/sysaux.dbf' size 500M
undo tablespace undotbs datafile '/oracle/oradata/undotbs.dbf' size 200M
default temporary tablespace temp tempfile '/oracle/oradata/temp.dbf' size 200M uniform size 1M;
If all the paths are OK, the new database will be created and opened.
4. Now, you have to run some sql scripts to create a catalog an procedures:
sqlplus "/as sysdba"
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
sqlplus system/***********
@?/sqlplus/admin/pupbld.sql
5. Now restart the database and create a default tablespace for users:
sqlplus "/as sysdba"
shu immediate
startup
create tablespace user s datafile '/oracle/oradata/users.dbf' size 20M;
alter database default tablespace users;
The database is in noarchivelog mode, so you can change it when needed.