{"id":1472,"date":"2016-07-20T09:50:08","date_gmt":"2016-07-20T07:50:08","guid":{"rendered":"https:\/\/clemente.pamplona.name\/dba\/?p=1472"},"modified":"2016-07-20T09:50:08","modified_gmt":"2016-07-20T07:50:08","slug":"errores-ora-16179-al-intentar-cambiar-el-log_archive_dest_1","status":"publish","type":"post","link":"http:\/\/clemente.pamplona.name\/dba\/errores-ora-16179-al-intentar-cambiar-el-log_archive_dest_1\/","title":{"rendered":"Errores ORA-16179 al intentar cambiar el LOG_ARCHIVE_DEST_1"},"content":{"rendered":"<p>Hoy vamos a ver una entrada tan absurda que roza casi lo idiota.<\/p>\n<p>Supongamos que queramos modificar o a\u00f1adir el destino de nuestros archivers,e intent\u00e1ndolo tenemos el error <b>ORA-16179<\/b><\/p>\n<pre>\r\nSQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION = D:\\oracle\\FRA\\QA';\r\nALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = 'LOCATION = D:\\oracle\\FRA\\QA''\r\nERROR en l\u03c6nea 1:\r\nORA-32017: fallo al actualizar SPFILE\r\nORA-16179: cambios incrementales en \"log_archive_dest_1\" no permitidos con SPFILE\r\n<\/pre>\n<p>La primera accion a temar en cuenta, <b><font color=red>es buscar blancos en el entrecomillado <\/b><\/font><\/p>\n<p>Una vez eliminados los blancos, funcionar\u00e1 correctamente  \ud83d\ude42 <\/p>\n<p>Pueden haber otros problemas que den este ORA-, todos ellos mas serios que el de esta entrada, su solucion la pod\u00e9is busar en:<\/p>\n<ul>\n<li> Soporte en  la  Nota OERR: ORA-16179 \u00abincremental changes to %s not allowed with SPFILE\u00bb Reference Note (Doc ID 194494.1)\n<li> <a href=\"https:\/\/burzaco.wordpress.com\/2012\/08\/24\/ora-16179-incremental-changes-to-log_archive_dest_1-not-allowed-with-spfile\/\">Blog de Juan Andres Mercado <\/a>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Hoy vamos a ver una entrada tan absurda que roza casi lo idiota. Supongamos que queramos modificar o a\u00f1adir el destino de nuestros archivers,e intent\u00e1ndolo tenemos el error ORA-16179 SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1 = &#8216;LOCATION = D:\\oracle\\FRA\\QA&#8217;; ALTER SYSTEM &hellip; <a href=\"http:\/\/clemente.pamplona.name\/dba\/errores-ora-16179-al-intentar-cambiar-el-log_archive_dest_1\/\">Sigue leyendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,60,66],"tags":[248,623,625,28],"class_list":["post-1472","post","type-post","status-publish","format-standard","hentry","category-11g","category-12c","category-errores-ora","tag-dummie","tag-log_archive_dest_1","tag-ora-16179","tag-spfile"],"_links":{"self":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1472","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/comments?post=1472"}],"version-history":[{"count":1,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1472\/revisions"}],"predecessor-version":[{"id":1473,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/posts\/1472\/revisions\/1473"}],"wp:attachment":[{"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/media?parent=1472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/categories?post=1472"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/clemente.pamplona.name\/dba\/wp-json\/wp\/v2\/tags?post=1472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}