How to download Oracle Software directly in Servers using wget.sh file | How to download using wget.sh file

I often wonder that how do we download GB size of oracle softwares and move it server and Install the same until I get to know how simple is that downloading any size of software using wget.sh shell script file directly in server.

Steps are very Simple. But as a first thing, Create/Have an Oracle account for You!

Step1:

Either Oracle eDelivery or Support.oracle.com, get the wget.sh file for the software that you would like to download

Download .sh and move the file to server where you want to download.

Step2:

Open shell scripts or command prompt just run the below command

[$] ./wget.sh

enter your username: bose.obiee@gmail.com + enter

[type your password] + enter

Note:

i. Enter the same username and password which you used to download the software

ii. After entering the username, just enter it 

iii. Second line will be blank but enter the oracle account password and click enter

iv. Check if you have proper privileges with read+write+execute permission in the target directory             when you are downloading.

If it is a bigger a software then it would take sometime based on the network speed in server and will complete the download.

Happy Blogging!

Bose

OBIEE 12c Lift and Shift

When we are doing the lift and shift of OBIEE 12c, We would be copying the entire OBIEE 12c installed directory to the new server. 

When we are doing this change, We have to complete prerequisite check first and then we have to update the hostname and IP Address of the new server in the following locations in OBIEE 12c files.

Following are the file locations and file names for two Node clustered Servers:

Node1

Update the IP address in startup.properties file in the following locations.

/OBIEE12C/user_projects/domains/bi/servers/bi_server1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/servers/bi_server3/data/nodemanager

/OBIEE12C/user_projects/domains/bi/servers/bi_server5/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBICCS/obiccs1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIJH/obijh1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIPS/obips1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBISCH/obisch1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIS/obis1/data/nodemanager

Update IP address of the new server in nodemanager.properties file in below location

/OBIEE12C/user_projects/domains/bi/nodemanager

Update IP address of the new server in  config.xml file in below location

/OBIEE12C/user_projects/domains/bi/config

Update IP address of the new server in admin.conf  file in below location

/OBIEE12C/user_projects/domains/ohs/config/fmwconfig/components/OHS/instances/ohs1

Update IP address of the new server in wsm-ccw-config.xml file in below location

/OBIEE12C/user_projects/domains/bi/config/fmwconfig

Node2:

Update the IP address in startup.properties file in the following locations.

/OBIEE12C/user_projects/domains/bi/servers/bi_server2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/servers/bi_server4/data/nodemanager

/OBIEE12C/user_projects/domains/bi/servers/bi_server6/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBICCS/obiccs2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIJH/obijh2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIPS/obips2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBISCH/obisch2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIS/obis2/data/nodemanager

Update the IP address in nodemanager.properties file in the following location.

/OBIEE12C/user_projects/domains/bi/nodemanager

Update the IP address in config.xml file in the following location.

/OBIEE12C/user_projects/domains/bi/config

Update the IP address in  admin.conf file in the following location.

/OBIEE12C/user_projects/domains/ohs/config/fmwconfig/components/OHS/instances/ohs2

Update the IP address in wsm-ccw-config.xml file in the following location.

/OBIEE12C/user_projects/domains/bi/config/fmwconfig

Cheers!

Bose

OBIEE 12c BIPLATFORM / MDS Account Password Expired or Account locked

I have recently come across an issue where few of our BI components went down and while stopping/restarting the services, It prompts for weblogic User Name and Password and also failing to start the services.

I have started analyzing the AdminServer log files in OBIEE 12c where I found the issue details like

[jdbc:oracle:thin:@//biapp:1521/bidev]

caused by java.sql.SQLException: ORA-28001: the password expired.

Then I understand that the supporting schemas like MDS, BIPLATFORM, IAU, OPSS and etc., accounts are expired in database. Here is the steps that how I have resolved that.

Step1: Connect to oracle database as a sys user and run the below query to get the expired accounts.

SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS WHERE ACCOUNT_STATUS LIKE 'EXPIRED%';

Above query will result all the expired account details.

OR

SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME LIKE 'DEV_%'

Above query will result all the accounts starting with the name 'DEV_'

 

If you see the above screenshot, 6 accounts are expired. Lets start fixing it.

Step2: First we have to get the existing password for the expired accounts. For that run below query.

SQL> SELECT USERNAME, PASSWORD FROM DBA_USERS WHERE USERNAME = 'DEV_BIPLATFORM';

This query will give the password for only DEV_BIPLATFORM account. same like, get the password for all the accounts.

Step3: Reset the password for the account

SQL> ALTER USER DEV_BIPLATFORM IDENTIFIED BY 'Admin123';

Step4: (Optional: If any account is locked)

SQL> ALTER USER DEV_BIPLATFORM ACCOUNT UNLOCK;

Step5: Disable Password expiry

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Note:

If you need to know the Profile name , then Please run the below Query:

SYNTAX: 

SELECT PROFILE FROM DBA_USERS WHERE USERNAME = '<USERNAME>';

E.G: 

SELECT PROFILE FROM DBA_USERS WHERE USERNAME = 'DEV_BIPLATFORM';

OBIEE 12c File Locations

If you wonder, where are RPD, Catalog and all the other locations in OBIEE 12c. Here is the path to few files:

Live RPD Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/bidata/service_instances/ssi/metadata/datamodel/customizations

Catalog Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/bidata/service_instances/ssi/metadata/content

To Start, Stop or Start and Deploy RPD BI Sevices [start.sh, stop.sh, status.sh, datamodel.sh]:
[ORACLE_BI_HOME]/user_projects/domains/biee/bitools/bin

To Start/ Stop Weblogic Server, NodeManager 
[startNodeManager.sh, stopNodeManager.sh, stopWeblogic.sh, startWeblogic.sh]:
[ORACLE_BI_HOME]/user_projects/domains/biee/bin

InstanceConfig.xml Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/biconfig/OBIPS

NQSConfig.INI Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/biconfig/OBIS

ssl Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/biconfig/core/ssl

ODBC.ini Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/bienv/core

obis.properties Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/bienv/OBIS

Catalog Manager:
[ORACLE_BI_HOME]/bi/bifoundation/web/catalogmanager

Cheers!
Bose

OBIEE 12c with MySQL Community Edition Connectivity

This post brings the workaround on How to connect OBIEE 12c Environment with MySQL Server Community Edition.
This is Tested on OBIEE 12.2.1.3.0

Assumption :
OBIEE 12c comes with DataDirect Connections and support only for Enterprise Edition. But our requirement is to connect Community Edition as our DW is developed in there.

MySQL Community Edition ( i.e. FREE edition )
Server OS is Redhat 7 64-bit

Import tables in OBIEE Admin Tool
Download latest ODBC Driver and Install, set up DSN,  , Create connection pool, Import metadata, Define business and presentation layers.

Problem:   
Data Direct Drivers are shipped to connect OBIEE to MySQL.  Unfortunately these do not work as you get a message "[nQSError: 16001] ODBC error state: S1000 code: 0 message: [DataDirect][ODBC MySQL Wire Protocol driver]Connections to MySQL Community Servers are not supported.  Please contact MySQL to obtain a MySQL Enterprise or Commercial version.."

Solution:
Step1:
Use MySQL native ODBC instead of DataDirect ODBC.

You can get these from
http://dev.mysql.com/downloads/connector/odbc/#downloads

This is an rpm download and install, you need root privileges to do this.  DO NOT DOWNLOAD THE ANSI driver as it does not work.  
We have to download for Redhat 64bit Server:
mysql-connector-odbc-setup-8.0.13-1.el7.x86_64.rpm

Step2:
Update the configuration in ODBC.ini

Go to the following directory and update the ODBC.ini file like below:

ORACLE_BI_HOME/domains/biee/config/fmwconfig/bienv/core

Note: We can use either OBDC Driver (libmyodbc8w) or ANSI Driver(libmyodbc8a).

[MySQLDevTest]
Driver         = /usr/lib64/libmyodbc8a.so
Description  = Connector/ODBC 8.0 ANSI Driver DSN
SERVER       = mysql.dbhostname.com
PORT          = 3306
USER          = username
Password     = password
Database     = dbname
OPTION       = 3

Step3:  

Go to the following directory and update the obis.properties file for LD_LIBRARY_PATH to point OBDC Driver.

ORACLE_BI_HOME/domains/biee/config/fmwconfig/bienv/OBIS

e.g. 

"LD_LIBRARY_PATH" value="/usr/lib64:$ORACLE_HOME/common/ODBC/Merant/6.0SP1/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/clients/epm/Essbase/EssbaseRTC/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib"

Import Points to Note:

Connection Pool Name, ODBC.ini configuration in OBDC Data Sources name and MYSQL configuration name has to be same.

E.g: MySQLConnTest

Cheers!

Bose

Starting and Stopping OBIEE 12c Services in Linux

Go to the following directory:

/obiee/Oracle/Middleware/Oracle_Home/user_projects/domains/biee/bitools/bin

Run the below commands to start, stop or to know the status of entire services.

To Stop All the Services

[root@obiee bin] ./stop.sh

To Know the  Status of All Services: 

[root@obiee bin] ./status.sh

To Start all BI Services

[root@obiee bin] ./start.sh

To particularly start or stop one or few services use below commands

Syntax:

./start.sh -i service_name1, service_name2

e.g: [root@obiee bin] ./start.sh -i obis1

./stop.sh -i servicename1, servicename2

[root@obiee bin] ./stop.sh -i obis1

In Windows, instead of .sh use .cmd. for Example. start.cmd

Cheers!

Bose

Setting Java Home in Linux

Edit the .bashrc or .bash_profile file and add the below line:

[$] vi .bashrc

export JAVA_HOME="Enter_the_Java_Home_Directory"

e.g: export JAVA_HOME=/app/JDK/jdk1.8

Here is the complete steps:

https://access.redhat.com/documentation/en-US/JBoss_Communications_Platform/5.0/html/Platform_Installation_Guide/sect-Configuring_Java.html

After updating it, just source the file so it would be effective immediately and you could verify with the below command

[$] source .bashrc

[$] echo $JAVA_HOME

Cheers!
Bose