I am trying to connect Oracle10 database but when i am trying to connect with sys log init gives me problem for insufficient previleges.
sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Oct 8 08:53:31 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn as sysdba
Enter user-name: sys
Enter password:
ERROR:
ORA-01031: insufficient privileges
what should i do?
please guide!!
thanks
Pat
10-08-2008, 10:37 AM
vnktummala
what is your environment? windows or unix ?
Thanks,
10-08-2008, 10:38 AM
midora
it's on unix(sun solaris)
10-08-2008, 10:44 AM
PAVB
Shall we understand you were able to connect that way in the past?
Do you have remote authentication enabled?
Are you using the oracle account to log into the Unix box?
Have you set your environmental variables properly?
10-08-2008, 02:35 PM
midora
yes they are all fine and the instnace comes back perfectly fine. but when i try to connect with sys id i get the errot ther previleges...
10-08-2008, 02:39 PM
vnktummala
are you using oracle id to connect unix box?
Thanks,
10-09-2008, 08:58 AM
midora
no
10-09-2008, 09:00 AM
davey23uk
you need to use an Id thats in the correct group on the server (usually dba)
10-09-2008, 09:02 AM
midora
I am connecting with unix id which is in dba group on the server!!
10-17-2008, 02:17 AM
dmdunyan
try this
Please try:
sqlplus / as sysdba
If that doesn't work (it should on unix, if your userid is a member of the 'dba' group) please let us know the setting of remote_login_passwordfile