Home » RDBMS Server » Server Administration » Hi help me remote adminstration Problem=ORA-01031: insufficient privileges
Hi help me remote adminstration Problem=ORA-01031: insufficient privileges [message #208436] Sun, 10 December 2006 22:07 Go to next message
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
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

Re: Hi help me remote adminstration Problem=ORA-01031: insufficient privileges [message #208531 is a reply to message #208444] Mon, 11 December 2006 04:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
make sure you have ORACLE_SID defined in your environment.
Re: Hi help me remote adminstration Problem=ORA-01031: insufficient privileges [message #208732 is a reply to message #208436] Tue, 12 December 2006 00:28 Go to previous message
sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore
Member

Hi

Thanking you


But Iam able to connect as other then "sys,system as sysdba"

example:if say sree/sree@us_orcl i'm able to connect DB
Previous Topic: Ora-29532 java.lang.OutOfMemory
Next Topic: Object type, please help....
Goto Forum:
  


Current Time: Sat Dec 03 08:00:26 CST 2016

Total time taken to generate the page: 0.08601 seconds