Batch file - system/password

[joyce_ank]

I've got a batch file , scheduled to do a hot backup which reads:

echo on
cd\
sqlplus system/password@evolvliv @u:\oracle\backupscripts\evolvlivofshotbackup.sql 1>>v:\backup\bkup.log


I've just changed the system password. How can I run this batch file without including the password.

Thanks

[Knarayan]

i think you coud do somthing like this:
invoke sqlplus in the foll way so that it doesn't prompt for password:
sqlplus /nolog @u:\oracle\backupscripts\evolvlivofshotbackup.sql 1>>v:\backup\bkup.log


and in the script include the command:
connect username/pass

Hope this helps

[joyce_ank]

It still requires a password. I'm using the task scheduler to invoke this batch file.

[marist89]

Use OS Authentication. Search these forums for details on how to set it up if interested...

[Shestakov]

If u want use this command:

sqlplus /nolog @u:\oracle\backupscripts\evolvlivofshotbackup.sql 1>>v:\backup\bkup.log

U shouldn't use special symbols in password lile @$&...
I had this problem with password when i used $ symbol.
If u have there are symbols, u should change password.