Date format into Timestamp with AM/PM

In OBIEE Answers,

MM/DD/YYYY format but I want to display it in MM/DD/YYYY HH:MM:SS AM

In Column Properties -> custom date format:

mm/dd/yyyy hh:mm:ss tt

AWS Solution Architect Mind Map

Oracle BI 12C Installation Error: BI Product Home must be specified in SYS property …: BI_PRODUCT_HOME

The BI 12C Installation throws the following error during the domain creation

 

BI Installation Error:

BI Configuration:

Config Action BI Configuration Failed

Configure BI Failed with cannon load EndpointManager: java.lang.RuntimeException. BI Product Home must be specified in sys property: oracle.bi.home.dir or env var:
BI_PRODUCT_HOME

 

BI Installation Error Screenshot:

 

 

Solution:

1. Close the BI 12C Configuration Assistant wizard

 

2. Run the RCU and Drop your BI schemas using the PREFIX

(Look at step 4 in the DROP RCU SCHEMAS )

 

3. Run the RCU and create the new BI Schemas again

 

4. Delete your partially-created BI domain from the following two folders

1. <MW_HOME>\user_projects\domains
2. <MW_HOME>\user_projects\applications

 

5. Create a new system variable that points to the <MW_HOME>\bi folder. For example, Look at the OBIEE 12C Installation

How to install OBIEE 12C NodeManager as Windows Service

In my previous post, I have explained step by step installation of OBIEE 12C on Windows machine. In this section, I detailed how to install OBIEE 12C node manager as Windows service. By doing this, we don’t need to start the Node Manager whenever the machine rebooted.

Note: The Node Manager is a WebLogic Machine

 

To Install OBIEE 12C Node Manager as Windows Service

 

1. Go to your <BI_DOMAIN_HOME>\bin directory, edit the installNodeMgrSvc.Cmd file set your DOMAIN_HOME property to your BI DOMAIN HOME. Don’t copy till bin directory

 

 

2. Open a command prompt in Administrative mode

 

 

2. Go to your BI Domain Home \ bin directory and run the command installNodeMgrSvc.cmd . Make sure you receive a successful Windows service creation message at the end of the command prompt

 

 

3. Open your Windows services, use the start /stop/ restart to control the Windows Node Manager service

 

 

 

How to Uninstall the Node Manager Windows service when it no longer needed

 

4. Stop the Windows Node Manager Service (Step 3), Open a command prompt as Administrator, and issue command ‘sc delete <SERIVICE_NAME>‘ like below

 

How to create a WebLogic Machine (12C)

• WebLogic machine is a logical representation of the server that hosts the WebLogic
• In a clustered environment, each server host a WebLogic machine
• The managed servers and Admin server can be associated with a WebLogic machine
• A WebLogic Machine requires a NAME, TYPE, LISTEN ADDRESS & PORT
• User can create multiple machines in a WebLogic domain
• The startNodeManager.sh (cmd) script is used to start the machine
• Once the machine is started, user can control the WebLogic servers like start or stop the servers

Create a WebLogic Machine

1. Login into to WebLogic console http://HOST:PORT/console

2. Click on Machines and select New

3. Input a machine name

4. Enable the desired Type, port number and click Finish