Results 1 to 11 of 11
  1. #1
    Join Date
    Feb 2004
    Location
    Houston, TX
    Posts
    10

    Unanswered: Enterprise Manage can't login as sysdba

    With a couple of databases (solaris 9.2.0.4) I can't log in as sysdba, I get an invalid username/password error. I can log into a dba account but not as sysdba. I have 20 other databases unix and windows (all 9.2.0.3 by the way) that I can log to as sysdba. Any ideas?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Any ideas?
    You are doing something wrong.
    What is different between those which work & those that fails?

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    my brilliant idea is that you have
    REMOTE_LOGIN_PASSWORDFILE set to NONE.

    Of it is set to exclusive then my other brilliant idea (note the sarcasm) is that you have not granted sysdba privs to whomever you are logging in as.

    Other than that I would say you have no passwordfile (ORAPWD) on those machines or something.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    Feb 2004
    Location
    Houston, TX
    Posts
    10
    I had the same idea. They were set to none I changed it to exclusive. Still can't log in. That's why I'm asking question.

    Differences. Only ones running 9.2.0.4 patch. Other than that just init.ora for warehouse compared to transactional systems (all the others).

    Any other ideas?

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You are sparse on details.
    Same OS user?
    Same/different system?
    Local/remote DBs?
    Compare & contrast.

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    did you create a password file for those servers before you bounced the databases?

    query v$pwfile_users to see who has sysdba privs. If it is blank then no one can connect remotely.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  7. #7
    Join Date
    Jan 2004
    Posts
    37
    in context of this may i ask you does scott have sysdba privs by default when you install oracle 9i????

  8. #8
    Join Date
    Feb 2004
    Location
    Houston, TX
    Posts
    10
    I won't be so cryptic.
    Login sys as sysdba does not work.
    I have a ORApwd file
    The results from
    Select * from v$pwfile_users is
    USERNAME SYSDB SYSOP
    SYS YES YES

    Looking at the advice given. I tried remote sysdba logins
    sqlplus /nolog
    connect sys@DB_ALIAS as sysdba

    I got the same error
    ERROR:
    ORA-01017: invalid username/password; logon denied

    This has nothing to do with Enterprise manager. Maybe the ORApwd is somehow corrupt or unusable on the two databases in question. I think I can focus on this to solve the problem. Thanks.

  9. #9
    Join Date
    Feb 2004
    Location
    Houston, TX
    Posts
    10
    Originally posted by chiranjib_s
    in context of this may i ask you does scott have sysdba privs by default when you install oracle 9i????
    No Scott is not sysdba

  10. #10
    Join Date
    Feb 2004
    Location
    Houston, TX
    Posts
    10
    I'm guessing my orapwd file is corrupt. I'm able to grant new users as sysdba, but sys doesn't work. The next time the db is down (very rarely) I'll recreate the orapwd files. I wonder if the upgrade from 9.2.0.3 to 9.2.0.4 is the culprit?

  11. #11
    Join Date
    Jul 2003
    Posts
    2,296
    I would bet some money it has to do with the password (possible corruption like you said). It is definitely checking the password and determining you have not entered it correctly.

    Why not log in to the host, connect /as sysdba, then change the sys password with an alter user command and see what happens?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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