Showing posts with label hyperion epm installation. Show all posts
Showing posts with label hyperion epm installation. Show all posts

Monday, February 25, 2013

Ports that come in handy in the Hyperion ecosystem


Ports are very important in the use of any application, especially the complex systems such as the EPM System. For example, if you had to type in the URL to access a Workspace, you are typing in the Port as well apart from the Server where the Workspace resides. The concept of Port is even more important if you are doing an EPM installation/configuration. Because we use several different Ports during EPM deployment, knowledge about what Port the different products in the EPM family use becomes very handy.

I have provided the following information regarding the Ports in accordance to system 11.1.2.1. Even though it may hold true to other versions as well, please do refer to manuals as per the version you are using for accuracy.

WebLogic Administration Server Port     7001

Foundation Services

  1. Listen Port                                  28080
  1. SSL Listen Port                          28443
Web Server Ports
  1. Oracle HTTP Server                  19000
  1. IIS                                              80
Performance Management Architecture Web Application
  1. Listen Port                 19091
  1. SSL Listen Port         19047
Performance Management Architecture Server         5251
Default Web Server Port           80 (HTTP) or 443 (IIS)
Essbase Ports

  1. Essbase Agent                                                 1423
  1. Essbase Server Applications                            32768 - 33768
  1. Essbase SSL Agent                                         6423
  1. Oracle Essbase Integration Services Server      3388
Administration Services Web Application
  1. Listen Port               10080
  1. SSL Listen Port       10083
Provider Services
  1. Listen Port              13080
  1. SSL Listen Port      13083

Essbase Studio Ports

  1. Listen                     5300
  1. HTTP Listen Port   9080
Reporting and Analysis Framework Web Application Ports
  1. Listen Port              4500
  1. SSL Listen Port      4504
Reporting and Analysis Framework Agent             6860
Reporting and Analysis Framework Services         6800-6805
Financial Reporting Ports

  1. Listen Port               8200
  1. SSL Listen Port       8243
Financial Reporting Print Service                 8297
Financial Reporting Scheduler Service          8299
Web Analysis Ports

  1. Listen Port                     16000
  1. SSL Listen Port             16045
Planning Ports
  1. Listen Port                   8300
  1. SSL Listen Port           8343

When an application is accessible via a network it means that it is using a TCP/IP port. When a port is used by an application, it cannot be used by another one. Even during installation/deployment, we will get an error message stating that a particular port is being used by another application. Therefore, the skill to find out what port is being used by what application comes in very handy.
If you want to find out what is using a specific Port, you can open the COMMAND PROPMT and type in

"netstat -aon | more"

or if you know the Port number, you can type in something liek "netstat -aon findstr "6800""

This way you will be able to find out what is being used, whether a particular port is listening, etc. 


Tuesday, January 22, 2013

EPM Installation and the role of User Account Control (UAC)


Oracle Essentials: Oracle Database 11g (4th Edition) by Greenwald, Ric (Google Affiliate Ad)
During Hyperion EPM installation, Oracle's EPM installation document instructs disabling the Window's User Account Control. If we do not disable the UAC, we will get an error message. This is what I have learned during the EPM installation. Through research on Microsoft page, I have found out the ways of disabling the UAC, and I have then here so that someone with the same issue can have a quick look for reference. These are available in Microsoft's page as well. 


To turn off UAC

  1. Click Start, and then click Control Panel.
  2. In Control Panel, click User Accounts.
  3. In the User Accounts window, click User Accounts.
  4. In the User Accounts tasks window, click Turn User Account Control on or off.
  5. If UAC is currently configured in Admin Approval Mode, the User Account Control message appears. Click Continue.
  6. Clear the Use User Account Control (UAC) to help protect your computer check box, and then click OK.
  7. Click Restart Now to apply the change right away, or click Restart Later, and then close the User Accounts tasks window.

 To disable UAC from prompting for credentials to install applications

  1. Click Start, click All Programs, click Accessories, click Run, type secpol.msc in the Open text box, and then click OK.
  2. From the Local Security Settings console tree, click Local Policies, and then click Security Options.
  3. Scroll down and double-click User Account Control: Detect application installations and prompt for elevation.
  4. Select the Disabled option, and then click OK.
  5. Close the Local Security Settings window.
 To disable Admin Approval Mode
  1. Click Start, click All Programs, click Accessories, click Run, type secpol.msc in the Open box, and then click OK.
  2. If the User Account Control dialog box appears, confirm that the action it displays is what you want, and then click Continue..
  3. From the Local Security Settings console tree, double-click Local Policies, and then double-click Security Options.
  4. Scroll down and double-click User Account Control: Run all administrators in Admin Approval Mode.
  5. Select the Disabled option, and then click OK.
  6. Close the Local Security Settings window.
 To change the elevation prompt behavior for administrators
  1. Click Start, click Accessories, click Run, type secpol.msc in the Open box, and then click OK.
  2. From the Local Security Settings console tree, click Local Policies, and then click Security Options.
  3. Scroll down to and double-click User Account Control: Behavior of the elevation prompt for administrators.
  4. From the drop-down menu, select one of the following settings:
    • Elevate without prompting (tasks that request elevation will automatically run as elevated without prompting the administrator)
    • Prompt for credentials (this setting requires user name and password input before an application or task will run as elevated)
    • Prompt for consent (default setting for administrators)
  5. Click OK.
  6. Close the Local Security Settings window.
To change the elevation prompt behavior for standard users
  1. Click Start, click Accessories, click Run, type secpol.msc in the Open box, and then click OK.
  2. From the Local Security Settings console tree, click Local Policies, and then Security Options.
  3. Scroll down to and double-click User Account Control: Behavior of the elevation prompt for standard users.
  4. From the drop-down menu, select one of the following settings:
    • Automatically deny elevation requests (standard users will not be able to run programs that require elevation, and they will not be prompted)
    • Prompt for credentials (this setting requires user name and password input before an application or task will run as elevated, and it is the default for standard users)
  5. Click OK.
  6. Close the Local Security Settings window.