Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to connect to newly installed Oracle XE instance?

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?

like image 451
michael nesterenko Avatar asked Mar 23 '11 13:03

michael nesterenko


3 Answers

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.

like image 105
Rejeev Divakaran Avatar answered Oct 10 '22 23:10

Rejeev Divakaran


Check the Oracle services are started

like image 23
cagcowboy Avatar answered Oct 11 '22 00:10

cagcowboy


Did you set your ORACLE_SID environment variable to the name of the instance you're connecting to?

like image 22
DCookie Avatar answered Oct 10 '22 23:10

DCookie