Home » RDBMS Server » Security » os authentication issue (11.2.0.1.0 Windos XP)
os authentication issue [message #523184] Fri, 16 September 2011 01:13 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
How can i use os authentication to login db?
SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges


sqlnet.ora text:
# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

#SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.INBOUND_CONNECT_TIMEOUT=1
Re: os authentication issue [message #523186 is a reply to message #523184] Fri, 16 September 2011 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You are not in the ORA_DBA group or you are not using the sqlnet.ora you think you use.

Regards
Michel

[Updated on: Fri, 16 September 2011 01:25]

Report message to a moderator

Re: os authentication issue [message #523196 is a reply to message #523186] Fri, 16 September 2011 03:16 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
my os is windows xp, how to check whether use ORA_DBA group and sqlnet.ora?
Re: os authentication issue [message #523197 is a reply to message #523196] Fri, 16 September 2011 03:27 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In "configuration panel", click on "Admin tools" and on "Computer Management" then choose "Users and groups".

Regards
Michel
Re: os authentication issue [message #523199 is a reply to message #523197] Fri, 16 September 2011 03:45 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
I have checked my user belong to ORA_DBA group.

C:\Documents and Settings\huangxl>set oracle_home=D:\oracle\product\11.2.0\dbhome_1\

C:\Documents and Settings\huangxl>set oracle_sid=orcl

C:\Documents and Settings\huangxl>sqlplus /nolog

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges

Re: os authentication issue [message #523229 is a reply to message #523199] Fri, 16 September 2011 05:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post result of "set" and "type D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora"

Regards
Michel
Re: os authentication issue [message #523443 is a reply to message #523229] Sun, 18 September 2011 20:05 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
"D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora"
# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

#SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.INBOUND_CONNECT_TIMEOUT=1
Re: os authentication issue [message #523456 is a reply to message #523443] Sun, 18 September 2011 23:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You didn't post what I asked.

Regards
Michel
Re: os authentication issue [message #523459 is a reply to message #523456] Mon, 19 September 2011 00:42 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
C:\Documents and Settings\huangxl>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users.WINDOWS
APPDATA=C:\Documents and Settings\huangxl\Application Data
CLIENTNAME=Console
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=HUANGXUELIANG
ComSpec=C:\WINDOWS\system32\cmd.exe
DSPackagePath=E:\Ascential\DataStage\Package
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\huangxl
JAVA_HOME=C:\Program Files\Java\jdk1.6.0
LOGONSERVER=\\HUANGXUELIANG
NUMBER_OF_PROCESSORS=2
ORACLE_HOME=D:\oracle\product\11.2.0\dbhome_1
ORACLE_UNQNAME=orcl
OS=Windows_NT
Path=C:\Program Files\Oracle\jre\1.1.8\bin;C:\Program Files\PC Connectivity Solution\;D:\oracle\product\11.2.0\dbhome_1\bin;C:\Pyt
hon26\Scripts;C:\Python26\;D:\oracle\oracle\product\11.2.0\dbhome_1\bin;C:\Program Files\Java\jdk1.6.0\bin;C:\WINDOWS\system32;C:\
WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\TortoiseSVN\bin;C:\Program Files\Common Files\Thunder Network\KanKan\Codecs;C:\P
rogram Files\IDM Computer Solutions\UltraEdit-32;;C:\Program Files\SinoVoice\jTTS 5.0 Desktop\Bin;C:\Program Files\Java\jdk1.6.0\b
in;%APPDATA%\Python\Scripts;D:\oracle\product\10.1.0;C:\Program Files\IDM Computer Solutions\UltraCompare;C:\Program Files\OpenVPN
\bin;C:\Program Files\MySQL\MySQL Server 5.0\bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.py;.pyw
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 13, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f0d
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\huangxl\LOCALS~1\Temp
TMP=C:\DOCUME~1\huangxl\LOCALS~1\Temp
USERDOMAIN=HUANGXUELIANG
USERNAME=huangxl
USERPROFILE=C:\Documents and Settings\huangxl
windir=C:\WINDOWS

Re: os authentication issue [message #523460 is a reply to message #523459] Mon, 19 September 2011 00:44 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
C:\Documents and Settings\huangxl>type D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

#SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.INBOUND_CONNECT_TIMEOUT=1
C:\Documents and Settings\huangxl>

Re: os authentication issue [message #523461 is a reply to message #523460] Mon, 19 September 2011 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't see any ORACLE_SID set.

Regards
Michel
Re: os authentication issue [message #523468 is a reply to message #523461] Mon, 19 September 2011 01:23 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
C:\Documents and Settings\huangxl>set oracle_sid=orcl

C:\Documents and Settings\huangxl>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users.WINDOWS
APPDATA=C:\Documents and Settings\huangxl\Application Data
CLIENTNAME=Console
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=HUANGXUELIANG
ComSpec=C:\WINDOWS\system32\cmd.exe
DSPackagePath=E:\Ascential\DataStage\Package
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\huangxl
JAVA_HOME=C:\Program Files\Java\jdk1.6.0
LOGONSERVER=\\HUANGXUELIANG
NUMBER_OF_PROCESSORS=2
ORACLE_HOME=D:\oracle\product\11.2.0\dbhome_1
oracle_sid=orcl
ORACLE_UNQNAME=orcl
OS=Windows_NT
Path=C:\Program Files\Oracle\jre\1.1.8\bin;C:\Program Files\PC Connectivity Solution\;D:\oracle\product\11.2.0\dbhome_1\bin;C:\Py
hon26\Scripts;C:\Python26\;D:\oracle\oracle\product\11.2.0\dbhome_1\bin;C:\Program Files\Java\jdk1.6.0\bin;C:\WINDOWS\system32;C:
WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\TortoiseSVN\bin;C:\Program Files\Common Files\Thunder Network\KanKan\Codecs;C:\
rogram Files\IDM Computer Solutions\UltraEdit-32;;C:\Program Files\SinoVoice\jTTS 5.0 Desktop\Bin;C:\Program Files\Java\jdk1.6.0\
in;%APPDATA%\Python\Scripts;D:\oracle\product\10.1.0;C:\Program Files\IDM Computer Solutions\UltraCompare;C:\Program Files\OpenVP
\bin;C:\Program Files\MySQL\MySQL Server 5.0\bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.py;.pyw
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 13, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f0d
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\huangxl\LOCALS~1\Temp
TMP=C:\DOCUME~1\huangxl\LOCALS~1\Temp
USERDOMAIN=HUANGXUELIANG
USERNAME=huangxl
USERPROFILE=C:\Documents and Settings\huangxl
windir=C:\WINDOWS

C:\Documents and Settings\huangxl>sqlplus /nolog

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges


SQL>

[Updated on: Mon, 19 September 2011 01:24]

Report message to a moderator

Re: os authentication issue [message #523485 is a reply to message #523468] Mon, 19 September 2011 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
How does it come that you variable is in lower case in your output when Windows is not case sensitive
and it shoud be in upper case?

Regards
Michel
Re: os authentication issue [message #524192 is a reply to message #523485] Thu, 22 September 2011 03:24 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
I change the variable to upper case,the problem is also apper.
C:\Documents and Settings\huangxl>set
ALLUSERSPROFILE=C:\Documents and Settings\All Users.WINDOWS
APPDATA=C:\Documents and Settings\huangxl\Application Data
CLIENTNAME=Console
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=HUANGXUELIANG
ComSpec=C:\WINDOWS\system32\cmd.exe
DSPackagePath=E:\Ascential\DataStage\Package
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\huangxl
JAVA_HOME=C:\Program Files\Java\jdk1.6.0
LOGONSERVER=\\HUANGXUELIANG
NUMBER_OF_PROCESSORS=2
ORACLE_HOME=d:\oracle\product\11.2.0\dbhome_1
ORACLE_SID=ORCL
ORACLE_UNQNAME=ORCL
OS=Windows_NT
Path=C:\Program Files\Oracle\jre\1.1.8\bin;C:\Program Files\PC Connectivity Solution\;D:\oracle\product\11.2.0\dbhome_1\bin;C:\Pyt
hon26\Scripts;C:\Python26\;D:\oracle\oracle\product\11.2.0\dbhome_1\bin;C:\Program Files\Java\jdk1.6.0\bin;C:\WINDOWS\system32;C:\
WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\TortoiseSVN\bin;C:\Program Files\Common Files\Thunder Network\KanKan\Codecs;C:\P
rogram Files\IDM Computer Solutions\UltraEdit-32;;C:\Program Files\SinoVoice\jTTS 5.0 Desktop\Bin;C:\Program Files\Java\jdk1.6.0\b
in;%APPDATA%\Python\Scripts;D:\oracle\product\10.1.0;C:\Program Files\IDM Computer Solutions\UltraCompare;C:\Program Files\OpenVPN
\bin;C:\Program Files\MySQL\MySQL Server 5.0\bin
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.py;.pyw
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 13, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f0d
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\huangxl\LOCALS~1\Temp
TMP=C:\DOCUME~1\huangxl\LOCALS~1\Temp
USERDOMAIN=HUANGXUELIANG
USERNAME=huangxl
USERPROFILE=C:\Documents and Settings\huangxl
windir=C:\WINDOWS

C:\Documents and Settings\huangxl>sqlplus /nolog

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges

Re: os authentication issue [message #524214 is a reply to message #524192] Thu, 22 September 2011 04:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Uncomment "SQLNET.AUTHENTICATION_SERVICES = (NTS)" in your sqlnet.ora.

Regards
Michel
Re: os authentication issue [message #524514 is a reply to message #524214] Sat, 24 September 2011 09:05 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
hi,
I Uncomment "SQLNET.AUTHENTICATION_SERVICES = (NTS)",it success,why?
C:\Documents and Settings\huangxl>type D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.INBOUND_CONNECT_TIMEOUT=1


SQL> connect / as sysdba
connected.

Re: os authentication issue [message #524516 is a reply to message #524514] Sat, 24 September 2011 09:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I Uncomment "SQLNET.AUTHENTICATION_SERVICES = (NTS)",it success,why?
Working as designed using Operating System authorization;
which you could learn about if you EVER decided to Read The Fine Manual found at http://tahiti.oracle.com
Re: os authentication issue [message #524519 is a reply to message #524514] Sat, 24 September 2011 09:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I Uncomment "SQLNET.AUTHENTICATION_SERVICES = (NTS)",it success,why?

Because you then explicitely allow OS authentications.
The default is you do not allow them.

Regards
Michel
Re: os authentication issue [message #524583 is a reply to message #524519] Sun, 25 September 2011 01:20 Go to previous message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks!
Previous Topic: SYS Password
Next Topic: Audit - without enabling
Goto Forum:
  


Current Time: Thu Mar 28 16:42:08 CDT 2024