1. 修改．bash_profile
oracle_sid=PROD
对象别名可创建
2.创建建库所需文件夹
admin(adump dudmp )
oradata
3．创建密码文件(as sysdba可使用多少个用户登录)
cd $ORACLE_HOME/dbs
orapwd file=orapwPROD entries=30 password=oracle
linux 密码文件的命名为orapw+oracle_sid
windows 密码文件命名为pwd+oracle_sid
4.创建并修改参数文件
创建参数
cd /u01/oracle/product/11.2.0/db_1/dbs
[oracle@oracleasm dbs]$ cat init.ora | grep -v ^# | grep -v ^$ >initPROD.ora
db_name=’PROD’
memory_target=1G
processes = 300
audit_file_dest=’/u01/app/oracle/admin/PROD/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=PRODXDB)’
open_cursors=300
remote_login_passwordfile=’EXCLUSIVE’
undo_tablespace=’UNDOTBS1′
control_files = (/u01/app/oracle/oradata/PROD/disk1/control01.ctl,/u01/app/oracle/oradata/PROD/disk2/control02.ctl )
compatible =’11.2.0′
5. 创建spfile
sqlplus / as sysdba
create spfile from pfile
startup nomount;
6.create db创建数据库
CREATE DATABASE PROD
CONTROLFILE REUSE
LOGFILE
GROUP 1 (‘/u01/app/oracle/oradata/PROD/disk1/redo01.log’) SIZE 50M,
GROUP 2 (‘/u01/app/oracle/oradata/PROD/disk2/redo02.log’) SIZE 50M
MAXLOGFILES 30
MAXLOGHISTORY 100
MAXDATAFILES 100
MAXINSTANCES 2
ARCHIVELOG
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET AL16UTF16
DATAFILE
‘/u01/app/oracle/oradata/PROD/disk1/system01.dbf’ size 10m AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX datafile ‘/u01/app/oracle/oradata/PROD/disk1/sysaux01.dbf’ size 10m AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
DEFAULT TEMPORARY TABLESPACE temp
tempfile ‘/u01/app/oracle/oradata/PROD/disk1/temp01.dbf’ size 10m REUSE
UNDO TABLESPACE undotbs1
datafile ‘/u01/app/oracle/oradata/PROD/disk1/undotbs01.dbf’ size 20m REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
7.执行脚本
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/224305.html原文链接：https://javaforall.net
