【Database 12c】手动创建CDB Container Database容器数据库 - 推酷
【Database 12c】手动创建CDB Container Database容器数据库
手动建库几乎是每个DBA都需要掌握的技能，而Database 12c中手动创建Container Database容器数据库的过程是如何的呢？
目前12c创建容器数据库Container Database和普通Database存在一点点小的区别，需要指定enable pluggable database，已创建的数据库目前无法转换为容器数据库。
创建必要的目录
mkdir -p /stage/oradata
mkdir -p /stage/fr
mkdir -p /u01/app/oracle/admin/MACLEANCDB/adump
我们创建 实例初始化文件，并创建DB:
1、 INIT.ORA
##############################################################################
# Copyright (c) , 2002 by Oracle Corporation
##############################################################################
###########################################
###########################################
_enable_pluggable_database=true
###########################################
# Cache and I/O
###########################################
db_block_size=8192
###########################################
# Cursors and Library Cache
###########################################
open_cursors=300
###########################################
# Database Identification
###########################################
db_domain=&&
db_name=&MACLEANC&
###########################################
# File Configuration
###########################################
db_create_file_dest=&/stage/oradata&
db_recovery_file_dest=&/stage/fr&
db_recovery_file_dest_size=
###########################################
# Miscellaneous
###########################################
compatible=12.0.0.0.0
db_unique_name=&MACLEANCDB&
diagnostic_dest=/u01/app/oracle
###########################################
# Network Registration
###########################################
#local_listener=LISTENER_MACLEANCDB
###########################################
# Processes and Sessions
###########################################
processes=300
###########################################
# SGA Memory
###########################################
sga_target=
###########################################
# Security and Auditing
###########################################
audit_file_dest=&/u01/app/oracle/admin/MACLEANCDB/adump&
audit_trail=db
remote_login_passwordfile=EXCLUSIVE
###########################################
# Shared Server
###########################################
dispatchers=&(PROTOCOL=TCP) (SERVICE=MACLEANCDBXDB)&
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_tablespace=UNDOTBS1
2、 创建密码文件
oracle@localhost:~$ /u01/app/oracle/product/12.1.0/dbhome_1/bin/orapwd file=/u01/app/oracle/product/12.1.0/dbhome_1/dbs/orapwMACLEANCDB force=y extended=y
Enter password for SYS:
3、 正式创建DB
oracle@localhost:~$ export ORACLE_SID=MACLEANCDB
oracle@localhost:~$ sqlplus / as sysdba
SQL& startup nomount pfile='init.ora';
ORACLE instance started.
Total System Global Area
Fixed Size
2268040 bytes
Variable Size
Database Buffers
Redo Buffers
5734400 bytes
CREATE DATABASE &MACLEANC&
MAXINSTANCES 8
MAXLOGHISTORY 1
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 1024
DATAFILE SIZE 700M AUTOEXTEND ON NEXT
10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE SIZE 550M AUTOEXTEND ON NEXT
10240K MAXSIZE UNLIMITED
SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE SIZE 20M AUTOEXTEND ON NEXT
640K MAXSIZE UNLIMITED
SMALLFILE UNDO TABLESPACE &UNDOTBS1& DATAFILE
SIZE 200M AUTOEXTEND ON NEXT
5120K MAXSIZE UNLIMITED
CHARACTER SET AL32UTF8
NATIONAL CHARACTER SET UTF8
LOGFILE GROUP 1
SIZE 51200K,
SIZE 51200K,
SIZE 51200K
USER SYS IDENTIFIED BY &oracle& USER SYSTEM IDENTIFIED BY &oracle&
Database created.
set linesize 2048;
column ctl_files NEW_VALUE ctl_
select concat('control_files=''', concat(replace(value, ', ', ''','''), '''')) ctl_files from v$parameter where name ='control_files';
host echo &ctl_files && /u01/app/oracle/admin/MACLEANCDB/scripts/init.
将控制文件信息写入到中==》 echo &ctl_files && /u01/app/oracle/admin/MACLEANCDB/scripts/init.
4、创建默认使用的USERS表空间
SQL& CREATE SMALLFILE TABLESPACE &USERS& LOGGING
SIZE 5M AUTOEXTEND ON NEXT
1280K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT
Tablespace created.
SQL& ALTER DATABASE DEFAULT TABLESPACE &USERS&;
Database altered.
5、 执行必要的数据字典创建脚本
alter session set &_oracle_script&=
alter pluggable database pdb$
alter pluggable database pdb$
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b catalog /u01/ap
p/oracle/product/12.1.0/dbhome_1/rdbms/admin/catalog.
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b catblock /u01/a
pp/oracle/product/12.1.0/dbhome_1/rdbms/admin/catblock.
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b catproc /u01/ap
p/oracle/product/12.1.0/dbhome_1/rdbms/admin/catproc.
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b catoctk /u01/ap
p/oracle/product/12.1.0/dbhome_1/rdbms/admin/catoctk.
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b owminst /u01/ap
p/oracle/product/12.1.0/dbhome_1/rdbms/admin/owminst.
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b pupbld -u SYSTE
M/&&systemPassword /u01/app/oracle/product/12.1.0/dbhome_1/sqlplus/admin/pupbld.
connect &SYSTEM&/&&&systemPassword&
set echo on
spool /u01/app/oracle/admin/MACLEANCDB/scripts/sqlPlusHelp.log append
host perl /u01/app/oracle/product/12.1.0/dbhome_1/rdbms/admin/catcon.pl -l /u01/app/oracle/admin/MACLEANCDB/scripts -b hlpbld -u SYSTE
M/&&systemPassword -a 1
/u01/app/oracle/product/12.1.0/dbhome_1/sqlplus/admin/help/hlpbld.sql 1helpus.
@/u01/app/oracle/product/12.1.0/dbhome_1/sqlplus/admin/help/hlpbld.sql helpus.
6、 创建一个PDB
cp init.ora
/u01/app/oracle/product/12.1.0/dbhome_1/dbs/initMACLEANCDB.ora
CREATE PLUGGABLE DATABASE MACLEANCDB ADMIN USER MACadmin IDENTIFIED BY oracle
FILE_NAME_CONVERT=(
'/stage/oradata/MACLEANCDB/DC36EDCEFA00B/datafile/o1_mf_system_8rns0lxf_.dbf', '/stage/oradata/PDB1/datafile/system01.clone',
'/stage/oradata/MACLEANCDB/DC36EDCEFA00B/datafile/o1_mf_sysaux_8rns13dk_.dbf', '/stage/oradata/PDB1/datafile/sysaux1.dbf.clone',
'/stage/oradata/MACLEANCDB/DC36EDCEFA00B/datafile/o1_mf_temp_8rns1d89_.tmp', '/stage/oradata/PDB1/datafile/temp1.tmp.clone'
STORAGE UNLIMITED;
已发表评论数()
请填写推刊名
描述不能大于100个字符!
权限设置： 公开
仅自己可见
正文不准确
标题不准确
排版有问题
主题不准确
没有分页内容
图片无法显示
视频无法显示
与原文不一致Oracle 实例创建脚本_数据库技术_Linux公社-Linux系统门户网站
你好，游客
Oracle 实例创建脚本
来源：Linux社区&
作者：handan725
遥想刚入职时，一台服务器就挂了，所以就是在&危难&中有机会学习。在夜深人静时，我想去回忆一下实例的创建。一种方法，DBCA，图形界面，但是需要依赖xming或xmanager这类软件；另一种方法就是脚本创建Oracle数据库实例。第一种方法简单，易上手，但是对初学者，不能学习到更多数据库知识；第二种方法用脚本就能更了然数据库的各种文件以及参数。本文只介绍脚本创建Oracle实例。
记得2010年，还是用Oracle10g，如今用11g，他们的差异在于dump 目录略不同。我们就高不就低，以Oracle 11g创建一个实例为例，一起看看有哪些点需要我们注意滴。
第一步：创建文件目录，并将文件目录授权给oracle用户，以webdb为实例名举例，进行如下操作，其中adump，dpdump，fast_recovery_area 是必须要有的（这几个目录11g跟10g略不同，需要注意），oradata/webdb和/tabdata/webdb的创建根据管理员习惯，一般oradata/webdb用来存储系统级别文件，如redolog,system file，undo file 等，tabdata/webdb用来放新增表空间文件（数据文件）。
mkdir -p /u00/app/oracle/admin/webdb/adump
mkdir -p /u00/app/oracle/admin/webdb/dpdump
mkdir -p /u00/app/oracle/fast_recovery_area/webdb
mkdir -p /u01/oradata/webdb
mkdir -p /u01/tabdata/webdb
chown oracle:oinstall /u00/app/oracle/admin/webdb/adump
chown oracle:oinstall /u00/app/oracle/admin/webdb/dpdump
chown oracle:oinstall /u00/app/oracle/fast_recovery_area/webdb
chown oracle:oinstall /u01/oradata/webdb
chown oracle:oinstall /u01/tabdata/webdb
第二步：export 实例名称
ORACLE_SID= export ORACLE_SID
第三步：手工在/etc/oratab文件下增加实例名称（这个文件很重要，详情后续会有文章介绍）
echo "webdb:$ORACLE_HOME:Y" && /etc/oratab
第四步：手工在$ORACLE_HOME/dbs增加pfile 文件（此文件是实例参数值的重要文件）
vi $ORACLE_HOME/dbs/initwebdb.ora
文件内容如下：
webdb.__db_cache_size=
webdb.__java_pool_size=4194304
webdb.__large_pool_size=4194304
webdb.__oracle_base='/u00/app/oracle'#ORACLE_BASE set from environment
webdb.__pga_aggregate_target=
webdb.__sga_target=
webdb.__shared_io_pool_size=0
webdb.__shared_pool_size=
webdb.__streams_pool_size=0
*.audit_file_dest='/u00/app/oracle/admin/webdb/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/oradata/webdb/control01.ctl','/u00/app/oracle/fast_recovery_area/webdb/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='webdb'
*.db_recovery_file_dest='/u00/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=
*.diagnostic_dest='/u00/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=webdbXDB)'
*.open_cursors=500
*.pga_aggregate_target=
*.processes=1000
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=1105
*.sga_target=
*.undo_tablespace='UNDOTBS1'
第五步：手工orap生成密码
$ORACLE_HOME/bin/orapwd file=$ORACLE_HOME/dbs/orapwwebdb password=dbpassword force=y
第六步：运行一些列脚本，直至数据库创建完毕。
（1）$ORACLE_HOME/bin/sqlplus /nolog
（2）sql&connect "SYS"/"password" as SYSDBA
//创建spfile基于刚给的pfile，为什么创建一个，这个很有用，万一pfile出错了，或者被意外更改，spfile的用途很大，后边有空来详细介绍下spfile跟pfile的使用，如果有spfile，oracle默认限度spfile，只有当spfile没有时，才读pfile。而且spfile是二进制，pfile就是普通的文件，可读可改。方便的同时也容易被误操作。
（3）sql&create spfile='$ORACLE_HOME/dbs/spfilewebdb.ora' from pfile='$ORACLE_HOME/dbs/initwebdb.ora';
（4）sql&startup nomount
（5）@createdb.sql
//createdb.sql脚本如下，其中包括redolog 大小，位置，以及系统文件等，尤其注意character set设置在这里，不要一失足，后面该很麻烦滴。关于这个字符集设置，小编也有血泪史，后面给大家介绍些诡异的手法。
CREATE DATABASE webdb
LOGFILE group 1 ('/u01/oradata/webdb/redo01.log' ) SIZE 51200K,
group 2 ('/u01/oradata/webdb/redo02.log' ) SIZE 51200K,
group 3 ('/u01/oradata/webdb/redo03.log' ) size 51200K
DATAFILE '/u01/oradata/webdb/system01.dbf' SIZE 200M autoextend on next 10M maxsize unlimited
sysaux datafile '/u01/oradata/webdb/sysaux01.dbf' size 100M autoextend on next 10M maxsize unlimited
character set WE8ISO8859P1
EXTENT MANAGEMENT LOCAL
undo tablespace UNDOTBS1
datafile '/u01/oradata/webdb/UNDOTBS01.dbf'
size 50M autoextend on next 5M maxsize UNLIMITED
default temporary tablespace temp
tempfile '/u01/oradata/webdb/temp01.dbf'
size 50M autoextend on next 640K maxsize UNLIMITED;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
ALTER SYSTEM SWITCH LOGFILE;
（6）@dic.sql
//运行数据字典dic.sql内容如下：
SET VERIFY OFF
connect "SYS"/"password" as SYSDBA
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catblock.sql
@?/rdbms/admin/catoctk.sql
@?/rdbms/admin/owminst.plb
connect "SYSTEM"/"password"
@?/sqlplus/admin/pupbld.sql
@?/sqlplus/admin/help/hlpbld.sql helpus.sql
（7）@ctab.sql
//ctab.sql 是创建表空间，语法格式如下。
connect "SYS"/"password" as SYSDBA
spool ctab
DROP TABLESPACE BACKUPINCLUDING CONTENTS AND DATAFILES;
CREATE TABLESPACE BACKUP DATAFILE
'/u01/tabdata/webdb/BACKUP.dbf' SIZE 1320M AUTOEXTEND ON NEXT 8K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;
（8）@cuser.sql
//cuser.sql是用来创建用户。
sqlplus / as sysdba
CREATE USER MAINT
IDENTIFIED BY password
DEFAULT TABLESPACE BACKUP
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 2 Roles for MAINT
GRANT CONNECT TO MAINT;
GRANT RESOURCE TO MAINT;
ALTER USER MAINT DEFAULT ROLE ALL;
-- 1 System Privilege for WBXMAINT
GRANT UNLIMITED TABLESPACE TO MAINT;
==============================================================================
基于以上步骤，就可以so easy且有所得滴创建一个instance。
还需要在listener 以及tns 文件上天剑才能进行网络连接。后面会给大家分享OracleDB连接方式时，再详细介绍。
希望对您有帮助，有什么可以帮您？请留言。
Oracle 11g 在 Linux 5.8_x64平台的***手册
Linux-6-64下***Oracle 12C笔记
在 6.4下***Oracle 11gR2(x64)
Oracle 11gR2 在VMWare虚拟机中***步骤
Debian 下 *** Oracle 11g XE R2
更多Oracle相关信息见 专题页面
本文永久更新链接地址：
相关资讯 & & &
& (05/28/:28)
& (05/26/:29)
& (08/13/:24)
& (09/17/:13)
& (10/23/:59)
　　　同意评论声明
　　　发表
尊重网上道德，遵守中华人民共和国的各项有关法律法规
承担一切因您的行为而直接或间接导致的民事或刑事法律责任
本站管理人员有权保留或删除其管辖留言中的任意内容
本站有权在网站内转载或引用您的评论
参与本评论即表明您已经阅读并接受上述条款How to Install Oracle 11g on Linux with ASM
& How to Install Oracle 11g on Linux with ASM
Table of Contents
ASK A QUESTION, ANSWER A QUESTION. CHECK OUT OUR NEW
Background & Overview
The following documentation provides instructions for building an Oracle 11g database with ASM residing on an Oracle Linux Server (Version 5.3, Kernal version 2.6.18). Use the command lsb_release -id to check the Oracle Linux OS version and uname -r to check the Kernal level.
Further reference documentation about Oracle 11g and Oracle Linux is detailed in the
section below.
Assumptions & Pre-Requisites
This document expects and assumes the following:
The instructions are carried out by a qualified DBA.
Access to the internet is available.
All necessary client software, e.g. Telnet and X-Server is available.
The resultant database will be standalone, i.e. not part of a cluster or failover configuration.
Documentation for clustered (RAC) configurations can be found here. - Add link when documentation available_
Documentation for failover configurations can be found here. - Add link when documentation available
All references to SID should be replaced with correct database name as derived using a suitable database naming standard.
All $variable references assume the .profile as described in the
section has been implemented and run.
There is only ONE database installed on the server.
Useful Information
This section outlines useful information and changes to previous 10g documentation found on this site. Some have been made for cosmetic reasons, others for more practical considerations.
A new deinstallation tool is used for deinstalling Oracle software and databases. See
section below.
On Linux the oratab and the oraInst.loc file is kept in directory /etc.
A new directory structure exists. .
A new init.ora parameter called diag_dest has been set and maps to the diag directory in the new directory structure mentioned above.
A listener.ora file has a new parameter called ADR_BASE_LISTENER. This maps to the base of the diag directory.
There are a number of new maintenance jobs in 11g. These will be turned off as part of this step-by-step guide.
In order to get the database working with ASM, Oracle Grid Infrastructure will need to be installed. This should not be mistaken for Oracle Grid Control. The following guide explains how to install Oracle Grid Infrastructure and any pre-requisite packages like ASMLIB.
section below.
At the time of writing this guide there are no supported Veritas Cluster agents for database version 11.2.
Step-By-Step Guide
1. Get a UNIX administrator to check the following Metalink article
to ensure that the SE Linux build meets Oracle's requirements.
2. Ensure oracle account and dba group exists.
3. Ensure the Oracle Linux version is 5.3 or higher.
lsb_release -id
4. Ensure the Oracle Linux Kernal version is 2.6.18 or higher.
5. Ask a UNIX administrator to check that the correct OS packages have been installed as detailled in the
section below.
6. Ensure that SHMMAX is set to 4Gb minus 1 byte. This is to accomodate feature/bug detailled in Metalink nore .
grep -i shmmax /etc/sysctl.conf
7. Ensure net.ipv4.ip_local_port_range is set to 9000 to 65500
8. Get a Unix administrator to set the machine to permissive mode.
setenforce 0
9. Check the machine is in permissive mode.
getenforce
NB This is required due to a bug/feature in Oracle.
10. Ensure /dev/shm is large enough. It should be set to the size of the physical RAM minus 4GB. (or an appropriate amount reserved for the OS)
cd /dev/shm
11. Ask a Unix administrator to install ASMLIB. At the time of writing this guide, the following Linux package had been identified by the Unix team, oracleasm-2.6.18-128.4.1.0.1.el5-2.0.5-1.el5.x86_64.rpm. This will install the follwing ASM 2.0 libraries
oracleasmlib-2.0 ~ The ASM libraries
oracleasm-support-2.0 ~ Utilities needed to administer ASMLib
oracleasm ~ A kernel module for the ASM library
12. Ask a Unix administrator to create a single partition on each device to be used by ASM.
fdisk /dev/mapper/& alias &
kpartx /dev/mapper/& alias && partition &
13. Ask a Unix administrator to create the ASM disks
oracleasm createdisk & disk label & /dev/mapper/& alias && partition &
14. Create and run .profile - see
section below.
15. Ensure the database file systems have been created with correct permissions and have been sized appropriately for the application. - see
section below.
16. Download the latest oracle binaries from . For example:
Enterprise Edition for Linux Operating System (64-bit)
linux.x64_11gR2_database_1of2.zip : 1,239,269,270 cksum -
linux.x64_11gR2_database_2of2.zip : 1,111,416,131 cksum -
linux.x64_11gR2_grid.zip : 1,052,897,657 cksum -
17. Unzip the downloaded files using the following commands
cd /u01/app/oracle/software/
unzip &filename&
18. Configure the DISPLAY variable.
19. Unset the ORACLE_HOME and TNS_ADMIN
unset ORACLE_HOME
unset TNS_ADMIN
20. Set the ORACLE_BASE
export ORACLE_BASE=/u01/app/oracle
21. Ensure ORACLE_HOME/bin is NOT in the PATH
22. Start x-server.
23. Start the installer.
cd /u01/app/oracle/software/grid
./runInstaller
24. Follow the instructions as demonstrated in the
section below.
Before continuing apply any oneoff patches or patch bundles or CPU patch bundles recommended by Oracle or the application vendor.
25. Create additional ASM Disk Groups
sqlplus '/ as sysasm'
SQL& create diskgroup FRA EXTERNAL REDUNDANCY
SQL& disk 'ORCL:asm disk label' ;
26. Create the ADM aliases
sqlplus '/ as sysasm'
SQL& alter diskgroup DATA add directory '+DATA/&SID&';
SQL& alter diskgroup FRA add directory '+FRA/& SID &';
SQL& alter diskgroup FRA add directory '+FRA/& SID &/arch';
27. Alter the disk group attributes to 11.2 compatability.
sqlplus '/ as sysasm'
SQL& alter diskgroup DATA set attribute 'compatible.asm'='11.2';
SQL& alter diskgroup DATA set attribute 'compatible.rdbms'='11.2';
SQL& alter diskgroup FRA set attribute 'compatible.asm'='11.2';
SQL& alter diskgroup FRA set attribute 'compatible.rdbms'='11.2';
28. Disable the high availability services.
crsctl disable has
29. Create the ASM init.ora.
Using vi create file $ORACLE_HOME/dbs/init+ASM.ora as defined in the
section below.
30. Create a password file for ASM
cd $ORACLE_HOME/dbs
rm orapw+ASM
orapwd file=orapw+ASM password=password
31. Shutdown ASM
sqlplus '/ as sysasm'
SQL& shutdown immediate
32. Startup ASM on the new pfile and create an spfile
sqlplus '/ as sysasm'
SQL& startup pfile='$ORACLE_HOME/dbs/init+ASM.ora'
SQL& create spfile='+DATA' from pfile='$ORACLE_HOME/dbs/init+ASM.ora';
SQL& shutdown immediate
33. Remove old init.ora files
cd $ORACLE_HOME/dbs
rm init.ora
rm init+ASM.ora
34. Startup ASM on the new spfile
sqlplus '/ as sysasm'
SQL& startup
35. Enable, Stop and Start the High Availability Service.
crsctl enable has
crsctl stop has
crsctl start has
36. Configure the DISPLAY variable.
37. Unset the ORACLE_HOME and TNS_ADMIN
unset ORACLE_HOME
unset TNS_ADMIN
38. Start x-server.
39. Start the installer.
cd /u01/app/oracle/software/database
./runInstaller
40. Follow the instructions as demonstrated in the
section below.
Before continuing apply any oneoff patches or patch bundles or CPU patch bundles recommended by Oracle or the application vendor.
41. Configure /etc/oratab file and test using . oraenv command - see
section below.
42. Configure $ORACLE_BASE/admin/SID/create/createdb.sql file, adjusting parameters accordingly - see
section below.
43. Configure $ORACLE_BASE/admin/SID/pfile/initSID.ora file, adjusting parameters accordingly and create symbollic link to it from $ORACLE_HOME/dbs - see
section below.
44. Remove template init.ora file from $ORACLE_HOME/dbs.
45. Configure Oracle environment variables using the following commands:
46. Set-up a $ORACLE_HOME/network/admin/listener.ora file as detailed in the
47. Start the listener using the command lsnrctl start.
48. Build the embryo database using the following commands:
cd $ORACLE_HOME/dbs
orapwd file=orapwSID password=&password&
cd $ORACLE_BASE/admin/SID/create
sqlplus '/ as sysdba'
SQL& @createdb.sql
Enter SYS password.
Enter SYSTEM password.
Enter SID name.
Wait for database to build - this may take up to 30 mins…
Confirm there are no unexpected errors in $ORACLE_BASE/admin/SID/create/createdb.log.
SQL& connect / as sysdba
SQL& CREATE SPFILE='/u01/app/oracle/admin/SID/pfile/spfileSID.ora' FROM PFILE='/u01/app/oracle/admin/SID/pfile/initSID.ora';
SQL& shutdown immediate
rm initSID.ora
ln -s /u01/app/oracle/admin/SID/pfile/spfileSID.ora spfileSID.ora
sqlplus '/ as sysdba'
SQL& startup
49. Disable the default 11g maintenance jobs.
sqlplus /nolog
SQL& connect sys as sysdba
SQL& BEGIN
SQL& dbms_auto_task_admin.disable(client_name =& 'auto optimizer stats collection', operation =& NULL,window_name =& NULL);
SQL& dbms_auto_task_admin.disable(client_name =& 'auto space advisor', operation =& NULL, window_name =& NULL);
SQL& dbms_auto_task_admin.disable(client_name =& 'sql tuning advisor', operation =& NULL, window_name =& NULL);
50. Confirm database has been recognised by the listener using the command lsnrctl status - this may take a minute or so to occur.
51. Remove unwanted files
cd $TNS_ADMIN
rm -rf samples
52. Configure $TNS_ADMIN/tnsnames.ora file, adjusting parameters accordingly - see
section below.
53. Confirm connections via SQLnet are working using the following commands:
sqlplus system/&password&@SID
How to Disable Oracle HAS
1. Disable Oracle HAS
crsctl disable has
Security Compliance
The following steps should be performed once the database has been built to ensure that the environment conforms to Oracle's Best Practices and also ensures that it doesn't fall foul of Internal Audit.
1. Remove the GRANT EXECUTE TO PUBLIC privilege from potentially harmful packages.
sqlplus '/ as sysdba'
SQL& revoke execute on utl_
SQL& revoke execute on dbms_
SQL& revoke execute on utl_
SQL& revoke execute on utl_
SQL& revoke execute on utl_
2. Ensure the following user-ids' passwords, where applicable, have been changed:
1. Adjust the database DEFAULT TABLESPACE settings so that the SYSTEM tablespace is not used inappropriately.
sqlplus '/ as sysdba'
SQL& alter database defa
SQL& alter user sys defau
SQL& alter user system defau
2. Correct any users that already have SYSTEM as their DEFAULT TABLESPACE
sqlplus '/ as sysdba'
SQL& select username, default_tablespace from dba_users where default_tablespace = 'SYSTEM';
SQL& alter user &user name& default tablespace &non-SYSTEM tablespace&;
3. Lock and expire potentially harmful built-in user-ids.
sqlplus '/ as sysdba'
SQL& alter user outln password
SQL& alter user dbsnmp password
Regression
To restore the environment back to its initial state, perform the following
1. Shutdown the database and listener.
2. Remove all database files, binaries, trace files and administration logs using the deinstall tool - see
File Listings
oracle .profile
#----------------------------------------------------------------------
# Configure Terminal Settings.
#----------------------------------------------------------------------
stty susp ^Z
stty quit ^C
stty erase ^H
export TERM=vt100-w
export ORACLE_TERM=vt100
#----------------------------------------------------------------------
# Configure Shell Settings.
#----------------------------------------------------------------------
export PATH=/bin:/usr/sbin:/usr/bin:/usr/local/bin:/usr/ccs/bin:$PATH
export EDITOR=vi
export HOSTNAME=‘hostname`
export PS1=’$LOGNAME@$HOSTNAME:$ORACLE_SID& '
export TMPDIR=/tmp
export TEMP=/tmp
#----------------------------------------------------------------------
# Configure Aliases.
#----------------------------------------------------------------------
alias ll=&ls -la&
alias bdf=&df -k&
#----------------------------------------------------------------------
# Configure Oracle Settings.
#----------------------------------------------------------------------
export ORACLE_BASE=/u01/app/oracle
export SQLPATH=$ORACLE_BASE/scripts/sql
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORACLE_HOME_LISTNER=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORATAB=/etc/oratab
SID:/u01/app/oracle/product/11.2.0/dbhome_1:Y
+ASM:/u01/app/oracle/product/11.2.0/grid:N
listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = &SID&)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(SID_NAME = &SID&)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = &hostname&)(PORT = 1521))
ADR_BASE_LISTENER = /u01/app/oracle
ASM Parameter File
###########################################
# Cache and I/O
###########################################
large_pool_size = 12m
###########################################
# ASM Instance Parameters
###########################################
instance_type = asm
asm_power_limit = 1
###########################################
# Security and Diagnostics
###########################################
remote_login_passwordfile = exclusive
diagnostic_dest = '/u01/app/oracle'
###########################################
# Disk Groups
###########################################
asm_diskstring = '/dev/oracleasm/disks/*'
asm_diskgroups = 'DATA','FRA'
initSID.ora
###########################################
# Cache and I/O
###########################################
db_block_size=8192
memory_target=
db_block_checking=MEDIUM
db_block_checksum='FULL'
###########################################
# Cursors and Library Cache
###########################################
open_cursors=500
###########################################
# Database Identification
###########################################
compatible='11.2.0.0.0'
db_name='SID'
###########################################
# Diagnostics and Statistics
###########################################
diagnostic_dest='/u01/app/oracle'
###########################################
# File Configuration
###########################################
control_files='+DATA/SID/control01.ctl','+DATA/SID/control02.ctl','+DATA/SID/control03.ctl'
###########################################
# Processes
###########################################
processes=1000
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_tablespace='UNDO'
###########################################
# Security and Auditing
###########################################
audit_trail='db'
remote_login_passwordfile='EXCLUSIVE'
###########################################
# Enabling Archivelog mode
###########################################
log_archive_dest='+FRA/SID/arch/d1'
log_archive_format=arch_%t_%s_%r.log
###########################################
# Defer Segment Creation
###########################################
deferred_segment_creation=FALSE
createdb.sql
-- Title : createdb.sql
-- Description : Build an empty database.
-- Usage/Notes : For use with 11g databases.
-- Required answers for SYS,
-- SYSTEM and SID.
ACCEPT syspw PROMPT 'Enter SYS password : '
ACCEPT systpw PROMPT 'Enter SYSTEM password : '
ACCEPT sid PROMPT 'Enter SID name : '
SET VERIFY OFF
SET ECHO ON
SPOOL createdb.log
STARTUP NOMOUNT
CREATE DATABASE &sid
USER SYS IDENTIFIED BY &syspw
USER SYSTEM IDENTIFIED BY &systpw
MAXDATAFILES 1024
MAXINSTANCES 1
MAXLOGFILES 32
MAXLOGMEMBERS 4
MAXLOGHISTORY 100
CHARACTER SET AL32UTF8
ARCHIVELOG
DATAFILE '+DATA/&sid/system_01.dbf'
EXTENT MANAGEMENT LOCAL
SYSAUX DATAFILE '+DATA/&sid/sysaux_01.dbf'
GROUP 1 ('+DATA/&sid/redo001a.dbf','+FRA/&sid/redo001b.dbf')
GROUP 2 ('+DATA/&sid/redo002a.dbf','+FRA/&sid/redo002b.dbf')
GROUP 3 ('+DATA/&sid/redo003a.dbf','+FRA/&sid/redo003b.dbf')
GROUP 4 ('+DATA/&sid/redo004a.dbf','+FRA/&sid/redo004b.dbf')
UNDO TABLESPACE undo
DATAFILE '+DATA/&sid/undo_01.dbf'
DEFAULT TEMPORARY TABLESPACE temp
TEMPFILE '+DATA/&sid/temp_01.dbf'
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1m
SET ECHO OFF
PROMPT Now running CATALOG. Please wait….
SET TERMOUT OFF
@${ORACLE_HOME}/rdbms/admin/catalog
SET TERMOUT ON
PROMPT Now running CATBLOCK. Please wait….
SET TERMOUT OFF
@${ORACLE_HOME}/rdbms/admin/catblock
SET TERMOUT ON
PROMPT Now running CATPROC. Please wait….
SET TERMOUT OFF
@${ORACLE_HOME}/rdbms/admin/catproc
SET TERMOUT ON
SET ECHO ON
CREATE TABLESPACE tools
DATAFILE '+DATA/&sid/tools_01.dbf' SIZE 400m
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE users
DATAFILE '+DATA/&sid/users_01.dbf' SIZE 400m
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
CREATE TABLESPACE indx
DATAFILE '+DATA/&sid/indx_01.dbf' SIZE 400m
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
CREATE USER ops$oracle IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE users
GRANT DBA TO ops$oracle
CONN system/&systpw
SET ECHO OFF
PROMPT Now running PUPBLD. Please wait….
SET TERMOUT OFF
@?/sqlplus/admin/pupbld.sql
SET TERMOUT ON
CONN system/&systpw
SET ECHO OFF
PROMPT Now running HLPBLD. Please wait….
SET TERMOUT OFF
@?/sqlplus/admin/hlpbld.sql
SET TERMOUT ON
SET ECHO ON
tnsnames.ora
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = &hostname&)(PORT = 1521))
(CONNECT_DATA = (SID = &SID&))
File Systems
--- /u01 --- /app --- /oraInventory
|aaaaaaaaaaaaaa|
|aaaaaaaaaaaaaa--- /oracle --- /software
|aaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaa--- /dba --- /scripts
|aaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaa|aaaaaaa--- /sql
|aaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaa--- /diag
|aaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaa--- /product ---/11.2.0 ---/dbhome_1
|aaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaa--- /product ---/11.2.0 ---/grid
|aaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaa--- /admin --- /SID --- /adump
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa--- /create
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa--- /exp
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa|aa (link to /u09)
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa--- /parfile
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa--- /pfile
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa--- /scripts ---/base ---/rfc
--- /u09 --- /oradata --- /SID -------- /exp ------- /d1
Example ASM Install
Select Install and Configure Grid Infrastructure for a Standalone Server
Click Next
Click Next
Set Disk Group Name to DATA
Ensure the Redundancy radio button is set to External
NB It is assumed that external disk infrastricture will mirror the disks. If not, review this option.
Ensure the Candidate Disk radio button is selected.
Tick the box next to the candidate disk(s) you wish to add to the disk group.
Click Next
Select Use same passwords for these accounts
Enter a valid password in the Specify Password box.
Enter a valid password in the Confirm Password box.
NB If you specified an insecure password, the following message will be displayed.
Set the ASM Database Administrator (OSDBA) Group to dba
Set the ASM Instance Administration Operator (OSOPER) Group to dba
Set the ASM Instance Administrator (OSASM) Group to dba
NB These options will be site specific and should be reviewed.
Click Next
Click Yes to continue.
Ensure Oracle Base is set to /u01/app/oracle
Click Next
Ensure the Inventory Directory is set to /u01/app/oraInventory
Click Next
Review the Summary screen
Click Finish
As root, ask the UNIX administrator to run /u01/app/oraInventory/orainstRoot.sh
As root, ask the UNIX administrator to run /u01/app/oracle/product/11.2.0/grid/root.sh
Click Close
Example Database Install
Un-tick the I wish to receive security updates via My Oracle Support box.
NB This is site specific and should be reviewed.
Click Next.
Click Yes to remain uninformed.
Select Install database software only.
Click Next.
Ensure Single instance database installation is selected.
Click Next.
Ensure languages Englsih and English (United Kingdom) are selected.
Click Next.
Ensure Enterprise Edition is selected.
Click Next.
Set Oracle Base to /u01/app/oracle
Allow Software Location to default
Click Next.
Ensure Database Administrator (OSDBA) Group is set to dba
Ensure Database Operator (OSOPER) Group is set to dba
Click Next
Review the summary.
If required save the response file by selecting Save Response File
Click Finish
This screen moves on automatically when complete.
Ask Unix Administrator to run root.sh. - Note: There is a known issue with running this script. See .
Click Close.
Other References
Known Issues
ORA-7445 [kokscold()+849]
Description
This is due to unpublished Bug 9594372, documented in Note
and occurs when running SQL_ANALYZE from a scheduled job. The SQL statement is likely to be similar to the following.
/* SQL Analyze(397,1) */ MERGE INTO MGMT_ARU_PATCH_RECOMMENDATIONS p USING ..
Apply patch 9594372
Running root.sh on the Database
Description
When running root.sh you are prompted for the local bin directory. The default directory is specified in square brackets. However, due to a bug in the root.sh script this default is not picked up. As a result, you will always need to specify the local bin directory regardless of the default specified within the square brackets.
Example Output
[root@myhost dbhome_1]# ./root.sh
Running Oracle 11g root.sh script…
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0/dbhome_1
Enter the full pathname of the local bin directory: [/usr/local/bin]: /usr/local/bin
The file &dbhome& already exists in /usr/local/bin. Overwrite it? (y/n)
Copying dbhome to /usr/local/bin …
The file &oraenv& already exists in /usr/local/bin. Overwrite it? (y/n)
Copying oraenv to /usr/local/bin …
The file &coraenv& already exists in /usr/local/bin. Overwrite it? (y/n)
Copying coraenv to /usr/local/bin …
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
Miscellaneous
OS Packages for Oracle Enterprise Linux v5
The following OS packages at the following minimum version should be installed on Oracle Enterprise Linux v5 before you start the Oracle software install.
Correct as of 01 September 2009
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5
glibc-devel-2.5
glibc-devel-2.5 (32 bit)
glibc-headers-2.5
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
sysstat-7.0.2
unixODBC-2.2.11
unixODBC-2.2.11 (32 bit)
unixODBC-devel-2.2.11
unixODBC-devel-2.2.11 (32 bit)
Removing an 11g Database
Use the following SQL script if you wish to remove just the 11g database. If you wish to remove both database and binaries, then use the deinstall tool, details of whcih can be found .
Shutdown the database and run the following SQL script logged onto ASM
alter diskgroup DATA drop file '+DATA/SID/system_01.dbf';
alter diskgroup DATA drop file '+DATA/SID/sysaux_01.dbf';
alter diskgroup DATA drop file '+DATA/SID/redo001a.dbf'
alter diskgroup DATA drop file '+DATA/SID/redo002a.dbf';
alter diskgroup DATA drop file '+DATA/SID/redo003a.dbf';
alter diskgroup DATA drop file '+DATA/SID/redo004a.dbf';
alter diskgroup FRA drop file '+FRA/SID/redo001a.dbf'
alter diskgroup FRA drop file '+FRA/SID/redo002a.dbf';
alter diskgroup FRA drop file '+FRA/SID/redo003a.dbf';
alter diskgroup FRA drop file '+FRA/SID/redo004a.dbf';
alter diskgroup DATA drop file '+DATA/SID/temp_01.dbf';
alter diskgroup DATA drop file '+DATA/SID/undo_01.dbf';
alter diskgroup DATA drop file '+DATA/SID/control01.ctl';
alter diskgroup DATA drop file '+DATA/SID/control02.ctl';
alter diskgroup DATA drop file '+DATA/SID/control03.ctl';
alter diskgroup FRA drop file '+FRA/SID/control01.ctl';
alter diskgroup FRA drop file '+FRA/SID/control02.ctl';
alter diskgroup FRA drop file '+FRA/SID/control03.ctl';
Deinstalling Oracle 11g Binaries and Database
With 11.2 the Oracle Universal Installer no longer removes Oracle software. Use the new deinstallation tool called deinstall available on the installation media before installation as well as in the Oracle home directory after installation.
Step-by-Step
1. Run this tool from ORACLE_HOME first.
cd $ORACLE_HOME/deinstall
./deinstall
When prompted for the database name enter the *SID* you want to remove.
NB This will remove the database binaries too.
When asked Do you still want to modify the details of SID database(s)? [n]: Answer N
NB You would answer Y if you wanted to amend the database configuration.
The tool should now complete okay after performing several tasks. See
An error will occur if there are any missing deinstall files at which point the tool prompts you to download the standalone version available in the deinstall directory on the installation media
Example Output
The following output is example output for removing a standalone database and the related binaries.
moc.niamodym.tsohym|elcaro#moc.niamodym.tsohym|elcaro:& ./deinstall
Checking for required files and bootstrapping …
Please wait …
Location of logs /u01/app/oracle/oraInventory/logs/
############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################## CHECK OPERATION START ########################
Install check configuration START
Checking for existence of the Oracle home location /u01/app/oracle/SID/product/11.2.0
Oracle Home type selected for de-install is: SIDB
Oracle Base selected for de-install is: /u01/app/oracle
Checking for existence of central inventory location /u01/app/oracle/oraInventory
Install check configuration END
Network Configuration check config START
Network de-configuration trace file location: /u01/app/oracle/oraInventory/logs/netdc_check265908.log
Network Configuration check config END
Database Check Configuration START
Database de-configuration trace file location: /u01/app/oracle/oraInventory/logs/databasedc_check3553666.log
Use comma as separator when specifying list of values as input
Specify the list of database names that are configured in this Oracle home [SID]: SID
###### For Database 'SID' ######
Single Instance Database
The diagnostic destination location of the database: /u01/app/oracle/SID/admin/SID/trace/diag/rdbms/SID
Storage type used by the Database: FS
Database file location: /u03/oradata/SID/users/d1,/u03/oradata/SID/tools/d1,/u03/oradata/SID/indx/d1,/u03/oradata/SID/system/d1,/u03/oradata/SID/sysaux/d1,/u04/oradata/SID/undo/d1
Flash recovery area location: /u10/oradata/SID/flash/d1/SID
database spfile location: /u01/app/oracle/SID/product/11.2.0/dbs/spfileSID.ora
The details of database(s) SID have been discovered automatically. Do you still want to modify the details of SID database(s)? [n]:
Database Check Configuration END
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: /u01/app/oracle/oraInventory/logs/emcadc_check.log
Checking configuration for database SID
Enterprise Manager Configuration Assistant END
Oracle Configuration Manager check START
OCM check log file location : /u01/app/oracle/oraInventory/logs//ocm_check3867.log
Oracle Configuration Manager check END
######################### CHECK OPERATION END #########################
####################### CHECK OPERATION SUMMARY #######################
Oracle Home selected for de-install is: /u01/app/oracle/SID/product/11.2.0
Inventory Location where the Oracle home registered is: /u01/app/oracle/oraInventory
The following databases were selected for de-configuration : SID
Database unique name : SID
Storage used : FS
No Enterprise Manager configuration to be updated for any database(s)
No Enterprise Manager ASM targets to update
No Enterprise Manager listener targets to migrate
Checking the config status for CCR
Oracle Home exists with CCR directory, but CCR is not configured
CCR check is finished
Do you want to continue (y - yes, n - no)? [n]: y
A log of this session will be written to: '/u01/app/oracle/oraInventory/logs/deinstall_deconfig_10-45-31-AM.out'
Any error messages from this session will be written to: '/u01/app/oracle/oraInventory/logs/deinstall_deconfig_10-45-31-AM.err'
######################## CLEAN OPERATION START ########################
Enterprise Manager Configuration Assistant START
EMCA de-configuration trace file location: /u01/app/oracle/oraInventory/logs/emcadc_clean.log
Updating Enterprise Manager ASM targets (if any)
Updating Enterprise Manager listener targets (if any)
Enterprise Manager Configuration Assistant END
Database de-configuration trace file location: /u01/app/oracle/oraInventory/logs/databasedc_clean6692780.log
Database Clean Configuration START SID
This operation may take few minutes.
Database Clean Configuration END SID
Network Configuration clean config START
Network de-configuration trace file location: /u01/app/oracle/oraInventory/logs/netdc_clean7065254.log
De-configuring Local Net Service Names configuration file…
Local Net Service Names configuration file de-configured successfully.
De-configuring backup files…
Backup files de-configured successfully.
The network configuration has been cleaned up successfully.
Network Configuration clean config END
Oracle Configuration Manager clean START
OCM clean log file location : /u01/app/oracle/oraInventory/logs//ocm_clean3867.log
Oracle Configuration Manager clean END
Oracle Universal Installer clean START
Detach Oracle home '/u01/app/oracle/SID/product/11.2.0' from the central inventory on the local node : Done
Delete directory '/u01/app/oracle/SID/product/11.2.0' on the local node : Done
The Oracle Base directory '/u01/app/oracle' will not be removed on local node. The directory is in use by Oracle Home '/u01/app/oracle/agent10g'.
The Oracle Base directory '/u01/app/oracle' will not be removed on local node. The directory is in use by central inventory.
Oracle Universal Installer cleanup was successful.
Oracle Universal Installer clean END
Oracle install clean START
Clean install operation removing temporary directory '/tmp/install' on node 'myhost'
Oracle install clean END
######################### CLEAN OPERATION END #########################
####################### CLEAN OPERATION SUMMARY #######################
Successfully de-configured the following database instances : SID
Cleaning the config for CCR
As CCR is not configured, so skipping the cleaning of CCR configuration
CCR clean is finished
Successfully detached Oracle home '/u01/app/oracle/SID/product/11.2.0' from the central inventory on the local node.
Successfully deleted directory '/u01/app/oracle/SID/product/11.2.0' on the local node.
Oracle Universal Installer cleanup was successful.
Oracle install successfully cleaned up the temporary directories.
#######################################################################
############# ORACLE DEINSTALL & DECONFIG TOOL END #############
Powered by
Unless otherwise stated, the content of this page is licensed under
Other interesting sites
A Site for Everyone Interested in Teaching and Learning
A Barrel Full of information for Oil Industry Professionals
Animation through Online Collaboration by students
Click here to edit contents of this page.
Click here to toggle editing of individual sections of the page (if possible).
Watch headings for an &edit& link when available.
Append content without editing the whole page source.
Check out how this page has evolved in the past.
If you want to discuss contents of this page - this is the easiest way to do it.
View and manage file attachments for this page.
A few useful tools to manage this Site.
See pages that link to and include this page.
Change the name (also URL address, possibly the category) of the page.
View wiki source for this page without editing.
View/set parent page (used for creating breadcrumbs and structured layout).
Notify administrators if there is objectionable content in this page.
Something does not work as expected? Find out what you can do.
documentation and help section.
Terms of Service - what you can, what you should not etc.
Privacy Policy.