OCM_session0_手动建库_os5.4
奇数机
主机名：ocm1ORACLE_SID=PRODIP:192.168.1.161oracle用户：密码是oracleroot用户：密码是123456
偶数机主机名：ocm2ORACLE_SID=EMREP和SBDBIP:192.168.1.162oracle用户：密码oracleroot用户：密码123456
操作系统版本：Enterprise-R5-U4-Server-i386-dvd数据库版本：10.2.0.2.0gridcontrol版本：10.2.0.1.1
Section 0 :创建数据库(即手动建库)1. Create a database the sid name is PROD2. Don't run the Script catalog.sql and catproc.sql
参考联机文档：Reference ==> Basic Initialization Parametershttp://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams002.htm#CJAJHDED
Administrator's Guide ==> Step 7: Issue the CREATE DATABASE Statementhttp://docs.oracle.com/cd/B19306_01/server.102/b14231/create.htm#sthref242
$ hostnameocm1$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 5.4 (Tikanga)$ /sbin/ifconfigeth0 Link encap:EthernetHWaddr 08:00:27:23:43:C3 inet addr:192.168.1.161Bcast:192.168.1.255Mask:255.255.255.0 inet6 addr: fe80::a00:27ff:fe23:43c3/64 Scope:Link UP BROADCAST RUNNING MULTICASTMTU:1500Metric: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.1Mask:255.0.0.0 inet6 addr: ::1/128 Scope:Host UP LOOPBACK RUNNINGMTU:16436Metric: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)
$
考试时可用sudo来继承root用户权限做管理员操作
准备工作：
1.查看oracle环境变量。
$ cat .bash_profile# .bash_profile
# Get the aliases and functionsif [ -f ~/.bashrc ]; then . ~/.bashrcfi
# User specific environment and startup programs
export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport PATH=$ORACLE_HOME/bin:$PATHPATH=$PATH:$HOME/bin
export PATH$
2.设置一下sqlplus命令提示符。
$ 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 OracleCOLUMN ROWLABEL FORMAT A15
-- Used for the SHOW ERRORS commandCOLUMN LINE/COL FORMAT A8COLUMN ERROR FORMAT A65WORD_WRAPPED
-- Used for the SHOW SGA commandCOLUMN name_col_plus_show_sga FORMAT a24COLUMN units_col_plus_show_sga FORMAT a15-- Defaults for SHOW PARAMETERSCOLUMN name_col_plus_show_param FORMAT a36 HEADING NAMECOLUMN value_col_plus_show_param FORMAT a30 HEADING VALUE
-- Defaults for SHOW RECYCLEBINCOLUMN 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_exp FORMAT 990 HEADING iCOLUMN parent_id_plus_exp FORMAT 990 HEADING pCOLUMN plan_plus_exp FORMAT a60COLUMN object_node_plus_exp FORMAT a8COLUMN other_tag_plus_exp FORMAT a29COLUMN other_plus_exp FORMAT a44
-- Default for XQUERYCOLUMN result_plus_xquery HEADING 'Result Sequence'set sqlprompt"_user'@'_connect_identifier>""/u01/app/oracle/product/10.2.0/db_1/sqlplus/admin/glogin.sql" 49L, 1569C written
3.查看是否有user和连接的标识符。
$ export ORACLE_SID=PROD$ sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 14 08:23:03 2014
Copyright (c) 1982, 2005, Oracle.All Rights Reserved.
@>conn /as sysdbaConnected to an idle instance.SYS@PROD>
####################################################################################################################ORA-12162: TNS:net service name is incorrectly specified-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 14 08:21:30 2014
Copyright (c) 1982, 2005, Oracle.All Rights Reserved.
@>conn /as sysdbaERROR:ORA-12162: TNS:net service name is incorrectly specified
指定ORACLE_SID=PROD即可####################################################################################################################
手动建库步骤：
1.创建密码文件
$ cd /u01/app/oracle/product/10.2.0/db_1/dbs/$ lltotal 28-rw-r----- 1 oracle oinstall 12920 May32001 initdw.ora-rw-r----- 1 oracle oinstall8385 Sep 111998 init.ora$ orapwd file=orapwPROD password=oracle entries=30$ lltotal 36-rw-r----- 1 oracle oinstall 12920 May32001 initdw.ora-rw-r----- 1 oracle oinstall8385 Sep 111998 init.ora-rw-r----- 1 oracle oinstall5120 Apr 14 08:26 orapwPROD$
2.创建相关目录
$ mkdir -p $ORACLE_BASE/admin/PROD/adump$ mkdir -p $ORACLE_BASE/admin/PROD/bdump$ mkdir -p $ORACLE_BASE/admin/PROD/cdump$ mkdir -p $ORACLE_BASE/admin/PROD/udump$ mkdir -p $ORACLE_BASE/oradata/PROD/Disk1$ mkdir -p $ORACLE_BASE/oradata/PROD/Disk2/arch$ mkdir -p $ORACLE_BASE/oradata/PROD/Disk3$ mkdir -p $ORACLE_BASE/oradata/PROD/Disk4$ mkdir -p $ORACLE_BASE/oradata/PROD/Disk5$
3.创建pfile参数文件$ pwd/u01/app/oracle/product/10.2.0/db_1/dbs$ vi initPROD.ora
CONTROL_FILES=('/u01/app/oracle/oradata/PROD/Disk1/control01.ctl','/u01/app/oracle/oradata/PROD/Disk2/control02.ctl','/u01/app/oracle/oradata/PROD/Disk3/control03.ctl')DB_BLOCK_SIZE=8192DB_CREATE_FILE_DEST=/u01/app/oracle/oradata/PROD/Disk1DB_CREATE_ONLINE_LOG_DEST_1=/u01/app/oracle/oradata/PROD/Disk1DB_NAME=PRODJOB_QUEUE_PROCESSES=10LOG_ARCHIVE_DEST_1='location=/u01/app/oracle/oradata/PROD/Disk2/arch'PROCESSES=200SGA_TARGET=500MBACKGROUND_DUMP_DEST=/u01/app/oracle/admin/PROD/bdumpCORE_DUMP_DEST=/u01/app/oracle/admin/PROD/cdumpUSER_DUMP_DEST=/u01/app/oracle/admin/PROD/udumpUNDO_MANAGEMENT=autoUNDO_TABLESPACE=undotbs1UNDO_RETENTION=5400~~~~~~~~"initPROD.ora" 16L, 659C written $
4.使用pfile生成spfile。
$ export ORACLE_SID=PROD$ sqlplus /nolog
SQL*Plus: Release 10.2.0.2.0 - Production on Mon Apr 14 08:33:48 2014
Copyright (c) 1982, 2005, Oracle.All Rights Reserved.
@>conn /as sysdbaConnected to an idle instance.SYS@PROD>create spfile from pfile;
File created.
SYS@PROD
5.然后启动到nomount，再查看是否以spfile启动的。
SYS@PROD>startup nomountORACLE instance started.
Total System Global Area524288000 bytesFixed Size 1261788 bytesVariable Size 146804516 bytesDatabase Buffers 373293056 bytesRedo Buffers 2928640 bytes
SYS@PROD>show parameter spfile
NAME TYPE VALUE------------------------------------ ----------- ------------------------------spfile string /u01/app/oracle/product/10.2.0 /db_1/dbs/spfilePROD.ora
SYS@PROD>show parameter dest
NAME TYPE VALUE------------------------------------ ----------- ------------------------------audit_file_dest string /u01/app/oracle/admin/PROD/adumpbackground_dump_dest string /u01/app/oracle/admin/PROD/bdumpcore_dump_dest string /u01/app/oracle/admin/PROD/cdumpdb_create_file_dest string /u01/app/oracle/oradata/PROD/Disk1db_create_online_log_dest_1 string /u01/app/oracle/oradata/PROD/Disk1...user_dump_dest string /u01/app/oracle/admin/PROD/udump
6，创建数据库脚本。
$ pwd/home/oracle$ vi create_database.sql
CREATE DATABASE PRODUSER SYS IDENTIFIED BY oracleUSER SYSTEM IDENTIFIED BY oracleLOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD/Disk1/redo01.log') SIZE 100M, GROUP 2 ('/u01/app/oracle/oradata/PROD/Disk1/redo02.log') SIZE 100M, GROUP 3 ('/u01/app/oracle/oradata/PROD/Disk1/redo03.log') SIZE 100MMAXLOGFILES 5MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 100MAXINSTANCES 1CHARACTER SET AL32UTF8NATIONAL CHARACTER SET AL16UTF16DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/system01.dbf' SIZE 325M REUSEEXTENT MANAGEMENT LOCALSYSAUX DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/sysaux01.dbf' SIZE 325M REUSEDEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/u01/app/oracle/oradata/PROD/Disk1/temp01.dbf' SIZE 20M REUSEUNDO TABLESPACE undotbs1 DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/undotbs01.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
$ lltotal 4-rw-r--r-- 1 oracle oinstall 885 Apr 14 08:44 create_database.sql
7.在nomount阶段运行脚本，创建数据库。
SYS@PROD>@/home/oracle/create_database
Database created.
8.创建数据库时，可以查看相关的告警日志。
$ tail -f alert_PROD.log
Mon Apr 14 20:43:36 2014CREATE DATABASE PRODUSER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY *LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD/Disk1/redo01.log') SIZE 100M, GROUP 2 ('/u01/app/oracle/oradata/PROD/Disk1/redo02.log') SIZE 100M, GROUP 3 ('/u01/app/oracle/oradata/PROD/Disk1/redo03.log') SIZE 100MMAXLOGFILES 5MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 100MAXINSTANCES 1CHARACTER SET AL32UTF8NATIONAL CHARACTER SET AL16UTF16DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/system01.dbf' SIZE 325M REUSEEXTENT MANAGEMENT LOCALSYSAUX DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/sysaux01.dbf' SIZE 325M REUSEDEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/u01/app/oracle/oradata/PROD/Disk1/temp01.dbf' SIZE 20M REUSEUNDO TABLESPACE undotbs1 DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/undotbs01.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITEDMon Apr 14 20:43:38 2014Database mounted in Exclusive ModeMon Apr 14 20:45:36 2014Successful mount of redo thread 1, with mount id 256759032Assigning activation ID 256759032 (0xf4dd4f8)Thread 1 opened at log sequence 1Current log# 1 seq# 1 mem# 0: /u01/app/oracle/oradata/PROD/Disk1/redo01.logSuccessful open of redo thread 1Mon Apr 14 20:45:37 2014MTTR advisory is disabled because FAST_START_MTTR_TARGET is not setMon Apr 14 20:45:37 2014SMON: enabling cache recoveryMon Apr 14 20:45:37 2014create tablespace SYSTEM datafile'/u01/app/oracle/oradata/PROD/Disk1/system01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL onlineMon Apr 14 20:45:47 2014Completed: create tablespace SYSTEM datafile'/u01/app/oracle/oradata/PROD/Disk1/system01.dbf' SIZE 325M REUSEEXTENT MANAGEMENT LOCAL onlineMon Apr 14 20:45:47 2014create rollback segment SYSTEM tablespace SYSTEMstorage (initial 50K next 50K)Completed: create rollback segment SYSTEM tablespace SYSTEMstorage (initial 50K next 50K)Mon Apr 14 20:46:02 2014CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE'/u01/app/oracle/oradata/PROD/Disk1/undotbs01.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITEDMon Apr 14 20:46:07 2014Successfully onlined Undo Tablespace 1.Completed: CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE'/u01/app/oracle/oradata/PROD/Disk1/undotbs01.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITEDMon Apr 14 20:46:07 2014create tablespace SYSAUX datafile'/u01/app/oracle/oradata/PROD/Disk1/sysaux01.dbf' SIZE 325M REUSE
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO onlineMon Apr 14 20:46:20 2014Completed: create tablespace SYSAUX datafile'/u01/app/oracle/oradata/PROD/Disk1/sysaux01.dbf' SIZE 325M REUSEEXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO onlineMon Apr 14 20:46:21 2014CREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE'/u01/app/oracle/oradata/PROD/Disk1/temp01.dbf' SIZE 20M REUSE
Completed: CREATE TEMPORARY TABLESPACE TEMPTS1 TEMPFILE'/u01/app/oracle/oradata/PROD/Disk1/temp01.dbf' SIZE 20M REUSEMon Apr 14 20:46:21 2014ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1Completed: ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPTS1Mon Apr 14 20:46:21 2014ALTER DATABASE DEFAULT TABLESPACE SYSTEM Completed: ALTER DATABASE DEFAULT TABLESPACE SYSTEM Mon Apr 14 20:46:26 2014SMON: enabling tx recoveryMon Apr 14 20:46:31 2014Threshold validation cannot be done before catproc is loaded.replication_dependency_tracking turned off (no async multimaster replication found)Starting background process QMNCQMNC started with pid=14, OS id=2495Mon Apr 14 20:46:32 2014Completed: CREATE DATABASE PRODUSER SYS IDENTIFIED BY *USER SYSTEM IDENTIFIED BY *LOGFILE GROUP 1 ('/u01/app/oracle/oradata/PROD/Disk1/redo01.log') SIZE 100M, GROUP 2 ('/u01/app/oracle/oradata/PROD/Disk1/redo02.log') SIZE 100M, GROUP 3 ('/u01/app/oracle/oradata/PROD/Disk1/redo03.log') SIZE 100MMAXLOGFILES 5MAXLOGMEMBERS 5MAXLOGHISTORY 1MAXDATAFILES 100MAXINSTANCES 1CHARACTER SET AL32UTF8NATIONAL CHARACTER SET AL16UTF16DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/system01.dbf' SIZE 325M REUSEEXTENT MANAGEMENT LOCALSYSAUX DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/sysaux01.dbf' SIZE 325M REUSEDEFAULT TEMPORARY TABLESPACE tempts1 TEMPFILE '/u01/app/oracle/oradata/PROD/Disk1/temp01.dbf' SIZE 20M REUSEUNDO TABLESPACE undotbs1 DATAFILE '/u01/app/oracle/oradata/PROD/Disk1/undotbs01.dbf' SIZE 100M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED 版权声明：本文为博主原创文章，未经博主允许不得转载。
页:
[1]