DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Connect internal does not ask me password

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi,

    We are on Oracle 8.1.7/ NT 4.

    I recently migrated the database from 8.0.5 to 8.1.7.1.3.

    In that process, I dropped the old Oracle service with
    oradim80 -delete -sid command

    and recreated new Oracle service with
    oradim -new -sid -intpwd ... command.

    I gave password for -intpwd parameter. But now, when I connect to internal. It does not ask me any password and successfully connects.

    How do I make to ask me password which I gave in oradim command?

    Thanks in Adv.

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Wink


    are you connecting remotely or serverside?
    I believe serverside does not ask for a password.

  3. #3
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi jgmagnus,

    It was asking password on server side prior to upgrade.

    On other instance which is still 805, it asks me the password when I say connect internal.

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  4. #4
    Join Date
    Mar 2001
    Posts
    635
    Hi


    Because during the Installation or Oracle 8i on Windows it creates a group on your windows Operating system called as

    ora_dba

    The Os user must be a part of this group that is the reason it is not asking you for the Internal password

    Regards
    Santosh

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


    How do I make to ask me password which I gave in oradim command?

    Thanks in Adv.

    I suggest you comment out the line SQLNET_AUTHENTICATION_SERVICES in your sqlnet.ora file. Then you will be asked for password.


  6. #6
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    Thumbs up

    Hi Santosh,

    it has not created any new group such as ora_dba on our windows Operating system.

    Hi Julian,

    That did the trick. I commented it out and now its asking me the password.

    Thanks alot to both of you.

    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

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

    Hi Julian,

    That did the trick. I commented it out and now its asking me the password.

    Thanks alot to both of you.

    You are welcome. That is one silly feature of Oracle...

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