Follow the link.
Amazing steps by WikiDot. Just click on the link
12c Install and ASM on REDHAT
Amazing steps by WikiDot. Just click on the link
12c Install and ASM on REDHAT
Background & Overview
The following documentation provides instructions for building an Oracle 12c database with ASM residing on RedHat (Version 6.7, Kernel version 2.6.32). Use the command cat /etc/*release* to check the Oracle Linux OS version and uname -r to check the Kernel level.
Further reference documentation about Oracle 12c and Oracle Linux is detailed in the Other References section below.
Assumptions
This document expects and assumes the following:
- The instructions are carried out by a qualified DBA.
- All necessary client software, e.g. Telnet and X-Server is 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 File Listings section has been implemented and run.
Useful Information
- Read the Known Issues section below.
Software
File Name | Description | Byte Count | MD5 Hash |
linuxamd64_12102_database_1of2.zip | Database Binaries File 1 | 1673544724 | 080435a40bd4c8dff6399b231a808e9a |
linuxamd64_12102_database_2of2.zip | Database Binaries File 2 | 1014530602 | 30f20ef9437442b8282ce3984546c982 |
linuxamd64_12102_grid_1of2.zip | Grid Infrastructure Binaries File 1 | 1747043545 | d793c2ba5db9008b79077bff8d27a219 |
linuxamd64_12102_grid_2of2.zip | Grid Infrastructure Binaries File 2 | 646972897 | 0e18a9abb80427baf18f85865b1ecd5d |
p20996835_121020_Linux-x86-64 | Grid Infrastructure and DB PSU | 1031691784 | F32C00880F4311A20D6D2174ABE95C38 |
p6880880_121010_Linux-x86-64 | OPatch Version 12.1.0.1.8 | 52853599 | f3978f9d719f8f345ca8cca386683a59 |
Step-By-Step Guide - Pre-Requisites
1. Ensure the Oracle Linux version is 6 or higher.
- cat /etc/*release*
2. Ensure the Oracle Linux Kernel version for both nodes is 2.6.18 or higher.
- uname -r
3. As a minimum ensure RedHat has the following packages installed on both nodes.
unzip (x86_64)
xorg-x11-utils-7.5-6.el6.x86_64
binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (i686)
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (i686)
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (i686)
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6 (i686)
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6 (i686)
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6 (i686)
libXext-1.1 (x86_64)
libXext-1.1 (i686)
libXtst-1.0.99.2 (x86_64)
libXtst-1.0.99.2 (i686)
libX11-1.3 (x86_64)
libX11-1.3 (i686)
libXau-1.0.5 (x86_64)
libXau-1.0.5 (i686)
libxcb-1.5 (x86_64)
libxcb-1.5 (i686)
libXi-1.3 (x86_64)
libXi-1.3 (i686)
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)
4. Set the kernel parameters in /etc/sysctl.conf for both nodes as follows. NOTE If the current value for any parameter is higher than the value listed below, do not change the value of that parameter.
shmmax - Half the server memory
shmmni - 4096 (or greater)
fs.file-max - 6815744 (or greater)
fs.aio-max-nr - 1048576 (or greater)
net.core.rmem_default - 262144 (or greater)
net.core.rmem_max - 4194304 or greater)
net.core.wmem_default - 262144 (or greater)
net.core.wmem_max - 1048576 (or greater)
sem - 250 32000 100 128 (or greater)
net.ipv4.ip_local_port_range - 9000 65535
5. Ensure oracle account and dba group exists on both nodes.
6. Update the following file /etc/security/limits.conf on both nodes.
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 20480
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768
7. Ensure the following line in the /etc/pam.d/login file existis on both nodes.
session required pam_limits.so
8. Create the .profile - see File Listings section below.
9. Install ASMLIB.
10. Create a single partition on each device to be used by ASM.
11. Create the ASM disks. For this installation the following disks will need to be created.
- asm-data01
- asm-fra01
- asm-redo01
- asm-redo02
12. Check to confirm the disk are set-up correctly
- /usr/sbin/oracleasm listdisks
13. Unzip the files
- Log on as Oracle
- cd /u01/app/oracle/SOFTWARE
- unzip linuxamd64_12102_database_1of2.zip
- unzip linuxamd64_12102_database_2of2.zip
- unzip linuxamd64_12102_grid_1of2.zip
- unzip linuxamd64_12102_grid_2of2.zip
- unzip p6880880_121010_Linux-x86-64
- unzip p20996835_121020_Linux-x86-64
Step-By-Step Guide - ASM Binary Installs
1. Log on to Oracle.
2. Unset ORACLE_HOME and GRID_HOME
- unset ORACLE_HOME
- unset GRID_HOME
- unset ORACLE_SID
- unset TNS_ADMIN
3. Install Grid Infrastructure Using the GUI
- cd /u01/app/oracle/SOFTWARE/grid
- ./runInstaller
4. Follow the instructions as detailed in the screenshots here
5. When prompted run the root scripts in the order specified
- Log on as root
- /u01/app/oraInventory/orainstRoot.sh
- /u01/app/oracle/product/12.1.0/grid/root.sh
Step-By-Step Guide - Configure ASM
1. Create the extra Disk Groups
- . oraenv
- ORACLE_SID = [oracle] ? +ASM
- sqlplus / as sysasm
- SQL> CREATE DISKGROUP FRA01 EXTERNAL REDUNDANCY DISK ‘/dev/asm-fra001′ ATTRIBUTE ‘COMPATIBLE.ASM’=’12.1.0.0.0′,’COMPATIBLE.RDBMS’=’12.1.0.0.0′,’AU_SIZE’=’4M';
- SQL> CREATE DISKGROUP REDO01 EXTERNAL REDUNDANCY DISK ‘/dev/asm-redo001′ ATTRIBUTE ‘COMPATIBLE.ASM’=’12.1.0.0.0′,’COMPATIBLE.RDBMS’=’12.1.0.0.0′,’AU_SIZE’=’4M';
- SQL> CREATE DISKGROUP REDO02 EXTERNAL REDUNDANCY DISK ‘/dev/asm-redo002′ ATTRIBUTE ‘COMPATIBLE.ASM’=’12.1.0.0.0′,’COMPATIBLE.RDBMS’=’12.1.0.0.0′,’AU_SIZE’=’4M';
2. Update parameter file with new Diskgroups
- SQL> ALTER SYSTEM SET ASM_DISKGROUPS=’FRA01′, ‘REDO01′, ‘REDO02′ SCOPE=BOTH SID=’+ASM’
3. Configure ASM to use huge pages
- . oraenv
- ORACLE_SID = [oracle] ? MYDB001
- SQL> sqlplus / as sysdba
- SQL> shutdown immediate;
- SQL> quit
- . oraenv
- ORACLE_SID = [oracle] ? +ASM
- SQL> sqlplus / as sysasm
- SQL> alter system set memory_max_target=0 scope=spfile sid=’*’;
- SQL> alter system set memory_target=0 scope=spfile sid=’*’;
- SQL> alter system set sga_target=1088M scope=spfile sid=’*’;
- SQL> alter system set use_large_pages=’ONLY’ scope=spfile sid=’*’;
- SQL> shutdown immediate;
- SQL> startup;
- SQL> quit
- . oraenv
- ORACLE_SID = [oracle] ? MYDB001
- SQL> sqlplus / as sysdba
- SQL> startup
Step-By-Step – Oracle Database Binary Install
1. Log on to Oracle
2. Unset variables
- unset ORACLE_BASE
- unset ORACLE_HOME
- unset GRID_HOME
- unset ORACLE_SID
- unset TNS_ADMIN
3. Install Database Software
- cd /u01/app/oracle/SOFTWARE/database
- ./runInstaller
4. Follow the instructions as detailed in the screenshots here and when prompted run root.sh.
- cd /u01/app/oracle/product/12.1.0/dbhome_1
- ./root.sh
5. Create a symbolic link for TNS directory entries to stop dbca from failing on DB creation and on crsct startup.
- cd /u01/app/oracle/product/12.1.0/dbhome_1/network/admin
- ln -s /u01/app/oracle/product/12.1.0/grid/network/admin/tnsnames.ora
- ln -s /u01/app/oracle/product/12.1.0/grid/network/admin/sqlnet.ora
- ln -s /u01/app/oracle/product/12.1.0/grid/network/admin/listener.ora
Step-By-Step – Oracle Database Creation
1. Log on to Oracle
2. Create the database using dbca
- cd /u01/app/oracle/product/12.1.0/dbhome_1/bin
- ./dbca
3. Follow the instructions as detailed in the screenshots here
Step-By-Step – Grid and Database Patching
1. Log on as Oracle
2. Install the latest version of OPatch in the GI home and DB home
- unzip p6880880_121010_Linux-x86-64.zip -d /u01/app/oracle/product/12.1.0/grid
- unzip p6880880_121010_Linux-x86-64.zip -d /u01/app/oracle/product/12.1.0/dbhome_1
3. Check the version of OPatch
- export ORACLE_HOME=/u01/app/oracle/product/12.1.0/grid
- $ORACLE_HOME/OPatch/opatch version
- export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
- $ORACLE_HOME/OPatch/opatch version
4. Validate the oraInventory
- export ORACLE_HOME=/u01/app/oracle/product/12.1.0/grid
- $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh /u01/app/oracle/product/12.1.0/grid
- export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
- $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh /u01/app/oracle/product/12.1.0/dbhome_1
5. Log on as root
6. Create a Grid OCM response file
- export ORACLE_HOME=/u01/app/oracle/product/12.1.0/grid
- $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /tmp/GI_ocm.rsp
- Press return when prompted for an email
- Answer “Yes” to remain uninformed of updates
7. Analyze the patch for conflicts with other patches already installed
- $ORACLE_HOME/OPatch/opatchauto apply /u01/app/oracle/SOFTWARE/20996835 -analyze -ocmrf /tmp/GI_ocm.rsp
8. Patch the Grid Infrastructure home and the Database Home
- $ORACLE_HOME/OPatch/opatchauto apply /u01/app/oracle/SOFTWARE/20996835 -ocmrf /tmp/GI_ocm.rsp
Step-By-Step – Database Configuration (Optional and Site Specific)
1. Log on as Oracle
2. Set some database options and rename the spfile in ASM
- . oraenv
- ORACLE_SID = [oracle] ? MYDB001
- SQL> sqlplus / as sysdba
- SQL> alter database flashback on;
- SQL> alter database force logging;
- SQL> alter system set cursor_sharing=force scope=spfile sid=’*';
- SQL> alter system set control_file_record_keep_time =14 scope=spfile sid=’*’;
- SQL> alter system set use_large_pages =’ONLY’ scope=spfile sid=’*’;
- SQL> BEGIN;
- SQL> exec dbms_auto_task_admin.disable(
- SQL> client_name => ‘auto optimizer stats collection’, operation => NULL, window_name => NULL);
- SQL> END;
- SQL> /
- SQL> create pfile=’/tmp/temporary.ora’ from spfile;
- SQL> shutdown immediate;
- SQL> startup pfile=’/tmp/temporary.ora’
- SQL> create spfile=’+DATA01/MYDB001/spfileMYDB001.ora’ from pfile=’/tmp/temporary.ora’
- SQL> shutdown immediate
- SQL> quit
- rm /tmp/temporary.ora
- cd $ORACLE_HOME/dbs
- echo “+DATA01/MYDB001/spfileMYDB001.ora” > initMYDB001.ora
- sqlplus / as sysdba
- SQL> startup
- SQL> show parameter spfile
- Check the new spfile has been picked up
- SQL> quit
- rman
- RMAN> connect target /
- RMAN> configure controlfile autobackup on;
- RMAN> quit
3. Implement DCD on the databases.
- cd $TNS_ADMIN
- vi sqlnet.ora
- Add the following line to the sqlnet.ora file.
- SQLNET.EXPIRE_TIME = 10
Security Compliance (Recommended, but optional)
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_file from public;
- SQL> revoke execute on dbms_random from public;
- SQL> revoke execute on utl_http from public;
- SQL> revoke execute on utl_smtp from public;
- SQL> revoke execute on utl_tcp from public;
- SQL> exit
2. Ensure the following user-ids' passwords, where applicable, have been changed:
- SYS
- SYSTEM
- DBSNMP
- OUTLN
- CTXSYS
- PERFSTAT
3. Adjust the database DEFAULT TABLESPACE settings so that the SYSTEM tablespace is not used inappropriately.
- sqlplus '/ as sysdba'
- SQL> alter database default tablespace users;
- SQL> alter user sys default tablespace system;
- SQL> alter user system default tablespace system;
4. 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>;
- SQL> exit
5. Lock and expire potentially harmful built-in user-ids.
- sqlplus '/ as sysdba'
- SQL> alter user &user_idpassword expire account lock;
- Repeat for each user as required.
- SQL> exit
Regression
To restore the environment back to its initial state, perform the following
1. Shutdown the environment
2. Remove all database files, binaries, trace files and administration logs using the deinstall tool - see Deinstall Section below.
File Listings
oracle .profile
#----------------------------------------------------------------------
# Configure Terminal Settings.
#----------------------------------------------------------------------
stty susp ^Z
stty quit ^C
stty erase ^?
export ORACLE_TERM=vt100
#----------------------------------------------------------------------
# Configure Shell Settings.
#----------------------------------------------------------------------
set -o vi
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
export TMOUT=7200
umask 022
#----------------------------------------------------------------------
# Configure Aliases.
#----------------------------------------------------------------------
alias ll="ls -la"
alias lt="ls -lrt|tail"
alias bdf="df -h"
#----------------------------------------------------------------------
# Configure Oracle Settings.
#----------------------------------------------------------------------
export ORACLE_BASE=/u01/app/oracle
export SQLPATH=$ORACLE_BASE/DBA/SQL
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
export OPATCH_LIB=/u01/app/oracle/SOFTWARE/OPATCH/OPatch
export PATH=$ORACLE_HOME/bin:$PATH:$OPATCH_LIB
export GRID_HOME==$ORACLE_BASE/product/12.1.0/grid
export TNS_ADMIN=$GRID_HOME/network/admin
oratab
MYDB001:/u01/app/oracle/product/12.1.0/dbhome_1:Y
+ASM1:/u01/app/oracle/product/12.1.0/grid:N
File Systems
--- /u01 --- /app --- /oraInventory
|aaaaaaaaaaaaaa|
|aaaaaaaaaaaaaa--- /oracle --- /software
|aaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaa--- /dba --- /scripts
|aaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaa|aaaaaaa--- /sql
|aaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaa--- /diag
|aaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaa--- /product ---/12.1.0 ---/dbhome_1
|aaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaa--- /product ---/12.1.0 ---/grid
|aaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaa--- /admin --- /SID --- /adump
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa|
|aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa--- /pfile
Example GRID Infrastructure Install
- Select Install and Configure Grid Infrastructure for a Standalone Server
- Click Next
- Select the languages you require. In this instance all languages have been chosen.
- Click Next
- Set Disk group name to DATA01
- Set Allocation Unit Size to 4MB
- Click Change Discovery Path
- Set Disk Discovery Path to /dev/asm (or to the path of your ASM LUNs)
- Click OK
- Ensure the radial button Candidate Disks is selected.
- Select the disks you want added to disk group DATA01 by ticking the box.
- Click Next
- Select the radial button Use same passwords for these accounts
- The passwords can be changed to something more suitable later.
- Click Next
- If presented with this screen click Yes
- As mentioned above, the passwords can be changed to something more suitable later
- For this installation no Grid Agent is going to be configured.
- Click NEXT
- In this installation the same OS group is going to be used. This may not be suitable for all environments.
- Set Oracle ASM Administrator (OSASM) Group to dba
- Set Oracle ASM DBA (OSDBA for ASM) Group to dba
- Set Oracle ASM Operator (OSOPER for ASM) Group (Optional) to dba
- Click Next
- If this is okay for the environment being built, click YES
- Ensure Oracle base is set to /u01/app/oracle
- Ensure Software location is set to /u01/app/oracle/product/12.1.0/grid
- The fields should already be populated with the above values.
- They can be changed, but it is recommended to keep the defaults.
- Click Next
- Ensure Inventory Directory is set to /u01/app/oraInventory
- The field should already be populated with the value above.
- The Inventory Directory can be changed, but it is recommended to keep the defaults.
- Click Finish
- In this environment the root password is known, so configuration scripts will be run automatically.
- Tick Automatically run configuration scripts
- Select the radial button Use "root" user credential
- Ensure the Password is set
- Click Next
- Wait for the verification process to complete.
- This screen will move on automatically.
- For demonstration purposes, this installation has some issues.
- The Fix & Check Again button can be used to fix any issues.
- Note that not all issues can be fixed and it may be necessary to refer the issues to a Unix Administrator
- Click Check Again when all issues have been resolved.
- Review this screen and click Install
- At this point a Response File can be saved by clicking Save Response File…
- A response file can be used for automated deployments.
- Wait for the installation to complete.
- This screen will move on automatically.
- Click Close
Example Database Binary 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.
- Select the languages you require. In this instance all languages have been chosen.
- Click Next
- Set Database edition to Enterprise Edition (6.4GB)
- Click Next
- Ensure Oracle base is set to /u01/app/oracle
- Ensure Software location is set to /u01/app/oracle/product/12.1.0/dbhome_1
- The fields should already be populated with the above values.
- They can be changed, but it is recommended to keep the defaults.
- Click Next
- In this installation different OS groups will be used. Optional groups will be left blank.
- This may not be suitable for all environments.
- Set Database Administrator (OSDBA) Group to dba
- Leave Database Operator (OSOPER) Group (Optional) blank.
- Set Database Backup and Recovery (OSBACKUPDBA) Group to bckpdba
- Set Data Guard administrative (OSDGDBA) Group to dgdba
- Set Encryption Key Management administrative (OSKMDBA) Group to kmdba
- Click Next
- Wait for the verification process to complete.
- This screen moves on automatically when complete.
- For demonstration purposes, this installation has some issues.
- The Fix & Check Again button can be used to fix any issues.
- Note that not all issues can be fixed and it may be necessary to refer the issues to a Unix Administrator
- Click Check Again when all issues have been resolved.
- Review this screen and click Install
- At this point a Response File can be saved by clicking Save Response File…
- A response file can be used for automated deployments.
- Wait for the installation process to complete.
- This screen will move on automatically.
- Get a UNIX administrator to run the Configuration Scripts as the root user.
- Click OK when the Configuration Scripts have completed successfully.
- Click Close
Example Database Creation
- Select Create Database
- Click Next.
- Select Advanced Mode.
- Click Next.
- Select General Purpose or Transaction Processing.
- Click Next.
- Set Global Database Name to MYDB001.MYDOMAIN.COM
- Ensure SID has been populated with MYDB001
- Click Next.
- For this installation no Grid Agent is going to be configured.
- Click Next
Set and confirm the passwords for the SYS and SYSTEM user.
Click Next
Click Next
- For this database, the GRID listener will be used. This may not be suitable for all environments.
- Tick the box alongside LISTENER
- Click Next
- Ensure Database files Storage Type is set to Automatic Storage Management (ASM)
- Select Use Common Location for All Database Files
- Set File Location to +DATA01
- Tick Use Oracle-Managed Files
- Ensure Recovery files Storage Type is set to Automatic Storage Management (ASM)
- Tick Specify Fast Recovery Area
- Set Fast Recovery Area to +FRA01
- Set the Fast Recovery Area Size to a suitable value
- Tick Enable Archiving
- Click Multiplex Redo Logs and Control Files…
- Set Location 1 to +REDO01
- Set Location 2 to +REDO02
- Click OK
- Click Next
- In this installation Sample Schemas and Database Vault & Label Security will be left as default.
- Click Next.
- For this installation Automatic Shared Memory Management will be used.
- Set SGA Size and PGA Size to suitable values.
- Click the Sizing tab.
- Set the Processes value to a suitable number for the environment.
- Click the Character Sets tab.
- These settings are dependent on the environment being built.
- Select Use Unicode (AL32UTF8) - Most systems would use this value.
- Set National Character Set to UTF8 - Unicode 3.0 UTF-8 Universal character set, CESU-8 compliant - Most systems would use this value.
- Set a Default Language
- Set a Default Territory
- Click the Connection Mode tab.
- Select Dedicated Server Mode
- Click All Initialization Parameters...
- Click Show Advanced Parameters
- Set the Initialization Parameters appropriately.
- In this installation the following parameters have been set in the DBCA GUI
- control_files have been set to use +DATA01 and +FRA01
- db_create_online_log_dest_1 has be set to use +REDO01
- db_create_online_log_dest_2 has be set to use +REDO02
- Click Close
- Click Next.
- Click Customize Storage Locations…
- Add additional REDO logs if required.
- Click Ok
- Tick Create Database
- If required at this point, a Database Template can be created by ticking Save as Database Template
- Set a Name for the Database Template if the Save as Database Template box has been ticked.
- The database creation scripts can be created by ticking Generate Database Creation Scripts
- Click Next
- Review the summary page
- Click Finish
- This screen will move on automatically.
- Set-up the passwords by clicking on Password Management if required.
- Click Close.
Other References
- None Currently
Known Issues
- None Currently
Deinstalling Oracle 12g Binaries and Database
With 12.1 the deinstallation tool is located 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.
2. Now run the tool from the GRID_HOME.
No comments:
Post a Comment