How to connect to newly installed Oracle XE instance?

oracle oracle10g oracle-xe
michael nesterenko picture michael nesterenko · Mar 23, 2011 · Viewed 19k times · Source

I have installed Oracle XE on Win7 x64 machine. Installation completed successfully without problem, or perhaps installer didn't tell about them. But after installation I can't connect to database; its web interface is not working. I have looked through list of open ports, and there is no 8080 port as was noted during installation. Also I can't connect via SQLPlus.

SQL> connect SYSTEM
Enter password:
ERROR:
ORA-12638: Credential retrieval failed

Somewhere in the web it was told to edit sqlnet.ora file, I have changed it in the following way: 

# SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.AUTHENTICATION_SERVICES = (NONE)

and now I get next error

SQL> connect SYSTEM
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

What do I need to change so that I can connect to it?

Answer

Rejeev Divakaran picture Rejeev Divakaran · May 13, 2012

I figured out the issue.
I was using domain login to install Oracle XE. If you are using domain login to install Oracle XE then the database creation will fail (though you may not get any error messages on that regard).
Solution:
Install Oracle using a local admin user.
Change SQLNET.AUTHENTICATION_SERVICES to (NONE) in sqlnet.ora.
Now login with your domain user to use oracle XE.

Related questions

Create date from year, month and day

Does Oracle have a builtin function to create a date from its individual components (year, month and day) that just returns null on missing data? I'm aware of TO_DATE() but I need to compose a string first and neither …

Read More
Using WMSYS.WM_CONCAT with Oracle XE 10g

When I try to use WMSYS.WM_CONCAT with Oracle XE 10g, I receive a compilation error: ORA-00904: "WMSYS"."WM_CONCAT": invalid identifier. Can anyone verify that this is indeed due to XE lacking this (undocumented) feature? If so, is …

Read More
how do i increase database size from 11GB to above 20Gb

Every time i get below error when ever i try to import new dump into the data base. How do i increase db size? Any ways to resolve this, without deleting data from database? ORA-12953: The request exceeds the maximum …

Read More