Thursday, May 21, 2015

OBIEE 11.1.1.9 Administrator Features

OBIEE 11.1.1.9 Administrator Features.
Mainly on presentation services diagnostics and dynamic log level  and filtering.

  1. Set dynamic log level per session from manage sessions
  2. Filter cursor cache based on specific user sessions
  3. Change sort order of cursor cache
  4. Show Presentation Services diagnostics per cursor





OBIEE 11G 11.1.1.9 View Types features TREEMAP

OBIEE 11G TREEMAP added in 11.1.1.9 version and it was there in BICS (BI Cloud Services) OR
11G 11.1.1.7.10 update as well.




Monday, May 18, 2015

Oracle Data Integrator 11G 11.1.1.9 Available for downloads with wallet and Asynchronous Web Services features

Oracle Data Integrator 11G 11.1.1.9 Available for downloads with wallet and Asynchronous Web Services features

Note:  Wallet feature already available in 12C.

http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html

Oracle Data Integrator 11.1.1.9.0 New Features

password-protected wallet.: 

Studio Login Security Enhancements Oracle Data Integrator Studio login credentials can now be stored in a password-protected wallet. In order to login to the Oracle Data Integrator Studio, a login profile must be created where the connectivity to the ODI repository and the user credentials are specified. Oracle Data Integrator can now save these credentials in either an encrypted login XML file or a password-protected wallet. Depending on your security requirements you can now choose either of them.

 Oracle Data Integrator Asynchronous Web Services 

The Oracle Data Integrator agent provides web services for invoking Oracle Data Integrator sessions in both synchronous and asynchronous modes. In the synchronous mode, the web services invocation is blocked until the session execution finishes. However, in the asynchronous mode the web services call is not blocked and the caller provides details of the end-point where the response should be sent on session completion. Oracle Data Integrator can now send responses to such asynchronous invocation to endpoints that are secured with Oracle Web Service Manager (OWSM) policies


Source : Oracle
http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html


Saturday, May 16, 2015

WebLogic Server instance as Windows Service and odi server as windows service

WebLogic Server instance as Windows Service and odi server as windows service

Create below .cmd files in C:\Oracle\Middleware\wlserver_10.3\server\bin.
*************************************************************************
Create two duplicate files from installSvc.cmd file and rename like below two files

1) installAdmSvc.cmd
2) installODISvc.cmd
and Add below line  in both files.

set JAVA_VM=-server














***************************
InstallAdminServer_Service.cmd
***************************

echo off
SETLOCAL
set JAVA_VENDOR=sun
set JAVA_HOME=C:\Java\jdk1.6.0_45
set DOMAIN_NAME=base_domain
set USERDOMAIN_HOME=C:\Oracle\Middleware\user_projects\domains\base_domain
set SERVER_NAME=AdminServer
set WLS_USER=weblogic
set WLS_PW=Admin123
set PRODUCTION_MODE=true
set MEM_ARGS=-Xms512m -Xmx1024m
cd %USERDOMAIN_HOME%
call %USERDOMAIN_HOME%\bin\setDomainEnv.cmd
call "C:\Oracle\Middleware\wlserver_10.3\server\bin\installAdmSvc.cmd"
ENDLOCAL

*************************
InstallODIServer_Service.cmd
*************************

echo off
SETLOCAL
set JAVA_VENDOR=sun
set JAVA_HOME=C:\Java\jdk1.6.0_45
set DOMAIN_NAME=base_domain
set USERDOMAIN_HOME=C:\Oracle\Middleware\user_projects\domains\base_domain
set SERVER_NAME=odi_server1
set WLS_USER=weblogic
set WLS_PW=Admin123
set PRODUCTION_MODE=true
set ADMIN_URL=http://localhost:7001
set MEM_ARGS=-Xms512m -Xmx1024m
cd %USERDOMAIN_HOME%
call %USERDOMAIN_HOME%\bin\setDomainEnv.cmd
call "C:\Oracle\Middleware\wlserver_10.3\server\bin\installODISvc.cmd"
ENDLOCAL


***********************************************************************
Installing AdminServer and odi_server1 using command line with Administrator user
***********************************************************************


















For debugging we can use below command.

cd C:\Oracle\Middleware\wlserver_10.3\server\bin
beasvc -debug "beasvc base_domain_AdminServer"
beasvc -debug "beasvc base_domain_odi_server1"





***********************************************************************
For Unstallation we can create new file for Adminserver and odi_server1
***********************************************************************

uninstallAdmSvc.cmd
*******************

echo off
SETLOCAL
set DOMAIN_NAME=base_domain
set SERVER_NAME=AdminServer
call "C:\Oracle\Middleware\wlserver_10.3\server\bin\uninstallSvc.cmd"
ENDLOCAL

uninstallAdmSvc.cmd
*******************

echo off
SETLOCAL
set DOMAIN_NAME=base_domain
set SERVER_NAME=odi_server1
call "C:\Oracle\Middleware\wlserver_10.3\server\bin\uninstallSvc.cmd"
ENDLOCAL

sc delete "beasvc base_domain_odi_server1"

 

***********************************************************************
Verify AdminServer and odi_server1 log files for errors
***********************************************************************

AdminServer.log file location
 C:\Oracle\Middleware\user_projects\domains\base_domain\servers\AdminServer\logs

odi_server1.log file location
C:\Oracle\Middleware\user_projects\domains\base_domain\servers\odi_server1\logs 


***********************************************************************
********************  COMMON ERRORS**********************
***********************************************************************


***********************************************************************
If we get error like  "java.lang.OutOfMemoryError: PermGen space"
***********************************************************************
 set MEM_ARGS=-Xms512m -Xmx1024m
and change in setDomainEnv.cmd
available in 
C:\Oracle\Middleware\user_projects\domains\base_domain\bin\setDomainEnv.cmd

***********************************************************************
If we get error like The object identified by: '31' could not be found
***********************************************************************
 remove admin url line or change port number as Adminserver host n port number like

set ADMIN_URL=http://localhost:7001


***********************************************************************
If we get error like Premature end of file encountered then copy below file
***********************************************************************

Error encountered when starting ADMIN Server. This is due to corrupted system-jazn-data.xml file.
Replace it in
Copy "system-jazn-data.xml" from
      ********************
SOURCE : C:\Oracle\Middleware\oracle_common\modules\oracle.jps_11.1.1\domain_config TO
DEST :  C:\Oracle\Middleware\user_projects\domains\base_domain\config\fmwconfig