OraFAQ Forum: Security » os authentication issue

Home » RDBMS Server » Security » os authentication issue (11.2.0.1.0 Windos XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

os authentication issue [message #523184]

Fri, 16 September 2011 01:13

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

Report message to a moderator

Re: os authentication issue [message #523186 is a reply to message #523184]

Fri, 16 September 2011 01:24

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

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?

Report message to a moderator

Re: os authentication issue [message #523197 is a reply to message #523196]

Fri, 16 September 2011 03:27

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In "configuration panel", click on "Admin tools" and on "Computer Management" then choose "Users and groups".

Regards
Michel

Report message to a moderator

Re: os authentication issue [message #523199 is a reply to message #523197]

Fri, 16 September 2011 03:45

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

Report message to a moderator

Re: os authentication issue [message #523229 is a reply to message #523199]

Fri, 16 September 2011 05:32

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post result of "set" and "type D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora"

Regards
Michel

Report message to a moderator

Re: os authentication issue [message #523443 is a reply to message #523229]

Sun, 18 September 2011 20:05

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

Report message to a moderator

Re: os authentication issue [message #523456 is a reply to message #523443]

Sun, 18 September 2011 23:22

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You didn't post what I asked.

Regards
Michel

Report message to a moderator

Re: os authentication issue [message #523459 is a reply to message #523456]

Mon, 19 September 2011 00:42

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

Report message to a moderator

Re: os authentication issue [message #523460 is a reply to message #523459]

Mon, 19 September 2011 00:44

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>

Report message to a moderator

Re: os authentication issue [message #523461 is a reply to message #523460]

Mon, 19 September 2011 00:48

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't see any ORACLE_SID set.

Regards
Michel

Report message to a moderator

Re: os authentication issue [message #523468 is a reply to message #523461]

Mon, 19 September 2011 01:23

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: os authentication issue [message #524192 is a reply to message #523485]

Thu, 22 September 2011 03:24

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

Report message to a moderator

Re: os authentication issue [message #524214 is a reply to message #524192]

Thu, 22 September 2011 04:17

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Uncomment "SQLNET.AUTHENTICATION_SERVICES = (NTS)" in your sqlnet.ora.

Regards
Michel

Report message to a moderator

Re: os authentication issue [message #524514 is a reply to message #524214]

Sat, 24 September 2011 09:05

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.

Report message to a moderator

Re: os authentication issue [message #524516 is a reply to message #524514]

Sat, 24 September 2011 09:08

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

Report message to a moderator