weird problem with invalid username/password

[lgaorcl]

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

[sambavan]

Then check to make sure that your environment is the same and you are connecting to the correct database instance.


Sam

[Mr.Hanky]

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

[lgaorcl]

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