{"id":2353,"date":"2011-03-08T06:32:05","date_gmt":"2011-03-08T10:32:05","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/"},"modified":"2011-03-08T06:32:05","modified_gmt":"2011-03-08T10:32:05","slug":"oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/","title":{"rendered":"&#8220;OCI failed to begin session&#8221; error while creating DB instance for DB auditing in Oracle Access Manager"},"content":{"rendered":"<p>The previous post talks about one issue occured during configuration of DB auditing in Oracle Access Manager. This post also talks about another issue of same feature. For configuring the DB Audit of Oracle Access Manager, an sql script has to be executed which creates 4 tables and one index. In our case, it is Oracle Database and thus I have executed <strong>audit_oracle.sql <\/strong>present in location identityServer_install_Dir\/oblix\/reports\/crystal.<\/p>\n<p>At first, I executed this sql script as sys user. The same user credentials has been\u00a0 provided in DB instance page as shown below.<\/p>\n<p><a href=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance_sys.GIF\" title=\"db instance sys\"><img decoding=\"async\" src=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance_sys.GIF\" alt=\"db instance sys\" \/><\/a><\/p>\n<p>After saving the configuration, we got the error as shown below.<\/p>\n<p><a href=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance_sys_fail.GIF\"><img decoding=\"async\" src=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance_sys_fail.GIF\" \/><\/a><\/p>\n<p>I have tried giving sys in User Name field as well, but no luck.<\/p>\n<p>I have seen the below error in oblog of identity server.<\/p>\n<p><font color=\"#999999\"><font color=\"#ff0000\">2011\/03\/07@12:22:11.532442\u00a0\u00a0\u00a0\u00a0\u00a0 18739\u00a0\u00a0 18739\u00a0\u00a0 SQL_ADAPTER\u00a0\u00a0\u00a0\u00a0 ERROR\u00a0\u00a0 0x00000067\u00a0\u00a0\u00a0\u00a0\u00a0 ..\/ocierrormap.cpp:53\u00a0\u00a0 &#8220;OCI failed to begin session&#8221;\u00a0\u00a0 method^OCIConnection::OCIConnection\u00a0\u00a0\u00a0\u00a0 ociRetCode^OCI_ERROR\u00a0\u00a0\u00a0 Diagnostic Record number^1\u00a0\u00a0\u00a0\u00a0\u00a0 Error Message^ORA-01017: invalid username\/password***************\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Error Code from OCIErrorGet^1017<\/font><br \/>\n<\/font><br \/>\nI ensured that password is not wrong. The actual problem is that it is not accepting the username with space. So the workaround is not to use sys user. For this, I have executed the sql script as as ods user (who is the owner of OID schema) and provide the same user credentials in DB instance creation page. Why should I create a new user in DB just for auditing purpose? Is it recommended or not? We shall see this later.<\/p>\n<p><a href=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance.GIF\" title=\"db instance\"><img decoding=\"async\" src=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance.GIF\" alt=\"db instance\" \/><\/a><\/p>\n<p>This time it accepted.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The previous post talks about one issue occured during configuration of DB auditing in Oracle Access Manager. This post also [&hellip;]<\/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":[42],"tags":[320,29,466],"class_list":["post-2353","post","type-post","status-publish","format-standard","hentry","category-troubleshooting","tag-auditing","tag-oam","tag-troubleshooting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>&quot;OCI failed to begin session&quot; error while creating DB instance for DB auditing in Oracle Access Manager -<\/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\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"&quot;OCI failed to begin session&quot; error while creating DB instance for DB auditing in Oracle Access Manager -\" \/>\n<meta property=\"og:description\" content=\"The previous post talks about one issue occured during configuration of DB auditing in Oracle Access Manager. This post also [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/\" \/>\n<meta property=\"article:published_time\" content=\"2011-03-08T10:32:05+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance_sys.GIF\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/\",\"name\":\"\\\"OCI failed to begin session\\\" error while creating DB instance for DB auditing in Oracle Access Manager -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance_sys.GIF\",\"datePublished\":\"2011-03-08T10:32:05+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/#primaryimage\",\"url\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance_sys.GIF\",\"contentUrl\":\"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance_sys.GIF\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"&#8220;OCI failed to begin session&#8221; error while creating DB instance for DB auditing in Oracle Access Manager\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; 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":"\"OCI failed to begin session\" error while creating DB instance for DB auditing in Oracle Access Manager -","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\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/","og_locale":"en_US","og_type":"article","og_title":"\"OCI failed to begin session\" error while creating DB instance for DB auditing in Oracle Access Manager -","og_description":"The previous post talks about one issue occured during configuration of DB auditing in Oracle Access Manager. This post also [&hellip;]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/","article_published_time":"2011-03-08T10:32:05+00:00","og_image":[{"url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance_sys.GIF","type":"","width":"","height":""}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/","url":"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/","name":"\"OCI failed to begin session\" error while creating DB instance for DB auditing in Oracle Access Manager -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/#primaryimage"},"thumbnailUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance_sys.GIF","datePublished":"2011-03-08T10:32:05+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/#primaryimage","url":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance_sys.GIF","contentUrl":"http:\/\/onlineappsdba.com\/wp-content\/uploads\/2011\/03\/dbinstance_sys.GIF"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2011\/03\/08\/oci-failed-to-begin-session-error-while-creating-db-instance-for-db-auditing-in-oracle-access-manager\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"&#8220;OCI failed to begin session&#8221; error while creating DB instance for DB auditing in Oracle Access Manager"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; 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\/2353","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=2353"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/2353\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=2353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=2353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=2353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}