APPLIES TO: Oracle WebLogic Server – Version 10.3.6 to 10.3.6 Generic Linux GOAL: If there are a lot of webLogic domains to configure, this document provides an example to define…
Read Moreset pagesize 10000 set linesize 133 column tablespace format a20 heading ‘Tablespace Name’ column segfile# format 9,999 heading ‘File|ID’ column spid format 9,999 heading ‘Unix|ID’ column segblk# format 999,999,999 heading…
Read Moreset head on column module format a20 set lines 1000 pages 1000 prompt SQL Ordered by Elapsed time /*FIND THE SNAP ID*/ set pages 0 col begin_interval_time for a30 col…
Read MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 MoreDescription: 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 MoreError: 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 MoreQuery 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 MoreThe 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