Oracle Database Discussions

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>;

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

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!

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

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.

shutdown the database and create the password file . but for this you need to login using a user with DBA group .

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.

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.