oracle操作手册 PDF 下载_Java知识分享网-免费Java资源下载

失效链接处理

oracle操作手册 PDF 下载

本站整理下载：

链接：https://pan.baidu.com/s/164kUCgwBjUafLStvhnrmzQ

提取码：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