01 November, 2007

Oracle XE installation problem

Have a problem with Oracle Database 10g Express Edition?
Oracle is installed but doesn't work?

This is caused by that your account is given from domain server or your system has non-English locale.

HowTo resolve this problem:

  1. Create local user (this user should not be a domain account).


  2. Set OS system locale to English (US or UK, via Regional and Language Options), reboot.


  3. Install Oracle XE under local user (via runas console program or via Run as... from Windows Explorer popup menu).


  4. Open file "Oracle\app\oracle\product\10.2.0\server\NETWORK\ADMIN\sqlnet.ora
    and comment (via # symbol) or remove line SQLNET.AUTHENTICATION_SERVICES = (NTS)


  5. Open shell, type sqlplus oracle_user/oracle_password and work with Oracle XE.

2 comments:

Anonymous said...

BTW Oracle XE really SUCKS =)

Anonymous said...

Thanx a lot, mate.