Saturday, February 23, 2019

ORA-39087: directory name directory_name is invalid


This error may be returned if you are trying to export or import using oracle data pump, but invalid directory name has been provided during this process. Following is an example of this.
 $expdp directory=mydir dumpfile=mydump.dmp logfile=mylog.log schemas=c##salman

Export: Release 12.1.0.2.0 - Production on Tue Jun 6 12:05:46 2017

Wednesday, February 13, 2019

ORA-15075: disk(s) are not visible cluster-wide


While adding a disk to a diskgroup in a RAC, you might face ORA-15075. Following is an example of this error.
SQL> alter diskgroup DATA add disk ‘ORCL:DATA4’, ‘ORCL:DATA5’;
alter diskgroup DATA add disk ‘ORCL:DATA4’, ‘ORCL:DATA5’
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15075: disk(s) are not visible cluster-wide

Tuesday, February 5, 2019

Deinstalling or Removing Oracle Software


We need to use “deinstall” utility to remove Oracle software from a system. In the following I will show how to deinstall Oracle grid infrastructure software. If you have an Oracle RDBMS home dependent on the GI home, then you should deinstall RDBMS software before deinstaling GI software. Process of deinstalling RDBMS home is similar to the deinstallation of grid infrastructure software.

Popular Posts - All Times