How to connect to a recently installed instance of Oracle XE?

Question

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

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

Somewhere on the Internet it was said to edit the sqlnet.ora file, I changed it as follows:

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

and now i get the following 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 1

I understood the question.

I used domain registration to install Oracle XE. If you use a domain account to install Oracle XE, then creating the database will fail (although you may not receive any error messages in this regard).

Decision:
Install Oracle using a local administrator.

Change SQLNET.AUTHENTICATION_SERVICES to (NONE) in sqlnet.ora.

Now log in with your domain user to use oracle XE.

Answer 2

Verify Oracle Services Startup

Answer 3

Have you set the environment variable ORACLE_SID to the name of the instance you are connecting to?

Answer 4

• Verify that the oracle service is running.
• did to start netca after installation? - if not, you can run it from cmd
• You cannot connect to the system if instacne is disabled only as sysdba (user sys)
• Ensure that the environment variables ORACLE_HOME, ORACLE_SID, PATH are in order
• If everything is ok, you can try to start / connect to the instance manually

Example:

 C:\Documents and Settings\asafm> C:\Documents and Settings\asafm> C:\Documents and Settings\asafm>sqlplus "sys as sysdba" SQL*Plus: Release 11.2.0.1.0 Production on Fri May 11 16:21:42 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter password: Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 535662592 bytes Fixed Size 1375792 bytes Variable Size 360710608 bytes Database Buffers 167772160 bytes Redo Buffers 5804032 bytes Database mounted. Database opened. SQL> SQL> SQL>select status from v$instance; 

Answer 5

As Rejeev Divakaran said, installing oracle XE with a local Windows user and switching to the domain user account, launched db, was able to connect.

Configuration

• Office laptop
• Windows 7 64 bit
• Oracle 11g XE

Answer 6

You can connect this way from the command line:

 sqlplus / as sysdba 

if so at the SQL command prompt type

 SQL>startup 

If the command returns ok, try connecting with a username and password.

Answer 7

This error message usually occurs when the database cannot be started. The Windows service may work, but still, Oracle may not be able to start server threads and distribute client connections.

See the application \ oracle \ admin \ xe \ bdump \ alert_xe.log for any error messages the last time you started the Oracle service.

Answer 8

Just in case, someone is "lucky" like me: I recently could not install Oracle with a local user (as suggested here earlier), since the target computer (Win2k8 x64) was also a domain controller for this network. All users were in the domain - there were no local users :(

Here are the steps I followed:

• Installed Oracle XE on my local machine (this works fine). Made a backup (using the built-in backup.bat );
• Transfer the fast_recovery_area folder to my target machine;
• Normally Oracle XE is installed on the target machine;

• Edited the %ORA_HOME%\network\admin\sqlnet.ora and performed this famous edit :

  SQLNET.AUTHENTICATION_SERVICES= (NONE)

• Edited file %ORA_HOME%\bin\restore.bat :

  • Replaced each rman target / (...) rman target sys/MySysDbaPass (...) with rman target sys/MySysDbaPass (...)
  • Each entry is replaced (...) connect / as sysdba^; on (...) connect sys/MySysDbaPass as sysdba^;

• Runned restore.bat - when prompted, points to fast_recovery_area , which I fast_recovery_area earlier.

• Done! (Pheew!)

Answer 9

Sorry for the answer to this old question, but I managed to get it to work ...

Make a change to sqlnet.ora.

Run StopDB.bat

Run MakeDB.bat

This will create a demo database, reset the password for "oracle", and also allow you to connect without errors.