{"id":2201,"date":"2013-07-10T18:09:29","date_gmt":"2013-07-10T10:09:29","guid":{"rendered":"http:\/\/rmohan.com\/?p=2201"},"modified":"2013-07-10T18:10:24","modified_gmt":"2013-07-10T10:10:24","slug":"recover-lost-passwords","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=2201","title":{"rendered":"Recover lost passwords"},"content":{"rendered":"<p>To recover a\u00a0<a href=\"http:\/\/en.kioskea.net\/contents\/attaques\/passwd.php3\">password<\/a>\u00a0in Oracle, simply connect under\u00a0<b>command line mode<\/b>\u00a0on the\u00a0<b><a href=\"http:\/\/en.kioskea.net\/contents\/cs\/csintro.php3\">server<\/a><\/b>:<\/p>\n<pre>#sqlplus \/nolog      \r\nSQL&gt;conn \/ as sysdba      \r\nSQL&gt;alter user Username identified by PASSWORD;<\/pre>\n<p>To reset your Orable database password:<\/p>\n<p>Your password file should be under &lt;orahome&gt;\\database\\PWD&lt;SID&gt;.ora.<\/p>\n<p><i>Delete it and run the Oracle password utility from the command prompt:<\/i><\/p>\n<pre>c\\:Oracle\\ora92\\database&gt;ORAPWD file=PWD&lt;SID&gt;.ora password={password} entries={however many}.<\/pre>\n<p>The &lt;password&gt; is your new sys password. After you log in as sys you can change it and create new passwords for system.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><b>How do I get the list of tables in an Oracle database from SQL Plus?<\/b><br \/>\n<a name=\"solution\"><\/a><\/p>\n<h2>Solution<\/h2>\n<p>To list the tables in the schema of the current user:<\/p>\n<pre>SELECT table_name FROM user_tables;<\/pre>\n<p>List the tables accessible by the user:<\/p>\n<pre>SELECT table_name FROM all_tables;<\/pre>\n<p>List all the tables (must be ADMIN):<\/p>\n<pre>SELECT table_name FROM dba_tables;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>To recover a password in Oracle, simply connect under command line mode on the server:<\/p>\n<p> #sqlplus \/nolog SQL&gt;conn \/ as sysdba SQL&gt;alter user Username identified by PASSWORD; <\/p>\n<p>To reset your Orable database password:<\/p>\n<p>Your password file should be under &lt;orahome&gt;\\database\\PWD&lt;SID&gt;.ora.<\/p>\n<p>Delete it and run the Oracle password utility from the command prompt:<\/p>\n<p> c\\:Oracle\\ora92\\database&gt;ORAPWD file=PWD&lt;SID&gt;.ora password={password} [&#8230;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2201"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2201"}],"version-history":[{"count":3,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2201\/revisions"}],"predecessor-version":[{"id":2204,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2201\/revisions\/2204"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}