確定好數據庫名和實例名

1.設置環境變量

2.創建需要的目錄

? mkdir -p $ORACLE_BASE/oradata/DB_NAME

? mkdir -p $ORACLE_BASE/admin/<sid>/adump

? mkdir -p $ORACLE_BASE/flash_recovery_area

3.創建參數文件pfile

cp $ORACLE_HOME/dbs/init.ora $ORACLE_HOME/dbs/initorcl.ora

內容如下

db_name='ORCL'

memory_target=1G

processes = 300

audit_file_dest='/u01/app/oracle/admin/orcl/adump'

audit_trail ='db'

db_block_size=8192

db_domain=''

db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'

db_recovery_file_dest_size=2G

diagnostic_dest='/u01/app/oracle'

dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'

open_cursors=300?

remote_login_passwordfile='EXCLUSIVE'

undo_tablespace='UNDOTBS1'

# You may want to ensure that control files are created on separate physical

# devices

control_files = ('/u01/app/oracle/oradata/orcl/control01.ctl', '/u01/app/oracle/oradata/orcl/control02.ctl')

compatible ='11.2.0'

4.創建密碼文件

[oracle@localhost dbs]$ orapwd file=orapworcl entries=5

Enter password for SYS: orcl

[oracle@localhost dbs]$ ls -l

total 8

-rw-r--r--. 1 oracle oinstall 2851 May 15 ?2009 init.ora

-rw-r-----. 1 oracle oinstall 2048 Dec 27 14:05 orapworcl

5.創建Oracle的建庫腳本crtdb.sql，內容如下

create database orcl

user sys identified by orcl

user system identified by orcl

maxlogfiles 5

maxlogmembers 5

maxloghistory 1

maxdatafiles 1024

character set zhs16gbk

national character set al16utf16

extent management local

logfile

group 1('/u01/app/oracle/oradata/orcl/redo01.log') size 50m,

group 2('/u01/app/oracle/oradata/orcl/redo02.log') size 50m,

group 3('/u01/app/oracle/oradata/orcl/redo03.log') size 50m

datafile '/u01/app/oracle/oradata/orcl/system.dbf' size 300M reuse autoextend on maxsize unlimited

sysaux datafile '/u01/app/oracle/oradata/orcl/sysaux.dbf' size 200M reuse autoextend on maxsize unlimited

default tablespace users datafile '/u01/app/oracle/oradata/orcl/user01.dbf' size 100M reuse autoextend on next 5M maxsize unlimited

default temporary tablespace temp tempfile '/u01/app/oracle/oradata/orcl/temp01.dbf' size 100M reuse autoextend on next 5M maxsize unlimited

undo tablespace undotbs datafile '/u01/app/oracle/oradata/orcl/undo01.dbf' size 200M reuse autoextend on next 50M maxsize unlimited;

6.啟動數據庫到nomount狀態

sqlplus / as sysdba

startup nomount

@crtdb.sql;

7.創建Oracle的數據字典

@$ORACLE_HOME/rdbms/admin/catalog.sql;

@$ORACLE_HOME/rdbms/admin/catproc.sql;

8.創建監聽netca

轉載于:https://blog.51cto.com/718693/1596675

《新程序員》：云原生和全面數字化實踐50位技術專家共同創作，文字、視頻、音頻交互閱讀

總結

以上是生活随笔為你收集整理的redhat6.4中手动创建oracle11g数据库的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。