Compile_jsp

compile_jsp
rm -fr $COMMON_TOP/_pages
mkdir $COMMON_TOP/_pages
perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 20 -log /tmp/compile.log

CM was not coming up , even while taking down was returning error :

shutdown error:
ORACLE Password:
ORACLE error 904 in FDPRRC

Cause: FDPRRC failed due to ORA-00904: "NLS_SORT": invalid identifier
.

The SQL statement being executed at the time of the error was:  and was executed from the file .
Cannot submit your concurrent request

Once killed the process, on start also only ICM was coming up and rest manager remains down.
ICM log file was having below error :
use: insert_fcp failed due to ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
ORA-06512: at "APPS.FND_CP_FNDSM", line 134
ORA-06512: at line 1.

The following actions were performed in order to solve the issue but without success:

- cleaned the fnd_nodes
- ran autoconfig in db tier and apps tier
- executed $FND_TOP/patch/115/sql/afdcm037.sql
- ran autoconfig again

TO check fnd_node details:
set lines 180
set pages 50
col NODE_NAME for a15 WORD_WRAPPED
COL SUPPORT_DB for a12
COL SUPPORT_CP for a12
COL SUPPORT_ADMIN for a15
COL SUPPORT_FORMS for a15
COL SUPPORT_WEB for a12
COL HOST for a15 WORD_WRAPPED
Col STATUS for a10
col DOMAIN for a20 WORD_WRAPPED
select NODE_NAME,SUPPORT_DB,SUPPORT_CP,SUPPORT_ADMIN,SUPPORT_WEB,SUPPORT_FORMS,STATUS,HOST,DOMAIN
from apps.fnd_nodes;

select control_code from fnd_concurrent_queues where concurrent_queue_name = 'FNDSCH'

Main cause:

Checking the AFCPFSMB.pls file version on the files system and on the DB side, there is a mismatch:
- on the file system:
adident Header $FND_TOP/patch/115/sql/AFCPFSMB.pls

AFCPFSMB.pls 120.7.12010000.6

- while on Database:
select text from dba_source where name = 'FND_CP_FNDSM' and text like '%Header%';

AFCPFSMB.pls 120.7.12010000.2

Solution:

Reloading this file without doing anything else is not recommended.

Re-apply patch 15981176 by following the read-me and make sure it updates the file correctly.

Then re-test to see if all the concurrent managers start successfully.

Reference doc id for the same:
Concurrent Managers Fail to Start: "insert_fcp failed due to ORA-00054" (Doc ID 2213565.1)

Error: ORA-06598: insufficient INHERIT PRIVILEGES privilege" during Oracle 12c running below script:

After database upgrade to 12c Database on running script:

Script:
SQL> SET SERVEROUTPUT ON
BEGIN
  xx_tools.osce_db_passwd_reset_pkg.change_db_account_passwords(p_execute_mode => TRUE);
END;SQL>   2    3
  4  /
BEGIN
*

Error:
ERROR at line 1:
ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "XX_TOOLS.OSCE_DB_PASSWD_RESET_PKG", line 1
ORA-06512: at line 2

Cause
This is due to a new security feature in 12c:

Before Oracle Database 12c, an Invoker Rights (IR) unit always ran with the privileges of its invoker. If its invoker had higher privileges than its owner, then the IR unit might perform operations unintended by, or forbidden to, its owner. As of Oracle Database 12c, an IR unit can run with the privileges of its invoker only if its owner has either the INHERIT PRIVILEGES privilege on the invoker or the INHERIT ANY PRIVILEGES privilege.

Solution:

SQL>

SQL> GRANT INHERIT PRIVILEGES ON USER "SYSTEM" TO PUBLIC;

Grant succeeded.

SQL> conn system/******

Connected.

SQL>

and then run the script , it went successfully.....

this is a new privilege in Oracle 12c .By default the privilege INHERIT PRIVILEGES is granted to PUBLIC, and it secures a weakness where a malicious user may accidentally get access to a privilege that user shouldn't have.