INSTALLATION DOCUMENTS BY RAVI

Sunday, June 30, 2019

Customizing logo OBIEE 12c lightweight login page


With OBIEE 12.2.1.4.0 there is, by default, a new login page called “lightweight SSO”.
It has a different style when compared to the “old” classical login page
By deploying a custom “oracle_logo.png” it will not affect the new login page.





















But after login to the page we were able to see the custom logo we deployed.





















If we inspect the page we didn’t find the oracle_logo.png and we can observer that it is using a different font as below “vafont”





















If we disable the font we can observer that “ORACLE” is replaced by a rectangle





















Workaround:
By editing the CSS file “loginhelper.css” we can customize the logo as below
Getting the logo URL:
Login to analytics page
Right click on logo and click on “View image info”





















Copy the image url

























/analytics/res/v-0gVQmmIfY4w/s_Alta/master/oracle_logo.png




Modify the file “loginhelper.css “ under the location /u01/app/oracle/middleware/user_projects/domains/bi/servers/bi_server1/tmp/_WL_user/bi-security-login/7iuedy/war/css as below
Remove the line “font-family: 'vafont';” under bitech-logo and add the image url to content under bitech-logo::before as below






















Login to EM console and restart the components







































Now we are able to see the custom logo





















Monday, June 17, 2019

sendEmail[18533]: ERROR => No TLS support! SendEmail can't load required libraries. (try installing Net::SSLeay and IO::Socket::SSL)


Getting the below error while trying to send mail using sendEmail on Linux:
sendEmail[18533]: ERROR => No TLS support!  SendEmail can't load required libraries. (try installing Net::SSLeay and IO::Socket::SSL)








Resolution:
To resolve this install the below rpms
yum install 'perl(Net::SSLeay)




yum install 'perl(IO::Socket::SSL)'






















































Now try to send the mail again




















It is failed with below error:
at ./sendEmail line 1906.
invalid SSL_version specified at /usr/share/perl5/vendor_perl/IO/Socket/SSL.pm line 444.

To resolve this error modify sendEmail file as below




















Now try to send the mail again, we will get a successful message


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.

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...