Db’i drop edip grid ve db home’unu deinstall ediyoruz ancak öncesinde “startup mount exclusive restrict” moduna geçmek isterken “ORA-02003: invalid USERENV parameter” hatasını alıyorsak init file’dan açabiliriz, ardından sağlıklı bir şekilde db’i drop edebiliriz.


[oracle@testdb01 scripts]$ cd $ORACLE_HOME
[oracle@testdb01 dbhome_1]$ cd ../..
[oracle@testdb01 product]$ ls -la
total 16
drwxr-xr-x. 4 oracle oinstall 4096 Aug 9 16:26 .
drwxr-xr-x. 13 oracle oinstall 4096 Aug 9 15:57 ..
drwxr-xr-x. 4 oracle oinstall 4096 Jan 24 2017 12.1.0
drwxr-xr-x 3 oracle oinstall 4096 Aug 9 10:48 12.2.0.1
[oracle@testdb01 product]$ cd 12.1.0
[oracle@testdb01 12.1.0]$ ls
dbhome_1 grid
[oracle@testdb01 12.1.0]$ cd dbhome_1/
[oracle@testdb01 dbhome_1]$ export ORACLE_HOME=/oracle/app/oracle/product/12.1.0/dbhome_1
[oracle@testdb01 dbhome_1]$ export ORACLE_SID=TESTDB
[oracle@testdb01 dbhome_1]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 10 09:16:00 2017

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00101: unknown parameter name '__inmemory_ext_roarea'
ORA-01078: failure in processing system parameters
LRM-00101: unknown parameter name '__inmemory_ext_roarea'
SQL> exit
Disconnected
[oracle@testdb01 dbhome_1]$ cd $ORACLE_HOME
[oracle@testdb01 dbhome_1]$ cd dbs
[oracle@testdb01 dbs]$ pwd
/oracle/app/oracle/product/12.1.0/dbhome_1/dbs
[oracle@testdb01 dbs]$ ls -la
total 17780
drwxr-xr-x. 2 oracle oinstall 4096 Aug 9 16:12 .
drwxr-xr-x. 75 oracle oinstall 4096 Aug 9 10:45 ..
-rw-rw----. 1 oracle oinstall 1544 Aug 9 16:19 hc_TESTDB.dat
-rw-r----- 1 oracle oinstall 63 Aug 9 15:20 initTESTDB.ora
-rw-r--r--. 1 oracle oinstall 2992 Feb 3 2012 init.ora
-rw-r-----. 1 oracle oinstall 24 Feb 17 2016 lkTESTDB
-rw-r-----. 1 oracle oinstall 7680 Feb 17 2016 orapwTESTDB
-rw-r----- 1 oracle oinstall 18169856 Aug 9 10:08 snapcf_TESTDB.f
[oracle@testdb01 dbs]$ cat initTESTDB.ora
SPFILE='+DATA01/TESTDB/PARAMETERFILE/spfile.273.904067065'
[oracle@testdb01 dbs]$ ORA-01078: failure in processing system parameters
-bash: ORA-01078:: command not found
[oracle@testdb01 dbs]$ LRM-00101: unknown parameter name '__inmemory_ext_roarea'
-bash: LRM-00101:: command not found
[oracle@testdb01 dbs]$ ORA-01078: failure in processing system parameters
-bash: ORA-01078:: command not found
[oracle@testdb01 dbs]$ 
[oracle@testdb01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 10 09:23:30 2017

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to an idle instance.

SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file '?/dbs/spfile@.ora'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3



SQL> select status from v$instance
 2 ;
select status from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0



SQL> 
SQL> startup mount pfile='/oracle/app/oracle/product/12.1.0/dbhome_1/dbs/initTESTDB.ora';
ORA-01078: failure in processing system parameters
LRM-00101: unknown parameter name '__inmemory_ext_roarea'

ORA-01078: failure in processing system parameters
SQL> startup mount exclusive restrict;
ORA-01078: failure in processing system parameters
LRM-00101: unknown parameter name '__inmemory_ext_roarea'
ORA-01078: failure in processing system parameters
LRM-00101: unknown parameter name '__inmemory_ext_roarea'
SQL> exit
Disconnected
[oracle@testdb01 dbs]$ . oraenv
ORACLE_SID = [TESTDB] ? +ASM
The Oracle base remains unchanged with value /oracle/app/oracle
[oracle@testdb01 dbs]$ export GRID_HOME=/oracle/app/oracle/product/12.1.0/grid
[oracle@testdb01 dbs]$ export ORACLE_HOME=/oracle/app/oracle/product/12.1.0/grid
[oracle@testdb01 dbs]$ echo $ORACLE_SID
+ASM
[oracle@testdb01 dbs]$ 
[oracle@testdb01 dbs]$ asmcmd
Connected to an idle instance.
ASMCMD> ls
ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run
ASMCMD> exit
[oracle@testdb01 dbs]$ sqlplus / as sysasm

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 10 09:34:18 2017

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-15149: another ASM instance found running on the host
SQL> exit
Disconnected
[oracle@testdb01 dbs]$ export ORACLE_HOME=/oracle/app/oracle/product/12.1.0/dbhome_1
[oracle@testdb01 dbs]$ export ORACLE_SID=TESTDB
[oracle@testdb01 dbs]$ echo $ORACLE_HOME
/oracle/app/oracle/product/12.1.0/dbhome_1
[oracle@testdb01 dbs]$ echo $ORACLE_SID
TESTDB
[oracle@testdb01 dbs]$ 
[oracle@testdb01 dbs]$ 
[oracle@testdb01 dbs]$ ls -la
total 17780
drwxr-xr-x. 2 oracle oinstall 4096 Aug 9 16:12 .
drwxr-xr-x. 75 oracle oinstall 4096 Aug 9 10:45 ..
-rw-rw----. 1 oracle oinstall 1544 Aug 9 16:19 hc_TESTDB.dat
-rw-r----- 1 oracle oinstall 63 Aug 9 15:20 initTESTDB.ora
-rw-r--r--. 1 oracle oinstall 2992 Feb 3 2012 init.ora
-rw-r-----. 1 oracle oinstall 24 Feb 17 2016 lkTESTDB
-rw-r-----. 1 oracle oinstall 7680 Feb 17 2016 orapwTESTDB
-rw-r----- 1 oracle oinstall 18169856 Aug 9 10:08 snapcf_TESTDB.f
[oracle@testdb01 dbs]$ vi initTESTDB.ora 
#SPFILE='+DATA01/TESTDB/PARAMETERFILE/spfile.273.904067065'

*.audit_file_dest='/orC
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='+DATA01/TESTDB/CONTROLFILE/current.262.904066929','+DATA01/TESTDB/CONTROLFILE/current.261.904066929'
*.db_block_size=8192
*.db_create_file_dest='+DATA01'
*.db_domain=''
*.db_name='TESTDB'
*.db_recovery_file_dest='+DATA01'
*.db_recovery_file_dest_size=4560m
*.diagnostic_dest='/oracle/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTDBXDB)'
*.enable_pluggable_databaC
*.memory_target=8009m
*.open_cursors=300
*.processes=600
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=680
*.undo_tablespace='UNDOTBS1'
~
~
~
~
~
~
~
"initTESTDB.ora" 32L, 1112C written
[oracle@testdb01 dbs]$ 
[oracle@testdb01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 10 09:40:36 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.

SQL> startup pfile ='/oracle/app/oracle/product/12.1.0/dbhome_1/dbs/initTESTDB.ora';
ORA-00134: invalid DISPATCHERS specification #2
ORA-00111: invalid attribute X
ORA-01078: failure in processing system parameters
SQL> exit
Disconnected
[oracle@testdb01 dbs]$ vi initTESTDB.ora 
#SPFILE='+DATA01/TESTDB/PARAMETERFILE/spfile.273.904067065'



*.audit_file_dest='/orC
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='+DATA01/TESTDB/CONTROLFILE/current.262.904066929','+DATA01/TESTDB/CONTROLFILE/current.261.904066929'
*.db_block_size=8192
*.db_create_file_dest='+DATA01'
*.db_domain=''
*.db_name='TESTDB'
*.db_recovery_file_dest='+DATA01'
*.db_recovery_file_dest_size=4560m
*.diagnostic_dest='/oracle/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTDBXDB)'
*.enable_pluggable_databaC
*.memory_target=8009m
*.open_cursors=300
*.processes=600
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=680
*.undo_tablespace='UNDOTBS1'
~
~

~
~
~
"initTESTDB.ora" 32L, 1121C written
[oracle@testdb01 dbs]$ 
[oracle@testdb01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 10 09:43:06 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.

SQL> startup pfile ='/oracle/app/oracle/product/12.1.0/dbhome_1/dbs/initTESTDB.ora';
ORA-00134: invalid DISPATCHERS specification #2
ORA-00111: invalid attribute X
ORA-01078: failure in processing system parameters
SQL> exit
Disconnected
[oracle@testdb01 dbs]$ vi initTESTDB.ora 
#SPFILE='+DATA01/TESTDB/PARAMETERFILE/spfile.273.904067065'

*.audit_file_dest='/orC
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='+DATA01/TESTDB/CONTROLFILE/current.262.904066929','+DATA01/TESTDB/CONTROLFILE/current.261.904066929'
*.db_block_size=8192
*.db_create_file_dest='+DATA01'
*.db_domain=''
*.db_name='TESTDB'
*.db_recovery_file_dest='+DATA01'
*.db_recovery_file_dest_size=4560m
*.diagnostic_dest='/oracle/app/oracle'
#*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTDBXDB)'
*.enable_pluggable_databaC
*.memory_target=8009m
*.open_cursors=300
*.processes=600
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=680
*.undo_tablespace='UNDOTBS1'
~
~
~
~
~
~
~
~
"initTESTDB.ora" 32L, 1122C written
[oracle@testdb01 dbs]$ 
[oracle@testdb01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 10 09:44:31 2017

Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup pfile ='/oracle/app/oracle/product/12.1.0/dbhome_1/dbs/initTESTDB.ora';
ORA-48108: invalid value given for the diagnostic_dest init.ora parameter
ORA-48140: the specified ADR Base directory does not exist [/oracle/app/oracle/product/12.1.0/dbhome_1/dbs/*.enable_pluggable_databaC]
ORA-48187: specified directory does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
SQL> exit
Disconnected
[oracle@testdb01 dbs]$ vi initTESTDB.ora 
#SPFILE='+DATA01/TESTDB/PARAMETERFILE/spfile.273.904067065'

*.audit_file_dest='/orC
*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='+DATA01/TESTDB/CONTROLFILE/current.262.904066929','+DATA01/TESTDB/CONTROLFILE/current.261.904066929'
*.db_block_size=8192
*.db_create_file_dest='+DATA01'
*.db_domain=''
*.db_name='TESTDB'
*.db_recovery_file_dest='+DATA01'
*.db_recovery_file_dest_size=4560m
*.diagnostic_dest='/oracle/app/oracle'
#*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTDBXDB)'
#*.enable_pluggable_databaC
*.memory_target=8009m
*.open_cursors=300
*.processes=600
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=680
*.undo_tablespace='UNDOTBS1'
~
~
~
~

~
~
"initTESTDB.ora" 32L, 1123C written
[oracle@testdb01 dbs]$ 
[oracle@testdb01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 10 09:45:22 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup pfile ='/oracle/app/oracle/product/12.1.0/dbhome_1/dbs/initTESTDB.ora';
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
SQL> exit
Disconnected
[oracle@testdb01 dbs]$ vi initTESTDB.ora 
#SPFILE='+DATA01/TESTDB/PARAMETERFILE/spfile.273.904067065'

#*.audit_file_dest='/orC
#*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='+DATA01/TESTDB/CONTROLFILE/current.262.904066929','+DATA01/TESTDB/CONTROLFILE/current.261.904066929'
*.db_block_size=8192
*.db_create_file_dest='+DATA01'
*.db_domain=''
*.db_name='TESTDB'
*.db_recovery_file_dest='+DATA01'
*.db_recovery_file_dest_size=4560m
*.diagnostic_dest='/oracle/app/oracle'
#*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTDBXDB)'
#*.enable_pluggable_databaC
*.memory_target=8009m
*.open_cursors=300
*.processes=600
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=680
*.undo_tablespace='UNDOTBS1'
~
~
~
~

~
~
~
"initTESTDB.ora" 32L, 1125C written
[oracle@testdb01 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 10 09:46:22 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.

SQL> startup pfile ='/oracle/app/oracle/product/12.1.0/dbhome_1/dbs/initTESTDB.ora';
ORACLE instance started.

Total System Global Area 8405385216 bytes
Fixed Size 2944416 bytes
Variable Size 4311745120 bytes
Database Buffers 4076863488 bytes
Redo Buffers 13832192 bytes
ORA-65093: multitenant container database not set up properly


SQL> 
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@testdb01 dbs]$ vi initTESTDB.ora 
#SPFILE='+DATA01/TESTDB/PARAMETERFILE/spfile.273.904067065'

#*.audit_file_dest='/orC
#*.audit_trail='db'
*.compatible='12.1.0.2.0'
*.control_files='+DATA01/TESTDB/CONTROLFILE/current.262.904066929','+DATA01/TESTDB/CONTROLFILE/current.261.904066929'
*.db_block_size=8192
*.db_create_file_dest='+DATA01'
*.db_domain=''
*.db_name='TESTDB'
*.db_recovery_file_dest='+DATA01'
*.db_recovery_file_dest_size=4560m
*.diagnostic_dest='/oracle/app/oracle'
#*.dispatchers='(PROTOCOL=TCP) (SERVICE=TESTDBXDB)'
*.enable_pluggable_database=true
*.memory_target=8009m
*.open_cursors=300
*.processes=600
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=680
*.undo_tablespace='UNDOTBS1'
~
~
~
~

~
~
"initTESTDB.ora" 32L, 1130C written
[oracle@testdb01 dbs]$ 
[oracle@testdb01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Thu Aug 10 09:48:49 2017
Copyright (c) 1982, 2016, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> shut abort;
ORACLE instance shut down.
SQL> startup pfile ='/oracle/app/oracle/product/12.1.0/dbhome_1/dbs/initTESTDB.ora';
ORACLE instance started.

Total System Global Area 8405385216 bytes
Fixed Size 2944416 bytes
Variable Size 4311745120 bytes
Database Buffers 4076863488 bytes
Redo Buffers 13832192 bytes
Database mounted.
Database opened.
SQL> select name, open_mode from v$database;

NAME OPEN_MODE
--------- --------------------
TESTDB READ WRITE

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL> show pdbs
ERROR:
ORA-00904: "APPLICATION_ROOT_CON_ID": invalid identifier



SP2-1545: This feature requires Database availability.
SQL> 
SQL> startup mount exclusive restrict;
SP2-0642: SQL*Plus internal error state 2133, context 2003:0:0
Unsafe to proceed
ORA-02003: invalid USERENV parameter


SQL> shut abort;
ORACLE instance shut down.
SQL> startup mount exclusive restrict pfile ='/oracle/app/oracle/product/12.1.0/dbhome_1/dbs/initTESTDB.ora';
ORACLE instance started.

Total System Global Area 8405385216 bytes
Fixed Size 2944416 bytes
Variable Size 4311745120 bytes
Database Buffers 4076863488 bytes
Redo Buffers 13832192 bytes
Database mounted.
SQL> select name, open_mode from v$database;

NAME OPEN_MODE
--------- --------------------
TESTDB MOUNTED

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
SQL> exit
[oracle@testdb01 dbs]$ 
[oracle@testdb01 dbs]$ echo $ORACLE_HOME
/oracle/app/oracle/product/12.1.0/dbhome_1
[oracle@testdb01 dbs]$ cd $ORACLE_HOME
[oracle@testdb01 dbhome_1]$ cd deinstall
[oracle@testdb01 deinstall]$ ./deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /oracle/app/oraInventory/logs/

############ ORACLE DECONFIG TOOL START ############


######################### DECONFIG CHECK OPERATION START #########################
## [START] Install check configuration ##


Checking for existence of the Oracle home location /oracle/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: /oracle/app/oracle
Checking for existence of central inventory location /oracle/app/oraInventory

## [END] Install check configuration ##


Network Configuration check config START

Network de-configuration trace file location: /oracle/app/oraInventory/logs/netdc_check2017-08-10_10-17-33-AM.log

Network Configuration check config END

Database Check Configuration START

Database de-configuration trace file location: /oracle/app/oraInventory/logs/databasedc_check2017-08-10_10-17-34-AM.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 []: /oracle/app/oracle/product/12.1.0/dbhome_1

###### For Database '/oracle/app/oracle/product/12.1.0/dbhome_1' ######

Specify the type of this database (1.Single Instance Database|2.Oracle Restart Enabled Database) [1]: 1
Specify the diagnostic destination location of the database [/oracle/app/oracle/diag/rdbms//oracle/app/oracle/product/12.1.0/dbhome_1]: 
Specify the storage type used by the Database ASM|FS []: ASM


Database Check Configuration END
Oracle Configuration Manager check START
OCM check log file location : /oracle/app/oraInventory/logs//ocm_check1995.log
Oracle Configuration Manager check END

######################### DECONFIG CHECK OPERATION END #########################

####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Home selected for deinstall is: /oracle/app/oracle/product/12.1.0/dbhome_1
Inventory Location where the Oracle home registered is: /oracle/app/oraInventory
The following databases were selected for de-configuration : /oracle/app/oracle/product/12.1.0/dbhome_1
Database unique name : /oracle/app/oracle/product/12.1.0/dbhome_1
Storage used : ASM
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: '/oracle/app/oraInventory/logs/deinstall_deconfig2017-08-10_10-17-31-AM.out'
Any error messages from this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2017-08-10_10-17-31-AM.err'

######################## DECONFIG CLEAN OPERATION START ########################
Database de-configuration trace file location: /oracle/app/oraInventory/logs/databasedc_clean2017-08-10_10-24-04-AM.log
Database Clean Configuration START /oracle/app/oracle/product/12.1.0/dbhome_1
This operation may take few minutes.
Database Clean Configuration END /oracle/app/oracle/product/12.1.0/dbhome_1

Network Configuration clean config START

Network de-configuration trace file location: /oracle/app/oraInventory/logs/netdc_clean2017-08-10_10-24-40-AM.log

De-configuring Naming Methods configuration file...
Naming Methods configuration file de-configured successfully.

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 : /oracle/app/oraInventory/logs//ocm_clean1995.log
Oracle Configuration Manager clean END

######################### DECONFIG CLEAN OPERATION END #########################

####################### DECONFIG CLEAN OPERATION SUMMARY #######################
Successfully de-configured the following database instances : /oracle/app/oracle/product/12.1.0/dbhome_1
Cleaning the config for CCR
As CCR is not configured, so skipping the cleaning of CCR configuration
CCR clean is finished
#######################################################################

############# ORACLE DECONFIG TOOL END #############

Using properties file /tmp/deinstall2017-08-10_10-16-10AM/response/deinstall_2017-08-10_10-17-31-AM.rsp
Location of logs /oracle/app/oraInventory/logs/

############ ORACLE DEINSTALL TOOL START ############

####################### DEINSTALL CHECK OPERATION SUMMARY #######################
A log of this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2017-08-10_10-17-31-AM.out'
Any error messages from this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2017-08-10_10-17-31-AM.err'

######################## DEINSTALL CLEAN OPERATION START ########################
## [START] Preparing for Deinstall ##
Setting LOCAL_NODE to testdb01
Setting CRS_HOME to false
Setting oracle.installer.invPtrLoc to /tmp/deinstall2017-08-10_10-16-10AM/oraInst.loc
Setting oracle.installer.local to false

## [END] Preparing for Deinstall ##

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

Detach Oracle home '/oracle/app/oracle/product/12.1.0/dbhome_1' from the central inventory on the local node : Done

Delete directory '/oracle/app/oracle/product/12.1.0/dbhome_1' on the local node : Done

The Oracle Base directory '/oracle/app/oracle' will not be removed on local node. The directory is in use by Oracle Home '/oracle/app/oracle/product/12.1.0/grid'.

Oracle Universal Installer cleanup was successful.

Oracle Universal Installer clean END


## [START] Oracle install clean ##

Clean install operation removing temporary directory '/tmp/deinstall2017-08-10_10-16-10AM' on node 'testdb01'

## [END] Oracle install clean ##


######################### DEINSTALL CLEAN OPERATION END #########################


####################### DEINSTALL CLEAN OPERATION SUMMARY #######################
Successfully detached Oracle home '/oracle/app/oracle/product/12.1.0/dbhome_1' from the central inventory on the local node.
Successfully deleted directory '/oracle/app/oracle/product/12.1.0/dbhome_1' on the local node.
Oracle Universal Installer cleanup was successful.

Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################


############# ORACLE DEINSTALL TOOL END #############

[oracle@testdb01 deinstall]$ ls
[oracle@testdb01 deinstall]$ cd ..
cd: error retrieving current directory: getcwd: cannot access parent directories: No such file or directory
[oracle@testdb01 ..]$ pwd
/oracle/app/oracle/product/12.1.0/dbhome_1/deinstall/..
[oracle@testdb01 ..]$ cd ..
[oracle@testdb01 12.1.0]$ ls -la
total 12
drwxr-xr-x. 3 oracle oinstall 4096 Aug 10 10:25 .
drwxr-xr-x. 4 oracle oinstall 4096 Aug 9 16:26 ..
drwxr-x---. 78 root oinstall 4096 Aug 9 10:49 grid
[oracle@testdb01 12.1.0]$ cd grid
[oracle@testdb01 grid]$ cd deinstall/
[oracle@testdb01 deinstall]$ pwd
/oracle/app/oracle/product/12.1.0/grid/deinstall
[oracle@testdb01 deinstall]$ 
[oracle@testdb01 deinstall]$ export ORACLE_HOME=/oracle/app/oracle/product/12.1.0/grid 
[oracle@testdb01 deinstall]$ export GRID_HOME=/oracle/app/oracle/product/12.1.0/grid 
[oracle@testdb01 deinstall]$ . oraenv
ORACLE_SID = [TESTDB] ? +ASM
The Oracle base remains unchanged with value /oracle/app/oracle
[oracle@testdb01 deinstall]$ echo $ORACLE_SID
+ASM 
[oracle@testdb01 deinstall]$ echo $ORACLE_SID
+ASM
[oracle@testdb01 deinstall]$ echo $ORACLE_HOME
/oracle/app/oracle/product/12.1.0/grid
[oracle@testdb01 deinstall]$ echo $GRID_HOME
/oracle/app/oracle/product/12.1.0/grid
[oracle@testdb01 deinstall]$ 
[oracle@testdb01 deinstall]$ ./deinstall
Checking for required files and bootstrapping ...
Please wait ...
Location of logs /oracle/app/oraInventory/logs/

############ ORACLE DECONFIG TOOL START ############


######################### DECONFIG CHECK OPERATION START #########################
## [START] Install check configuration ##

Checking for existence of the Oracle home location /oracle/app/oracle/product/12.1.0/grid
Oracle Home type selected for deinstall is: Oracle Grid Infrastructure for a Standalone Server
Oracle Base selected for deinstall is: /oracle/app/oracle
Checking for existence of central inventory location /oracle/app/oraInventory
Checking for existence of the Oracle Grid Infrastructure home /oracle/app/grid

## [END] Install check configuration ##

Traces log file: /oracle/app/oraInventory/logs//crsdc_2017-08-10_10-32-27AM.log

Network Configuration check config START

Network de-configuration trace file location: /oracle/app/oraInventory/logs/netdc_check2017-08-10_10-32-27-AM.log

Network Configuration check config END

Asm Check Configuration START

ASM de-configuration trace file location: /oracle/app/oraInventory/logs/asmcadc_check2017-08-10_10-32-28-AM.log

ASM was not detected in the Oracle Home
Database Check Configuration START

Database de-configuration trace file location: /oracle/app/oraInventory/logs/databasedc_check2017-08-10_10-32-29-AM.log

Database Check Configuration END

######################### DECONFIG CHECK OPERATION END #########################


####################### DECONFIG CHECK OPERATION SUMMARY #######################
Oracle Grid Infrastructure Home is: /oracle/app/grid
The following nodes are part of this cluster: null
The cluster node(s) on which the Oracle home deinstallation will be performed are:null
Oracle Home selected for deinstall is: /oracle/app/oracle/product/12.1.0/grid
Inventory Location where the Oracle home registered is: /oracle/app/oraInventory
The home being deconfigured is NOT a configured Grid Infrastructure home (/oracle/app/grid)
ASM was not detected in the Oracle Home
Do you want to continue (y - yes, n - no)? [n]: y
A log of this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2017-08-10_10-32-25-AM.out'
Any error messages from this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2017-08-10_10-32-25-AM.err'

######################## DECONFIG CLEAN OPERATION START ########################
Database de-configuration trace file location: /oracle/app/oraInventory/logs/databasedc_clean2017-08-10_10-34-11-AM.log
ASM de-configuration trace file location: /oracle/app/oraInventory/logs/asmcadc_clean2017-08-10_10-34-11-AM.log
ASM Clean Configuration END

Network Configuration clean config START

Network de-configuration trace file location: /oracle/app/oraInventory/logs/netdc_clean2017-08-10_10-34-11-AM.log

De-configuring Listener configuration file...
Listener configuration file de-configured successfully.

De-configuring Naming Methods configuration file...
Naming Methods 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


######################### DECONFIG CLEAN OPERATION END #########################


####################### DECONFIG CLEAN OPERATION SUMMARY #######################
The home being deconfigured is NOT a configured Grid Infrastructure home (/oracle/app/grid)
#######################################################################


############# ORACLE DECONFIG TOOL END #############

Using properties file /tmp/deinstall2017-08-10_10-31-59AM/response/deinstall_2017-08-10_10-32-25-AM.rsp
Location of logs /oracle/app/oraInventory/logs/

############ ORACLE DEINSTALL TOOL START ############

####################### DEINSTALL CHECK OPERATION SUMMARY #######################
A log of this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2017-08-10_10-32-25-AM.out'
Any error messages from this session will be written to: '/oracle/app/oraInventory/logs/deinstall_deconfig2017-08-10_10-32-25-AM.err'

######################## DEINSTALL CLEAN OPERATION START ########################
## [START] Preparing for Deinstall ##
Setting LOCAL_NODE to testdb01
Setting CRS_HOME to false
Setting oracle.installer.invPtrLoc to /tmp/deinstall2017-08-10_10-31-59AM/oraInst.loc
Setting oracle.installer.local to false

## [END] Preparing for Deinstall ##

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

Detach Oracle home '/oracle/app/oracle/product/12.1.0/grid' from the central inventory on the local node : Done

The Oracle Base directory '/oracle/app/oracle' will not be removed on local node. The directory is in use by Oracle Home '/oracle/app/grid'.

Oracle Universal Installer cleanup was successful.

Oracle Universal Installer clean END


## [START] Oracle install clean ##

Clean install operation removing temporary directory '/tmp/deinstall2017-08-10_10-31-59AM' on node 'testdb01'

## [END] Oracle install clean ##

######################### DEINSTALL CLEAN OPERATION END #########################

####################### DEINSTALL CLEAN OPERATION SUMMARY #######################
Successfully detached Oracle home '/oracle/app/oracle/product/12.1.0/grid' from the central inventory on the local node.
Failed to delete directory '/oracle/app/oracle/product/12.1.0/grid' on the local node.
Oracle Universal Installer cleanup was successful.

Oracle deinstall tool successfully cleaned up temporary directories.
#######################################################################

############# ORACLE DEINSTALL TOOL END #############

[oracle@testdb01 deinstall]$