DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Oracle 10g XE

  1. #1
    Join Date
    Apr 2008
    Location
    Dallas, TX
    Posts
    2

    Oracle 10g XE

    Hi,

    I installed Oracle 10g Express edition on my laptop for educational purpose. I lost the administrator password and unable to login through the login page.

    Is there a way to reset/receover the password without uninstalling or do I have to reinstall again.

    Thanks
    Ram

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    What do you mean you lost the administrator password?

    Just in case try this:
    set your ORACLE_HOME and ORACLE_SID, then...
    sqlplus /nolog
    conn sys as sysdba
    press Enter when asked for the password
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Apr 2008
    Location
    Dallas, TX
    Posts
    2
    Thanks. I was able to login as mentioned below. I am not sure how to proceed further.

    Two things I want to rectify:

    1. when I installed the default user created was system. How to reset the password for this user. Now when I try to login, it says the account is locked.

    2. The URL http://127.0.0.1:8080/apex does not open up the database page. How to rectify it. I have tried with localhost:8080 also in the url.

    Any suggestions would be appreciated.

    Thanks
    Ram

  4. #4
    Join Date
    May 2008
    Posts
    1
    1.
    sql>conn / as sysdba;
    provide password ur password.
    sql>alter user identified by

    2.
    start your database.
    command prompt: netstat -an | find "TCP"
    check for the ip and port, status.
    ping the ip address.

    if not, change the port:8080
    sql>exec dbms_xdb.sethttpport(8090);
    sql>exec dbms_xdb.setlistenerlocalaccess(true);<-- should be true
    now: 127.0.0.1:8090
    try doing these, may work.

    cheers!

  5. #5
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    Quote Originally Posted by raambala
    Thanks. I was able to login as mentioned below. I am not sure how to proceed further.

    Two things I want to rectify:

    1. when I installed the default user created was system. How to reset the password for this user. Now when I try to login, it says the account is locked.
    If your account is locked,unlock it.

    connect as sys user, then

    alter user system account unlock;

    if you need to change the password,do it like the above poster said..

    alter user system identified by ;

  6. #6
    Join Date
    Nov 2008
    Posts
    6
    how can lost your password??

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    Quote Originally Posted by sandypeter111
    how can lost your password??
    never forgotten a password?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width