opatchauto Hangs While Applying a patch to DB home

(Doc ID 2049111.1)

Last updated on DECEMBER 04, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

12.1.0.1.8 opatchauto is able to apply Jul PSU 21150782 to GI home, but hangs forever when applying to DB home, log shows it was running the following:

Successfully executed the command:
echo 'SPOOL OFF' >>
/opt/ORACLE/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/oplan/spfquery.sql

2015-08-11_13-10-04 :
Executing command as oracle :
cd /opt/ORACLE/app/oracle/product/12.1.0.2/db_1; ORACLE_HOME=/opt/ORACLE/app/oracle/product/12.1.0.2/db_1 ORACLE_SID=TS981CDB1 /opt/ORACLE/app/oracle/product/12.1.0.2/db_1/bin/sqlplus / as sysdba

 

$ cat /opt/ORACLE/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/oplan/spfquery.sql
SET HEADING OFF
SET SERVEROUTPUT OFF
SPOOL /opt/ORACLE/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/oplan/spf.txt
SELECT DECODE(value',' NULL',' 'PFILE'',' 'SPFILE') '\'Init File Type\ FROM
sys.v_'\' WHERE name = 'spfile';
SPOOL OFF


The spfquery.sql has wrong syntax:

SQL> SELECT DECODE(value',' NULL',' 'PFILE'',' 'SPFILE') '\'Init File Type\
FROM sys.v_'\' WHERE name = 'spfile'
*
ERROR at line 1:
ORA-00907: missing right parenthesis



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms