Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Unhappy Unanswered: cannot connect as sysdba

    Hello,

    Every time I try to connect to the oracle database ver 9 as sysdba(or any user) I get ORA-01031: insufficient privileges. The only way I can get the SQL promt is to 'sqlplus /nolog' but then when I try to connect I get the same error.

    I am running oracle 9 on a solaris 9 box

    We have recently changed the pam modules in solaris to allow the OS to authenticate from a LDAP server I have tried changing them back but this doesn't seem to affected it at all!

    has anyone got any suggestions?

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    Hi,

    I've had the same problems. Seems like the errormessage is a bit confusing. I've noticed you get the error message after connecting as sysdba with the wrong password.
    Verify the password, otherwise recreate the password file using ORAPWD or check the init.ora for the remote_login_passwordfile parameter (but i don't think your problem is in the parameter).

    Hope this helps
    Edwin van Hattem
    OCP DBA / System analyst

  3. #3
    Join Date
    Sep 2003
    Posts
    4
    How would I go about recreating the password file?

  4. #4
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    on the shell prompt execute orapwd.exe
    this gives you help about the program

    Usage: orapwd file=<fname> password=<password> entries=<users>

    file= the complete path to the directorie the passwordfileshould be created including the name of the passwordfile itself.
    password= the new password for the DBA and DBOPER users
    entries = the maximum number of distinct DBA and opers (this one is optional)

    It would be like this:
    orapwd \u1\oracle_home\database\PWDdatabasename.ora 10

    Hope this helps
    Edwin van Hattem
    OCP DBA / System analyst

  5. #5
    Join Date
    Sep 2003
    Posts
    4
    tried replacing the password file but I still get ORA-01031: insufficient privileges

    thanks for the help anyway

  6. #6
    Join Date
    Sep 2003
    Location
    The Netherlands
    Posts
    311
    hi,

    what name did u use for the password file?
    Make sure it is PWD<sidname>.ora.
    Also check to see what password file is used by checking the value of ORA_<SID>_PWFILE environment parameter (I'm not sure about this on solaris, it's what oracle recommends for windows).

    Also be sure to log on to the solaris box as a member of the ORADBA group.

    Are u connecting to the database on the box itself or remotely?
    Edwin van Hattem
    OCP DBA / System analyst

  7. #7
    Join Date
    Sep 2003
    Posts
    4
    Thanks for all of your help but I have found the problem it appears to be the ldapclientinst command that we used to add it to the LDAP directory as I have uninstalled it and everything works as it should. Not a great solution but its a start!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •