{"id":944,"date":"2014-03-31T17:22:14","date_gmt":"2014-03-31T21:22:14","guid":{"rendered":"https:\/\/gonzalo.aro.cl\/blog\/?p=944"},"modified":"2014-03-31T17:22:14","modified_gmt":"2014-03-31T21:22:14","slug":"recuperar-password-de-system-en-oracle","status":"publish","type":"post","link":"https:\/\/gonzalo.aro.cl\/blog\/2014\/03\/31\/recuperar-password-de-system-en-oracle\/","title":{"rendered":"Recuperar password de SYSTEM en Oracle"},"content":{"rendered":"<p>A veces pasa que si no existe un proceso para guardar o mantener las password de los distintos sistemas actualizada, puede pasar que se cambie la password sin que todos los participantes se enteren.<\/p>\n<p>Oracle puede ser un caso, pero si tienes la password de root, del sistema (o administrador en caso de windows) puedes aplicar los siguientes pasos<\/p>\n<pre class=\"brush: bash\">\r\n[root@server ~]# su - oracle\r\n[oracle@server ~]$ sqlplus \/nolog\r\nSQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 31 17:16:17 2014\r\nCopyright (c) 1982, 2009, Oracle.  All rights reserved.\r\nSQL> connect \/ as sysdba\r\nConnected.\r\nSQL> ALTER USER system IDENTIFIED BY lanuevapassword;\r\n\r\nUser altered.\r\n\r\nSQL> exit\r\nDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\n<\/pre>\n<p>En windows solo debes poner a un usuario (el que utilizas para administrar) en el grupo DBA de Oracle, y con ese usuario utilizar sqlplus. Con ello te podr\u00e1s conectar y cmabiar la password.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A veces pasa que si no existe un proceso para guardar o mantener las password de los distintos sistemas actualizada, puede pasar que se cambie la password sin que todos los participantes se enteren. Oracle puede ser un caso, pero si tienes la password de root, del sistema (o administrador en caso de windows) puedes [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,9,50,35,13],"tags":[],"class_list":["post-944","post","type-post","status-publish","format-standard","hentry","category-centos","category-oracle","category-redhat","category-solaris","category-windows"],"_links":{"self":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/944"}],"collection":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/comments?post=944"}],"version-history":[{"count":1,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/944\/revisions"}],"predecessor-version":[{"id":945,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/posts\/944\/revisions\/945"}],"wp:attachment":[{"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/media?parent=944"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/categories?post=944"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gonzalo.aro.cl\/blog\/wp-json\/wp\/v2\/tags?post=944"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}