Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Blog
June 20, 2017 Webcast: Maintenance Strategies for Oracle E-Business Suite
NEWS AND UPDATES

Webcast: Maintenance Strategies for Oracle E-Business Suite

(more…)

June 20, 2017 java.io.IOException: ORA-01691: unable to extend lob segment
Errors/Workarounds-ApplicationsOracle APPS DBA

ERROR

Start uploading…
Target file: SAF654_XML.rtf
Creating a new record in XDO_LOBS: SAF645_XML.rtf
java.io.IOException: ORA-01691: unable to extend lob segment XDO.SYS_LOB00001312564V00010$$ by 16 in tablespace APPS_TS_TX_DATA   

(more…)

June 19, 2017 ORA-12645 Parameter does not exist, Oracle error code
Errors/Workarounds10gErrors/Workarounds11gOracle Database Material

ERROR

Translation of the error message from Oracle’s support site:
ORA-12645: Parameter does not exist.

Cause: A sqlnet.ora parameter from which a value was needed does not exist.
Action: Set the parameter in the parameter file.

(more…)

June 17, 2017 APP-FND-01542: This Applications Server is not authorized to access this database
Errors/Workarounds-ApplicationsOracle APPS DBA

ERROR

APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your System Administrator.

SOLUTION

Step 1.  Backup context file .

Step 2. Update the context variable:

s_appserverid_authentication

By default in 11.5.10, this is set to SECURE.

In previous 11i versions, this was set to OFF.
For debug purposes, you can use ON or OFF.

Modes:

– ON : Partial
– SECURE : activates full server security (SECURE mode)
– OFF : deactivates server security

Step 3. Run Autoconfig to instantiate the change.