• Find us:
    +1-669-900-5138   |   +44-203-372-5553
  • Free Newsletter

    Get Latest Updates

  • Make Training Enquiry


    Company

  • Categories

  • Archive

  • Oracle Governance and Risk Compliance (GRC) Manager installation Overview

    Posted by "" in "GRCM, UCM" on 2008-08-06

    Share on FacebookTweet about this on TwitterShare on Google+Share on LinkedInEmail this to someone

    Oracle GRC Manager

    This post covers installation overview of Oracle’s GRC Manager  (Governance and Risk Compliance Manager)  version 7.8 .

    You can download Oracle’s GRC (Governance & Risk compliance Manager) from http://edelivery.oracle.com >> E-Business Suite >> 12.0.4 >> Download (Oracle Governance, Risk, and Compliance Manager 7.8 & Stellent UCM Content Server 7.5.2 )

    .
    GRC Manager requires :

    i) Windows Server 2000 SP3 or Windows Server 2003 SP1 (as of today, You can’t install it on Unix)
    ii) Microsoft .net framework 2.0
    iii) Microsoft IIS (Web) Server 5.0, 5.1, 6.0
    iv) Oracle (earlier Stellent) Content Server 7.5.2
    v) Oracle Content Server database repository – MS SQL server (2000 SP4, 2005 SP3) or Oracle DB (9.2.0.7, 10.2.0.3)

    .
    Order of Installation for GRC Manager :

    1. Install Oracle (Stellent) Content Server 7.5.2
    1.1 Install Web Server for Content Server
    1.2 Install Database for Content Server
    1.3 Install Master Content Server
    1.4Configure WebServer to use with content server (If not done during content Server Installation on step 1.3)
    1.5 Configure Database to use with Content Server (If not done during content Server Installation on step 1.3)

    .

    2. Install GRC Manager
    2.1 Install GRC Manager Component on Content Server 7.5.2
    2.1.1 Install Component SoapDownloadPatch
    2.1.2 Install Component e100SOA
    2.1.3 Install Component OrgMapMailer
    2.1.4 Install Component SoxSecurity
    2.1.5 Install Component UserProxy
    2.1.6 Install Component UserAliasInMetaData (Optional for ADSI Support)
    2.1.7 Install Component IndexerPatch (Optional for ADSI Support)
    2.1.8 Install Component SoxWsdls  (Optional for ADSI Support)
    2.1.9 Install Component EmailPatch
     
    2.2 Install GRC Manager Application
    2.3 GRC Post Installation Task
    2.4 Configure GRC Manager with Microsoft Active Directory & SSO (optional) 
     

    .

    Things good to know about Oracle (Stellent) Content Server 7.5.2

    1. You can install Content Server on windows Server (2003, 2000 SP4), Sun Solaris, IBM AIX, HP UX, Red Hat Linux, SUSE Linux
    2. Content Server support following Web Server – IIS, Apache, SunONE 6, Sun Java System Web Server
    3.Repository for content Server can be MS Sql Server(2000 SP3, 2005), Oracle (9.2.0.7, 10.2.0.3), sybase, Informix or IBM DB2
    4. Content Server software and repository could be on different server (recommended)
    5. Content Server can be installed using Wizard (GUI), Command line or in silent mode
    6.You can use defualt JVM shipped with Content Server or use customized JVM (already installed on machine)
    7.Installation logs for Oracle (stellent) content server should be in $INSTALL_DIR/install directory with file name as log.txt
    8.Default login page for content server is http://hostname.domain:webPort/stellent (sysadmin/idc)
    9.Main configuration file for stellent content server is $INSTALL_DIR/config/config.cfg
     

    To know more about Stellent (now Oracle) Universal Content Management Click Here

    19 Responses to “Oracle Governance and Risk Compliance (GRC) Manager installation Overview”

    1. indrajit agasti says:

      hi Atul,

      I’m facing an issue while installing GRCM 7.8 on Oracle UCM 10gR3.

      During GRC Manager Application installation (more precisely Table updatations), it’s throwing an error “ORA-00947 : not enough values” .

      Tried with SSOSDBSetupUtility .. had no luck ..
      Update Tables is throwing the above error ..

      Metalink and Google hits hardly return anything.

      Do you have any idea wat sud be my approach to resolve this issue ??

      Seems,in UCM 10gR3 there is some change in Table Structure :)

      Thx in Advance,
      Indrajit

    2. Atul says:

      Is GRC Manager certified with UCM 10gR3 ?

      In my opinion install Content Server (7.5.2) and try again or check with Oracle Support.

    3. indrajit agasti says:

      hmmm .. ‘ll try with Stellent 7.5.2 .

      But the fact is, Oracle has modified Stellent 7.5.2 to UCM 10gR3, thus there is no more existence of STELLENT .. Unforntunately, Oracle is yet to modify their docs :(

    4. Atul says:

      I tried with Stellenet content server 7.5.2 and GRMC manager on windows and I did manage to install it successfully.
      If it doesn’t work with 7.5.2 update here with O.S. Version

    5. indrajit agasti says:

      ok .. Atul if u still have access to the UCM DB,can u kindly chk if any mismatch in the structure of below 9 tables:

      (my config is Win Srvr 2003,Oracle DB 10.2.0.3,UCM 10gR3 )

      SQL> desc DocMetaDefinition
      Name Null? Type
      —————————————– ——– ——————

      DNAME NOT NULL VARCHAR2(30 CHAR)
      DTYPE VARCHAR2(50 CHAR)
      DISREQUIRED NOT NULL NUMBER(1)
      DISENABLED NOT NULL NUMBER(1)
      DISSEARCHABLE NOT NULL NUMBER(1)
      DCAPTION VARCHAR2(50 CHAR)
      DISOPTIONLIST NOT NULL NUMBER(1)
      DOPTIONLISTKEY VARCHAR2(50 CHAR)
      DDEFAULTVALUE VARCHAR2(50 CHAR)
      DORDER NOT NULL NUMBER(38)
      DOPTIONLISTTYPE VARCHAR2(8 CHAR)
      DISPLACEHOLDERFIELD NOT NULL NUMBER(1)

      SQL> desc DocTypes
      Name Null? Type
      —————————————– ——– ——————–

      DDOCTYPE NOT NULL VARCHAR2(30 CHAR)
      DDESCRIPTION VARCHAR2(80 CHAR)
      DGIF VARCHAR2(50 CHAR)

      SQL> desc OptionsList
      Name Null? Type
      —————————————– ——– ———————-

      DKEY NOT NULL VARCHAR2(50 CHAR)
      DOPTION NOT NULL VARCHAR2(50 CHAR)
      DORDER NOT NULL NUMBER(38)

      SQL> desc RoleDefinition
      Name Null? Type
      —————————————– ——– ——————–

      DROLENAME NOT NULL VARCHAR2(30 CHAR)
      DGROUPNAME NOT NULL VARCHAR2(30 CHAR)
      DPRIVILEGE NOT NULL NUMBER(38)

      SQL> desc SecurityGroups
      Name Null? Type
      —————————————– ——– ————————

      DGROUPNAME NOT NULL VARCHAR2(30 CHAR)
      DDESCRIPTION VARCHAR2(80 CHAR)

      SQL> desc WorkflowAliases
      Name Null? Type
      —————————————– ——– ———————-

      DWFSTEPID NOT NULL NUMBER(38)
      DWFID NUMBER(38)
      DALIAS NOT NULL VARCHAR2(50 CHAR)
      DALIASTYPE NOT NULL VARCHAR2(20 CHAR)

      SQL> desc WorkflowCriteria
      Name Null? Type
      —————————————– ——– ————————-

      DWFID NOT NULL NUMBER(38)
      DWFCRITERIANAME NOT NULL VARCHAR2(30 CHAR)
      DWFCRITERIAOPERATOR VARCHAR2(8 CHAR)
      DWFCRITERIAVALUE VARCHAR2(30 CHAR)

      SQL> desc Workflows
      Name Null? Type
      —————————————– ——– ———————–

      DWFNAME VARCHAR2(30 CHAR)
      DWFID NOT NULL NUMBER(38)
      DWFDESCRIPTION VARCHAR2(80 CHAR)
      DCOMPLETIONDATE TIMESTAMP(6)
      DSECURITYGROUP VARCHAR2(30 CHAR)
      DWFSTATUS VARCHAR2(20 CHAR)
      DWFTYPE VARCHAR2(20 CHAR)
      DPROJECTID VARCHAR2(30 CHAR)
      DISCOLLABORATION NOT NULL NUMBER(1)

      SQL> desc WorkflowSteps
      Name Null? Type
      —————————————– ——– ————————-

      DWFSTEPNAME VARCHAR2(30 CHAR)
      DWFSTEPID NOT NULL NUMBER(38)
      DWFID NUMBER(38)
      DWFSTEPDESCRIPTION VARCHAR2(80 CHAR)
      DWFSTEPTYPE VARCHAR2(20 CHAR)
      DWFSTEPISALL NOT NULL NUMBER(1)
      DWFSTEPWEIGHT NUMBER(38)

    6. indrajit agasti says:

      Hi Atul,

      installation was successful with Stellent 7.5.2.

      but i’m unable to launch GRCM.

      Enter the URL to the Stellent Financial Compliance Director web server:

      http://in-ccustelnt/oraclegrcmanager

      isn’t it the URL to launch GRCM ??

    7. Atul says:

      This is right URL.

      Did you do post installation steps ?

      How about configuring IIS webserver ?

      Is IIS forwarding requests to GRCM ?

    8. indrajit agasti says:

      yes the post installation part is taken care .

      IIS configuration ?? sorry ! wat needs to be done ?

      http://in-ccustelnt/OracleGRCManager returns
      “The Web page can’t be found”

      Atul, i unsinstalled GRCM and retried.. still same issue..

      Enter the URL to the Stellent Financial Compliance Director web server: wat sud be this value ?? seems here i’m making some mistake.

    9. indrajit agasti says:

      Hi Atul,

      i’m unable to view the Business Process.
      It throws ORA-12704: character set mismatch

      During installantion of Contenet Server,i’ve provided ‘file encoding’ as UTF8 while ‘database
      field encoding’ as Native encoding .

      Cud it b the reason ? (DB is 10.2.0.3)

      Shall i need to provide the 1st entry as ‘default encoding’ ?

      Thx..
      Indrajit

    10. Subhankar says:

      I am getting the following message while navigating some of the menus in the Oracle GRC Manager

      Exception
      The ‘OraOLEDB.Oracle’ provider is not registered on the local machine.

    11. dsharma says:

      Hi Atul,
      Where can I find the GRC Manager Admin and User guides. I tried on otn website and also on google but cudnt find. Actually I am trying to find out what relation does Access Manager has with GRC Manager. What can be done in between them ? Is there a way in which we can control OAM policies from GRC Manager ?? Please help out…. thanks

    12. Atul Kumar says:

      GRC documentation is available with software in same location (edelivery) check link in post

    13. mmansour says:

      * Can Oracle Content Server be replaced by another content management system, or it is a must for GRC Manager?

      * Does Oracle Content Server need separate license with GRC Manager, or it is bundled with GRC Manager with the same license?

    14. Atul Kumar says:

      @ mmansour, as per GRCM 7.8 installation doc only certified content management system is Oracle Content Server 7.5.2 however you can use Microsoft SQL server or Oracle Database as Repository for Oracle Content Server.

      For license , please contact your Oracle Sales representative

    15. mmansour says:

      Dear Atul,

      It is possible to install more than one Content Server instance, but GRC Manager would be connected to only one Content Server instance, is it right?

      If yes, what is the best practice to install a test environment and a production environment for Oracle GRC Manager on the same server?

    16. mmansour says:

      As mentioned in GRC_Suite_Support_Matrix, GRC Manager is not supported on Oracle RAC database

      Is there a way to install GRC Manager with High Availabilty options?

      And what is the best topology to install (Oracle Database, Content Server, and GRC Manager) to fulfill the High Availability option?

    17. Sasikumars says:

      Can i know the GRCC Updating tables list?

    18. mahender says:

      how much space it require to install the oracle finance R12 software.

    19. Sasidhar says:

      Atul
      The above mentioned GRC path is not available now can u pls post the correct one i am not able to find what to download, GRC on edelivery has totally changed

    Leave a Reply



  • K21 Technologies is among the most experienced Oracle Gold Partner for Identity Access Management service providers. We work with application development companies and in-house technology division to help achieve significant returns on their IT security investment. Our clientele includes some of the globally renowned corporate, which speaks of our expertise in our field.

    We have the most talented and experienced team that can swiftly deploy security solutions even in complex IT ecosystem. Our clients highly appreciate our timely implementation, interactive training, on-demand support and community resources.
  • CONTACTS

    K21 Technologies
    8 Magnolia Place, Harrow,
    London, HA2 6DS

    UK: +44(0)7476444481
    USA: +1-888-414-1821

  • 2014, K21 Technologies. All rights reserved DMCA.com
  • TOP