|
奇数机
主机名：ocm1
ORACLE_SID=PROD
IP:192.168.1.161
oracle用户：密码是oracle
root用户：密码是123456
偶数机
主机名：ocm2
ORACLE_SID=EMREP和SBDB
IP:192.168.1.162
oracle用户：密码oracle
root用户：密码123456
操作系统版本：Enterprise-R5-U4-Server-i386-dvd
数据库版本：10.2.0.2.0
gridcontrol版本：10.2.0.1.1
Section 0 :创建数据库(即手动建库) 1. Create a database the sid name is PROD 2. Don't run the Script catalog.sql and catproc.sql
参考联机文档： Reference ==> Basic Initialization Parameters http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams002.htm#CJAJHDED
Administrator's Guide ==> Step 7: Issue the CREATE DATABASE Statement http://docs.oracle.com/cd/B19306_01/server.102/b14231/create.htm#sthref242
[oracle@ocm1 ~]$ hostname ocm1 [oracle@ocm1 ~]$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 5.4 (Tikanga) [oracle@ocm1 ~]$ /sbin/ifconfig eth0 Link encap:Ethernet HWaddr 08:00:27:23:43:C3 inet addr:192.168.1.161 Bcast:192.168.1.255 Mask:255.255.255.0 inet6 addr: fe80::a00:27ff:fe23:43c3/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:315 errors:0 dropped:0 overruns:0 frame:0 TX packets:151 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:29390 (28.7 KiB) TX bytes:19900 (19.4 KiB) Memory:f0000000-f0020000
lo Link encap:Local Loopback inet addr:127.0.0.1 Mask:255.0.0.0 inet6 addr: ::1/128 Scope:Host UP LOOPBACK RUNNING MTU:16436 Metric:1 RX packets:1504 errors:0 dropped:0 overruns:0 frame:0 TX packets:1504 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:4332028 (4.1 MiB) TX bytes:4332028 (4.1 MiB)
[oracle@ocm1 ~]$
考试时可用sudo来继承root用户权限做管理员操作
准备工作：
1.查看oracle环境变量。
[oracle@ocm1 ~]$ cat .bash_profile # .bash_profile
# Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi
# User specific environment and startup programs
export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export PATH=$ORACLE_HOME/bin:$PATH PATH=$PATH:$HOME/bin
export PATH [oracle@ocm1 ~]$
2.设置一下sqlplus命令提示符。
[oracle@ocm1 ~]$ vi /u01/app/oracle/product/10.2.0/db_1/sqlplus/admin/glogin.sql -- -- Copyright (c) 1988, 2004,
Oracle Corporation. All Rights Reserved. -- -- NAME -- glogin.sql -- -- DESCRIPTION -- SQL*Plus global login "site profile" file -- -- Add any SQL*Plus commands here that are to be executed when a -- user starts SQL*Plus, or uses the SQL*Plus CONNECT command -- -- USAGE -- This script is automatically run --
-- Used by Trusted Oracle COLUMN ROWLABEL FORMAT A15
-- Used for the SHOW ERRORS command COLUMN LINE/COL FORMAT A8 COLUMN ERROR FORMAT A65 WORD_WRAPPED
-- Used for the SHOW SGA command COLUMN name_col_plus_show_sga FORMAT a24 COLUMN units_col_plus_show_sga FORMAT a15 -- Defaults for SHOW PARAMETERS COLUMN name_col_plus_show_param FORMAT a36 HEADING NAME COLUMN value_col_plus_show_param FORMAT a30 HEADING VALUE
-- Defaults for SHOW RECYCLEBIN COLUMN origname_plus_show_recyc FORMAT a16 HEADING 'ORIGINAL NAME' COLUMN objectname_plus_show_recyc FORMAT a30 HEADING 'RECYCLEBIN NAME' COLUMN objtype_plus_show_recyc FORMAT a12 HEADING 'OBJECT TYPE' COLUMN droptime_plus_show_recyc FORMAT a19 HEADING 'DROP TIME'
-- Defaults for SET AUTOTRACE EXPLAIN report -- These column definitions are only used when SQL*Plus -- is connected to Oracle 9.2 or earlier. COLUMN id_plus |