OPMN (Oracle Process Manager and Notification Server)

Oracle Process Manager and Notification Server (OPMN), which is used for process Start/Stop/restart and it can be used for process recovery.

• It can be managed via Enterprise Manger

         

• It can be managed through the command line and it can be located in the following path.

      [Oracle Home]/instances/instance1/bin/opmnctl.bat

Starting or Stopping all processes or services from the command line

• Checking the current status of all managed services

[Oracle Home]/instances/instance1/bin>opmnctl status

• To start all the services

[Oracle Home]/instances/instance1/bin>opmnctl startall

• To stop all the services

[Oracle Home]/instances/instance1/bin>opmnctl stopall

Start/Stop/Restart the individual process or service from the command line

• To start individual service

[Oracle Home]/instances/instance1/bin>opmnctl startproc  ias-component=coreapplication_obis1

• To Stop individual Service use the below command

Opmnctl stopproc 

• To restart individual service use the below command

Opmnctl restartproc 

Start/Stop/Restart the individual process or service from the Enterprise Manager

Using Custom Format in OBIEE Answers

The report requirement is show (+) Character if the value is positive and (-) character if the value is negative and Values to be shown as "$425 K"

To achieve this format in OBI answers, we have to manually change the custom format in column properties to show the results in desired format as shown below.

"+" #,##0;"-" #,##0
$#,##0 K

Result:

To avoid blank spaces or Null Values in Pivot table view, use below format in custom format section.


#,##0;-#,##0;0

column name has Leading or Trailing spaces in it

Error :[39015]

The name @1%s has leading or trailing space(s) in it.

Cause. The name has leading or trailing space(s).

Response. Remove the leading or trailing space(s) using the Administration Tool.

Error: [39016]

The alias "@1%s" of @2%s has leading or trailing space(s) in it.

Cause. The alias has leading or trailing space(s).

Response. Remove the leading or trailing space(s) using the Administration Tool.

The above errors, causes and responses are provided in Oracle Bookshelf. 

To resolve your issue, remove extra spaces after the column names.

Issue with Direct Database Request in OBIEE

We have an issue with Direct database request while creating a report. The below is the issue.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 13017] User or group has not been granted the Direct Database Access privilege to access the database ‘YOUR CONNECTION POOL’. Please verify the User/Group Permissions in the Oracle BI Administration Tool. (HY000)

Solution

 In Presentation Services->Settings->Administrations->Manage Privilege" have given permission to "Execute Direct Database Requests"  for user or Group.

AND Mandatory to give an access in RPD.

Open OBIEE Administrative tool click on Manage->security->user or Group
Double click on the user  or group who needs to have the execute direct database request permission.Select "allow" from the drop down list in the query limits block to the respective connection pool.

Hope this will resolve your issue.