Printable View
hi all,
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
what is your environment? windows or unix ?
Thanks,
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?
Thanks,
no
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!!
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
G Luck
Also try:
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
Connected.
SQL>
I tried all thw ay but getting same error back. But the wierd matter is,
If i use any other tool then OEM or Putty like MS for Oracle i can connect with sys user name and password.
for remote_login =
remote_login_passwordfile='EXCLUSIVE'
Please help!!
Thanks
Pat