when I try connect to sqlplus , it show me the following message :SQLNET.AUTHENTICATION_SERVICES=(NONE)
SQL*Plus: Release 184.108.40.206.0 Production on Jue Abr 11 16:08:52 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> connI see the Services.msc program and the OracleService and Listener are UP AND RUNNING
Enter user-name: system
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
Database is down. Services have to be running, be sure and double check the OracleServiceXE in the services applet, with a sysdba connection try a startup, in a command box ...ORA-01034: ORACLE not available
If the database does not startup and say "database open", installer probably did not get to complete all its tasks, if so a deinstall and try another installer run. See the windows uninstall steps at http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#CIHDDHJD
sqlplus /nolog conn /as sysdba; ... connected to idle instance ... startup ... memory info ... ... Database mounted. ... Database open.
Not relevant, that's a cluster ready services piece and not part of an XE install.clsc.log file is showing ...
The user logged into the host is most likely not in the ORA_DBA group. There are other client settings that can cause this setup problem but lacking group membership is the most common one.conn /as sysdba ... ERROR: ORA-01031: insufficient privileges
Try the start/run/lusrmgr.msc for the local users and groups applet, in Groups, pick ora_dba and the Add button for your user login.
net localgroup ora_dba Alias name ora_dba ... Members <domain>\<user1> <user2> NT AUTHORITY\SYSTEM ...
That's one of the other causes of the insufficient privs error when using conn /as sysdba. A "connect /" uses OS authentication and the NONE disables it. Can't connect / or conn /as sysdba with that particular setting.modiffied the : sqlnet.ora file as bellow : SQLNET.AUTHENTICATION_SERVICES=(NONE)
SQLNET.AUTHENTICATION_SERVICES=(NTS)This is my users
C:\Windows\System32>net localgroup ora_dbawhen I use the command : lsnrctl status ; I Get :
Nombre de alias ora_dba
Comentario Oracle DBA Group
Se ha completado el comando correctamente.
LSNRCTL for 32-bit Windows: Version 220.127.116.11.0 - Production on 18-ABR-2013 12:26:26As you see, the listener and the Service are running succesful,
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
Version TNSLSNR for 32-bit Windows: Version 18.104.22.168.0 - Production
Start Date 18-ABR-2013 12:21:36
Uptime 0 days 0 hr. 4 min. 54 sec
Trace Level offSecurity ON: Local OS AuthenticationSNMP OFF
Default Service XE
Listener Parameter File D:\Orecle_XE_11g\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File D:\Orecle_XE_11g\app\oracle\diag\tnslsnr\ADUANA-PC\listener\alert\log.xml
Listening Endpoints Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Thanks very much.Security ON: Local OS Authentication
Don't think so, that's a listener setting. I've got the SQLNET.AUTHENTICATION_SERVICES = (NTS) and lsnrctl status shows the same exact Security line.security param is the root problem ?
Well, not exactly. The listener is running but the database has not registered with the listener, should have a "Service" line similar to:the listener and the Service are running succesful,
And should also have another one, 'Service "XEXDB" has 1 instance(s).' as well for Apex, but that only means the web pages at http...:8080/apex won't work. Most likely something not exactly correct with the client network setup, but first things first, lets get past the sqlplus can't connect trouble.
Service "xe" has 1 instance(s).
And take a look in the folder ...diag/rdbms/xe/xe/trace/alert_xe.log and go to the very bottom, there should not be a line similar to:
echo %username% ... mamolina ? echo %userdomain% ... ADUANA ?
at the end of the file.
Instance shutdown complete
1 Uninstall Oracle XEThanks to everyone again. :D
2 Log In as NOT A USER DOMAIN in the windows PC.
3 Install Oracle XE again
4 Verify the Installation , and it Run OK !!!
5 Log In as A USER DOMAIN in the windows PC.
6 verify the Oracle XE DB, and it , Runnig and all is Ok !!! :D
7 Now everytime log as a USER DOMAIN in the windows PC and load the ServiceXE and the Listener normally.