oracle 9i 手工建库,Oracle 9i数据库手工建库过程简记

7.创建users表空间

create tablespace users

datafile '$Oracle_HOME/oradata/user01.dbf'  size 600m

autoextend on next 1024k maxsize unlimited

extent management local uniform size 500K;

create user test identified by test;

great dba,connect to test;

8.创建默认spfile和pfile

create spfile from pfile='/home/oracle/yd.ora';

create pfile from spfile;

9.创建网络监听

cd $ORACLE_HOME/network/admin

cat listener.ora

在listener.ora中增加以下语句

( sid_desc=

(global_dbname=dcmsuat)

(oracle_home=/u01/app/oracle/product/9.2.0)

(sid_name=dcmsuat)

)

cat tnsnames.ora

dcmsuat=

( description=

(address_list=

(address=(protocol=tcp)(host=103.160.128.29)(port=1521))

)

(connect_data=

(server=dedicated)

(service_name=dcmsuat)

)

)

10.测试数据库(略)