This discussion is archived
1 Reply Latest reply: Jun 15, 2013 11:56 AM by Paul M. RSS

USERNAME and PASSWORD

79e29485-11ce-49d6-9fe8-ff1314772e65 Newbie
Currently Being Moderated

HI, I need help regarding my username and password I sort of forgotten those. How can I  change them? Is there a way, other that reinstalling?

 

thank you and God bless you.

  • 1. Re: USERNAME and PASSWORD
    Paul M. Oracle ACE
    Currently Being Moderated


    HI, I need help regarding my username and password I sort of forgotten those. How can I  change them? Is there a way, other that reinstalling?

     

    Yes, there is. You don't specify your OS nor XE version. Anyway you can set the XE environment, for example the following refers to 10g XE on Windows (OS prompt) :

     

     

    set ORACLE_SID=XE

    set ORACLE_HOME=C:\oraclexe\app\oracle\product\10.2.0\server

    set PATH=C:\oraclexe\app\oracle\product\10.2.0\server\bin;%PATH%

    sqlplus / as sysdba

     

     

    At this point, assuming your OS user is member of ORA_DBA group, you can do what you want, for example change your user's password

     

     

    SQL> alter user <your user> identified by <new passord>;

     

    Or you can create new users : for this one please check the documentation : http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8003.htm#i2065278