weird problem with invalid username/password
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: weird problem with invalid username/password

  1. #1
    Join Date
    Jun 2000
    Posts
    315
    I have been running a bat job on NT to do hot backup for one of my databases. It has been running fine. But today I got a invalid username/password error message after script invoke a sqlplus window. I use user system to log in. And the password never changed. I tried to log on using the same username/password to sqlplus manually. It was fine. What happend?

    Lisa

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Then check to make sure that your environment is the same and you are connecting to the correct database instance.


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    Another option is the ORACLE_SID could have changed if there are multiple instances on this box, are there.
    Try this from a command prompt
    SET ORACLE_SID=correct sid name

    Just typing SET and hitting enter willl display the current sid.

    MH

  4. #4
    Join Date
    Jun 2000
    Posts
    315
    Thanks for all your reply! I found out the problem was with '\', and '/'. NT is weird. Sometimes it is sensitive to / and \, but sometimes, it isn't. (I replaced all the / to \ in the script early this morning).

    Thanks again!

    Lisa

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