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]$
Orhan Eripek's Oracle Blog 