Friday, February 28, 2014

Oracle XE, sys/password not working

I have been using Oracle XE and many things were using SYS/password, one fine day all those connection failing with "invalid username password". After few mins of googling I got the answer:

\oraclexe\app\oracle\product\11.2.0\server\database\

and rename PWDXE.ora

and run cmd>orapwd file =<above file name> password=<new password>

for example:
oraclexe\app\oracle\product\11.2.0\server\bin>orapwd file=D:\Oracle\oraclexe\app\oracle\product\11.2.0\server\database\PWDXE.ora password=<new password>