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 MoreSession 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 MoreUnable 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 MoreHow 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 MoreHow 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 MoreHow 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 MoreHow 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 MoreHow to resolve Resolve ORA-20005: object statistics are locked (stattype = ALL)
Introduction Need for want of lock statistics in a oracle table in some cases, for example 1. Don’t want a table to be analyzed by schedule statistics job but want…
Read MoreHow to resolve FRM-30087: Unable to create form file
Error: FRM-30087: Unable to create form file $ORACLE_HOME/forms/WOENTRY.fmx Cause: Non-oracle user cannot write in the “output” directory or the mentioned fmx exists but user cannot overwrite it. Workaround: 1. By…
Read MoreHow to resolve Forms Builder Does not Launch on Linux RHEL 7
Error: error while loading shared libraries: libXm.so.3: cannot open shared object file: No such file or directory Solution: 1. As a workaround, make sure the following 64 bits openmotif packages…
Read More