This is pretty much a shot in the dark, but you might try re-creating the password file. On Wed, Jan 21, 2009 at 7:15 PM, Jack van Zanen <jack@xxxxxxxxxxxx> wrote: > Some more information > > > The problem we are facing is as follows > > there is a offline backup and to accomadate this there is 3 steps > > 1. Bat file that shuts down oracle database > call C:\Oracle\Ora9i\BIN\sqlplus.exe "orabackup/<password>@DB1 as > sysoper" @C:\SQL\shutdown.sql > > 2. Some backup script outside our controld > > 3. Bat file that starts up oracle database > call C:\Oracle\Ora9i\BIN\sqlplus.exe > "orabackup/<same_password_as_above>@DB1 as sysoper" > @C:\SQL\startup.sql > > Now step 1 works fine as the database comes down. Step 2 works fine as > we have been informed that database files are copied. At step 3 the > logfile shows "ORA-01017: invalid username/password; logon denied" > > I tried connecting as sysdba but end up with ORA-12560 (protocol > adaptor error) and the only way to solve this is to restart the > service which autostarts the database. > > > > > Brgds > > Jack > > > > > > 2009/1/22 Jack van Zanen <jack@xxxxxxxxxxxx> > > > > Hi > > > > > > We have a script that has connection issues and one of the things we see > is that around the time it tries to connect we have several files with names > like ".blocked.00d5c" (last 5 characters change). > > > > This is oracle 9.2.0.5 on windows. > > > > This server was running out of space and was rebuild by doing a fresh OS > install after which a system backup was put over the top. > > NO fresh oracle install > > > > Brgds > > -- > > Jack van Zanen > > > > ------------------------- > > This e-mail and any attachments may contain confidential material for the > sole use of the intended recipient. If you are not the intended recipient, > please be aware that any disclosure, copying, distribution or use of this > e-mail or any attachment is prohibited. If you have received this e-mail in > error, please contact the sender and delete all copies. > > Thank you for your cooperation > > > > -- > Jack van Zanen > > ------------------------- > This e-mail and any attachments may contain confidential material for > the sole use of the intended recipient. If you are not the intended > recipient, please be aware that any disclosure, copying, distribution > or use of this e-mail or any attachment is prohibited. If you have > received this e-mail in error, please contact the sender and delete > all copies. > Thank you for your cooperation > -- > //www.freelists.org/webpage/oracle-l > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'