Chaning of Sys and System Password do not take affect
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Chaning of Sys and System Password do not take affect

Hybrid View

  1. #1
    Join Date
    Oct 2001
    Location
    New Jersey
    Posts
    20

    Question

    Hi,

    Can somebody explain to me why if I alter the sys or system passwords on Oracle 8.1.7 the original and new passwords both work when logging in using svrmgrl. I am issuing the following command as a sysdba user:

    alter user system identified by xxxx;

    alter user sys identified by xxxx;

    After channing the password, I can login as a system or sys using either the old or new password via svrmgrl.

    I have tried to re-created the PWDxxxx file, but this does not help. I have tried to removed the service by using oradim and re-creating the service with a new internal password, but this does not help.

    Any help would be appreciated.

    Mike



  2. #2
    Join Date
    Nov 2001
    Posts
    15

    Re:

    hi,

    i'm guessing you're on NT, but can you confirm this. also, what happens if you use a bogus password, does it still let you in? and do you have this problem using sqlplus? or only svrmgrl?

    nick

  3. #3
    Join Date
    Oct 2001
    Location
    New Jersey
    Posts
    20
    nratanasin,

    Yes, I am running NT. I justed tried a bogus password and that worked to. Any ideas?

    Mike

  4. #4
    Join Date
    Oct 2001
    Location
    New Jersey
    Posts
    20
    nratanasin,

    Sorry, I forgot to mention that if I used sqlplus only the new password works.

    Mike

  5. #5
    Join Date
    Jul 2000
    Posts
    521
    Does your NT user has a OS level authentication enabled ?
    svk

  6. #6
    Join Date
    Oct 2001
    Location
    New Jersey
    Posts
    20
    SVK,

    How would I determine if my user has os level authentication enabled ?

    Mike

  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Mike, could you post here your sqlnet.ora file. It is the key issue.

    The password file is meant for INTERNAL and SYS as SYSDBA.




  8. #8
    Join Date
    Oct 2001
    Location
    New Jersey
    Posts
    20
    Julian,

    The following is my sqlnet.ora file:

    # SQLNET.ORA Network Configuration File: C:\oracle\ora81\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)


    Mike

  9. #9
    Join Date
    Nov 2001
    Posts
    15

    Re:

    hey mike,

    well, here's a couple of notes. first of all, your os user is in the NT user group ORA_DBA. you can see this by running NT's User Manager (usrmgr.exe). being in this group allows a few things:

    1) when running svrmgrl or sqlplus, you can connect as INTERNAL and not get prompted for a password. if you remove yourself from the ORA_DBA group, you will get prompted for a password.

    2) when running svrmgrl, you can connect anyone as sysdba! and it doesn't matter what password you type in! try it. connect any user as sysdba and it will connect you without regards to the password you typed. then check to see who you are connected as with:

    SELECT username FROM user_users;

    and you will see that you are currently connected as SYS, no matter who you try to connect as.

    3) when running sqlplus, you can connect anyone as sysdba, but you must know the correct password! after being connected run:

    SELECT username FROM user_users;

    and you'll see that you are indeed connected as the correct user, but with sysdba privileges.


    so anyway, all this was just to say that your passwords were never really messed up, svrmgrl was just not authenticating your user by passwords. in fact, it was just connecting you as INTERNAL whenever you tried to connect as sysdba. and being in the ORA_DBA group allowed you to do this.

    sqlplus, on the other hand, doesn't try to connect you as INTERNAL whenever you connect as sysdba. but it does allow you to connect any user as sysdba, as long as the os user is in the ORA_DBA group. i personally never use svrmgrl. sqlplus has all of the same functionalities of svrmgrl; also svrmgrl is no longer existent in 9i (i think). and just a side note...if you want to run sqlplus without prompting you for a username (like svrmgrl does), just type 'sqlplus /nolog' at the command prompt.

    so anyway, i don't really have a resolution for all this. but, hopefully this helps with your understanding of the problem. please let me know if there is still something you would like to resolve with this issue.

    nick

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by mvanhouten
    Julian,

    The following is my sqlnet.ora file:

    # SQLNET.ORA Network Configuration File: C:\oracle\ora81\network\admin\sqlnet.ora
    # Generated by Oracle configuration tools.

    SQLNET.AUTHENTICATION_SERVICES= (NTS)

    NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)


    Mike
    Mike,

    Comment out SQLNET.AUTHENTICATION_SERVICES= (NTS) and tell me if you are being now able to log in with the old password.


Posting Permissions

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


Click Here to Expand Forum to Full Width