OraFAQ Forum: Server Administration » insufficient privileges when trying to connect

Home » RDBMS Server » Server Administration » insufficient privileges when trying to connect (oracle 9i, microsoft windows server 2003)

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

insufficient privileges when trying to connect [message #340268]

Tue, 12 August 2008 02:52

tsuria
Messages: 8
Registered: August 2008

Junior Member

Hello all.

I'm pretty new in Oracle.
I'm trying to connect as sysdba via sqlPlus.
I wrote those lines in the COMMAND LINE:

C:\>sqlplus /nolog
SQL> connect / as sysdba

and that's what i get:

ERROR:
ORA-01031: insufficient privileges

i tried to google it but i can't find the appropriate solution.
What the problem is?

Thanks, MTs

Report message to a moderator

Re: insufficient privileges when trying to connect [message #340281 is a reply to message #340268]

Tue, 12 August 2008 03:32

ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai

Senior Member

This is what i think----
Try to set ORACLE_HOME and ORACLES_SID on command prompt before starting to connect.

Report message to a moderator

Re: insufficient privileges when trying to connect [message #340282 is a reply to message #340268]

Tue, 12 August 2008 03:32

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

Senior Member
Account Moderator

Which solution did you find and try that didn't work?

Regards
Michel

Report message to a moderator

Re: insufficient privileges when trying to connect [message #340291 is a reply to message #340282]

Tue, 12 August 2008 04:13

tsuria
Messages: 8
Registered: August 2008

Junior Member

i find this command: net localgroup ora_dba user /add
this command added you in the sysdba group.

i tried to do that but i receive this message:
The specified account name is already a member of the local group.

Report message to a moderator

Re: insufficient privileges when trying to connect [message #340295 is a reply to message #340281]

Tue, 12 August 2008 04:24

tsuria
Messages: 8
Registered: August 2008

Junior Member

How do i set the ORACLE_HOME?

thanks, MTs

Report message to a moderator

Re: insufficient privileges when trying to connect [message #340314 is a reply to message #340295]

Tue, 12 August 2008 05:24

magic
Messages: 5
Registered: July 2007
Location: Slovakia

Junior Member

may be this way

cmd
C:\>set ORACLE_HOME=<path to oracle>
C:\>sqlplus ....

or you can check it before you set it:

C:\echo %ORACLE_HOME%

Report message to a moderator

Re: insufficient privileges when trying to connect [message #340351 is a reply to message #340268]

Tue, 12 August 2008 07:47

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

Senior Member

Instead of google just search on this forums you will get complete solution for this with reason.

www.orafaq.com "search word" ORA-01031

Report message to a moderator

Re: insufficient privileges when trying to connect [message #342678 is a reply to message #340268]

Sun, 24 August 2008 00:59

tsuria
Messages: 8
Registered: August 2008

Junior Member

Thank you all.

Report message to a moderator

Re: insufficient privileges when trying to connect [message #342937 is a reply to message #340268]

Mon, 25 August 2008 10:34

ramyaselvi16
Messages: 14
Registered: April 2008
Location: Chennai

Junior Member

Hi friend,

pls try this procedure ,

c:\sqlplus /nolog

sql>connect internal

sql> startup

sql> connect system/password as sysdba

after tried this send me feedback

thanks

[Updated on: Mon, 25 August 2008 10:35]

Report message to a moderator

Re: insufficient privileges when trying to connect [message #342942 is a reply to message #342937]

Mon, 25 August 2008 10:39

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

Senior Member

Quote:

oracle 9i, microsoft windows server 2003

I think your solution will not work becuase Database Version is 9i.

SQL> select * from v$version where rownum=1;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production

SQL> connect internal;
Enter password:
ERROR:
ORA-09275: CONNECT INTERNAL is not a valid DBA connection

[Updated on: Mon, 25 August 2008 10:40]

Report message to a moderator

Previous Topic:	ORA-00600
Next Topic:	killed session still in v$session but not in v$process

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 22:22:47 CST 2024