Invisible Indexes

In the name of Allah, Most Gracious, Most Merciful

Use following link for article.

Invisible Indexes

I hope it will serve the purpose.

How to Install Oracle Business Intelligence Enterprise Edition 11.1.1.6.0 (OBIEE) on Solaris 10 64-bit

In the name of Allah, Most Gracious, Most Merciful.
In this article I will describe the Installation of Oracle Business Intelligence Enterprise Edition 11.1.1.6.0 (OBIEE) on Solaris 10 64-bit. Before proceeding with installation make sure that you have created required database bi schema by running Repository Creation Utility (11.1.1.6.0). You can download the windows version of the utility and execute on database. Please find Oracle Database 11g installation on Solaris 10 64-bit here.

Download Repository Creation Utility (11.1.1.6.0) for windows and extract it on file system. Run following bat file

rcuHome\BIN\rcu.bat

Figure - 1

 Click "Next" or "تالى".

Figure - 2

 Select "Create" and click "Next" or "تالى".

Figure - 3

Provide database connection information and click "Next" or "تالى".

Figure - 4

 If your database character set is non-AL32UTF8 then above warning message will appear you can igrore it.

Figure - 5

Click OK.

Figure - 6

 Specify schema prefix and click "Next" or "تالى".

Figure - 7

Click OK

Figure - 8

 Specify password for database schema and click "Next" or "تالى".

Figure - 9

 Provide tablespace information and click "Next" or "تالى".

Figure - 10

Click OK

Figure - 11

 Click OK

Figure - 12

 Click Create.

Figure - 13

Click Finish. Repository Creation Utility completed successfully. Now run installer for Oracle Business Intelligence Enterprise Edition from Solaris 10 system by running following command.

Disk1/runInstaller

Figure - 14

Click Next.

Figure - 15

 Select "Skip Software Update" and click Next.

Figure - 16

 Select "Enterprise Install" and click Next.

Figure - 17

 Click Next.

Figure - 18

Provide new weblogic domain information and click Next.

Figure - 19

Provide new Middleware home location and click Next.

Figure - 20

Provide database connection information and password for DEV_BIPLATFORM schema that was created by RCU and click Next.

Figure - 21

Provide database connection information and password for DEV_MDS schema that was created by RCU and click Next.

Figure - 22

Click Next.

Figure - 23

Click Next.

Figure - 24

Uncheck the updates check box and click Next.

Figure - 25

 Click Yes.

Figure - 26

 Click Next.

Figure - 27

 View progress.

Figure - 28

View progress.

Figure - 29

View progress.

Figure - 30

View progress.

Figure - 31

 View URL information and click Finish.

Figure - 32

Run the URL of "Business Intelligence Enterprise Edition" from Figure - 31 in a browser. Provide weblogic as username and its password to logon.

Installation of Oracle Business Intelligence Enterprise Edition 11g 11.1.1.6.0 on Solaris 10 64-bit completes. Insha-Allah this will help and serve the purpose. For any corrections and improvements please suggest.

How to fix "Changes made in uifont.ali file through Enterprise Manager are not visible to in-process Reports Server"

In the name of Allah, Most Gracious, Most Merciful.

In this article I will describe how to fix "Changes made in uifont.ali file through Enterprise Manager are not visible to in-process Reports Server" issue. This bug is present in Oracle Reports 11g. Font Subsetting, Font Aliasing and Font Embedding modification through Enterprise Manager does not effect to in-process reports server.

There are two workarounds for this.

1. Actually, Enterprise Manager (EM) writes changes to the uifont.ali file located in following directory :

%INSTANCE_HOME%\config\FRComponent\frcommon\TOOLS\common

Although the standalone Reports Servers read from this file, the in-process Reports Server reads the uifont.ali file located in the following directory:

%ORACLE_HOME%\tools\common

2. By default the "UI" key in registry has the value :

%ORACLE_HOME%\tools\common

Add the directory "%INSTANCE_HOME%\config\FRComponent\frcommon\TOOLS\common" to this key. For example by default it is as follows :

D:\oracle\Middleware_dev11g\dev11g\tools\common

Change it as follows :

D:\oracle\Middleware_dev11g\dev11g\tools\common;D:\oracle\Middleware_dev11g\dev11g_inst\config\FRComponent\frcommon\TOOLS\COMMON

See Oracle Note 965582.1

Insha-Allah this will help and serve the purpose. For any corrections and improvements please suggest.

 

How to install Oracle Enterprise Manager Cloud Control 12c 64-bit on Solaris 10 64-bit

In the name of Allah, Most Gracious, Most Merciful.

In this article I will describe the installation of Oracle Enterprise Manager Cloud Control 12c 12.1.0.1.0 64-bit installation On Oracle Solaris 10 64-bit. Before proceeding make sure that repository database is already installed. You can find the 11gR2 database installation here. Installation of database completes most of the system parameter settings. 

Before installation of Enterprise  Manager you need to de-configure the database control repository from the above installed database. Run the following command from "oracle" user to do so.

$ emca -deconfig dbcontrol db -repos drop

Provide sys and sysman user passwords when prompted. Backup the spfile and execute the following commands on terminal.

sqlplus / AS SYSDBA 

ALTER SYSTEM SET processes=300 SCOPE=SPFILE;

ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;

ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;

SHUTDOWN IMMEDIATE

STARTUP

Download the Enterprise Manager Cloud Control 12c 12.1.0.1.0 64-bit for Solaris 64-bit and extract it. 

cd /export/home/oracle

$ unzip em12_solarisx64_disk1of2.zip

$ unzip em12_solarisx64_disk2of2.zip

$ ./runInstaller

Figure - 1

Un-check the security updates check box and click Next.

Figure - 2

Click Yes.

Figure - 3

Select the "Skip" radio option and click Next.

Figure - 4

 Click Next.

Figure - 5

Select "Advanced" option in "Create a new Enterprise Manager System" option. Provide Middleware Home Location and click Next.

Figure - 6

Select the management capabilities of your choice and click Next.

Figure - 7

Provide Weblogic and Nodemanager information and click Next.

Figure - 8

Provide installed database connection information and click Next.

Figure - 9

Click Yes.

Figure - 10

Click Yes.

Figure - 11

 Provide sysman's password and oms registration password and click Next.

Figure - 12

Click Next.

Figure - 13

Review information and click Next.

Figure - 14

Review information and click Next.

Figure - 15

Review progress.

Figure - 16

Review progress.

Figure - 17

Review progress.

Figure - 18

Open a terminal and run the above mentioned script with "root" user.

Figure - 19

Review information, copy Enterprise Manager Cloud Control URL and paste in a browser.

Figure - 20

Enter sysman and its password and click Login.

Figure - 21

Add following variables in oracle user's profile.

ORACLE_BASE=/u01/app/oracle

export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3/db_1

export ORACLE_HOME

OMS_HOME=$ORACLE_BASE/middleware/oms

export OMS_HOME

AGENT_HOME=$ORACLE_BASE/middleware/agent/core/12.1.0.1.0

export AGENT_HOME

Start Enterprise Manager by executing following commands.

$ cd ~

$ . ./.profile

$ORACLE_HOME/bin/dbstart $ORACLE_HOME

$OMS_HOME/bin/emctl start oms

$AGENT_HOME/bin/emctl start agent

Stop Enterprise Manager by executing following commands. 

$OMS_HOME/bin/emctl stop oms -all

$AGENT_HOME/bin/emctl stop agent

$ORACLE_HOME/bin/dbshut $ORACLE_HOME

Insha-Allah this will help and serve the purpose. For any corrections and improvements please suggest.