Linux下手动创建数据库

环境：已经存在一个数据库，且运行正常
其他环境设置和检查如下：
spsuzor01:~ # grep oracle  /etc/passwd
oracle:x:1000:1000::/opt/oracle:/bin/bash
spsuzor01:~ # grep oinstall /etc/group
oinstall:!:1000:
spsuzor01:~ # grep dba /etc/group
dba:!:1001:oracle
spsuzor01:~ # su - oracle
oracle@spsuzor01:~> echo $SHELL
/bin/bash
oracle@spsuzor01:~> ORACLE_SID=spsuzdb2
oracle@spsuzor01:~> export ORACLE_SID
oracle@spsuzor01:~>
oracle@spsuzor01:~> ORACLE_HOME=/opt/oracle/product/10.2.0/db_1
oracle@spsuzor01:~> export ORACLE_HOME
oracle@spsuzor01:~>
oracle@spsuzor01:~> ORACLE_BASE=/opt/oracle
oracle@spsuzor01:~> export ORACLE_BASE
oracle@spsuzor01:~>
create the pfile into the location /opt/oracle/product/10.2.0/db_1/dbs/initspsuzdb2.ora

put the spsuzdb2_manually.sql into /opt/oracle

please create all the folder and files under user oracle

/data/oradata/SPSUZDB2/onlinelog/
/opt/oracle/flash_recovery_area/SPSUZDB2/onlinelog
/data/oradata/SPSUZDB2/datafile/
/data/oradata/SPSUZDB2/controlfile/
/opt/oracle/flash_recovery_area/SPSUZDB2/controlfile

Do as below
oracle@spsuzor01:~>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Jul 20 15:27:04 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.

Total System Global Area 1258291200 bytes
Fixed Size                  1267236 bytes
Variable Size             318769628 bytes
Database Buffers          922746880 bytes
Redo Buffers               15507456 bytes
SQL> @/opt/oracle/spsuzdb2_manually.sql

Database created.

SQL>@?/rdbms/admin/catalog.sql
SQL>@?/rdbms/admin/catproc.sql
SQL>@?/sqlplus/admin/pupbld.sql
SQL> create spfile from pfile;

File created.
    
SQL>shutdown
SQL>startup
SQL>@/opt/oracle/DBinit/sp_init.sql
change below files
oracle@spsuzor01:~/product/10.2.0/db_1/network/admin> ls
listener.ora  samples  shrept.lst  tnsnames.ora
-- change the listener.ora and tnsnames.ora to add spsuzdb2 instance
spsuzor01:~ # ls -l /etc/oratab
-rw-rw-r--  1 oracle root 764 Jul 20 17:45 /etc/oratab
spsuzor01:~ #