Re: Connection issues // .blocked.00d5c

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 21 Jan 2009 19:30:12 -0600
Message-ID: <ad3aa4c90901211730y3c75da5cha137367722e0c0c9_at_mail.gmail.com>

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_at_vanzanen.com> 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>_at_DB1 as
> sysoper" _at_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>_at_DB1 as sysoper"
> _at_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_at_vanzanen.com>
> >
> > 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 21 2009 - 19:30:12 CST