天堂乐fun88网 - 轻松学习从此开始!    

天堂乐fun88网

Java1234官方群17:
Java1234官方群17:565097738
        

IDEA永久激活

Java1234 VIP课程

Java毕业设计指导(联系锋哥)

Java毕业设计指导(联系锋哥)         Java1234至尊VIP(特价活动)

oracle操作手册 PDF 下载


分享到:
时间:2022-02-18 10:11来源:http://www.51qzml.com 作者:转载  
oracle操作手册 PDF 下载
失效链接处理
oracle操作手册  PDF 下载


本站整理下载:
链接: 
提取码:9nu1 
 
 
相关截图:
 
主要内容:


1.数据库的创建
以下仅为数据库创建的样例脚本,在实际系统中应根据数据库设计要与系统实际配置而改变参数:
1.1.以下为ORACLE启动初始文件initora.ora
#this sampale init file writen by wzy 2002/11/15 
db_name = "jf"
instance_name = ora8
#service_names = ora
#db_files = 1024
control_files = ("/home/oracle/OraCtl/control01.ctl", "/home/oracle/OraCtl/control02.ctl", "/home/oracle/OraCtl/control03.ctl")
open_cursors = 100
max_enabled_roles = 50
db_file_multiblock_read_count = 8
db_block_buffers = 4096
shared_pool_size = 52428800
large_pool_size = 78643200
java_pool_size = 20971520
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 115
parallel_max_servers = 5
log_buffer = 32768
max_dump_file_size = 10240
global_names = true
#oracle_trace_collection_name = ""
db_block_size = 16384
#remote_login_passwordfile = exclusive
#os_authent_prefix = ""
job_queue_processes = 4
job_queue_interval = 60
open_links = 10
#large_pool_size = 614400
java_pool_size = 20971520
distributed_transactions = 10
mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
mts_dispatchers = "(protocol=TCP)"
#compatible = 8.1.0
sort_area_size = 65536
sort_area_retained_size = 65536
# log_archive_start = true
1.2.以下是建库脚本
#!/bin/sh
ORACLE_SID=ora8
export ORACLE_SID
 
svrmgrl
connect internal
startup nomount pfile = $ORACLE_HOME/dbs/initora.ora
CREATE DATABASE "app1" 
controlfile reuse
   maxdatafiles 500
   maxinstances 8
   maxlogfiles 32
   character set ZHS16GBK
   national character set ZHS16GBK
DATAFILE '/oradata/app1/system01.dbf' SIZE 200M
logfile group 1 ('/opt/oracle/oradata/app1/app1_redo01.log', 
'/oradata/app1/app1_redo01.log') SIZE 20M,
        group 2 ('/opt/oracle/oradata/app1/app1_redo02.log',
         '/oradata/app1/app1_redo02.log') SIZE 20M,
        group 3 ('/opt/oracle/oradata/app1/app1_redo03.log',
                 '/oradata/app1/app1_redo03.log') SIZE 20M;
@/opt/oracle/product/8.1.7/rdbms/admin/catalog.sql;
CREATE ROLLBACK SEGMENT r0 TABLESPACE SYSTEM
STORAGE (INITIAL 128k NEXT 128k MINEXTENTS 2 MAXEXTENTS 20);
ALTER ROLLBACK SEGMENT r0 ONLINE;
 
REM ************ TABLESPACE FOR OEM_REPOSITORY ***************
CREATE TABLESPACE OEM_REPOSITORY DATAFILE '/oradata/app1/oemrep01.dbf' SIZE 5M REUSE 
AUTOEXTEND ON NEXT 25M MAXSIZE 80M
MINIMUM EXTENT 128k
DEFAULT STORAGE ( INITIAL 128k NEXT 128k MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0);
 
REM ************** TABLESPACE FOR ROLLBACK *****************
CREATE TABLESPACE RBS DATAFILE '/oradata/app1/rbs01.dbf' SIZE 200M REUSE 
DEFAULT STORAGE ( INITIAL 128k NEXT 128k MINEXTENTS 2 MAXEXTENTS UNLIMITED  PCTINCREASE 0);
 
REM ************** TABLESPACE FOR TEMPORARY *****************
CREATE TABLESPACE TEMP DATAFILE '/oradata/app1/temp01.dbf' SIZE 200M REUSE 
DEFAULT STORAGE ( INITIAL 128k NEXT 128k MINEXTENTS 2 MAXEXTENTS UNLIMITED PCTINCREASE 0) TEMPORARY;
 
REM ************** TABLESPACE FOR USER *********************
CREATE TABLESPACE USERS DATAFILE '/oradata/app1/users01.dbf' SIZE 50M REUSE 
DEFAULT STORAGE ( INITIAL 128k NEXT 128k MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0);
 
REM ************** TABLESPACE FOR INDEX *********************
CREATE TABLESPACE INDX DATAFILE '/oradata/app1/indx01.dbf' SIZE 50M REUSE 
DEFAULT STORAGE ( INITIAL 128k NEXT 128k MINEXTENTS 1 MAXEXTENTS UNLIMITED PCTINCREASE 0);
 
REM **** Creating four rollback segments **************add rollback segment to 20***
CREATE ROLLBACK SEGMENT r01 TABLESPACE RBS 
STORAGE(INITIAL 128k NEXT 128k MINEXTENTS 2 MAXEXTENTS UNLIMITED  optimal 4096K);
 
CREATE ROLLBACK SEGMENT r02 TABLESPACE RBS
STORAGE(INITIAL 128k NEXT 128k MINEXTENTS 2 MAXEXTENTS UNLIMITED  optimal 4096K);
 
CREATE ROLLBACK SEGMENT r03 TABLESPACE RBS
STORAGE(INITIAL 128k NEXT 128k MINEXTENTS 2 MAXEXTENTS UNLIMITED  optimal 4096K);
 
CREATE ROLLBACK SEGMENT r04 TABLESPACE RBS
STORAGE(INITIAL 128k NEXT 128k MINEXTENTS 2 MAXEXTENTS UNLIMITED  optimal 4096K);
 
CREATE ROLLBACK SEGMENT r05 TABLESPACE RBS
STORAGE(INITIAL 128k NEXT 128k MINEXTENTS 2 MAXEXTENTS UNLIMITED  optimal 4096K);
 
CREATE ROLLBACK SEGMENT r06 TABLESPACE RBS
STORAGE(INITIAL 128k NEXT 128k MINEXTENTS 2 MAXEXTENTS UNLIMITED  optimal 4096K);

 

------分隔线----------------------------

锋哥公众号


锋哥微信


关注公众号
【Java资料站】
回复 666
获取 
66套java
从菜鸡到大神
项目实战课程

锋哥推荐