Monday, November 9, 2020

 INFO:

Problem

===========

During install database 19c we have the below error.

========================================


/bin/sh: line 2: /usr/bin/as: Permission denied


INFO:

mv: cannot stat ‘ntcontab.o’: No such file or directory


INFO:

/usr/bin/ar: /u01/install/DWH/19.0.0/lib/ntcontab.o: No such file or directory


INFO:

make: *** [ntcontab.o] Error 1


INFO: End output from spawned process.

INFO: ----------------------------------

INFO: Exception thrown from action: make

Exception Name: MakefileException

Exception String: Error in invoking target 'mkldflags ntcontab.o nnfgt.o' of makefile '/u01/install/DWH/19.0.0/network/lib/ins_net_client.mk'. See '/opt/oracle/oraInventory/logs/InstallActions2020-11-09_12-04-12PM/installActions2020-11-09_12-04-12PM.log' for details.

Exception Severity: 1



Solution:

==========

login by root user the run the below command

chmod 777 /usr/bin/as

Tuesday, April 28, 2020

Disable Oracle Label Security (OLS) 11gR1


Check Oracle Label Security OLS Status
=============================

SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Label Security';

Disable Oracle Label Security OLS
=============================

sqlplus sys as sysoper
Enter password: password

SQL> SHUTDOWN IMMEDIATE
SQL> EXIT

$ emctl stop dbconsole
$ lsnrctl stop [listener_name]
cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk lbac_off
cd $ORACLE_HOME/bin
relink all

Wednesday, April 15, 2020

Adop Apply patch and its translation:


adop phase=apply patches=1012464,10124646_AR:u10124646.drv

adop phase=apply apply_mode=downtime patches=30980514,30980514_AR:u30980514.drv

APP-FND-1434: fdlsql cannot find FROM clause in QuickPick statement is returned


PROBLEM STATEMENT
=================
While trying to setup the profile option PO : Attachments to display in Notification Header, 
when calling the LOV error APP-FND-1434: fdlsql cannot
find FROM clause in QuickPick statement is returned















Solution
==========
apply the following patch.

Patch 30007772: In oracle purchasing, profile option 
"PO: Attachment to display in Notification Header" can be set up successfully.