Database Blog

OBIEE 11g Analytics : Error while logging into application portal “Authentication failed: invalid user/password”

OBIEE 11g Analytics : Error while logging into application portal “Authentication failed: invalid user/password” When we try to login to OBIEE 11g Analytics after installation, We were not able to…

Read More

ORA-12537 While Connecting To Database Via Listener

  ORA-12537 While Connecting To Database Via Listener   Connection to the database server fails with ORA-12537 Local connections working fine but the connection via listener fails with ORA-12537  …

Read More

OBIEE 11g Client Admin Tool Connection To Datasource In Offline Mode Fails With Error “The Connection Has Failed”

OBIEE 11g Client Admin Tool Connection To Datasource In Offline Mode Fails With Error “The Connection Has Failed” Created a new repository (RPD) using the Oracle Business Intelligence Enterprise Edition…

Read More

ORA-27211: Failed to load Media Management Library

Issue : Rman backup script fails with the below error. But strangely if we run the backup manually it went fine. RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============…

Read More

ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ

ORA-06512: at “APPS.FND_CP_OPP_IPC”, line 85 ISSUE:XML reports  complete in warning This is a freshly cloned instance and all managers and OPP services were up and running.However users were reporting of…

Read More

Find Total Version Count for Every one hour from AWR table

Script: set serveroutput onset lines 130set verify offaccept v_begin_time prompt ‘Enter BEGIN_TIME DD-MON-YY HH24:MI:SS->’accept v_end_time prompt ‘Enter END_TIME DD-MON-YY HH24:MI:SS->’DECLARE   lv_v_version_count   dba_hist_sqlstat.version_count%TYPE;   lv_n_cnt         NUMBER                            := 0; BEGIN   FOR c1 IN     …

Read More

Hard_Parse Value for every one hour from AWR tables.

Script :   set serveroutput on set lines 130 set verify off accept v_begin_time prompt ‘Enter BEGIN_TIME DD-MON-YY HH24:MI:SS->’ accept v_end_time prompt ‘Enter END_TIME DD-MON-YY HH24:MI:SS->’ DECLARE    lv_v_stat_name   dba_hist_sysstat.stat_name%TYPE;…

Read More

SSL Configuration on R12

OS level Required rpm’s: xmlsec1-openssl-1.2.6-3 openssl-0.9.7a-43.18.el4 openssl-devel-0.9.7a-43.18.el4 openssl-devel-0.9.7a-43.18.el4 xmlsec1-openssl-1.2.6-3 openssl096b-0.9.6b-22.46.el4_8.1 openssl-perl-0.9.7a-43.18.el4 openssl-0.9.7a-43.18.el4 openssl096b-0.9.6b-22.46.el4_8.1 Generate Certificate: Move  these key to the  wallet directory         To Validate the Certificate…

Read More

INSTALLING ORACLE APEX 3.1 ON ORACLE 10g

                          Download the Apex 3.1 and move to /home/oracle dir Now unzip the  file . login to database and execute the following commands. $sqlplus / as sysdba sql> show parameter…

Read More

Configure Apex 4.0 with Apex Listener using Glassfish

Software Requirement: 1.JDK 1.6 or Higher (Download it from http://www.oracle.com/technetwork/java/javase/downloads  /jdk7-downloads-1880260.html )  2.apex_listener.1.1.4.195.00.12.zip  (Download it from http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.html) 3.ogs-3.1.2.2-web-unix-ml.sh (Glassfish) (Download it from http://www.oracle.com/technetwork/java/javaee/downloads/java-ee-sdk-6u3-jdk-6u26-downloads-439816.html)  Installation StepsInstall JDK RPM on Server:                                 …

Read More