在linux服务器新建Oracle database

su -l oracle [重要](使用Oracle用户的环境变量)

----------------------------------------------------

创建数据库:

$ORACLE_HOME/product/10.2.0/db_1/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName hadb.archives -sid hadb -sysPassword capinfo -continueOnNonFatalErrors false

遇到要设置DISPLAY环境变量的时候,重启Linux服务器

----------------------------------------------------

启动listener:

$ORACLE_HOME/product/10.2.0/db_1/bin/lsnrctl start

----------------------------------------------------

创建表空间
SQL> sqlplus /nolog
SQL> conn sys/capinfo@hadb_archives as sysdba
SQL> create tablespace 'archives' logging datafile '/data/oracle/product/10.2.0/db_1/oradata/hadb/archives.dbf' size 100m autoextend on next 100m maxsize unlimited extent management local;

-----------------------------------------------------

创建用户

SQL> create user archives identified by capinfo default tablespace archives temporary tablespace temp;
SQL> grant connect,resource to archives;
SQL> commit;