{"id":2049,"date":"2021-01-22T16:44:29","date_gmt":"2021-01-22T16:44:29","guid":{"rendered":"https:\/\/swiv.com.br\/changing-oracle-apex-admin-password\/"},"modified":"2026-05-27T20:02:53","modified_gmt":"2026-05-27T19:02:53","slug":"changing-oracle-apex-admin-password","status":"publish","type":"post","link":"https:\/\/swiv.com.br\/index.php\/2021\/01\/22\/changing-oracle-apex-admin-password\/","title":{"rendered":"CHANGING ORACLE APEX ADMIN PASSWORD"},"content":{"rendered":"\n<p>Primeiro, devemos ir at\u00e9 a pasta que abriga a instala\u00e7\u00e3o do Apex, checar se o arquivo &#8220;apxchpwd.sql&#8221; est\u00e1 hospedado l\u00e1, e posteriormente \u00e9 s\u00f3 execut\u00e1-lo no banco de dados para proceder com a altera\u00e7\u00e3o da senha:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \\&quot;wp-block-syntaxhighlighter-code\\&quot;\"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\n&#x5B;oracle@oel7 ~]$ cd $ORACLE_HOME\/apex\n&#x5B;oracle@oel7 apex]$ ls -la apxchpwd.sql\n-rw-r--r-- 1 oracle oinstall 4016 Nov  8  2019 apxchpwd.sql\n&#x5B;oracle@oel7 apex]$ sqlplus \/ as sysdba\n \nSQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 22 13:40:58 2021\nVersion 19.3.0.0.0\n \nCopyright (c) 1982, 2019, Oracle.  All rights reserved.\n \n \nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.3.0.0.0\n \nSQL&gt; @apxchpwd.sql\n...set_appun.sql\n================================================================================\nThis script can be used to change the password of an Application Express\ninstance administrator. If the user does not yet exist, a user record will be\ncreated.\n================================================================================\nEnter the administrator&#039;s username &#x5B;ADMIN]\nUser &quot;ADMIN&quot; exists.\nEnter ADMIN&#039;s email &#x5B;ADMIN]\nEnter ADMIN&#039;s password &#x5B;]\nChanged password of instance administrator ADMIN.\n \nSQL&gt;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>Primeiro, devemos ir at\u00e9 a pasta que abriga a instala\u00e7\u00e3o do Apex, checar se o arquivo &#8220;apxchpwd.sql&#8221; est\u00e1 hospedado l\u00e1, e posteriormente \u00e9 s\u00f3 execut\u00e1-lo no banco de dados para proceder com a altera\u00e7\u00e3o da senha:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[18],"class_list":["post-2049","post","type-post","status-publish","format-standard","hentry","category-administration","tag-oracle-apex"],"_links":{"self":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2049","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=2049"}],"version-history":[{"count":1,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2049\/revisions"}],"predecessor-version":[{"id":9271,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/posts\/2049\/revisions\/9271"}],"wp:attachment":[{"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=2049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/swiv.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=2049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}