OraFAQ Forum: Server Administration » Hi help me remote adminstration Problem=ORA-01031: insufficient privileges

Home » RDBMS Server » Server Administration » Hi help me remote adminstration Problem=ORA-01031: insufficient privileges

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

Hi help me remote adminstration Problem=ORA-01031: insufficient privileges [message #208436]

Sun, 10 December 2006 22:07

sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore

Member

Hi

I have a server which is at US,I have administate it from IND

here Problem is that i'm able to conn that server with database user name and password but if i'm trying with sys and password
ot system and password

iam getting error

SQL> conn system/manager1@us_orcl10g as sysdba
ERROR:
ORA-01031: insufficient privileges

Warning: You are no longer connected to ORACLE.
SQL> conn system/manager@us_orcl10g as sysdba
ERROR:
ORA-01031: insufficient privileges

Thanks in Advance
Sreenivaasrao

[Updated on: Sun, 10 December 2006 22:08]

Report message to a moderator

Re: Hi help me remote adminstration Problem=ORA-01031: insufficient privileges [message #208438 is a reply to message #208436]

Sun, 10 December 2006 22:12

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,

can you post ur sqlnet.authentication.services=?
NONE or NTS

regards
Taj

Report message to a moderator

Re: Hi help me remote adminstration Problem=ORA-01031: insufficient privileges [message #208439 is a reply to message #208436]

Sun, 10 December 2006 22:25

sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore

Member

Hi

Here my sqlnet.ora file

SQLNET.AUTHENTICATION_SERVICES = (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)

thanks in advance
Sreenivas

Report message to a moderator

Re: Hi help me remote adminstration Problem=ORA-01031: insufficient privileges [message #208441 is a reply to message #208439]

Sun, 10 December 2006 22:41

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi,

ur OS user member of ORA_DBA group. ? if not then add ur user in ORA_DBA group.

regards
Taj

Report message to a moderator

Re: Hi help me remote adminstration Problem=ORA-01031: insufficient privileges [message #208444 is a reply to message #208441]

Sun, 10 December 2006 23:01

sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore

Member

Hi

This is Not problem woth OS user i think,because iam trying to connect to remote mechine DB using connecting string

Note:OS user belongs ORA_DBA group

[Updated on: Sun, 10 December 2006 23:02]

Report message to a moderator