-
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
-
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
-
It still requires a password. I'm using the task scheduler to invoke this batch file.
-
Use OS Authentication. Search these forums for details on how to set it up if interested...
-
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.