{"id":144,"date":"2014-03-28T20:54:17","date_gmt":"2014-03-28T23:54:17","guid":{"rendered":"http:\/\/www.fernandosimon.com\/blog\/?p=144"},"modified":"2015-01-25T23:35:48","modified_gmt":"2015-01-26T02:35:48","slug":"role-separation-e-ora-600-kfdskalloc0","status":"publish","type":"post","link":"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/","title":{"rendered":"Role Separation e ORA-600 [kfdskAlloc0]"},"content":{"rendered":"<p style=\"text-align: justify;\">Um post r\u00e1pido sobre um problema recorrente, mas que pode ajudar algu\u00e9m. Como DBA voc\u00ea est\u00e1 preocupado em seguir as recomenda\u00e7\u00f5es e melhores pr\u00e1ticas e instala um banco de dados com \u201crole separation\u201d. Usu\u00e1rios separados, um para o Grid e um para o Oracle, mas no final das contas recebe um belo ORA-600.<\/p>\n<p style=\"text-align: justify;\">No ambiente descrito aqui temos um banco de dados Oracle 11.2.0.4 instalado em um Oracle Enterprise Linux 6.5 x64 com usu\u00e1rios espec\u00edficos para o Grid e outro para o Oracle. De qualquer forma esse erro tamb\u00e9m j\u00e1 ocorreu em um Exadata e em RAC, e j\u00e1 vi em outras vers\u00f5es.<\/p>\n<p style=\"text-align: justify;\">Voc\u00ea segue o ritual e instala o Grid com sucesso, inicia a inst\u00e2ncia do ASM e instala o Oracle (com o usu\u00e1rio oracle). Mas ao tentar restaurar um backup ou chamar o \u201cdbca\u201d voc\u00ea recebe um \u201c<strong>ORA-00600: internal error code, arguments: [kfdskAlloc0]<\/strong>\u201d. Vou tentar exemplificar e mostrar a solu\u00e7\u00e3o.<\/p>\n<p style=\"text-align: justify;\"><!--more Continue lendo...--><\/p>\n<p style=\"text-align: justify;\">Como disse, temos um ambiente com \u201crole separation\u201d, Grid 11.2.0.4 instalado e ASM instanciado com usu\u00e1rio grid; Oracle 11.2.0.4 instalado com usu\u00e1rio oracle (mas sem inst\u00e2ncia criada). Para exemplificar tentei restaurar um backup full da produ\u00e7\u00e3o (mas poderia ser um dbca, por exemplo). Voc\u00ea chama o RMAN e abre a inst\u00e2ncia com um pfile j\u00e1 restaurado:<\/p>\n<pre>RMAN&gt; startup nomount pfile='\/tmp\/pfile.ora';\r\n\r\nOracle instance started\r\n\r\nTotal System Global Area     801701888 bytes\r\n\r\nFixed Size                     2257520 bytes\r\nVariable Size                301993360 bytes\r\nDatabase Buffers             494927872 bytes\r\nRedo Buffers                   2523136 bytes\r\n\r\nRMAN&gt;<\/pre>\n<p style=\"text-align: justify;\">Depois, voc\u00ea continua e tenta restaurar o controlfile (com o destino sendo o ASM) e ai come\u00e7am os problemas:<\/p>\n<pre>RMAN&gt; run {\r\n2&gt;   allocate channel 'dev_0' type 'sbt_tape' parms 'ENV=(NSR_SERVER=server-networker.tjsc.jus.br,NSR_CLIENT=exadb01,NSR_DPRINTF=TRUE, NSR_DEBUG_FILE=\/tmp\/t1.log,NSR_DEBUG_LEVEL=2)' ;\r\n3&gt;   restore controlfile from 'bkp-ctf-D-dbrest-DBID-871962163-T-20131109-NB-24233.bkp';\r\n4&gt; }\r\n\r\nusing target database control file instead of recovery catalog\r\nallocated channel: dev_0\r\nchannel dev_0: SID=24 device type=SBT_TAPE\r\nchannel dev_0: NMO v5.0.0.0\r\n\r\nStarting restore at 12\/11\/2013 18:11:39\r\n\r\nchannel dev_0: restoring control file\r\nRMAN-00571: ===========================================================\r\nRMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============\r\nRMAN-00571: ===========================================================\r\nRMAN-00601: fatal error in recovery manager\r\nRMAN-03004: fatal error during execution of command\r\nORA-03114: not connected to ORACLE\r\n[oracle@cvmlx-dbrst-01 ~]$<\/pre>\n<p style=\"text-align: justify;\">Voc\u00ea olha e come\u00e7a a pensar onde errou, revisa o procedimento e n\u00e3o acha a falha. Por fim, recorre ao \u201calert\u201d da inst\u00e2ncia e descobre a origem do erro:<\/p>\n<pre>[oracle@cvmlx-dbrst-01 ~]$ tail -100f \/u01\/app\/oracle\/diag\/rdbms\/dbrest\/dbrest\/trace\/alert_dbrest.log\r\n...\r\n...\r\nMMNL started with pid=18, OS id=27009\r\nNOTE: initiating MARK startup\r\nstarting up 1 shared server(s) ...\r\nStarting background process MARK\r\nTue Nov 12 18:15:03 2013\r\nMARK started with pid=20, OS id=27013\r\nNOTE: MARK has subscribed\r\nORACLE_BASE from environment = \/u01\/app\/oracle\r\nTue Nov 12 18:15:06 2013\r\nSweep [inc][2121]: completed\r\nSweep [inc2][2121]: completed\r\nTue Nov 12 18:16:31 2013\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/dbrest\/dbrest\/trace\/dbrest_rbal_27001.trc:\r\nORA-15183: ASMLIB initialization error [driver\/agent not installed]\r\nWARNING: FAILED to load library: \/opt\/oracle\/extapi\/64\/asm\/orcl\/1\/libasm.so\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/dbrest\/dbrest\/trace\/dbrest_rbal_27001.trc:\r\nORA-15183: ASMLIB initialization error [driver\/agent not installed]\r\nTue Nov 12 18:16:31 2013\r\nSUCCESS: diskgroup DATA was dismounted\r\nERROR: diskgroup DATA was not mounted\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/dbrest\/dbrest\/trace\/dbrest_rbal_27001.trc  (incident=4121):\r\n<strong>ORA-00600: internal error code, arguments: [kfdskAlloc0], [], [], [], [], [], [], [], [], [], [], []<\/strong>\r\nIncident details in: \/u01\/app\/oracle\/diag\/rdbms\/dbrest\/dbrest\/incident\/incdir_4121\/dbrest_rbal_27001_i4121.trc\r\nUse ADRCI or Support Workbench to package the incident.\r\nSee Note 411.1 at My Oracle Support for error and packaging details.\r\nErrors in file \/u01\/app\/oracle\/diag\/rdbms\/dbrest\/dbrest\/trace\/dbrest_rbal_27001.trc:\r\n<strong>ORA-00600: internal error code, arguments: [kfdskAlloc0], [], [], [], [], [], [], [], [], [], [], []<\/strong>\r\nRBAL (ospid: 27001): terminating the instance due to error 488\r\nTue Nov 12 18:16:35 2013\r\nSystem state dump requested by (instance=1, osid=27001 (RBAL)), summary=[abnormal instance termination].\r\nSystem State dumped to trace file \/u01\/app\/oracle\/diag\/rdbms\/dbrest\/dbrest\/trace\/dbrest_diag_26983_20131112181635.trc\r\nDumping diagnostic data in directory=[cdmp_20131112181635], requested by (instance=1, osid=27001 (RBAL)), summary=[abnormal instance termination].\r\nInstance terminated by RBAL, pid = 27001\r\n[oracle@cvmlx-dbrst-01 ~]$<\/pre>\n<p style=\"text-align: justify;\">Nota-se que a inst\u00e2ncia foi abortada devido ao \u201cORA-00600: internal error code, arguments: [kfdskAlloc0][]&#8230;\u201d. Infelizmente para muitos o Google n\u00e3o \u00e9 amigo (at\u00e9 agora) e n\u00e3o retorna nada relacionado (al\u00e9m de descobrir que tem menos de 10 links como resposta da pesquisa).<\/p>\n<p style=\"text-align: justify;\">Por sorte, a solu\u00e7\u00e3o \u00e9 bem simples e j\u00e1 presente no MOS. Devido ao ambiente usar \u201crole separation\u201d o Oracle n\u00e3o consegue se comunicar com o Grid por estarem em grupos (de sistema operacional) diferentes. Mesmo o usu\u00e1rio oracle pertencendo ao mesmo grupo do usu\u00e1rio grid (grupo asmadmin neste caso) ele n\u00e3o consegue acessar o ASM.<\/p>\n<p>Observe abaixo como o ASM est\u00e1 configurado, perceba que o usu\u00e1rio \u00e9 o grid e o grupo \u00e9 o asmadmin.<\/p>\n<pre>[root@cvmlx-dbrst-01 bin]# \/usr\/sbin\/oracleasm configure\r\nORACLEASM_ENABLED=true\r\nORACLEASM_UID=<strong>grid<\/strong>\r\nORACLEASM_GID=<strong>asmadmin<\/strong>\r\nORACLEASM_SCANBOOT=true\r\nORACLEASM_SCANORDER=\"\"\r\nORACLEASM_SCANEXCLUDE=\"\"\r\nORACLEASM_USE_LOGICAL_BLOCK_SIZE=\"false\"\r\n[root@cvmlx-dbrst-01 bin]#<\/pre>\n<p style=\"text-align: justify;\">\u00a0Agora olhe o bin\u00e1rio do Oracle:<\/p>\n<pre>[root@cvmlx-dbrst-01 ~]# cd \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/bin\/\r\n[root@cvmlx-dbrst-01 bin]# ls -l oracle\r\n-rwsr-s--x 1 <strong>oracle<\/strong> <strong>oinstall<\/strong> 239626595 Nov 12 17:18 oracle\r\n[root@cvmlx-dbrst-01 bin]#<\/pre>\n<p style=\"text-align: justify;\">Existem 2 solu\u00e7\u00f5es oficiais para o problema, a primeira mais r\u00e1pida e menos traum\u00e1tica \u00e9 mudar manualmente o grupo do bin\u00e1rio \u201coracle\u201d que est\u00e1 localizado em $ORACLE_HOME\/bin\/oracle. Essa \u00e9 a solu\u00e7\u00e3o proposta pela nota: \u201cORA-15183 Unable to Create Database on Server using 11.2 ASM and Grid Infrastructure (Doc ID 1054033.1)\u201d. Seguindo esta nota a solu\u00e7\u00e3o seria:<\/p>\n<pre>[root@cvmlx-dbrst-01 ~]# cd \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/bin\/\r\n[root@cvmlx-dbrst-01 bin]# chgrp asmadmin oracle\r\n[root@cvmlx-dbrst-01 bin]# chmod 6751 oracle\r\n[root@cvmlx-dbrst-01 bin]# ls -l oracle\r\n-rwsr-s--x 1 <strong>oracle<\/strong> <strong>asmadmin<\/strong> 239626595 Nov 12 17:18 oracle\r\n[root@cvmlx-dbrst-01 bin]#<\/pre>\n<p style=\"text-align: justify;\">Depois de verificar a permiss\u00e3o atual e corrigir ela, voc\u00ea pode continuar a restaurar ou criar o banco com sucesso:<\/p>\n<pre>RMAN&gt; run {\r\n2&gt;   allocate channel 'dev_0' type 'sbt_tape' parms 'ENV=(NSR_SERVER=server-networker.tjsc.jus.br,NSR_CLIENT=exadb01,NSR_DPRINTF=TRUE, NSR_DEBUG_FILE=\/tmp\/t1.log,NSR_DEBUG_LEVEL=2)' ;\r\n3&gt;   restore controlfile from 'bkp-ctf-D-dbrest-DBID-871962163-T-20131107-NB-23891.bkp';\r\n4&gt; }\r\n\r\nusing target database control file instead of recovery catalog\r\nallocated channel: dev_0\r\nchannel dev_0: SID=24 device type=SBT_TAPE\r\nchannel dev_0: NMO v5.0.0.0\r\n\r\nStarting restore at 12\/11\/2013 18:29:29\r\n\r\nchannel dev_0: restoring control file\r\nchannel dev_0: restore complete, elapsed time: 00:02:36\r\noutput file name=+DATA\/dbrest\/controlfile\/current.256.831321123\r\nFinished restore at 12\/11\/2013 18:32:05\r\nreleased channel: dev_0\r\n\r\nRMAN&gt;<\/pre>\n<p style=\"text-align: justify;\">A solu\u00e7\u00e3o da nota 1054033.1 \u00e9 bem r\u00e1pida e simples, voc\u00ea s\u00f3 tem que tomar cuidado, pois toda e qualquer atualiza\u00e7\u00e3o ou aplica\u00e7\u00e3o de patch vai ter quer corrigir as permiss\u00f5es novamente.<\/p>\n<p style=\"text-align: justify;\">Existe uma segunda nota no MOS que \u00e9 mais radical: \u201cSRVCTL CHANGES THE PERMISSION AND GROUP OF ORACLE BINARY (Doc ID 1508027.1)\u201d. A solu\u00e7\u00e3o proposta na nota envolve a corre\u00e7\u00e3o do conte\u00fado do arquivo &lt;GI_HOME&gt;\/rdbms\/lib\/config.c e o relink do bin\u00e1rio \u201coracle\u201d.<\/p>\n<p style=\"text-align: justify;\">Sinceramente, eu prefiro e acho bem mais simples s\u00f3 alterar a permiss\u00e3o do bin\u00e1rio como a nota 1054033.1 sugere (bem como a solu\u00e7\u00e3o que apresento neste post). Neste exemplo o erro foi \u201cORA-00600: internal error code, arguments: [kfdskAlloc0][]&#8230;\u201d, mas pode aparecer como:<\/p>\n<ul>\n<li>ORA-00600 [kfkLoadByNum03] no Oracle 10<\/li>\n<li>ORA-00600: [kfk_load_by_idx_in_pga9] no Oracle 11.2<\/li>\n<li>ORA-15183: ASMLIB initialization error no Oracle 11.1<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Eu j\u00e1 vi esse mesmo erro ocorrer em um Exadata com 11.2.0.4 rodando o \u00faltimo PSU (de Janeiro de 2014). Como disse, a solu\u00e7\u00e3o \u00e9 simples, mas o erro pode assustar na hora, ainda mais quando voc\u00ea est\u00e1 migrando um banco de um local para outro.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Um post r\u00e1pido sobre um problema recorrente, mas que pode ajudar algu\u00e9m. Como DBA voc\u00ea est\u00e1 preocupado em seguir as recomenda\u00e7\u00f5es e melhores pr\u00e1ticas e instala um banco de dados com \u201crole separation\u201d. Usu\u00e1rios separados, um para o Grid e um para o Oracle, mas no final das contas recebe um belo ORA-600. No ambiente [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[40,30,29,6,5],"tags":[],"class_list":["post-144","post","type-post","status-publish","format-standard","hentry","category-40","category-banco-de-dados","category-database","category-exadata","category-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Role separation e ORA-600 kfdskAlloc0, corrigindo o erro<\/title>\n<meta name=\"description\" content=\"ORA-600 kfdskAlloc0, problemas ao criar um banco em ambiente com role separation.\" \/>\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.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Role separation e ORA-600 kfdskAlloc0, corrigindo o erro\" \/>\n<meta property=\"og:description\" content=\"ORA-600 kfdskAlloc0, problemas ao criar um banco em ambiente com role separation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/\" \/>\n<meta property=\"og:site_name\" content=\"Fernando Simon\" \/>\n<meta property=\"article:published_time\" content=\"2014-03-28T23:54:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-01-26T02:35:48+00:00\" \/>\n<meta name=\"author\" content=\"Simon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Simon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/\"},\"author\":{\"name\":\"Simon\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\"},\"headline\":\"Role Separation e ORA-600 [kfdskAlloc0]\",\"datePublished\":\"2014-03-28T23:54:17+00:00\",\"dateModified\":\"2015-01-26T02:35:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/\"},\"wordCount\":681,\"commentCount\":1,\"articleSection\":[\"600\",\"Banco de Dados\",\"Database\",\"Exadata\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/\",\"url\":\"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/\",\"name\":\"Role separation e ORA-600 kfdskAlloc0, corrigindo o erro\",\"isPartOf\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#website\"},\"datePublished\":\"2014-03-28T23:54:17+00:00\",\"dateModified\":\"2015-01-26T02:35:48+00:00\",\"author\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\"},\"description\":\"ORA-600 kfdskAlloc0, problemas ao criar um banco em ambiente com role separation.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.fernandosimon.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Role Separation e ORA-600 [kfdskAlloc0]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#website\",\"url\":\"https:\/\/www.fernandosimon.com\/blog\/\",\"name\":\"Fernando Simon\",\"description\":\"Have you hugged your backup today?\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.fernandosimon.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9\",\"name\":\"Simon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"caption\":\"Simon\"},\"sameAs\":[\"http:\/\/www.fernandosimon.com\"],\"url\":\"https:\/\/www.fernandosimon.com\/blog\/author\/simon\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Role separation e ORA-600 kfdskAlloc0, corrigindo o erro","description":"ORA-600 kfdskAlloc0, problemas ao criar um banco em ambiente com role separation.","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.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/","og_locale":"en_US","og_type":"article","og_title":"Role separation e ORA-600 kfdskAlloc0, corrigindo o erro","og_description":"ORA-600 kfdskAlloc0, problemas ao criar um banco em ambiente com role separation.","og_url":"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/","og_site_name":"Fernando Simon","article_published_time":"2014-03-28T23:54:17+00:00","article_modified_time":"2015-01-26T02:35:48+00:00","author":"Simon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Simon","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/#article","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/"},"author":{"name":"Simon","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"headline":"Role Separation e ORA-600 [kfdskAlloc0]","datePublished":"2014-03-28T23:54:17+00:00","dateModified":"2015-01-26T02:35:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/"},"wordCount":681,"commentCount":1,"articleSection":["600","Banco de Dados","Database","Exadata","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/","url":"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/","name":"Role separation e ORA-600 kfdskAlloc0, corrigindo o erro","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#website"},"datePublished":"2014-03-28T23:54:17+00:00","dateModified":"2015-01-26T02:35:48+00:00","author":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"description":"ORA-600 kfdskAlloc0, problemas ao criar um banco em ambiente com role separation.","breadcrumb":{"@id":"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fernandosimon.com\/blog\/role-separation-e-ora-600-kfdskalloc0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fernandosimon.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Role Separation e ORA-600 [kfdskAlloc0]"}]},{"@type":"WebSite","@id":"https:\/\/www.fernandosimon.com\/blog\/#website","url":"https:\/\/www.fernandosimon.com\/blog\/","name":"Fernando Simon","description":"Have you hugged your backup today?","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fernandosimon.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9","name":"Simon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","caption":"Simon"},"sameAs":["http:\/\/www.fernandosimon.com"],"url":"https:\/\/www.fernandosimon.com\/blog\/author\/simon\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5ofTp-2k","_links":{"self":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/144","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/comments?post=144"}],"version-history":[{"count":0,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/144\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/media?parent=144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/categories?post=144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/tags?post=144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}