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)

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/ 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_INSTANCE (for 11g only)
DOMAIN_HOME (for 11g, 12c only)

Run the below command: -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

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