{"id":38,"date":"2011-09-08T11:20:40","date_gmt":"2011-09-08T10:20:40","guid":{"rendered":"http:\/\/www.hman-projects.de\/?p=38"},"modified":"2011-09-08T11:20:40","modified_gmt":"2011-09-08T10:20:40","slug":"oracle-passwort-reset","status":"publish","type":"post","link":"https:\/\/www.hman-projects.de\/?p=38","title":{"rendered":"Oracle &#8211; Passwort Reset"},"content":{"rendered":"<p>Problemdarstellung<br \/>\nHat man das passwort der Datenbank dann doch vergessen&#8230; wie kommt man wieder dran?<br \/>\nUnter Windows einloggen. Man muss Mitglied der Gruppen Administrators oder der  ORA_DBA sein.<\/p>\n<p>Danach:<br \/>\nsqlplus \/nolog<br \/>\nconnect \/ as sysdba<\/p>\n<p>Nun ist man ohne Passwort connected und kann Passw\u00f6rter setzen<br \/>\nALTER USER username IDENTIFIED BY new_password;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Problemdarstellung Hat man das passwort der Datenbank dann doch vergessen&#8230; wie kommt man wieder dran? Unter Windows einloggen. Man muss Mitglied der Gruppen Administrators oder der ORA_DBA sein. Danach: sqlplus \/nolog connect \/ as sysdba Nun ist man ohne Passwort connected und kann Passw\u00f6rter setzen ALTER USER username IDENTIFIED BY new_password;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[9],"class_list":["post-38","post","type-post","status-publish","format-standard","hentry","category-allgemein","tag-oracle-reset-passwort"],"_links":{"self":[{"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=\/wp\/v2\/posts\/38"}],"collection":[{"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=38"}],"version-history":[{"count":1,"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=\/wp\/v2\/posts\/38\/revisions"}],"predecessor-version":[{"id":40,"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=\/wp\/v2\/posts\/38\/revisions\/40"}],"wp:attachment":[{"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=38"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=38"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hman-projects.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=38"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}