Oracle Fusion Middleware: How to find Oracle Weblogic Server Version? - Oracle Weblogic Server Versiyonu Nasıl Bulınur?

To find out  the WebLogic Server Version, we may go to  registry.xml in MIDDLEWARE_HOME
We open registry.xml and search for “component name=”WebLogic Server”” version=”10.3.5.0″ (variable version next to this will tell you weblogic version.

For example ours was 10.3.5.0.

Oracle E-Business Suite: Concurrent Requests Performance History - Concurrent Request'lerle ilgili İstatistik Performans Bilgisi

Query About Performance Statistics of Concurrent Requests:

This query gives us the count of  daily run concurrents. In addition to that their daily running duration, average running hours and pending hours are also shown. That's how we could diagnose if there had been wrong with the system. In case there was a problem, we could easily detect and investigate the problem on that day or period.

 SELECT TO_CHAR(TRUNC(ACTUAL_START_DATE),'DD-MON-YY DY') STARTDATE,  
 COUNT(*) COUNT, ROUND(SUM(ACTUAL_COMPLETION_DATE - ACTUAL_START_DATE) * 24, 2) RUNNING_HOURS,  
 ROUND(AVG(ACTUAL_COMPLETION_DATE - ACTUAL_START_DATE) * 24, 2) AVG_RUNNING_HOURS,  
 ROUND(SUM(ACTUAL_START_DATE - REQUESTED_START_DATE) * 24, 2) PENDING_HOURS,  
 ROUND(AVG(ACTUAL_START_DATE - REQUESTED_START_DATE) * 24, 2) AVG_PENDING_HOURS  
 FROM APPLSYS.FND_CONCURRENT_PROGRAMS P,APPLSYS.FND_CONCURRENT_REQUESTS R  
 WHERE R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID  
 AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID  
 AND R.STATUS_CODE IN ('C','G')  
 AND TRUNC(ACTUAL_COMPLETION_DATE) > TRUNC(SYSDATE-6)  
 AND TO_CHAR(TRUNC(ACTUAL_START_DATE),'DD-MON-YY DY') IS NOT NULL  
 GROUP BY TRUNC(ACTUAL_START_DATE)   
 ORDER BY TRUNC(ACTUAL_START_DATE) ASC;

Reference:

1-http://dbavandana.blogspot.com.tr/2013/06/concurrent-manager-queries.html

Oracle E-Business Suite: Concurrent Programs Under Queue - Sırada Bekleyen İşlemler, Concurrentlar

Concurrent Programs Under Queue:

The query given below can show us the queries that are on hold, waiting to be executed. There could be a condition on the number of concurrents waiting and in the end if this number is too much, a mail can be sent to the administrator to check if something is wrong.

select user_CONCURRENT_PROGRAM_NAME "PROGRAM NAME",concurrent_queue_name "QUEUE NAME", priority,decode(phase_code,'P','Pending') "PHASE",   
 decode(status_code,'A','Waiting','B','Resuming','C','Normal','D','Cancelled','E','Error','F',  
 'Scheduled','G','Warning','H','On Hold','I','Normal','M','No Manager','Q','Standby','R','Normal','S',  
 'Suspended','T','Terminating','U','Disabled','W','Paused','X','Terminated','Z','Waiting') "   
 NAME", status_code,count(*) from   
 fnd_concurrent_worker_requests   
 where phase_code='P' and hold_flag!='Y'   
 and requested_start_date<=sysdate  
 and concurrent_queue_name<> 'FNDCRM'  
 and concurrent_queue_name<> 'GEMSPS'  
 group by   
 user_CONCURRENT_PROGRAM_NAME,  
 concurrent_queue_name,priority,phase_code,status_code  
 order by count(*) desc;  

Referans:

1- http://dbavandana.blogspot.com.tr/2013/06/concurrent-manager-queries.html

Oracle E-Business Suite: How to hide the Apps password while applying a patch? - Apps kullanıcısı şifresini gizlemek

In Oracle EBS to hide our passwords while applying our patches, we could use "flags=hidepw" .Thus we could prevent our machine from writing the password information in the log files.

> adpatch flags=hidepw

In order to make sure it is always applied, we could define an alias.

The real importance of this matter is that if we could draw some attention to this matter, we could look for ways to hide our passwords in other commands and subjects.

Oracle Fusion Middleware: Oracle Configuration Manager - OCM - What is OCM?

What is Oracle Configuration Manager?

OCM is a  tool to monitor our Oracle system to provide correct information to us and to Oracle Support.

How to obtain OCM?

OCM can be downloaded as a patch. From Oracle Support Page, we click on Patches and Updates and we  do a simple search of the Patch "5567658".

How to install OCM?

To install it, we have to run cmd as an administrator. Then we change our directory to the directory of OCM and run setupCCR.exe.

For Fusion Middleware:
For fusion middleware OCM is already configured and placed under fmw_home/utils. It is also stated under the topic "2.4.9 Fusion MiddleWare and Fusion Applications" .

 Link is given below:
"http://docs.oracle.com/cd/E49269_01/doc.12/e48361/ch2_preinstall.htm"


References:

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=200946853606923&id=369619.1&_afrWindowMode=0&_adf.ctrl-state=zutsf9dfd_4 - Doc ID: 369619.1

OCM Documentation Site: http://www.oracle.com/technetwork/documentation/ocm-092152.html

Oracle Fusion Middleware: Running RDA - Remote Diagnostic Agent(RDA) - RDA Çalıştırmak

RDA is a utility to be used to gather information that will aid in problem diagnostics. When we open an SR to Oracle, they will surely be requesting RDA analysis. This will surely shorten the duration for Oracle to provide a solution to the present error. Besides collecting logs is an integral part of chores that is requested by Oracle Support Team.

It is also a great to document what is on our system and how it is formed. It can be run against any number of Oracle tool such Oracle Database, Hyperion, Oracle BIEE and etc...

Once it is installed, rda.sh is run and it starts to gather information. Then the information can be put into Oracle Support(Metalink)

I also had an other article about RDA for EBS diagnostic purposes.

Below, supported products are listed for RDA.

Products Supported

RDA collects information that is useful for diagnosing issues related to the following Supported Oracle products

• OLAP Products (Express Server, Financial Analyzer, and Demand Planning Server)
• Oracle Application Server (iAS 1.0.2.x/9.0.x/10.1.2.x/10.1.3.x,10.1.4.x,WebLogic Server (WLS) Release 9.x and 10.x,11g (WLS), HTTP Server,WebCache,J2EE/OC4J)
• Oracle Billing and Revenue Management products
• Oracle BPEL Process Manager
• Oracle Collaboration Suite (Email Server,Calendar,Discussions,Content Services,Workspaces,WebClient,and Wireless)
• Oracle Data Integrator
• Oracle Developer (Forms and Reports)
• Oracle Ebusiness Suite 11i and 12
• Oracle Enterprise Content
• Oracle Enterprise Single Sign-on
• Oracle Enterprise performance management (Hyperion) products
• Oracle Guardian
• Oracle Identity Management products
• Oracle JDBC/PRO *C/ODBC and other development client related information
• Oracle Management Server and Intelligent Agent (Grid Server, Agent Server, DB Control)
• Oracle Networking products
• Oracle RAC Cluster (Single/Multiple Nodes, Automatic Storage Management, Oracle Cluster File System, Data Guard)
• Oracle RDBMS Server (Standard and Enterprise Editions)
• Oracle Retail (Retek)
• Oracle SQL*Plus/iSQL*Plus
• Oracle TimesTen In-Memory Database
• Oracle Universal Archive (11g)
• PeopleSoft
• Siebel

How To Download?

First we have to download the RDA.zip which can be accessed using the link in the References section.
RDA is also shipped with multiple Oracle products, for instance: Oracle Fusion Middleware, Oracle Communications Billing and Revenue Management, Oracle Configuration Manager, RAC and DB.

For example in Oracle Fusion Middleware it comes under the $MW_HOME/oracle_common/rda. To check if we have a proper installation of Oracle RDA we need to go to RDA Home and execute "rda.cmd -cv" in a Windows Environment which will control the directories. 

The result will be in the "output" directory. The required information can be started from index.html page.

References:

Oracle Support RDA -
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=180849391182810&id=314422.1&_afrWindowMode=0&_adf.ctrl-state=lo7kefmoz_115 - Doc ID 314422.1

https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=190383470244444&id=1498376.1&_afrWindowMode=0&_adf.ctrl-state=15trm3fo54_88
 - Doc ID:1498376.1

Oracle Fusion Middleware: OBIEE 11.1.1.7 Installation - OBIEE 11.1.1.7 Kurulumu

OBIEE is a Reporting Tool  which is comprised of 2  parts that is it's RCU(Repositories) and its main setup.

I will be summarizing the steps with proper pictures. I used to explain the whole process in Turkish but from now on I will use English. Nonetheless  you may ask me to explain the process in Turkish or English.

RCU Installation For OBIEE

Rcu will  let us create the users and schemas needed. It will connect to the database, create its schemas according to the settings that we set.

We go and run rcu.bat as an Administrator.

 We create the repositories.

 We have to provide database connection details.

 A prefix is given to cleary separate the schemas.

 Temp tablespace is given for the schemas to be used as the common tablespace.

In the end we have created 2 schemas with their corresponding passwords. These schemas will be given with their passwords during the OBIEE installation.

OBIEE Installation: 

OBIEE installation is the main setup in our installation. The executables, WebLogic Server, and OBIA setup is made.

We run it as an Administrator.

We choose enterprise installation since we are not upgrading but making an installtation from the beginning

 Then OBIA_MDS and OBIA_BIPLATFORM passwords are entered with  their connection details.

Briefly we have first created the schemas with RCU and then made the main setup. We will have our WebLogic Server and Enterprise Manager and OBI Analytics at the end of the installation.

The URL's below will be the link of our installation.

http://localhost:7001/console
http://localhost:7001/em
http://localhost:9704/analytics

But we are not still done with the installation. We still need the database connection,

Database Connection Through BI Administration Tool:

Database Connection details are entered by clicking to Connection Pool section.

After we enter the deatils we will check out and see if there is any error. If an error is found then there is a problem. Warnings can be ignored.

INST-08072: The BIEE Installer requires at least one IPv4 network interface, none were found Error: 

The error below can occur during the OBIEE installation, if we have started the installation with different settings other than English. To resolve this all the settings in Regional Settings must be set to English.