problem with sys log in
I am trying to connect Oracle10 database but when i am trying to connect with sys log init gives me problem for insufficient previleges.
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
ORA-01031: insufficient privileges
what should i do?
what is your environment? windows or unix ?
it's on unix(sun solaris)
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?
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...
are you using oracle id to connect unix box?
you need to use an Id thats in the correct group on the server (usually dba)
I am connecting with unix id which is in dba group on the server!!
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