【oracle手工建庫】

sub8412發表於2012-11-13
Oracle
1、oracle環境變數設定 .bash_profile
umask 022
export PATH
export ORACLE_BASE=/home/oracle/oracle10g
export ORACLE_SID=odd
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/jdk/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib
export LC_CTYPE=en_US.UTF-8
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

2、建立pfile引數檔案 initodd.ora
control_files=(/opt/oracle/oradata/odd/control01.ctl,/opt/oracle/oradata/odd/control02.ctl)
db_name=odd
db_block_size=8192
undo_management=AUTO
sga_target=200m
user_dump_dest=/opt/oracle/admin/udump
background_dump_dest=/opt/oracle/admin/bdump
undo_tablespace=undotbs

3、建立密碼檔案 orapwodd
orapwd file=orapwodd password=oracle

4、建立目錄
mkdir -p /opt/oracle/oradata/odd/
mkdir -p /opt/oracle/admin/adump
mkdir -p /opt/oracle/admin/bdump
mkdir -p /opt/oracle/admin/cdump
mkdir -p /opt/oracle/admin/udump

5、將資料庫啟動到nomount狀態，執行建立資料庫指令碼
sqlplus / as sysdba
startup nomount

CREATE DATABASE odd
USER SYS IDENTIFIED BY oracle
USER SYSTEM IDENTIFIED BY oracle
LOGFILE GROUP 1 ('/opt/oracle/oradata/odd/redo01.log') SIZE 50M,
GROUP 2 ('/opt/oracle/oradata/odd/redo02.log') SIZE 50M,
GROUP 3 ('/opt/oracle/oradata/odd/redo03.log') SIZE 50M
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXLOGHISTORY 1
MAXDATAFILES 100
MAXINSTANCES 1
CHARACTER SET UTF8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/opt/oracle/oradata/odd/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/opt/oracle/oradata/odd/sysaux01.dbf' SIZE 325M REUSE
DEFAULT TEMPORARY TABLESPACE tempts1
TEMPFILE '/opt/oracle/oradata/odd/temp01.dbf'
SIZE 20M REUSE
UNDO TABLESPACE undotbs
DATAFILE '/opt/oracle/oradata/odd/undotbs01.dbf'
SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;

6、進入資料庫執行指令碼
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

7、驗證
desc dba_tables
desc dbms_output

set serveroutput on
execute dbms_output.put_line('This is');

8、安裝scott使用者
@?/rdbms/admin/ultsampl.sql 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/20553601/viewspace-749149/，如需轉載，請註明出處，否則將追究法律責任。

相關文章