About Me

Anjum Ara I am a technology enthusiast, an ardent reader. My latest interest is virtualization. In my free time, I love understanding child nutrition, child holistic development. I bake, read, paint, and do whatever it takes to improve myself every day.

Friday, August 16, 2013

Hyperion 11.1.2.3 user provisioning issue

ARCHITECTURE:
==============

Hyperion Version : 11.1.2.3

DB -  11.2.0.3 single instance exadata DB
Exalytic Linux - PCM, EAS, ESS, Planning, EIS , OHS, Calcmanager,APS, Essbase Server
Exalytic Win - FCM, HFM, HSF, Foundation(shared Services and workspace), FR, WA, FDM, IR, Reporting and Analysis, SOA,


ISSUE DETAILS :

Testing is failing for the following components

--> HSS Provisioning few roles is failing with error "apache bridge failure" or "Page cannot be displayed 400 error message"
--> Not able to connect to FR Studio using BIG IP URL or either OHS physical URL
--> After launching Webanalysis Login page when trying to login its giving "
Page cannot be displayed 400 error message"
--> HFM Sample application creation from workspace is taking long time and getting timed out.
--> OHS is not able to connect to any of the manage servers on windows MT box, For the applications deployed on windows manage server it is failing with "apache bridge failure error message"
--> Here OHS is running on linux and HSS on windows machine, I am able to test other components running on linux machine - PCM, Planning (able to create the application successfully)
--> I am able to connect to FR Studio using the ManageServerIP:ManageServerPort , and I am able to provision all roles without any issues when i login to workspace using
ManageServerIP:ManageServerPort, So this tells there is no issues with component wise.


--> OHS port is opened from windows(HSS) server to linux (OHS) server and All manage server ports running on windows server is opened from OHS box.
--> Tried reconfiguring OHS but still same issue and also tried enabling weblogicplugin on windows domain, But still same issue




Solution:

Suggested:
uncomment the following lines in the mod_wl_ohs.conf file on the OHS server:

Debug ALL
WLLogFile /tmp/weblogic.log

stop/start OHS retest HSS URL via port 19000 and check the /tmp/weblogic.log file for where the plugin is trying to send traffic to.



Implemented:
 After enabling the DEBGUG ALL option

The following error message was occurring in the debug log file

2013-08-08T07:45:06.1439-05:00 <13082137596590645> Error 13 in opening temp request body file '/tmp/_wl_proxy/_post_13082_0'
2013-08-08T07:47:26.4328-05:00 <13082137596604649> Error 13 in opening temp request body file '/tmp/_wl_proxy/_post_13082_1'



Final Solution: changed the file permission of /tmp/_wl_proxy/ file.
Share:

Sunday, August 4, 2013

Important Views in Oracle DB

1. dba_tablespaces
SQL> desc dba_tablespaces;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)
 BLOCK_SIZE                                NOT NULL NUMBER
 INITIAL_EXTENT                                     NUMBER
 NEXT_EXTENT                                        NUMBER
 MIN_EXTENTS                               NOT NULL NUMBER
 MAX_EXTENTS                                        NUMBER
 MAX_SIZE                                           NUMBER
 PCT_INCREASE                                       NUMBER
 MIN_EXTLEN                                         NUMBER
 STATUS                                             VARCHAR2(9)
 CONTENTS                                           VARCHAR2(9)
 LOGGING                                            VARCHAR2(9)
 FORCE_LOGGING                                      VARCHAR2(3)
 EXTENT_MANAGEMENT                                  VARCHAR2(10)
 ALLOCATION_TYPE                                    VARCHAR2(9)
 PLUGGED_IN                                         VARCHAR2(3)
 SEGMENT_SPACE_MANAGEMENT                           VARCHAR2(6)
 DEF_TAB_COMPRESSION                                VARCHAR2(8)
 RETENTION                                          VARCHAR2(11)
 BIGFILE                                            VARCHAR2(3)
 PREDICATE_EVALUATION                               VARCHAR2(7)
 ENCRYPTED                                          VARCHAR2(3)
 COMPRESS_FOR                                       VARCHAR2(12)




Common Usage:
SQL> select TABLESPACE_NAME from dba_tablespaces where TABLESPACE_NAME='HSS';

TABLESPACE_NAME
------------------------------
HSS

SQL> select TABLESPACE_NAME from dba_tablespaces where TABLESPACE_NAME='EAS';

no rows selected

=============================================================

Share:

xhost command in Linux

xhost 

Description
       The xhost program is used to add and delete host names or user names to
       the list allowed to make connections to the X server.  In the  case  of
       hosts,  this  provides  a rudimentary form of privacy control and secu-
       rity.  It is only sufficient for a workstation (single  user)  environ-
       ment,  although  it  does  limit  the worst abuses.  Environments which
       require more sophisticated measures  should  implement  the  user-based
       mechanism  or use the hooks in the protocol for passing other authenti-
       cation data to the server.
Learning
     Assuming we have two hosts one 'local host' and the other where connection is being established as 'remote host'  . Giving xhost + <hostname> gives permission to which host(s) should be able to establish a connection with the localhost.

Typical usage with VNC. 
     On remote host:
                                vncserver 
    Enter the password and end result is obtained as <hostname>:<display#>

  Download vncviewer clients like TightVNC, Run VNC.
connect as <hostname/ipaddress>:<display#> enter the password that was provided and the connection is established.

Now on vncserver enter xhost + or xhost + `hostname`
set display 
                  export DISPLAY=:<display#> or
                  export DISPLAY=<hostname>:<display#>

Then type
                               xclock

to validate if clock is shown and display is set right.

This is a non secure way of working but a secure connection can be established via tunneling.



Can learn about usage by using man xhost on linux/unix systems.




Share: