8 Replies Latest reply: Jul 3, 2012 9:13 PM by SampathWeerasekara RSS

    Oracle XE default username / password

    631319
      Hi all,

      An instance of Oracle 10g XE had been set up for my team a while back by a previous employee. Unfortunately, he left without telling us the username / password that he had set up for the database.

      Is there a default username / password (that has DBA privileges) that we can use to get into this XE database, or are we looking at removing this database and re-installing it?

      Thanks,

      Tom
        • 1. Re: Oracle XE default username / password
          Surachart Opun
          Can you login on your server?

          If yes, what OS

          If Linux/Unix

          export ORACLE_SID=XE
          export ORACLE_HOME=<Oracle_XE_install_path>
          sqlplus / as sysdba

          SQL> alter user sys indentified by <new_password>;

          SQL> alter user system indentified by <new_password>;


          If windows


          set ORACLE_SID=XE
          set ORACLE_HOME=<Oracle_XE_install_path>
          sqlplus / as sysdba

          SQL> alter user sys indentified by <new_password>;

          SQL> alter user system indentified by <new_password>;
          • 2. Re: Oracle XE default username / password
            631319
            Perfect!

            Though, it turned out to be easier than that. One of the START command options for Oracle XE (windows) is to run 'Run SQL Command Line'. Once I got there, I connected as SYSDBA as you suggested. I altered the user, and we're back in business.

            Thanks for your help,

            Tom
            • 3. Re: Oracle XE default username / password
              OBIGuy
              I logged into the server machine and executed the following on the Windows command prompt:

              set ORACLE_SID=XE
              sqlplus / as sysdba

              However, I am getting the following error message - ORA-01031: insufficient privileges.

              I also tried the "Run SQL Command Line" utility, but not sure how to log on as SYSDBA at the SQL prompt there.

              Could someone help me with this?

              Thanks!
              • 4. Re: Oracle XE default username / password
                752163
                Hi,

                Once you set the oracle_sid then type sqlplus sys as sysdba then it will ask you the password,give the password for sys user.

                Regards,
                khaja
                • 5. Re: Oracle XE default username / password
                  OBIGuy
                  Hello Khaja, thats the very issue. I do not have the SYS password. This instance of OracleXE was setup few weeks back by some one else, and he is not around now. So this very exercise is amied at resetting the SYS password somehow, so that we can use the XE instance.
                  • 6. Re: Oracle XE default username / password
                    shakilshaikh
                    shutdown the database and create the password file . but for this you need to login using a user with DBA group .
                    • 7. Re: Oracle XE default username / password
                      832007
                      Hi peeps,

                      OS - windows server2008
                      oracle - client 10g Express Edition + Oracle DB 10g express edition

                      I've tried to run sql command >

                      1) start DB
                      2) run sql ...SQL > connect system/system
                      ERROR:
                      0RA-12560 TNS : Protocol adapter error.

                      I figured that I've totally forgot my username./pw , so i tried the following .

                      alter user system identified by system ;
                      SP2-0640: Not connected.

                      Please advice.
                      • 8. Re: Oracle XE default username / password
                        SampathWeerasekara
                        Hi, For each and every unexpected behaviour/error see the installation logs at C:\oraclexe\app\oracle\product\11.2.0\server\config\log. It will tell what went wrongs during installation.

                        In my case, it shows some thing related to windows events are full. I cleared all the events, de-install oracle and re-install. Everything is perfect.