DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Batch file - system/password

  1. #1
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    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




  2. #2
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    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
    KN

  3. #3
    Join Date
    Oct 2001
    Location
    Hornchurch, Essex UK
    Posts
    132
    It still requires a password. I'm using the task scheduler to invoke this batch file.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Use OS Authentication. Search these forums for details on how to set it up if interested...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width