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;
----------------------------------------------------
创建数据库:
$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;