OCM实验-手工建库

startup nomount; --先确保参数文件有效

CREATE DATABASE orcl
USER SYS IDENTIFIED BY sys
USER SYSTEM IDENTIFIED BY system
LOGFILE GROUP 1 ('/u01/redo_logs/redo01a.log','/u01/redo_logs/redo01b.log') SIZE 100M BLOCKSIZE 512,
GROUP 2 ('/u01/redo_logs/redo02a.log','/u01/redo_logs/redo02b.log') SIZE 100M BLOCKSIZE 512,
GROUP 3 ('/u01/redo_logs/redo03a.log','/u01/redo_logs/redo03b.log') SIZE 100M BLOCKSIZE 512
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
EXTENT MANAGEMENT LOCAL
DATAFILE '/home/oracle/oradata/system01.dbf' SIZE 325M REUSE
SYSAUX DATAFILE '/home/oracle/oradata/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TABLESPACE users
DATAFILE '/home/oracle/oradata/users01.dbf'
SIZE 10M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/home/oracle/oradata/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs1
DATAFILE '/home/oracle/oradata/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

SQL> show parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      ORCL

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

In SQL*Plus, connect to your Oracle Database instance as SYSTEM user:

@?/sqlplus/admin/pupbld.sql

--配置连接字符串
vict =
 (DESCRIPTION =
    (ADDRESS =
    (PROTOCOL = TCP)(HOST = 192.168.180.128 )(PORT = 1521))
 (CONNECT_DATA =
    (SERVICE_NAME = ORCL )
  ))

相关文档：点击打开链接