oracle命令如何創建數據庫

這篇文章主要介紹oracle命令如何創建數據庫，文中介紹的非常詳細，具有一定的參考價值，感興趣的小伙伴們一定要看完！

oracle命令（手工）創建數據庫
有時由于沒有圖形界面，需要調動命令，查詢網上各資料，匯總之后，編寫了自己一次的命令創建數據庫的經歷。

1 添加環境變量
export PATH
export ORACLE_BASE=/u01
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0.4/db_1
export ORACLE_SID=dbtest
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/lib64:$LD_LIBRARY_PATH
umask 022
unset USERNAME


2 系統規劃 db_name=dbtest oracle_sid=dbtest
3 手工創建目錄
mkdir -p /u01/app/oracle/admin/dbtest/adump
mkdir -p /u01/app/oracle/admin/dbtest/bdump
mkdir -p /u01/app/oracle/admin/dbtest/cdump
mkdir -p /u01/app/oracle/admin/dbtest/udump




4建立密碼文件：
orapwd file=/u01/product/10.2.0.4/db_1/dbs/orapwdbtest password=123456
5---修改參數文件：


*.audit_file_dest='/u01/admin/dbtest/adump'
*.background_dump_dest='/u01/admin/dbtest/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/u01/oradata/dbtest/control01.ctl','/u01/oradata/dbtest/control02.ctl','/u01/oradata/dbtest/control03.ctl'
*.core_dump_dest='/u01/admin/dbtest/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='dbtest'
*.db_recovery_file_dest='/u01/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.job_queue_processes=10
*.log_archive_dest_1='location=/u01/arch'
*.log_archive_dest_2=''
*.open_cursors=300
*.pga_aggregate_target=545489408
*.processes=1500
*.recyclebin='OFF'
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1210612736
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/admin/dbtest/udump'






---------------------------------------------------
可將此文件復制到:
6--- 登陸oracle：
> sqlplus / as sysdba
7--- 啟動實例：
SQL> startup nomount pfile=/u01/product/10.2.0.4/db_1/dbs/initdbtest.ora
8--- 創建數據庫的腳本：
-----------------------------------------------------------
CREATE DATABASE dbtest
LOGFILE
GROUP 1 ('/u01/oradata/dbtest/redo01.log','/u01/oradata/dbtest/redo01_1.log') size 500m reuse,
GROUP 2 ('/u01/oradata/dbtest/redo02.log','/u01/oradata/dbtest/redo02_1.log') size 500m reuse,
GROUP 3 ('/u01/oradata/dbtest/redo03.log','/u01/oradata/dbtest/redo03_1.log') size 500m reuse
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXLOGHISTORY 200
MAXDATAFILES 500
MAXINSTANCES 5
ARCHIVELOG
CHARACTER SET ZHS16GBK
NATIONAL CHARACTER SET AL16UTF16
DATAFILE '/u01/oradata/dbtest/system01.dbf' SIZE 1000M EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '/u01/oradata/dbtest/sysaux01.dbf' SIZE 1000M
UNDO TABLESPACE UNDOTBS1 DATAFILE '/u01/oradata/dbtest/UNDOTBS1.dbf' SIZE 500M
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u01/oradata/dbtest/temp01.dbf' SIZE 500M;




-----------------------------------------------------------
9--- 運行如下文件(安照下面的先后順序)：
sql>@$ORACLE_HOME/rdbms/admin/catalog.sql
sql>@$ORACLE_HOME/rdbms/admin/catproc.sql
sql>conn system/manager
sql>@$ORACLE_HOME/sqlplus/admin/pupbld.sql
10--- 創建相關表空間與用戶：
create tablespace testnew datafile '/u01/oradata/dbtest/testnew01.dbf' size 2g;
create user testnew identified by testnew default tablespace testnew;
grant connect,resource to testnew;

以上是“oracle命令如何創建數據庫”這篇文章的所有內容，感謝各位的閱讀！希望分享的內容對大家有幫助，更多相關知識，歡迎關注億速云行業資訊頻道！