Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Oracle 12c Silent Mode Binary Install and De-install

-
Installation of the Oracle Binaries is a pretty simple task for the DBA’s. However the process may become exhaustive if you are repeatedly performing these installs on a number of servers. For this you can speed up the installation process by using the silent mode installation. This allows you to install the Oracle software without using the graphical interactive mode. In this article we will look at Installing and De-Installing Oracle 12c database software, using the silent mode.

Oracle 12c Silent Mode Binary Install

When invoking the command line runInstaller de-install option, some mandatory arguments should be provided which are the minimum requirements for the installation. In case of 12c, an example is that of new database roles which should be mapped to an OS group. Failing to map these groups will result in error.
In the example below we will use Software only option for the install. You can also place all these parameters in a response file and provide the file path in command line, as below.
 $./runInstaller oracle.install.option=INSTALL_DB_SWONLY \
>     ORACLE_BASE=/u01/app/oracle \
>     ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 \
>     UNIX_GROUP_NAME=oinstall \
>     oracle.install.db.DBA_GROUP=dba \
>     oracle.install.db.OPER_GROUP=oper \
>     oracle.install.db.BACKUPDBA_GROUP=dba \
>     oracle.install.db.DGDBA_GROUP=dba \
>     oracle.install.db.KMDBA_GROUP=dba \
>     FROM_LOCATION=../stage/products.xml \
>     INVENTORY_LOCATION=/u01/app/oraIventory \
>     SELECTED_LANGUAGES=en \
>     oracle.install.db.InstallEdition=EE \
>     DECLINE_SECURITY_UPDATES=true  -silent -waitForCompletion

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB.   Actual 39852 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 3989 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-11-21_08-35-42PM. Please wait ...[WARNING] [INS-35342] The specified group for Database Operator (OSOPER) group (Optional): may not be defined in the system.

CAUSE: The OS group you specified as Database Operator (OSOPER) group (Optional): may not be configured on the server, or in the Network Information Service (NIS).
ACTION: Check the group name you selected, and specify a different group, or create the group on the server or in the Network Information Service.

You can find the log of this install session at:
/u01/app/oraIventory/logs/installActions2013-11-21_08-35-42PM.log

The installation of Oracle Database 12c was successful.
Please check '/u01/app/oraIventory/logs/silentInstall2013-11-21_08-35-42PM.log' for more details.

As a root user, execute the following script(s):

1. /u01/app/oraIventory/orainstRoot.sh
2. /u01/app/oracle/product/12.1.0/dbhome_1/root.sh
Successfully Setup Software.


$ su
Password:

# . /u01/app/oraIventory/orainstRoot.sh
Changing permissions of /u01/app/oraIventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraIventory to oinstall.

The execution of the script is complete.

# . /u01/app/oracle/product/12.1.0/dbhome_1/root.sh
Check /u01/app/oracle/product/12.1.0/dbhome_1/install/root_localhost.localdomain_2013-11-21_20-44-27.log for the output of root script.

De-Installing Database Binaries

Prior to 12c, if you wanted to de-install the database software, you would have to download the de-install utility. But in 12c the de-install utility has been made part of database software itself. You can run the de-install utility by invoking the runInstaller with the deinstall switch. In the example below we will de-install the oracle software installed at /u01/app/oracle/product/12.1.0/dbhome_1.
You will be asked to provide confirmation of components to de-configuration like LISTENER, Database itself.
   $ ./runInstaller -deinstall -home /u01/app/oracle/product/12.1.0/dbhome_1/
Checking for required space in /tmp directory ...
Please wait ...
Space check on /tmp directory passed...
Bootstrapping the deinstall components...Done
Location of logs /u01/app/oraInventory/logs/

############ ORACLE DEINSTALL & DECONFIG TOOL START ############
######################### CHECK OPERATION START #########################

## [START] Install check configuration ##
Checking for existence of the Oracle home location /u01/app/oracle/product/12.1.0/dbhome_1
Oracle Home type selected for deinstall is: Oracle Single Instance Database
Oracle Base selected for deinstall is: /u01/app/oracle
Checking for existence of central inventory location /u01/app/oraInventory
Checking for sufficient temp space availability on node(s) : 'localhost.localdomain'
## [END] Install check configuration ##

Network Configuration check config START
Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_check2013-11-20_08-51-35-PM.log
Specify all Single Instance listeners that are to be de-configured [LISTENER]:
Network Configuration check config END
Database Check Configuration START
Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_check2013-11-20_08-51-41-PM.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 [cdb12c]:

###### For Database 'cdb12c' ######
Single Instance Database
The diagnostic destination location of the database: /u01/app/oracle/diag/rdbms/cdb12c
Storage type used by the Database: FS
Database file location: /u01/app/oracle/oradata/cdb12c,/u01/app/oracle/fast_recovery_area/cdb12c
Fast recovery area location: /u01/app/oracle/fast_recovery_area/CDB12C
database spfile location: /u01/app/oracle/product/12.1.0/dbhome_1/dbs/spfilecdb12c.ora
The details of database(s) cdb12c have been discovered automatically. Do you still want to modify the details of cdb12c database(s)? [n]:
Database Check Configuration END

Oracle Configuration Manager check START
OCM check log file location : /u01/app/oraInventory/logs//ocm_check274.log
Oracle Configuration Manager check END

######################### CHECK OPERATION END #########################
####################### CHECK OPERATION SUMMARY #######################
Oracle Home selected for deinstall is: /u01/app/oracle/product/12.1.0/dbhome_1
Inventory Location where the Oracle home registered is: /u01/app/oraInventory
Following Single Instance listener(s) will be de-configured: LISTENER
The following databases were selected for de-configuration : cdb12c
Database unique name : cdb12c
Storage used : FS
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/oraInventory/logs/deinstall_deconfig2013-11-20_08-51-31-PM.out'
Any error messages from this session will be written to: '/u01/app/oraInventory/logs/deinstall_deconfig2013-11-20_08-51-31-PM.err'

######################## CLEAN OPERATION START ########################
Database de-configuration trace file location: /u01/app/oraInventory/logs/databasedc_clean2013-11-20_08-52-21-PM.log
Database Clean Configuration START cdb12c
This operation may take few minutes.
Database Clean Configuration END cdb12c
Network Configuration clean config START
Network de-configuration trace file location: /u01/app/oraInventory/logs/netdc_clean2013-11-20_08-57-03-PM.log
De-configuring Single Instance listener(s): LISTENER
De-configuring listener: LISTENER
Stopping listener: LISTENER

Warning: Failed to stop listener. Listener may not be running.

Deleting listener: LISTENER
Listener deleted successfully.
Listener de-configured successfully.

De-configuring Listener configuration file...
Listener 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/oraInventory/logs//ocm_clean274.log
Oracle Configuration Manager clean END

Setting the force flag to false
Setting the force flag to cleanup the Oracle Base
Oracle Universal Installer clean START

Detach Oracle home '/u01/app/oracle/product/12.1.0/dbhome_1' from the central inventory on the local node : Done
Delete directory '/u01/app/oracle/product/12.1.0/dbhome_1' 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/product/12.1.0/oggcore_1'.
Oracle Universal Installer cleanup was successful.
Oracle Universal Installer clean END

## [START] Oracle install clean ##
Clean install operation removing temporary directory '/tmp/deinstall_bootstrap' on node 'localhost'
## [END] Oracle install clean ##

######################### CLEAN OPERATION END #########################
####################### CLEAN OPERATION SUMMARY #######################

Successfully de-configured the following database instances : cdb12c

Following Single Instance listener(s) were de-configured successfully: LISTENER

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/product/12.1.0/dbhome_1' from the central inventory on the local node.
Successfully deleted directory '/u01/app/oracle/product/12.1.0/dbhome_1' on the local node.

Oracle Universal Installer cleanup was successful.

Run 'rm -rf /opt/ORCLfmap' as root on node(s) 'localhost' at the end of the session.

Oracle deinstall tool successfully cleaned up temporary directories.

####################################################################
############# ORACLE DEINSTALL & DECONFIG TOOL END #############

Comments

Post a Comment

Popular posts from this blog

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

-
Method 1 You can check the mode of the server using "pg_controldata". [pgsql@test~]$ pg_controldata /usr/local/pgsql/data84/ Database cluster state: in archive recovery --> This is Standby Database Database cluster state: in production --> This is Production Database [Master] Method 2 You can use pg_is_in_recovery() which returns True if recovery is still in progress(so the server is running in standby mode or slave) postgres=# select pg_is_in_recovery(); pg_is_in_recovery ------------------- t (1 row) If Return    false   so the server is running in primary mode or master postgres=# select pg_is_in_recovery(); pg_is_in_recovery ------------------- f (1 row)
Read more

7 Steps to configure BDR replication in postgresql

-
Image
 The  BDR  (Bi-Directional Replication) project adds multi-master replication to PostgreSQL 9.4.  Postgres-BDR has a lower impact on the masters(s) than trigger-based replication solutions. There is no write-amplification, as it does not require triggers to write to queue tables in order to replicate writes.   Here We are using  postgres version 9.4.12 and bdr version 1.0.2. for configuring  multi master replication . Simply Following 7 steps you can configure the multi master replication in postgresql. To download the bdr in below link. .   https://github.com/2ndQuadrant/bdr/archive/bdr-pg/REL9_4_12-1.tar.gz $ tar -xzvf REL9_4_12-1.tar.gz $ wget https://github.com/2ndQuadrant/bdr/archive/bdr-plugin/1.0.2.tar.gz $ tar -xzvf 1.0.2.tar.gz 1. To install BDR. $ cd ~/bdr-bdr-pg-REL9_4_12-1 $ ./configure --prefix=/usr/lib/postgresql/9.4 --enable-debug --with-openssl $ make -j4 -s install-world $ cd ~/bdr-bdr-plugin-1.0.2 $ PATH=/usr/lib/postgresql/9.4/bin:"$PATH" ./c
Read more

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

-
In this post, I am sharing few important function for finding the size of database, table and index in PostgreSQL. Finding object size in postgresql database is very important and common. Is it very useful to know the exact size occupied by the object at the tablespace. The object size in the following scripts is in GB. The scripts have been formatted to work very easily with PUTTY SQL Editor. 1. Checking table size excluding table dependency: SELECT pg_size_pretty(pg_relation_size('mhrordhu_shk.mut_kharedi_audit')); pg_size_pretty ---------------- 238 MB (1 row) 2. Checking table size including table dependency: SELECT pg_size_pretty(pg_total_relation_size('mhrordhu_shk.mut_kharedi_audit')); pg_size_pretty ---------------- 268 MB (1 row) 3. Finding individual postgresql database size SELECT pg_size_pretty(pg_database_size('db_name')); 4. Finding individual table size for postgresql database -including dependency index: SELECT pg_size_pretty(pg_total_rel
Read more

Ora2PG - Oracle/MySQL to Postgres DB migration Version 20.0

-
Ora2Pg is a free tool used to  migrate  an  Oracle  or MySQL database to a  PostgreSQL  compatible schema. It connects your  Oracle  database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into your  PostgreSQL  database. ora2pg version 20.0 software : ora2pg-20.0.tar ora2pg-20.0   https://github.com/darold/ora2pg/releases/tag/v20.0 Some Blogs about DB Migration : https://2ndquadrant.in/postgresmigration/oracle-to-postgresql-migration/ https://2ndquadrant.in/database-migration-from-oracle-to-postgres/ INSTALLATION All Perl modules can always be found at CPAN ( http://search.cpan.org/ ). Just type the full name of the module (ex: DBD::Oracle) into the search input box, it will brings you the page for download. Releases of Ora2Pg stay at SF.net ( https://sourceforge.net/projects/ora2pg/ ). Under Windows you should install Strawberry Perl ( http://strawberryperl.com/ ) and the OSes corresponding Oracle clients. I
Read more

PostgreSQL Introduction

-
PostgreSQL tutorial provides basic and advanced concepts of SQL. Our PostgreSQL tutorial is designed for beginners and professionals. PostgreSQL is an opens-source object-relational database management system (ORDBMS). Our PostgreSQL tutorial includes all topics of PostgreSQL language such as create database, create table, drop database, drop table, select database, select table, insert record, update record, delete record, triggers, functions, procedures, cursors etc. There are also given PostgreSQL interview questions and quizzes to help you better understand the PostgreSQL language. Prerequisite: Before you start doing practice with various types of examples given in this reference, I'm making an assumption that you are already aware about what is database, especially RDBMS and what is a computer programming language. you must have the basic knowledge of SQL Problem: We assure that you will not find any problem in this PostgreSQL tutorial. But if there is any mistake
Read more