{"id":449,"date":"2008-04-29T08:53:13","date_gmt":"2008-04-29T12:53:13","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/"},"modified":"2008-04-29T23:53:02","modified_gmt":"2008-04-30T03:53:02","slug":"install-orace-role-manager-orm-on-windows-vista","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/","title":{"rendered":"Install Oracle Role Manager ORM on Windows Vista"},"content":{"rendered":"

Oracle Role Manager is part of Oracle Identity Management Suite<\/a>\u00a0to manage various user roles across enterprise. ORM is product from Bridgestream<\/strong> acquired by Oracle in 2007.<\/p>\n

For overview of Role Manager visit my previous\u00a0post under related at bottom or Visit Here<\/a>\u00a0<\/p>\n

<\/u><\/strong><\/p>\n

Quick Installation Steps for ORM
\n<\/u><\/strong>1) Install Application Server(IBM Websphere or JBoss). This Application Server will host ORM application.
\n2) Install Oracle Database 10.2.0.3 or higher (This database will be used to store ORM data)
\n3) Create tablespace, schema, application user in database installed above
\n4) Install ORM Software
\n5) Deploy ORM application on Application Server installed in step 1 (ormconsole<\/strong> & webui<\/strong>)<\/p>\n

* Note ORM software\u00a0and Application Server should be installed on\u00a0same machine.<\/p>\n

–<\/p>\n

Prepare Database for Oracle Role Manager<\/strong><\/u><\/p>\n

— Install Database 10.2.0.3 or higher<\/strong> on same machine as ORM or on different machine<\/p>\n

— Machine hosting ORM should be able to connect to database<\/p>\n

— Download Oracle Database From here\u00a0 depending on your windows version from here <\/a><\/p>\n

— Install Oracle Database<\/p>\n

–Download Role Manager from here <\/a><\/p>\n

— Extract\u00a0 ORM software as_windows_x86_orm_10140.zip
\n<\/strong>
\n— Go to directory where you unzipped rolemanager software and then samples\\sqlscripts\\oracle<\/strong> like<\/p>\n

cd c:\\atul\\role_manager\\Disk1\\samples\\sqlscripts\\oracle<\/p>\n

— If database is on other machine (than ORM) then copy samples directory to database<\/p>\n

— Connect to database as sysdba sqlplus “\/as sysdba”<\/strong><\/p>\n

Create Tablespace
\n<\/strong>— Create tablespace like \u00a0SQL>@create-tablespace.sql <data_dir> <index_dir> <temp_dir>
\n—–SQL>@create-tablespace.sql “C:\\oracle\\product\\10.2.0\\oradata\\orcl” “C:\\oracle\\product\\10.2.0\\oradata\\orcl”\u00a0“C:\\oracle\\product\\10.2.0\\oradata\\orcl”<\/strong>\u00a0\u00a0<\/p>\n

\u00a0(**My datafile location was above hence I gave that location change this location as per your installation)<\/p>\n

Create Schema
\n<\/strong>SQL>@create-schema-owner.sql <owner_username> <owner_password>
\nSQL>@create-schema-owner.sql orm welcome1<\/p>\n

Create\u00a0ORM\u00a0Apps User<\/strong>\u00a0
\nSQL>@create-app-user.sql <app_username> <app_password>
\nSQL>@create-app-user.sql orm_app welcome1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

(**Database User and Application User can’t be same)
\n\u00a0<\/p>\n

This completes database preparation for Oracle Role Manager (ORM). Next Step is to install Oracle Role Manager Software<\/p>\n

<\/u><\/p>\n

<\/u><\/p>\n

Install\u00a0Oracle Role Manager Software<\/strong><\/u><\/p>\n

Check Prereqs
\n<\/strong>– Ensure database 10.2.0.3 or higher is installed
\n– Ensure tablespace, schema and ORM application user are created on database
\n– Download ORM software from here <\/a>\u00a0if not done already<\/p>\n

Start Installation
\n<\/strong>– Start installer by running executable in Disk1 (from directory where you unzipped ORM software)<\/p>\n

–\u00a0Enter\u00a0ORM Home Name<\/strong> and Installation Directory<\/strong><\/p>\n

\"ORM\"<\/a><\/p>\n

— Select Installation Type (Install Software<\/strong> only or Install & Configure<\/strong>)
\nYou can install first and configure with database later or install and configure both at same time<\/p>\n

\"ORM\"<\/a><\/p>\n

– Select from available configuration options<\/strong><\/p>\n

\"ORM\"<\/a><\/p>\n

– Provide database connection details<\/strong> as shown in diagram ( *Note application user and schema name can’t be same)<\/p>\n

\"ORM\"<\/a><\/p>\n

– Specify ORM administrator <\/strong>username and password<\/p>\n

\"ORM\"<\/a><\/p>\n

— Finally you should see Successful Installation<\/strong><\/p>\n

\"ORM\"<\/a><\/p>\n

This installs ORM software, finally we need to deploy ORM application on Application Server (JBOSS or IBM Websphere)<\/p>\n

How to deploy application ORM application in JBOSS coming soon ……<\/font><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Oracle Role Manager is part of Oracle Identity Management Suite\u00a0to manage various user roles across enterprise. ORM is product from […]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[198],"tags":[],"class_list":["post-449","post","type-post","status-publish","format-standard","hentry","category-orm"],"yoast_head":"\nInstall Oracle Role Manager ORM on Windows Vista -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install Oracle Role Manager ORM on Windows Vista -\" \/>\n<meta property=\"og:description\" content=\"Oracle Role Manager is part of Oracle Identity Management Suite\u00a0to manage various user roles across enterprise. ORM is product from […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/\" \/>\n<meta property=\"article:published_time\" content=\"2008-04-29T12:53:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2008-04-30T03:53:02+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/04\/orm_11.thumbnail.JPG\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/\",\"name\":\"Install Oracle Role Manager ORM on Windows Vista -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/04\/orm_11.thumbnail.JPG\",\"datePublished\":\"2008-04-29T12:53:13+00:00\",\"dateModified\":\"2008-04-30T03:53:02+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/#primaryimage\",\"url\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/04\/orm_11.thumbnail.JPG\",\"contentUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/04\/orm_11.thumbnail.JPG\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install Oracle Role Manager ORM on Windows Vista\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation & Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Install Oracle Role Manager ORM on Windows Vista -","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/","og_locale":"en_US","og_type":"article","og_title":"Install Oracle Role Manager ORM on Windows Vista -","og_description":"Oracle Role Manager is part of Oracle Identity Management Suite\u00a0to manage various user roles across enterprise. ORM is product from […]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/","article_published_time":"2008-04-29T12:53:13+00:00","article_modified_time":"2008-04-30T03:53:02+00:00","og_image":[{"url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/04\/orm_11.thumbnail.JPG","type":"","width":"","height":""}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/","url":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/","name":"Install Oracle Role Manager ORM on Windows Vista -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/#primaryimage"},"thumbnailUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/04\/orm_11.thumbnail.JPG","datePublished":"2008-04-29T12:53:13+00:00","dateModified":"2008-04-30T03:53:02+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/#primaryimage","url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/04\/orm_11.thumbnail.JPG","contentUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2008\/04\/orm_11.thumbnail.JPG"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2008\/04\/29\/install-orace-role-manager-orm-on-windows-vista\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Install Oracle Role Manager ORM on Windows Vista"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation & Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/449","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=449"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/449\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=449"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=449"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=449"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}