connecting EXTERNALLY from your local
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: connecting EXTERNALLY from your local

  1. #1
    Join Date
    Jun 2001
    Posts
    243
    how can you connect sql*plus from your local PC if your password is set EXTERNALLY?...they prompt me for the password when I try to use sql*plus from my local PC...
    what should I do?


  2. #2
    Join Date
    Oct 2001
    Posts
    122
    What OS you are using? you need to set ORACLE_SID, TNS_ADMIN and all other required registry parameters to
    use OS Authentication.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    identified externally means OS authetification, you have to logon with OS user who is also a database user who has been identified externally when he was added in the database, your PC user is probably not the right one

  4. #4
    Join Date
    Oct 2001
    Posts
    122
    adding to above...

    also, you need to check what is os_auth_suffix you are
    setting from init.ora. You should have a user in database
    which is 'your set os suffix'+windows username set as
    externally.

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