Home » RDBMS Server » Server Administration » SYSDBA
SYSDBA [message #234168] Mon, 30 April 2007 04:54 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
hi,
i loged in to a server as admin user (ORA_DBA group in windows).When i tried to connect using Connect "/ as SYSDBA" ,i get error insufficient privilleges.What could be the reason here ?Does it mean SYS dont have SYSDBA prililege ?
Re: SYSDBA [message #234182 is a reply to message #234168] Mon, 30 April 2007 05:41 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Have you modified sqlnet.ora SQLNET.AUTHENTICATION_SERVICES = (NTS)
Re: SYSDBA [message #234410 is a reply to message #234182] Tue, 01 May 2007 09:26 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
yes, its SQLNET.AUTHENTICATION_SERVICES= (NTS)
Re: SYSDBA [message #234552 is a reply to message #234410] Wed, 02 May 2007 02:04 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Have you checked that sys have been granted the sysdba role ?

dwadm@DW.US.ORACLE.COM> select * from v$pwfile_users;

USERNAME                       SYSDBA SYSOPER
------------------------------ ------ -------
SYS                            TRUE   TRUE

[Updated on: Wed, 02 May 2007 02:27]

Report message to a moderator

Re: SYSDBA [message #234565 is a reply to message #234168] Wed, 02 May 2007 09:36 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Yes, SYS shows ,has SYSDBA prvilege.
Stil not sure whts wrong here Embarassed
Re: SYSDBA [message #234569 is a reply to message #234168] Wed, 02 May 2007 09:42 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
re-iterating...

my OS user is under ORA_DBA group in windows
SYS is granted SYSDBA, i can connect as sys/welcome as SYSDBA
SQLNET.AUTHENTICATION_SERVICES= (NTS)

a question.Does password file has any role to play here ?
Re: SYSDBA [message #234573 is a reply to message #234168] Wed, 02 May 2007 10:03 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>a question.Does password file has any role to play here ?
IMO, no it does not.

If you are desperate, you could try
SQLNET.AUTHENTICATION_SERVICES= (NONE)

Previous Topic: UTL_FILE error
Next Topic: ORA-03113
Goto Forum:
  


Current Time: Thu Dec 08 06:22:00 CST 2016

Total time taken to generate the page: 0.15051 seconds