Showing posts with label OBIEE 10G. Show all posts
Showing posts with label OBIEE 10G. Show all posts

Thursday, March 20, 2014

Steps To Uninstall OBIEE 10g On Windows

Follow these steps to successfully uninstall OBIEE 10g on a Windows environment:

1. From the Start menu, navigate to Settings - > Control Panel -> Add or Remove Programs.
2. In Add or Remove Programs section, select Oracle Business Intelligence 10.x and click Remove.
3. In the OC4J Administrator User Information window, enter the password, and then click Next.
4. Follow the uninstall program prompts and reboot the system.
5.  After rebooting, log on as the Administrator and go to Start -> Run and type:
regedit. BACKUP YOUR Registry before moving forward.
6. Go HKLM -> Software - Oracle. There will be a registry key with a name like:
Key_OHxxxxxxxxxx
where xxxxxxxxxx = the unique Oracle home key. If there are multiple Oracle Homes on the pc, you may need to highlight each one and look at the Oracle_Home value on the right side of the screen to determine the correct Registry Key for OBIEE 10g. Once you have found the correct Registry Key, delete it.
7. Reboot the system.
8. Open Windows Explorer and delete the OBIEE 10g Oracle Home folder and reboot one more time.

OBIEE 10g should now be successfully uninstalled.

OBIEE 10G Installation Steps

Prerequisites

  1. Java SDK 1.5.0 or later is installed
  2. Ensure that database connectivity software that Oracle BI Server uses to connect to the database is installed. For example, if the Oracle BI Server needs to access an Oracle database, install the Oracle 10g client
  3. If you are planning to use Microsoft Internet Information Server (IIS):  - Microsoft Data Access Components (MDAC) version 2.7 or later is installed.  - Microsoft IIS is installed and that the IUSR_machinename matches the true name of the machine being used.
  4. If you are planning to use Oracle Application Server 10g and choose the Advanced option, ensure that you specify the location of your Oracle_Home.

Hardware and Software Requirements

The following is a list of hardware and software requirements:
Oracle BI Server components:
- CPU and RAM: 1 GHz, 2 GB RAM, with two or more processors recommended
- Disk Space: 800 MB of hard disk space, plus appropriate disk space for cache storage and Scheduler results (temporary disk space of 2 GB)
Oracle BI Presentation Services components:
- CPU and RAM: 1 GHz, 2 GB RAM, with two or more processors recommended
- Disk Space: 500 MB of hard disk space, plus appropriate disk space for cache storage and log files (temporary disk space of 2 GB)
Supported browsers include: 
- Microsoft Internet Explorer 6.0 
- Microsoft Internet Explorer 7.0 
- Firefox 1.5.x 
- Firefox 2.0 
- Mozilla 1.7.x
- Netscape 7.2.x

Client operating systems:
- Microsoft Windows 2000 Professional with Service Pack 3 or later 
- Microsoft Windows 2003 Professional with Service Pack 1 or later (32-bit only)
- Microsoft Windows XP Professional with Service Pack 1 or later

Server operating systems:
- For Oracle BI Server: Microsoft Windows 2000 Service Pack 4/2003 Server
Microsoft Word 2000 or later (if installing BI Publisher)

Installing Oracle BI EE


For this installation, a single instance of Oracle Database 10is deployed locally.

1.For this installation you need to download the software from OTN. Navigate to the directory where the files were unzipped, and double-click the setup.exe file located in the Windows\Server\Oracle_Business_Intelligence subdirectory.

2.
The InstallShield Wizard appears and prepares your Java Virtual Machine

3.
If you are running Windows 2003 or Windows XP, follow the instructions to disable DEP (Data Execution Protection) if DEP is presently running on your machine; otherwise, click Next.

4.
In this step you choose both a product directory and a data directory. The Basic installation type deploys components in stand-alone Oracle ApplicationContainers for J2EE (OC4J) or in Microsoft IIS. If you are using Oracle Server 10.1.3.1.0 or later, select Advanced.
This installation assumes that OC4J is used. Accept the default names for both directories and accept the Basicinstallation type. Click Next.


Note: If you are running Oracle Application Server 10.1.3.1.0 or later and you have selected the Advanced option, you will be asked to choose: the Installation Type (Compete, Client Tools, and so forth), the application server running Presentation Services (Oracle Application Sever or Microsoft IIS), and the location for the server.
If you want to perform a custom installation, select the Advanced option and click Next. Select theCustom option button and click Next. Choose the components that you want to install and clickNext.
5.
Click the Complete option button to perform a full installation for this setup. This installs the following components: Oracle BI Server, Oracle BI Presentation Services, Oracle BI Client Tools, Oracle BI Disconnected Client, and Oracle BI Publisher. Note: ODBC and JDBC drivers will be installed as well.
Click Next.
6.
Next you choose the application server that runs Presentation Services and Presentation Services Plug-Ins. Click the option button for Oracle Containers for J2EE (OC4J) and click Next.

7.
Now browse to locate your JDK location (JAVA_HOME environment variable). Note: As mentioned in thePrerequisite section, you must be running Java SDK version 1.5.0 or later.
Specify a password for the oc4jadmin password text box. This password is used for future oc4j maintenance. Click Next.


Note: If you selected the Advanced option in step 4, you need to identify the location of the Oracle Application Server.

8.
Whether your server participates in a cluster or not, you need to choose how to start the services. If you chooseAutomatic, machine boot time will increase. Click Next.

9.
Accept the default error message language and click Next.

10.
A summary of your installation appears. Click Next.



11.
The InstallShield proceeds with the installation.

12.
A confirmation window appears after the installation has completed successfully. Click Next.

13.
A second summary window appears, providing you with useful information about OC4J. Click Next

14.
Click Finish to restart your machine.

Sunday, January 12, 2014

Manual start/stop OBIEE 10g services in linux/unix

Here how you can stop and start OBIEE 10g services.

TO STOP:

cd <>/OracleBI/setup/
./run-sa.sh stop -----------------stopBI server
./run-saw.sh stop----------------stop Presentation server
./run-sch.sh stop---------------- stop Schedular
./run-ccs.sh stop----------------- stop Cluster Controller

TO START:

cd <>/OracleBI/setup/
./run-sa.sh start--------------to start BI server
./run-saw.sh start-------------to start Presentation server
./run-sch.sh start----------to start Schedular
./run-ccs.sh start----------to start Cluster Controller

Saturday, January 11, 2014

Oracle Business Intelligence 10g log files and Path

1) Logs generated under $OracleBI:


  •  server/logs/NQServer.log                     : BI Server log
  •  server/logs/NQQuery.log                      : Query log
  •  server/logs/NQSAdminTool.log         : This is the Oracle BI Administration Tool log file for its events and usage
  •  server/Repository/<repository>.log : Repository log
  •  log/install.log                                              : Installation log
  •  corda50/docs                                               : corda(generates chart) log
  •  web/catalogmanager/workspace/.metadata/.log : Catalog manager log
  •  oc4j_bi/j2ee/home                                     : OC4J logs


2) Logs generated under $OracleBIData:


  •  web/log/sawlogN.log(N=0,1,2,,,)                     : Presentation Server log
  •  web/log/javahost/jhostN.log.N(N=0,1,2,,,) : javahost log
  •  jobmanager/.metadata/.log                               : Job Manager logs