{"id":3612,"date":"2014-03-11T04:53:00","date_gmt":"2014-03-11T03:53:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/"},"modified":"2014-03-11T04:53:00","modified_gmt":"2014-03-11T03:53:00","slug":"troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/","title":{"rendered":"Troubleshooting: ORA-29283 when oracle is member of a group with read\/write privileges"},"content":{"rendered":"<p>Recently, I worked on an Oracle database migration for a customer and I faced a strange behavior when accessing a file stored on the file system of the Oracle database. The database has been migrated on a new server, and consolidated with existing databases. Several jobs are running into the database and need to access the file system to read or write some files. A particular file is received daily from a remote job over FTP. This file is owned by the &#8220;dc_ftp&#8221; user in \/home\/dc_ftp.<\/p>\n<p>First, this is the directory where the file is located:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; select directory_name, directory_path from dba_directories where directory_name='MYDIR';\nDIRECTORY_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DIRECTORY_PATH\n------------------------- -------------------------------------------------------\nMYDIR\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/home\/dc_ftp\/out<\/pre>\n<p>The file is named myfile.txt and exists in \/home\/dc_ftp\/out:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">dc_ftp@srvora01$ ls \/home\/dc_ftp\/out\/\nmyfile.txt<\/pre>\n<p>During functional tests, I was able to successfully read the file from the database:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; declare\n\u00a0 p_file utl_file.file_type;\nbegin\n\u00a0 p_file := utl_file.fopen ('MYDIR', 'myfile.txt', 'w');\nend;\n\/\n\u00a0\nPL\/SQL procedure successfully completed.<\/pre>\n<p>But members of the application team, connected from SQL Developer, were not able to read this file:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; declare\n\u00a0 p_file utl_file.file_type;\nbegin\n\u00a0 p_file := utl_file.fopen ('MYDIR', 'myfile.txt', 'r');\nend;\n\/\u00a0 2\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0 6\ndeclare\n*\nERROR at line 1:\nORA-29283: invalid file operation\nORA-06512: at \"SYS.UTL_FILE\", line 536\nORA-29283: invalid file operation\nORA-06512: at line 4<\/pre>\n<p>My first hypotheses, such as misconfiguration in SQL Developer tool, wrong entries in the TNS Names, or wrong permissions on the listener binaries, were quickly eliminated.<\/p>\n<p>Both instance and host are correct, so the TNS entry seems to be OK:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; select instance_name, host_name from v$instance;\nINSTANCE_NAME\u00a0\u00a0\u00a0 HOST_NAME\n---------------- ----------------------------------------------------------------\nDB11G\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 srvora01<\/pre>\n<p>The listener is owned by oracle, as expected:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@srvora01$\u00a0 ps -ef | grep tnslsnr\noracle\u00a0\u00a0\u00a0 9684\u00a0\u00a0\u00a0\u00a0 1\u00a0 0 16:33 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 00:00:01 \/u00\/app\/oracle\/product\/11.2.0\/db_3_0\/bin\/tnslsnr LISTENER -inherit<\/pre>\n<p>And to finish, the problem occurs with or without SQL Developer.<\/p>\n<p>The next step was to check permissions. First at the DB level:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; select grantee, privilege, table_name from dba_tab_privs where table_name='MYDIR';\nGRANTEE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PRIVILEGE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TABLE_NAME\n------------------------------ ---------------------------------------- ---------------\nSYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 WRITE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MYDIR\nSYSTEM\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 READ\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MYDIR<\/pre>\n<p>&nbsp;<\/p>\n<p>Then at the operating system level:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@srvora01$ ls -altr \/home\/dc_ftp\/out\ntotal 12\n-rw-r-----. 1 dc_ftp dc_ftp\u00a0\u00a0 16 Feb 24 16:48 myfile.txt\ndrwxr-x---. 2 dc_ftp dc_ftp 4096 Feb 24 16:48 .\ndrwxr-xr-x. 5 dc_ftp dc_ftp 4096 Feb 24 16:54 ..<\/pre>\n<p>We can see that files and directory are not directly owned by oracle, but oracle is member of the group dc_ftp. It gets the read privilege on the file from the group dc_ftp:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle @ srvora01$ id oracle\nuid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54325(oper),54330(dc_ftp)<\/pre>\n<p>Finally, oracle user can clearly access the file from an operating system point of view, since it can order the &#8220;cat&#8221; command on the file:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@srvora01$ cat \/home\/dc_ftp\/out\/myfile.txt\ntest\ntest\u00e9\u00e0\u00e8<\/pre>\n<p>Now let&#8217;s see which problem occurs when Oracle tries to access the\u00a0 directory from the session.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; set define #\nSQL&gt; column spid new_value unix_pid\nSQL&gt; select spid from v$process p join v$session s on p.addr=s.paddr and s.sid=sys_context('userenv','sid');\nSPID\n------------------------\n10914<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; host strace -e trace=open -p #unix_pid &amp; echo $! &gt; .tmp.pid\nProcess 10914 attached - interrupt to quit\n\u00a0\nSQL&gt; declare\n\u00a0 p_file utl_file.file_type;\nbegin\n\u00a0 p_file := utl_file.fopen ('MYDIR', 'myfile2.txt', 'w');\nend;\n\/\n\u00a0 2\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0 6\u00a0 \n\u00a0 \ndeclare\n*\nERROR at line 1:\nORA-29283: invalid file operation\nORA-06512: at \"SYS.UTL_FILE\", line 536\nORA-29283: invalid file operation\nORA-06512: at line 4\n\u00a0\nopen(\"\/home\/dc_ftp\/out\/myfile2.txt\", O_WRONLY|O_CREAT|O_TRUNC, 0666) = -1 EACCES (Permission denied)<\/pre>\n<p>The previous message clearly indicates that it is a permission issue. Oracle has no privilege to access the directory to read or write&#8230;<\/p>\n<p>We can verifiy if it works when setting the permission READ to the file mytext.txt for non owner or group (i.e.644):<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">root@srvora01# chmod 644 \/home\/dc_ftp\/out\/myfile.txt\nroot@srvora01# ls -altr \/home\/dc_ftp\/out\ntotal 12\n-rw-r--r--. 1 dc_ftp dc_ftp\u00a0\u00a0 16 Feb 24 16:48 myfile.txt\ndrwxr-xr-x. 2 dc_ftp dc_ftp 4096 Feb 24 16:48 .\ndrwxr-xr-x. 5 dc_ftp dc_ftp 4096 Feb 24 16:54 ..<\/pre>\n<p>&nbsp;<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@srvora01$ sqlplus system\/****@DB11G\n\u00a0\nSQL&gt; declare\n\u00a0 p_file utl_file.file_type;\nbegin\n\u00a0 p_file := utl_file.fopen ('MYDIR', 'myfile.txt', 'r');\nend;\n\/\u00a0 2\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0 6 \n\u00a0\nPL\/SQL procedure successfully completed.<\/pre>\n<p>This is the workaround.<\/p>\n<p>But what if the file must not be read by the rest of the world? The file is generated with 640 permissions for a good readon here. So I had to fix the issue definitely.<\/p>\n<p>Fortunately, I fell on a Metalink note which helped me find the solution to my problem. According to the note ID 832323.1, if the file or directory is accessed through a group on which oracle is member of (here dc_ftp group has read privileges on the file), adding oracle to that group while the database is running may cause the error ORA-29283 to occur.<\/p>\n<p>Fine! But the database was restarted several times during the migration process, because of some initialization parameters to apply. I was totally sure that the database had been restarted after oracle user had been added to dc_ftp group! Moreover, I got no error when connected locally on the server. The error only occured when connected remotely through SQLNET, using sqlplus system\/****@DB11G for instance through the listener&#8230;<\/p>\n<p>That&#8217;s why I had an idea. If the database processes are starting with the oracle user&#8217;s permissions and if the database need to be restarted in order to make changes to take effect, the listener should be affected too! And the listener was never restarted during the migration. It was only reloaded to reflect changes from the new instance. This could explain why only sessions opened through the listener are affected&#8230;<\/p>\n<p>I restarted the listener and&#8230; all problems went away!!<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@srvora01$ lsnrctl stop listener\noracle@srvora01$ lsnrctl start listener\noracle@srvora01$ sqlplus system\/*****@DB11G\n\u00a0\nSQL&gt; declare\n\u00a0 p_file utl_file.file_type;\nbegin\n\u00a0 p_file := utl_file.fopen ('MYDIR', 'myfile.txt', 'r');\nend;\n\/\u00a0 2\u00a0\u00a0\u00a0 3\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0 5\u00a0\u00a0\u00a0 6\n\u00a0\nPL\/SQL procedure successfully completed.<\/pre>\n<p>To summarize, do not forget that the listener can also be impacted when changing permissions while it is running. It would be better to restart it instead of a simple reload when you make these kinds of modifications.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recently, I worked on an Oracle database migration for a customer and I faced a strange behavior when accessing a file stored on the file system of the Oracle database. The database has been migrated on a new server, and consolidated with existing databases. Several jobs are running into the database and need to access [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[46,96,247,44],"type_dbi":[],"class_list":["post-3612","post","type-post","status-publish","format-standard","hentry","category-database-management","tag-linux-unix","tag-oracle","tag-sql-developer-3-0","tag-troubleshooting"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Troubleshooting: ORA-29283 when oracle is member of a group with read\/write privileges - dbi Blog<\/title>\n<meta name=\"description\" content=\"Recently, I worked on an Oracle database migration for a customer and I faced an ORA-29283 error message when accessing a file stored on the file system of the Oracle database.\" \/>\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\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Troubleshooting: ORA-29283 when oracle is member of a group with read\/write privileges\" \/>\n<meta property=\"og:description\" content=\"Recently, I worked on an Oracle database migration for a customer and I faced an ORA-29283 error message when accessing a file stored on the file system of the Oracle database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-03-11T03:53:00+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Troubleshooting: ORA-29283 when oracle is member of a group with read\/write privileges\",\"datePublished\":\"2014-03-11T03:53:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/\"},\"wordCount\":650,\"commentCount\":0,\"keywords\":[\"Linux\/UNIX\",\"Oracle\",\"SQL developer 3.0\",\"Troubleshooting\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/\",\"name\":\"Troubleshooting: ORA-29283 when oracle is member of a group with read\/write privileges - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2014-03-11T03:53:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"Recently, I worked on an Oracle database migration for a customer and I faced an ORA-29283 error message when accessing a file stored on the file system of the Oracle database.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Troubleshooting: ORA-29283 when oracle is member of a group with read\/write privileges\"}]},{\"@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\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Troubleshooting: ORA-29283 when oracle is member of a group with read\/write privileges - dbi Blog","description":"Recently, I worked on an Oracle database migration for a customer and I faced an ORA-29283 error message when accessing a file stored on the file system of the Oracle database.","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\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/","og_locale":"en_US","og_type":"article","og_title":"Troubleshooting: ORA-29283 when oracle is member of a group with read\/write privileges","og_description":"Recently, I worked on an Oracle database migration for a customer and I faced an ORA-29283 error message when accessing a file stored on the file system of the Oracle database.","og_url":"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/","og_site_name":"dbi Blog","article_published_time":"2014-03-11T03:53:00+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Troubleshooting: ORA-29283 when oracle is member of a group with read\/write privileges","datePublished":"2014-03-11T03:53:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/"},"wordCount":650,"commentCount":0,"keywords":["Linux\/UNIX","Oracle","SQL developer 3.0","Troubleshooting"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/","url":"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/","name":"Troubleshooting: ORA-29283 when oracle is member of a group with read\/write privileges - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2014-03-11T03:53:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"Recently, I worked on an Oracle database migration for a customer and I faced an ORA-29283 error message when accessing a file stored on the file system of the Oracle database.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/troubleshooting-ora-29283-when-oracle-is-member-of-a-group-with-readwrite-privileges\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Troubleshooting: ORA-29283 when oracle is member of a group with read\/write privileges"}]},{"@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\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3612","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\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3612"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3612\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3612"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3612"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3612"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3612"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}