Home » RDBMS Server » Server Administration » insufficient privileges when trying to connect (oracle 9i, microsoft windows server 2003)
icon6.gif  insufficient privileges when trying to connect [message #340268] Tue, 12 August 2008 02:52 Go to next message
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
Re: insufficient privileges when trying to connect [message #340281 is a reply to message #340268] Tue, 12 August 2008 03:32 Go to previous messageGo to next message
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.
Re: insufficient privileges when trying to connect [message #340282 is a reply to message #340268] Tue, 12 August 2008 03:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which solution did you find and try that didn't work?

Regards
Michel
Re: insufficient privileges when trying to connect [message #340291 is a reply to message #340282] Tue, 12 August 2008 04:13 Go to previous messageGo to next message
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.
Re: insufficient privileges when trying to connect [message #340295 is a reply to message #340281] Tue, 12 August 2008 04:24 Go to previous messageGo to next message
tsuria
Messages: 8
Registered: August 2008
Junior Member
How do i set the ORACLE_HOME?

thanks, MTs
Re: insufficient privileges when trying to connect [message #340314 is a reply to message #340295] Tue, 12 August 2008 05:24 Go to previous messageGo to next message
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%

Re: insufficient privileges when trying to connect [message #340351 is a reply to message #340268] Tue, 12 August 2008 07:47 Go to previous messageGo to next message
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
icon14.gif  Re: insufficient privileges when trying to connect [message #342678 is a reply to message #340268] Sun, 24 August 2008 00:59 Go to previous messageGo to next message
tsuria
Messages: 8
Registered: August 2008
Junior Member
Thank you all.
Re: insufficient privileges when trying to connect [message #342937 is a reply to message #340268] Mon, 25 August 2008 10:34 Go to previous messageGo to next message
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 Go to previous message
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:
  


Current Time: Sat Dec 10 06:52:54 CST 2016

Total time taken to generate the page: 0.04576 seconds