1. 设置ORACLE_SID:
2. 建立相关目录
3. 建立密码文件
4. 建立参数文件
5. 用SQL建立DB
1
export ORACLE_SID=ad_test
注意不能超过8个字符
2
mkdir ad_test
cd ad_test
mkdir bdump
mkdir adump
mkdir cdump
mkdir udump
mkdir data
mkdir diag
3
------ export ORACLE_HOME= /home/oracle/11.2.0.4
orapwd file=$ORACLE_HOME/dbs/orapwad_test password=oracleentries=5 force=y
--- 这步也就是建立SYS的远程登陆密码
4
--- 也是在dbs下
vi initad_test.ora
ad_test.__db_cache_size=654311424
ad_test.__java_pool_size=16777216
ad_test.__large_pool_size=16777216
ad_test.__oracle_base='/home/oracle'#ORACLE_BASE set from environment
ad_test.__pga_aggregate_target=939524096
ad_test.__sga_target=1744830464
ad_test.__shared_io_pool_size=0
ad_test.__shared_pool_size=1023410176
ad_test.__streams_pool_size=0
*.audit_file_dest='/home/oracle/ad_test/adump'
*.cluster_database=false
*.compatible='11.2.0.4'
*.control_files='/home/oracle/ad_test/data/control01.ctl','/home/oracle/ad_test/data/control02.ctl','/home/oracle/ad_test/data/control03.ctl'
*.core_dump_dest='/home/oracle/ad_test/cdump'
*.cursor_sharing='EXACT'
*.db_block_size=8192
*.db_domain=''
*.db_name='ad_test'
*.diagnostic_dest='/home/oracle/ad_test/diag'
*.instance_name='ad_test'
*.job_queue_processes=4
*.log_archive_format='ad_test_%t_%r_%s.dbf'
*.memory_target=2560M
*.nls_territory='AMERICA'
*.open_cursors=500
*.optimizer_mode='ALL_ROWS'
*.processes=1000
*.query_rewrite_enabled='FALSE'
*.remote_login_passwordfile='EXCLUSIVE'
*.session_max_open_files=30
*.star_transformation_enabled='TRUE'
*.statistics_level='ALL'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=900
*.undo_tablespace='UNDOTBS1'
5
Sqlplus / as sysdba
spool /home/oracle/adam/create_ad_test.log
startup nomountpfile=/home/oracle/11.2.0.4/dbs/initad_test.ora
create databasead_test
user sysidentified by oracle
user systemidentified by oracle
maxinstances10
maxlogfiles 48
maxloghistory256
maxdatafiles1024
maxlogmembers5
noarchivelog
character set AL32UTF8
nationalcharacter set UTF8
sysauxdatafile
'/home/oracle/ad_test/data/sysaux01.dbf' size 500M
datafile
'/home/oracle/ad_test/data/system01.dbf' size 500M
extent managementlocal
logfile
group1 ('/home/oracle/ad_test/data/redo_01a.log',
'/home/oracle/ad_test/data/redo_01b.log') size 200M,
group2 ('/home/oracle/ad_test/data/redo_02a.log',
'/home/oracle/ad_test/data/redo_02b.log')size 200M,
group3 ('/home/oracle/ad_test/data/redo_03a.log',
'/home/oracle/ad_test/data/redo_03b.log') size 200M
defaulttemporary tablespace TEMP
TEMPFILE
'/home/oracle/ad_test/data/temp_01.dbf' size 200M
extentmanagement local uniform size 32k
defaulttablespace users
datafile'/home/oracle/ad_test/data/users01.dbf'
size20m reuse
extentmanagement local
segmentspace management auto
UNDOTablespace UNDOTBS1 datafile
'/home/oracle/ad_test/data/undotbs01.dbf' size 200M
RETENTION NOGUARANTEE;
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
connect system/oracle
@?/sqlplus/admin/plustrce.sql
@?/sqlplus/admin/pupbld.sql
@?/rdbms/admin/utlxplan.sql
spool off
6 做一下验证
select * from dba_registry;