Clone the bi-server in OBIEE 11G

To clone your biserver in OBIEE 11G login to your Weblogic Admin Console, from bifoundation_domain select Environments and follow the steps.

1) In the change center Click "Lock and Edit", this would make servers available for selection.

 

2) By clicking in the check box Select the server you want to clone from the provided server list and click clone.

3) Provide the server name for your all new server and assign a port for it, the administrator should notice that server name and port(Here I am Using 9705) should be unique. Click ok to make the clone.

4) Go to Change Center and Activate the changes.

5) Move to the control tab in the Summary of Servers.

6) Select the new server and click Start button. (Due to some memory limitation in my machine I am giving a Force Shutdown for my default Server.)

7) Wait till it starts up.

8) You can observe the status of the server and satus of last action. If your process is complete status of last action would show "TASK COMPLETED"

9) The new server can be accessed through the new port assigned (9705)

10) New Server is also listed in the Enterprise Manager.

Thus the cloning of biserver is completed.

 Thank you for sparing your time with my blog.

Local Temporary tables

Local temporary tables are valid within Modules/Schema and are bound to active SQL sessions.
The syntax to create a Local Temporary table is:

DECLARE LOCAL TEMPORARY TABLE table_name ( fields);

Example

DECLARE LOCAL TEMPORARY TABLE employee_temp
( employee_id number(10) not null,
  employee_name varchar2(50) not null,
  employee_designation  varchar2(50)
);

The above command will create a temporary "employee_temp" table.

Substring in Oracle SQL

The basic syntax for Sub-String in oracle sql is

"SUBSTR(string/column/field,start_position,length)"

and this function is available in all versions from Oracle DB 8i till Oracle DB 12 C (Oracle 12c)

If start_position is 0, then the SUBSTR function treats start_position as 1 (ie: the first position in the string).

If start_position is a positive number, then the SUBSTR function starts from the beginning of the string.

If start_position is a negative number, then the SUBSTR function starts from the end of the string and counts backwards.

If length is a negative number, then the SUBSTR function will return a NULL value.

Examples:

SUBSTR('This is a test', 6, 2)	return 'is'
SUBSTR('This is a test', 6)	return 'is a test'
SUBSTR('IntelBusi', 1, 5)	return 'Intel'
SUBSTR('IntelBusi', -4, 4)	return 'Busi'
SUBSTR('IntelBusi', -4, 3)	return 'Bus'