Posts by Ragunathan Kannan

Unable to alter APPS_NE user to change password

APP-FND-02704: Unable to alter user APPS_NE to change password” while changing APPS password using FNDCPASS Issue: Changing apps password using FNDCPASS fails with below error APP-FND-02704: Unable to alter user…

Read More

HRglobal driver in Oracle APPS R12.2 Version

How to Run hrglobal driver in Oracle EBS 12.2.X Version? Steps to apply hrglobal driver in Oracle EBS 12.2.x version Start an Oracle online EBS Patching cycle. adop phase=prepare 2.Source…

Read More

SharePlex reports out-of-sync conditions

How SharePlex reports out-of-sync conditions For all objects except those involved in transformation, SharePlex verifies that the source and target data in a given operation are synchronized before posting the…

Read More

How to check what current IDLE_TIME is set at in 11g ORACLE DATABASE

The Idle Time Resource Usage setting limits the maximum idle time allowed in a session. Idle time is a continuous inactive period during a session, expressed in minutes. Long-running queries…

Read More

To Enable & Disable ADDM reports in Pluggable Database Oracle

Enable & Disable ADDM reports in Pluggable Database Oracle you can configure ADDM reports for Pluggable database(PDBs). By default it is disabled. You need to enable it manually by executing…

Read More

Recover a dropped table

Recover a dropped table in Oracle 11g Steps to recover a dropped table in Oracle 11g when flashback mode is off After dropping table and before restoring it from the…

Read More

ORA – bootstrap Error

ORA-00704 bootstrap process failure After Upgrading ORACLE_HOME (from 11.1.0.7.0 to 12.1.0.2.0), I was started my database by using startup command, then got below error. Connected to an idle instance. SQL>…

Read More

ADJRIINITPASSWD.sql Failed

ADJRIINITPASSWD.sql Fails With An ORA-01031 Error: Error: Unable to execute statement < Begin ad_jar.get_jripasswords(:l_storepass, :l_keypass); End; > len = 63 AD Administration error: ORA-01031: insufficient privileges ORA-06512: at “SYS.DBMS_SESSION”, line…

Read More

Change WEB Port on 12.2

Change WEB Port on 12.2 The steps to change the webport to 8000. Step-1:Start only Weblogic admin using  adadminsrvctl.sh  start on run file system Login to Enterprise Manager(em) Console using below…

Read More

ORA-01017: invalid username/password; logon denied

ORA-01017: invalid username/password; logon denied   ERROR: ORA-01017: invalid username/password; logon denied   First of all you need to edit your sqlnet.ora adding (or lowering) the parameter   SQLNET.ALLOWED_LOGON_VERSION_SERVER to…

Read More