April 2016 archive

"ORA-15040: diskgroup is incomplete" but diskgroup is mounted

Those days, I was creating a new database on a system and when I tried to create any file (spfile / pwfile / control file) on diskgroup, I started receiving the error below: ORA-15001: diskgroup "DATA" does not exist or is not mounted ORA-15040: diskgroup is incomplete Usually this error comes together with something like …

Continue reading

libasmclntsh12.so missing after OPatch failed in Oracle 12c

Those days, I was trying to apply the latest Oracle Grid Infrastructure PSU over my 12.1.0.2 Clusterware. During the apply phase, the OPatch failed because the gcc was not available for execution. Actually, someone gave chmod 700 to /usr/bin/gcc for protection. /grid/app/grid/product/12.1.0/grid/bin/orald: line 31: /usr/bin/gcc: Permission denied /grid/app/grid/product/12.1.0/grid/bin/orald: line 31: exec: /usr/bin/gcc: cannot execute: Permission denied make[2]: …

Continue reading