日期:2014-05-16 浏览次数:20523 次
案例:
think =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS=(PROTOCOL = tcp)(HOST= 192.168.227.128)(PORT= 1521)
)
)
)
SID_LIST_think =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl.oracle.com)
(SID_NAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)))orcl =
(DESCRIPTION =
(ADDRESS=(PROTOCOL= tcp)(HOST= 192.168.227.128)(PORT= 1521))
(CONNECT_DATA=(SERVICE_NAME= orcl.oracle.com))
)
CREATE DATABASE orcl
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/u01/app/oracle/oradata/orcl/redo01.log') SIZE 100M,
GROUP 2 ('/u01/app/oracle/oradata/orcl/redo02.log') SIZE 100M,
GROUP 3 ('/u01/app/oracle/oradata/orcl/redo03.log') SIZE 100M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/app/oracle/oradata/orcl/system01.dbf' SIZE 600M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/app/oracle/oradata/orcl/sysaux01.dbf' SIZE 450M REUSE
DEFAULT TABLESPACE users
DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf' size 50M REUSE
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '/u01/app/oracle/oradata/orcl/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/u01/app/oracle/oradata/orcl/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;[oracle@localhost admin]$ pwd
/u01/app/oracle/admin
[oracle@localhost admin]$ mkdir -p orcl/{a,b,c,u,dp}dump
[oracle@localhost flash_recovery_area]$ pwd
/u01/app/oracle/flash_recovery_area
[oracle@localhost admin]$ mkdir ORCL
[oracle@localhost dbs]$ pwd
/u01/app/oracle/product/10.2.0/db_1/dbs
[oracle@localhost dbs]$ ls
alert_orcl.log hc_orcl.dat hc_think.dat initdw.ora init.ora snapcf_orcl.f[oracle@localhost dbs]$ orapwd file=orapworcl password=oracle entries=5