Database environment not set, going to check for GridHome.
LsInventorySession failed: RawInventory gets null OracleHomeInfo
Error running opatch. Error code : 73
Cannot confirm bugfixes applied to the Database ORACLE_HOME.
cd $ORACLE_HOME/oui/bin
./attachHome.sh
[UNEXPECTED] Could not find patch context file from database [UNEXPECTED]Patch edition context file not found in database for host
Solution: Run Autoconfig in Patch file system
sqlplus ebs_system/sys
alter trigger ebs_logon disable;
Source the patch file system and run Autoconfig
#!/bin/bash
export ORACLE_HOME=/u01/app/oracle_home
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=ERPCDB1
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
l_user='apps'
l_psw='Admin1234'
l_conn_string='mydb'
sql_error=`sqlplus -silent $l_user/$l_psw@$l_conn_string <<END
WHENEVER SQLERROR EXIT 1
begin
/* Call compute_sal stored procedure */
XX_AP_PAY_BATCH_JOB_PRC;
exception
when others then
raise;
end;
/
EXIT;
END`
Result=$?
echo $Result
if [[ $Result -ne 0 ]]
then
echo "${sql_error}"
echo "Error calling the PL/SQL procedure."
exit $Result
else
echo "PL/SQL Procedure executed successfully."
exit 0
fi
When a notification fails to be rendered or delivered from the Java tier (in this case due to an email server outage) then the notification will be placed into a FAILED state. The notifications that fails to be delivered to a user then has their notification preference set to DISABLED and any subsequent notifications will be automatically be set to FAILED either at the PL/SQL level or the java level depending on where the request for a notification is received.
Run the following select statement to identify those users that are DISABLED:
select user_name from fnd_user_preferences where PREFERENCE_VALUE = 'DISABLED';
Below block update the user preferences
DECLARE
l_disabled_count NUMBER;
l_updated_count NUMBER;
BEGIN
DBMS_OUTPUT.PUT_LINE('Program to display updated row count');
DBMS_OUTPUT.PUT_LINE('**************************************');
SELECT count(*)
INTO l_disabled_count
FROM fnd_user_preferences
WHERE PREFERENCE_VALUE = 'DISABLED';
dbms_output.put_line('Disabled Count :'||l_disabled_count);
BEGIN
update fnd_user_preferences
set preference_value = 'MAILHTML'
where PREFERENCE_VALUE = 'DISABLED';
dbms_output.put_line('Updated Row count: '||SQL%ROWCOUNT);
COMMIT;
EXCEPTION WHEN OTHERS THEN
dbms_output.put_line('Error in Update - '||SUBSTR(SQLERRM,1,100));
END;
DBMS_OUTPUT.PUT_LINE('**************************************');
EXCEPTION WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Error in Main - '||SUBSTR(SQLERRM,1,100));
END;
