Oracle ocm中文题与考试答案--学员版

codedba

630

20页

59次

2021-04-19

免费下载

更多 IT 认证课程请访问美河学习在线 www.eimhe.com

考试时间安排：130 40 85 110 90 50 60 60 50

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

===================================================================

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

第一场：

setup1

--1.1.1.1-4

手工建库：在偶数机操作

mkdir /u01/app/oracle/oradata/PROD3

orapwd file=$ORACLE_HOME/dbs/orapwPROD3 password=oracle entries=5;

vi /home/oracle/3.ora

db_block_size=8192

db_name=PROD3

sga_target=500m

control_files='/u01/app/oracle/oradata/PROD3/control01.ctl'

db_create_file_dest='/u01/app/oracle/oradata/PROD3'

. oraenv ---->PROD4

export ORACLE_SID=PROD3

sqlplus / as sysdba

SQL>startup nomount pfile='/home/oracle/3.ora'

SQL>create database character set al32utf8 extent management local;

SQL>@?/rdbms/admin/catalog.sql

SQL>@?/rdbms/admin/catproc.sql

SQL>alter user system identified by oracle;

SQL>conn system/oracle

SQL>@?/sqlplus/admin/pupbld.sql

SQL>conn / as sysdba

SQL>create spfile from memory;

创建 em：在奇数机操作，在 PROD1 创建 EM

SQL>alter user dbsnmp identified by oracle account unlock;

emca -config dbcontrol db -repos recreate

emctl status dbconsole

访问方式：https://10.190.104.111:1158/em

--1.2.1.1

创建临时表空间组在 PROD1 上操作：

更多 IT 认证课程请访问美河学习在线 www.eimhe.com

SQL>create temporary tablespace temp1 tempfile

'/u01/app/oracle/oradata/PROD1/temp1.dbf' size 50m autoextend on tablespace group

temp_grp;

SQL>create temporary tablespace temp2 tempfile

'/u01/app/oracle/oradata/PROD1/temp2.dbf' size 50m autoextend on tablespace group

temp_grp;

SQL>alter database default temporary tablespace temp_grp;

在 PROD1 上操作：

--1.2.2.1

创建大文件表空间：

SQL>create bigfile tablespace test datafile

'/u01/app/oracle/oradata/PROD1/test01.dbf' size 400m autoextend on next 1m maxsize

4t extent management local uniform size 1m;

--1.2.3.1

SQL>create tablespace indx datafile '/u01/app/oracle/oradata/PROD1/indx1.dbf' size

40m;

--1.2.4.1

SQL>create tablespace tools datafile '/u01/app/oracle/oradata/PROD1/tools1.dbf'

size 10m;

--1.2.5.1

创建初始区大小为 2M 的表空间：

SQL>create tablespace oltp datafile '/u01/app/oracle/oradata/PROD1/oltp1.dbf' size

48m autoextend on next 2m extent management local uniform size 2m segment space

management auto;

--1.3.1.1

设置 undoretention 时间：

SQL>alter system set undo_retention=5400;

SQL>alter system set undo_management=auto scope=spfile;

SQL>alter system set processes=135 scope=spfile;

--1.4.1.1-7

创建各个实例的 TNSNAME 和创建一个 1526 的监听：

PROD1

PROD_S

PROD2

PROD3

EMREP

of 20

免费下载

oracle

关注

评论