1 Reply Latest reply: Jun 15, 2013 1:56 PM by Paul M. RSS

    USERNAME and PASSWORD

    79e29485-11ce-49d6-9fe8-ff1314772e65

      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.


          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