Yearly Archives: 2020

Oracle Statspack Installing and Configuration

Description: This Document for configuring oracle Statspack, schedule auto snapshot and report generation. The Statspack tool is instead of AWR report because AWR is licensed Statspack is non licensed. Steps:…

Read More

Node id does not exist for the current application server id

Description: After Clone the Oracle Application R12.1.3 and login the application this error occurs. Solution: Check the Server ID in fnd_node table . Select server_id from fnd_node; Take a backup…

Read More

Adding and Configure Printer in Solaris 10 Sparc

Description: Oracle have lot of printing option to configuring in Solaris 10, this is also one method will follow to setup printer on EBSR12 in Solaris Sparc 10 Steps: Login…

Read More

Session Trace (10064) for a concurrent request

Description: Oracles have lot of trace utility the oradebug is one the utility to trace particular running concurrent request using oracle spid. Steps: Check Request ID from Find Concurrent request…

Read More

Unable to open user preference file

Description: The user was running RDF report and concurrent completed with error That issue occur on the prefs.ora file is missing or non-accessible owner Solution: copy the prefs.ora file from…

Read More

Oracle Reports are Failing with ORA-00600: internal error code

Description: Customers run the Oracle Report are Failing with APPS.FND_CP_OPP_IPC ORA-00600: internal error code. This issue made low level business impact   Solution: Check the Concurrent Log file to detail…

Read More

How to resolve ORA-28040: No matching authentication protocol

Error: ORA-28040: No matching authentication protocol Cause: 1. This problem was encountered on database instance version 12.2 and above and clients with version 9g/10g/11g. Example: In my case the development…

Read More

How to export and import oracle apex application and workspace from command line

Query to identify applications/workspace information of your Oracle apex Application COLUMN workspace FORMAT A20 COLUMN workspace_id FORMAT 99999999999999999999 COLUMN application_id FORMAT A14 COLUMN application_name FORMAT A20 — List applications. SELECT…

Read More

How to enable trace/debug in tomcat and which log we need to analyze when there is any issue reported

The default log files and logging levels are defined in logging.properties file under the below location /home/oracle/tomcat_09_Aug_2020/apache-tomcat-9.0.36/conf. The list is arranged in order by level of detail from the least…

Read More

How to Find underscore_parameters in a database during Audit process

Impact: Unknown underscore parameters without proper advice from metalink, would impact the database. Solution: We need to ensure that we have proper advises from Oracle Support on those underscore parameters…

Read More