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?
Then check to make sure that your environment is the same and you are connecting to the correct database instance.
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.
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).