linux的Oracle安装以及配置 续

 

启动listener程序

$ Lsnrctl start

1.5    创建数据库

没有特别说明,系统操作用户均为oracle

su - oracle

1.    使用sqlplus建立数据库

sqlplus / as sysdba

sql> startup nomount

sql>@crt_dbs.sql

crt_dbs.sql文件内容如下

-- create dbs

CREATE DATABASE VoIP2G

LOGFILE

GROUP 1 '/u01/oracle/oradata/VoIP2G/redo01.log' SIZE 300M,

GROUP 2 '/u01/oracle/oradata/VoIP2G/redo02.log' SIZE 300M,

GROUP 3 '/u01/oracle/oradata/VoIP2G/redo03.log' SIZE 300M

DATAFILE '/u01/oracle/oradata/VoIP2G/system01.dbf' SIZE 800M AUTOEXTEND ON NEXT 5M

DEFAULT TEMPORARY TABLESPACE tmp TEMPFILE '/u01/oracle/oradata/VoIP2G/tmp01.dbf' SIZE 2048M AUTOEXTEND OFF

UNDO TABLESPACE undotbs1 DATAFILE '/u01/oracle/oradata/VoIP2G/undo01.dbf' SIZE 2048M AUTOEXTEND OFF

    CONTROLFILE REUSE

    NOARCHIVELOG

    MAXLOGFILES 64

    MAXLOGMEMBERS 5

    MAXDATAFILES 512

    MAXINSTANCES 8

    MAXLOGHISTORY 7260

CHARACTER SET ZHS16CGB231280;

-- create tbs

create tablespace VOIP2G_CDR

LOGGING

DATAFILE '/u01/oracle/oradata/VoIP2G/voip2g_cdr01.dbf' SIZE 4096M

EXTENT MANAGEMENT LOCAL UNIFORM

SEGMENT SPACE MANAGEMENT AUTO

online;

create tablespace VOIP2G_STAT

LOGGING

DATAFILE '/u01/oracle/oradata/VoIP2G/voip2g_stat01.dbf' SIZE 4096M

EXTENT MANAGEMENT LOCAL UNIFORM

SEGMENT SPACE MANAGEMENT AUTO

online;

create tablespace VOIP2G_INDEX

LOGGING

DATAFILE '/u01/oracle/oradata/VoIP2G/voip2g_index01.dbf' SIZE 4096M

EXTENT MANAGEMENT LOCAL UNIFORM

SEGMENT SPACE MANAGEMENT AUTO

online;

create tablespace VOIP2G_DATA

LOGGING

DATAFILE '/u01/oracle/oradata/VoIP2G/voip2g_data01.dbf' SIZE 4096M

EXTENT MANAGEMENT LOCAL UNIFORM

SEGMENT SPACE MANAGEMENT AUTO

online;

create temporary tablespace VOIP2G_TEMP

TEMPFILE '/u01/oracle/oradata/VoIP2G/voip2g_temp01.dbf' SIZE 4096M

EXTENT MANAGEMENT LOCAL UNIFORM

online;

2. 创建系统存储过程

@?/rdbms/admin/catalog.sql

@?/rdbms/admin/catproc.sql

connect system/manager

@?/sqlplus/admin/pupbld.sql

3. 切换数据库到archive模式

sqlplus / as sysdba

Sql> shutdown immediate

startup mount

alter database archivelog;

archive log start

alter database open;

archive log list;