INSTALLATION DOCUMENTS BY RAVI

Friday, May 31, 2019

Converting bat file to exe


Sample bat file:
Create a sample bat file as below
























By executing this bat file we will get the below output













Converting bat files to exe:
Download and install bat to exe converter as below






































Run the installer as administrator and
Provide the bat file to convert to exe and click on complete
























This will create a exe file as below























Double click the exe file to see the output
















Collecting Diagnostic Information for OBIEE Security Issues Analysis using RDA utility


Important information:
Ensure you are logged on to the host machine experiencing the problem as the Operating System user that owns the files to be collected.
If your issue involves multiple processes distributed across different hosts, follow the instructions for each host machine.

Run RDA:
Navigate to ORACLE_HOME/oracle_common/rda










Set the below environment variables:
ORACLE_HOME
ORACLE_INSTANCE (for 11g only)
DOMAIN_HOME (for 11g, 12c only)








Run the below command:

rda.sh -s OutputFileName  -v -p FM12c_Bi










Note: We may get this issue due to older rda version and resolution is to upgrade the rda utility to newer version.

Checking rda version:























Upgrading RDA:
Download and stage the Patch set 29687335 as below
















































Backup the current rda folder and replace it with rda folder from downloaded patch.




















Check the version now:

























Collecting diagnostic information:

























































































































Note: Upload this zip file to oracle support if we raise any service request.

Creating Pluggable database using database configuration assistant


Launch Database Configuration Assistant



























Select Manage Pluggable Databases and click on Next




















Select Create a Pluggable Database and click on Next




















Select database , provide username and password and click on Next





















Click on Yes





















Click on Next





















Provide pluggable database name, location and user details and click on Next





















Click on Yes





















Click on Finish







































Pluggable database created successfully, click on close



Thursday, May 30, 2019

Steps for collecting OBIEE 12c diagnostic bundle


With this we can collect the below security files and logs as a bundle:
[DOMAINHOME]/bi/bilogs
[DOMAINHOME]/bi/config
[DOMAINHOME]/bi/servers
[DOMAINHOME]/bi/nodemanager
[DOMAINHOME]/bi/biupgrade
[DOMAINHOME]/bi/bin/setDomainEnv.sh

Collect a diagnostic bundle by running the following command:
[DOMAINHOME]/bitools/bin/diagnostic_dump.sh | .cmd [your path]/<zip file name>.






Click Enter
































Archiving Catalog through Catalog Manager


Open Catalog Manager



























Go to File and Click on Open Catalog





















Provide the details below and click on ok



















Type: Online
User: weblogic
Password: ********
Locale: English



Click on Ok















Double click on Catalog Root and select the folder we want to Archive


















Provide the path and select time stamps and permissions and click on ok



















Click on OK



















Archived catalog file


















SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...