Resetting the OBIEE BISystemUser Password

These instructions describe how to change the Oracle Business Intelligence Enterprise Edition (OBIEE) password for the BISystemUser.

1. Log in to the WebLogic Admin Console

2. Change the password for WebLogic "BISystemUser" user under Security Realms

3. Log in to the EM Console

4. Navigate to Weblogic Domain > (right-click) obieedomain > Security > Credentials

5. Expand oracle.bi.system

6. Click on "system.user" then "Edit"

7. Change the password

References

• http://docs.oracle.com/cd/E21764_01/bi.1111/e10543/privileges.htm
• http://obieesagar.blogspot.com/2013/03/resetting-bisytemuser-password-in-obiee.html

 

Applicable Versions

• OBIEE 11g (11.1.1.9.0)

 

Setting WebLogic Server JVM heap

1. Edit both files:

• $MSERVER_HOME/bin/setDomainEnv.sh
• $ASERVER_HOME/bin/setDomainEnv.sh

2. Search for the following:

# IF USER_MEM_ARGS the environment variable is set, use it to override ALL MEM_ARGS values'

3. Replace it with:

# IF USER_MEM_ARGS the environment variable is set, use it to override ALL MEM_ARGS values
if [[ "${SERVER_NAME}" == AdminServer ]] ; then
export USER_MEM_ARGS="-Xms256m -Xmx2048m -XX:MaxPermSize=512m ${MEM_DEV_ARGS}"
fi
if [[ "${SERVER_NAME}" == osb_server1 ]] ; then
export USER_MEM_ARGS="-Xms8192m -Xmx8192m -XX:MaxPermSize=512m ${MEM_DEV_ARGS}"
fi
if [[ "${SERVER_NAME}" == osb_server2 ]] ; then
export USER_MEM_ARGS="-Xms8192m -Xmx8192m -XX:MaxPermSize=512m ${MEM_DEV_ARGS}"
fi
if [[ "${SERVER_NAME}" == bam_server1 ]] ; then
export USER_MEM_ARGS="-Xms8192m -Xmx8192m -XX:MaxPermSize=512m -XX:+UseTLAB -XX:TLABSize=64k -XX:PermSize=256m ${MEM_DEV_ARGS}"
fi
if [[ "${SERVER_NAME}" == bam_server2 ]] ; then
export USER_MEM_ARGS="-Xms8192m -Xmx8192m -XX:MaxPermSize=512m -XX:+UseTLAB -XX:TLABSize=64k -XX:PermSize=256m ${MEM_DEV_ARGS}"
fi
if [[ "${SERVER_NAME}" == soa_server1 ]] ; then
export USER_MEM_ARGS="-Xms8192m -Xmx8192m -XX:MaxPermSize=512m -XX:+UseTLAB -XX:TLABSize=64k -XX:PermSize=256m ${MEM_DEV_ARGS}"
fi
if [[ "${SERVER_NAME}" == soa_server2 ]] ; then
export USER_MEM_ARGS="-Xms8192m -Xmx8192m -XX:MaxPermSize=512m -XX:+UseTLAB -XX:TLABSize=64k -XX:PermSize=256m ${MEM_DEV_ARGS}"
fi 

Applicable Versions

• Oracle WebLogic Server 11g (10.3.6)

 

Oracle Maven Repository and Corrupted JARs

A colleague of mine approached me with a problem, I had recently switched a project over to Log4j2 and everything was going fine, but when he pull the latest develop branch and tried to build he got this eclipse error.

We tried a bunch of typical things, cleaning the build, deleting the project, doing a git clean, restarting Eclipse, etc. Decided to do a little Googling and found an article talking about corrupted JARs. So we though ok delete the folder for the JAR problem solved. Not so fast, happened again. So I thought a little more and asked him to open  the JAR file as if it was plain text. Low and behold we get some HTML.

The fix in this case was just that they needed to setup their authentication to the Oracle Maven Repo.



References:

http://docs.oracle.com/middleware/1213/core/MAVEN/config_maven_repo.htm#MAVEN9018

Enable SSL debug settings in WebLogic startup

1. Edit the start script:

vi $MSERVER_HOME/bin/startManagedWebLogic.sh

2. Add the following:

JAVA_OPTIONS="-Dweblogic.security.SSL.trustedCAKeyStore="/u01/app/oracle/middleware/wlserver_10.3/server/lib/cacerts" ${JAVA_OPTIONS} -Dssl.debug=true -Dweblogic.StdoutDebugEnabled=true"

Applicable Versions

• Oracle WebLogic Server 11g (10.3.6)

 

Setting up a bootable USB drive to install Oracle Linux 7

Want to create a USB boot drive for Oracle Linux 7? First, make sure you have one with at least 16 GB.

1. On Microsoft Windows, download pwfree91-x86.iso. This will be used by the USB Installer program.

2. Download USB Installer 1.9.6.7.

3. Select the options below to format the USB drive and make it bootable.

4. Log in to an existing Oracle Linux installation (could be any VirtualBox image).

5. Make sure your USB drive is connected.

6. In my example below, I can see my USB drive mounted as /media/NEWVOLUME.

[root@soahost ~]# df -m

Filesystem           1M-blocks  Used Available Use% Mounted on

/dev/mapper/vg_soatraining-lv_root

                         18527  5743     11820  33% /

tmpfs                     3301     1      3300   1% /dev/shm

/dev/sda1                  477   169       279  38% /boot

/dev/sdb1                25070  5096     18678  22% /u01

/dev/sdc                 32126   347     30126   2% /oracle

/dev/sdd1                29570 25277      4293  86% /media/NEWVOLUME

7. Unmount the USB drive.

[root@soahost u01]# umount /dev/sdd1

8. Designate the first partition as bootable.

[root@soahost u01]# parted /dev/sdd

GNU Parted 2.1

Using /dev/sdd

Welcome to GNU Parted! Type 'help' to view a list of commands.

(parted) toggle 1 boot                                                    

(parted) quit                                                             

Information: You may need to update /etc/fstab.

9. Download the Install_OL_fromUSBStick_Script script.

10. Download Oracle Linux 7 from the Oracle Software Delivery Cloud.

11. Specifically download these two files:

• V100082-01.iso (Oracle Linux Release 7 Update 2 for x86_64 64 Bit)
• V100086-01.iso (Oracle Linux Release 7 Update 2 Boot ISO image for x86_64 64 bit)

13. Make the script executable and run it.

[root@soahost u01]# chmod 500 Install_OL_fromUSBStick_Script 

[root@soahost u01]# sh Install_OL_fromUSBStick_Script --reset-mbr ./V100086-01.iso /dev/sdd1

Verifying image...

Install_OL_fromUSBStick_Script: line 527: checkisomd5: command not found

Are you SURE you want to continue?

Press Enter to continue or ctrl-c to abort

.

.

.

progress 276168704/277409792 (4.7 MB/s)

progress 276234240/277409792 (4.7 MB/s)

progress 276299776/277409792 (4.7 MB/s)

progress 276365312/277409792 (4.7 MB/s)

progress 276430848/277409792 (4.7 MB/s)

.

.

.

progress 277409792/277409792 (4.7 MB/s)

Updating boot config file

Installing boot loader

USB stick set up as live image!

14. Take the USB drive out of your machine, and put it back in so that it gets auto-mounted.

15. Copy the V100082-01.iso file to the USB drive which will be needed once installation begins.

[root@soahost u01]# cp ./V100082-01.iso /media/NEWVOLUME

References:

• https://blogs.oracle.com/OTNGarage/entry/how_to_install_oracle_linux
• https://docs.oracle.com/cd/E52668_01/E54695/html/ol7-install-media-usb.html
• https://docs.oracle.com/cd/E37670_01/E41137/html/ol_usb_boot.html

Applicable Versions:

• Oracle Linux 7+

Running BSU to patch WebLogic Server

1. Copy the patch to the required directory:

cp /tmp/p24667634_1036_Generic.zip $MW_HOME/utils/bsu/cache_dir

cd $MW_HOME/utils/bsu/cache_dir

unzip p24667634_1036_Generic.zip 

cd $MW_HOME/utils/bsu

2. Confirm when the last patch update was deployed:

. $WL_HOME/server/bin/setWLSEnv.sh

java weblogic.version

3. For example, the output could look something like this

WebLogic Server 10.3.6.0.161018 PSU Patch for BUG23743997 TUE SEP 30 20:43:33 IST 2012
WebLogic Server 10.3.6.0 Tue JAN 15 12:36:25 PST 2011 1441050

4. See the list of applied patches:

./bsu.sh -view -status=applied -prod_dir=/u01/app/oracle/middleware/wlserver_10.3

5. Apply the patch (replace XIDD with the patchlist id) (the patchlist id is in the readme):

./bsu.sh -install -patch_download_dir=/u01/app/oracle/middleware/utils/bsu/cache_dir -patchlist=XIDD -prod_dir=/u01/app/oracle/middleware/wlserver_10.3

6. If the patch fails, uninstall the previous patch (replace K25M with the patchlist id), then repeat step #5:

./bsu.sh -remove -patchlist=K25M -prod_dir=/u01/app/oracle/middleware/wlserver_10.3

 

Applicable Versions

• Oracle WebLogic Server 11g