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 )
))
　　


　　相关文档：点击打开链接
　　

版权声明：本文为博主原创文章，未经博主允许不得转载。