Connecting Microsoft SQL Server using Oracle SQL developer

We can connect Microsoft SQL server using oracle SQL developer by following the steps below.

Download “jTDS-SQL Server and Sybase JDBC driver”.

Open SQL developer

Click on Tools and then click on Preferences

Under Database Click on Third Party JDBC Driver

Add the downloaded SQL server JDBC driver and click on ok

Try to create a new connection, we will see SQL Server option now.

Select SQL Server and provide the connection details and Click on Test.

We will get a Success status.

Error in invoking target 'agent nmb nmo nmhs' of makefile

Error in invoking target 'agent nmb nmo nmhs' of makefile

INFO: Exception thrown from action: make

Exception Name: MakefileException

Exception String: Error in invoking target 'agent nmb nmo nmhs' of makefile '/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk'. See '/u01/app/oraInventory/logs/installActions2019-06-17_02-10-30AM.log' for details.

Exception Severity: 1

SOLUTION

The solution is to add “-lnnz11” to the end of the ins_emagent.mk

Edit $ORACLE_HOME/sysman/lib/ins_emagent.mk, search for the line

$(MK_EMAGENT_NMECTL)

 Replace the line with

$(MK_EMAGENT_NMECTL) -lnnz11

Then click “Retry” button to continue.

Customizing Logo OBIEE 12.2.1.4

Form OBIEE 12.2.1.3 and later for customizing logo under Administration, Theme Management option ids provided

Steps for customizing Logo:

Login to Analytica page and click on Administration

Under Theme Management click on Manage Themes

Now we are going to change the default logo from oracle to google.

Note:

Image name must be saved without any special characters

Image size must not exceed Pixels Horizontal: 130 and Vertical: 28

Example image file:

Provide Theme Name

Select Logo and upload the image file we want to use as logo

Provide Header Title

Check the box for Active

Click on Save

We will get a successful message

Click on Ok

Reload the page

Now we will able to see Custom Logo and Title

OBIEE 12c Start Script Fails to Connect to the Node Manager with Error General SSLEngine Problem

After configuring SSL with Custom Identity and Trust Keystores and when we try to start the servers getting the below error

Resolution:

To resolve this Invoke WLST with additional Java parameters that explicitly identify the Custom Trust KeyStore, as below

Backup the ORACLE_HOME/oracle_common/common/bin/wlst_internal.sh file

Edit the wlst_internal.sh file, add the Java parameters (either before or after the ${JVM_ARGS} entry)

From:  eval '"${JAVA_HOME}/bin/java"' ${JVM_ARGS} weblogic.WLST '"$@"'

To:

eval '"${JAVA_HOME}/bin/java"' ${JVM_ARGS} -Dweblogic.security.SSL.ignoreHostnameVerification=true -Dweblogic.security.CustomTrustKeyStoreType="JKS" -Dweblogic.security.TrustKeyStore=CustomTrust -Dweblogic.security.CustomTrustKeyStoreFileName="/u01/app/oracle/keystores/keystore.jks" weblogic.WLST '"$@"'

Save and close the file.

Try to restart the servers again

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

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

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