ORACLE手工建库

oracle 手工建库

第一步: 创建目录,赋予权限 oinstall组

手工建库的权限一般    755

1建立instance-------------控制文件

 2password file

 3nomount-----&gtcreate database

 

 

cd $ORACLE_HOME/dbs

Cd $ORACLE_BASE

Orapwdbtomato 口令文件

重新建立口令文件：

Orapwd 

 

建立存储路径

[oracle@host2.yisi.net: /u01/app/oracle/product/10.2.0/db_1/dbs]$ mkdir -p /u01/app/oracle/oradata/dbtomato/disk1

[oracle@host2.yisi.net: /u01/app/oracle/product/10.2.0/db_1/dbs]$ mkdir -p /u01/app/oracle/oradata/dbtomato/disk2

[oracle@host2.yisi.net: /u01/app/oracle/product/10.2.0/db_1/dbs]$ mkdir -p /u01/app/oracle/oradata/dbtomato/disk3

[oracle@host2.yisi.net: /u01/app/oracle/product/10.2.0/db_1/dbs]$ mkdir -p /u01/app/oracle/oradata/dbtomato/disk4

[oracle@host2.yisi.net: /u01/app/oracle/product/10.2.0/db_1/dbs]$ mkdir -p /u01/app/oracle/oradata/dbtomato/disk5

 

Initdbatomato.ora

db_name='dbtomato'

memory_target=400m

processes = 150

audit_file_dest='$ORACLE_BASE/admin/dbtomato/adump'

audit_trail ='db'

db_block_size=8192

db_domain=''

diagnostic_dest='$ORACLE_BASE'

open_cursors=300

remote_login_passwordfile='EXCLUSIVE'

undo_tablespace='UNDOTBS1'

control_files = $ORACLE_BASE/oradata/dbtomato/control01.ctl

compatible ='11.2.0'

 

建库语句

CreateDatabase.sql

 

CREATE DATABASE dbtomato

USER SYS IDENTIFIED BY sys

USER SYSTEM IDENTIFIED BY system

   LOGFILE GROUP 1 ('/u01/app/oracle/oradata/dbtomato/disk1/redo01.log',

                    '/u01/app/oracle/oradata/dbtomato/disk2/redo01.log') SIZE 100M BLOCKSIZE 512,

           GROUP 2 ('/u01/app/oracle/oradata/dbtomato/disk1/redo02.log',

                    '/u01/app/oracle/oradata/dbtomato/disk2/redo02.log') SIZE 100M BLOCKSIZE 512,

           GROUP 3 ('/u01/app/oracle/oradata/dbtomato/disk1/redo03.log',

                    '/u01/app/oracle/oradata/dbtomato/disk2/redo03.log') SIZE 100M BLOCKSIZE 512

MAXLOGFILES 10

MAXLOGMEMBERS 5

MAXLOGHISTORY 5

MAXDATAFILES 200

CHARACTER SET zhs16gbk

   NATIONAL CHARACTER SET AL16UTF16

   EXTENT MANAGEMENT LOCAL

   DATAFILE '/u01/app/oracle/oradata/dbtomato/disk3/system01.dbf' SIZE 325M REUSE

   SYSAUX DATAFILE '/u01/app/oracle/oradata/dbtomato/disk4/sysaux01.dbf' SIZE 325M REUSE

   DEFAULT TABLESPACE users

      DATAFILE '/u01/app/oracle/oradata/dbtomato/disk3/users01.dbf'

      SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED

   DEFAULT TEMPORARY TABLESPACE tempts

      TEMPFILE '/u01/app/oracle/oradata/dbtomato/disk4/temp01.dbf'

      SIZE 20M REUSE

   UNDO TABLESPACE UNDOTBS1

      DATAFILE '/u01/app/oracle/oradata/dbtomato/disk5/undotbs01.dbf'

      SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30151911/viewspace-1605689/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30151911/viewspace-1605689/