{"id":2615,"date":"2012-08-08T01:49:00","date_gmt":"2012-08-07T23:49:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/"},"modified":"2012-08-08T01:49:00","modified_gmt":"2012-08-07T23:49:00","slug":"ora-03113-caused-by-database-vault-rule-sets","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/","title":{"rendered":"ORA-03113 caused by Database Vault Rule Sets"},"content":{"rendered":"

The Database Vault solution allows to create rules that manage access to database. Among these rules there is what is called in Database Vault \u201cRule Sets\u201d. These logic components are written as PL\/SQL functions to return Boolean results. If rule expressions do not match the user context, the access is refused and a specific message can be configured in order to warn the user that he is not authorized to access this specific object. These expressions can be for instance related to the client IP address, the session username, the time or date and many other things.<\/p>\n

During one of my missions I had to configure Database Vault Rule Set in order to prevent access from specific IP adresses and specific\u00a0session username. \u00a0For each rule set the database vault administrator (me\u00a0;-))\u00a0have to specify a name. In my case I decided to use an explicit name such as \u201cSecurity Rule set for manager group\u201d. You can find a typical Rule Set definition screen below:<\/p>\n

\"Database<\/p>\n

Unfortunately, some minutes after having implemented this rule set, some users complain about an error message looking like this:<\/p>\n

SQL> select * from toto.ow_frm_plant;\nselect * from toto.ow_frm_plant\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\nError on line 1 :\nORA-03113: end-of-file on communication channel\nProcessus IS: 29976\nSession ID : 32, Serial Number : 271<\/pre>\n
In fact this error was coming from my rule set name. Despite the fact that name field in rule set form offers the possibility to use many characters (more than\u00a032), the maximum length of a rule set name is 31 characters.<\/p>\n
Therefore, a\u00a0Rule Set name looking like “Security Rule Set test with lon” won’t generate an ORA-03113\u00a0error, but a Rule Set name looking like “Security Rule Set test with long” will generate an ORA-03113.<\/p>\n
The following screen presents a correct rule set name with less than 32 characters and the normal rule set error message:<\/p>\n
\"Database<\/p>\n
The error Database Vault error message (in this example “My Error Message”) will be displayed below as expected:<\/p>\n
\u00a0SQL> select * from toto.ow_frm_plant\nselect * from toto.ow_frm_plant\n\nERROR on line 1:ORA-47305:20003 My error message<\/pre>\n
Hope this helps!<\/p>\n","protected":false},"excerpt":{"rendered":"
Database Vault solution allows to create rules that manage access to database. Among these rules there is what is called in Database Vault \u201cRule Sets\u201d. These logic components are written as PL\/SQL functions to return Boolean results. <\/o_p><\/p>\n
If rule expressions do not match the user context, the access is refused and a specific message can be configured in order to warn the user that he is not authorized to access this specific object. These expressions can be for instance related to the client IP address, the session username, the time or date and many other things.<\/p>\n","protected":false},"author":10,"featured_media":2616,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[280,318,17,25],"type_dbi":[],"class_list":["post-2615","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-database","tag-database-vault","tag-oracle-11g","tag-security"],"acf":[],"yoast_head":"\nORA-03113 caused by Database Vault Rule Sets - dbi Blog<\/title>\n<meta name=\"description\" content=\"How to solve ORA-03113 in the context of Database Vault Rule Sets\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORA-03113 caused by Database Vault Rule Sets\" \/>\n<meta property=\"og:description\" content=\"How to solve ORA-03113 in the context of Database Vault Rule Sets\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2012-08-07T23:49:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/001-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"668\" \/>\n\t<meta property=\"og:image:height\" content=\"438\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Gr\u00e9gory Steulet\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gr\u00e9gory Steulet\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/\"},\"author\":{\"name\":\"Gr\u00e9gory Steulet\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\"},\"headline\":\"ORA-03113 caused by Database Vault Rule Sets\",\"datePublished\":\"2012-08-07T23:49:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/\"},\"wordCount\":310,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/001-1.jpg\",\"keywords\":[\"database\",\"Database Vault\",\"Oracle 11g\",\"Security\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/\",\"name\":\"ORA-03113 caused by Database Vault Rule Sets - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/001-1.jpg\",\"datePublished\":\"2012-08-07T23:49:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\"},\"description\":\"How to solve ORA-03113 in the context of Database Vault Rule Sets\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/001-1.jpg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/001-1.jpg\",\"width\":668,\"height\":438},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORA-03113 caused by Database Vault Rule Sets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\",\"name\":\"Gr\u00e9gory Steulet\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"caption\":\"Gr\u00e9gory Steulet\"},\"description\":\"Gr\u00e9gory Steulet has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies and high availability solutions (Oracle DataGuard, Data Replication Block Device). His expertise also includes Avaloq banking applications, as well as the open source field (MySQL, Unix\/Linux, etc.). Gr\u00e9gory Steulet is \\\"Oracle Certified Professional 10g\\\", \\\"MySQL Cluster 5.1 Certified\\\", and \\\"Avaloq Certified Professional 2.6\\\". Prior to joining dbi services, Gr\u00e9gory Steulet was Senior Consultant at Trivadis in Lausanne. He also worked as IT Administrator at Box Telecom in Miami Beach, Florida (USA). Gr\u00e9gory Steulet has an Executive MBA from the International Institute of Management in Technology, Fribourg (CH). He also holds a Bachelor's Degree in Business Administration and Computer Science from the University of Applied Sciences Western Switzerland. His branch-related experience covers Telecommunications, Financial Services \/ Banking, Logistics, Pharma etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/gregory-steulet\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ORA-03113 caused by Database Vault Rule Sets - dbi Blog","description":"How to solve ORA-03113 in the context of Database Vault Rule Sets","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:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/","og_locale":"en_US","og_type":"article","og_title":"ORA-03113 caused by Database Vault Rule Sets","og_description":"How to solve ORA-03113 in the context of Database Vault Rule Sets","og_url":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/","og_site_name":"dbi Blog","article_published_time":"2012-08-07T23:49:00+00:00","og_image":[{"width":668,"height":438,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/001-1.jpg","type":"image\/jpeg"}],"author":"Gr\u00e9gory Steulet","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Gr\u00e9gory Steulet","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/"},"author":{"name":"Gr\u00e9gory Steulet","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098"},"headline":"ORA-03113 caused by Database Vault Rule Sets","datePublished":"2012-08-07T23:49:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/"},"wordCount":310,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/001-1.jpg","keywords":["database","Database Vault","Oracle 11g","Security"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/","url":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/","name":"ORA-03113 caused by Database Vault Rule Sets - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/001-1.jpg","datePublished":"2012-08-07T23:49:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098"},"description":"How to solve ORA-03113 in the context of Database Vault Rule Sets","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/001-1.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/001-1.jpg","width":668,"height":438},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/ora-03113-caused-by-database-vault-rule-sets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ORA-03113 caused by Database Vault Rule Sets"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098","name":"Gr\u00e9gory Steulet","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","caption":"Gr\u00e9gory Steulet"},"description":"Gr\u00e9gory Steulet has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies and high availability solutions (Oracle DataGuard, Data Replication Block Device). His expertise also includes Avaloq banking applications, as well as the open source field (MySQL, Unix\/Linux, etc.). Gr\u00e9gory Steulet is \"Oracle Certified Professional 10g\", \"MySQL Cluster 5.1 Certified\", and \"Avaloq Certified Professional 2.6\". Prior to joining dbi services, Gr\u00e9gory Steulet was Senior Consultant at Trivadis in Lausanne. He also worked as IT Administrator at Box Telecom in Miami Beach, Florida (USA). Gr\u00e9gory Steulet has an Executive MBA from the International Institute of Management in Technology, Fribourg (CH). He also holds a Bachelor's Degree in Business Administration and Computer Science from the University of Applied Sciences Western Switzerland. His branch-related experience covers Telecommunications, Financial Services \/ Banking, Logistics, Pharma etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/gregory-steulet\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2615"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2615\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/2616"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2615"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}