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?
11-30-2001, 03:04 PM
Then check to make sure that your environment is the same and you are connecting to the correct database instance.
11-30-2001, 03:51 PM
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.
11-30-2001, 04:07 PM
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).