Re: How to query Standby database ...

Anjan,

First off, the answer to your question is to make sure that REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE is set in the paramter file for your DB and that you have used orapwd to create a (current) password file with an appropriate password. Then login as internal/that_secret_password or as sys/your_sys_password and it should work fine.

Having just been through this, let me suggest STRONGLY that you abandon this line of attack. I had a Perl program that did exactly what you are trying to do and woke up every 15 minutes to erase logfiles. However -- and I'm not sure exactly how -- the database got updated before the actual log was finished and the program deleted the logfile, causing me a lot of grief since I didn't see it for some days and... well the story gets pretty ugly from that point on.

Now, I use a program (also Perl) that parses the alert log and deletes archive logs based on what is in the alert log. It has worked very, very nicely for the last month...

larry

On Thu, 25 Oct 2001 09:25:22 -0800620
"Anjan Thakuria" <anjan.thakuria_at_eds.com> wrote:

> Hi,
>
> We have a standby environment where due to application constraints we
> have to apply logs based on the application progress.
>
> However before I was made responsible the remote archiving was not
> enabled, and files were transferred through a script. Now to clear the
> archive dest I need to write a script to delete only the logs that have
> been backed up and applied. So here are my questions...
>
> 1. On the standby host I can get into the database -- sqlplus '/ as
> sysdba' . How can I get onto it remotely since I need to get in as
> somebody as SYSDBA. If I try
>
> sqlplus '"sys/password_at_connect_string as sysdba'" it still asks me for
> a password. What am I doing wrong.
>
>
> 2. This is an academic question. Am I correct in assuming that
> password changes done in the production is passed onto the standby
> database.
>
> 3. I try to logon to the standby database locally as follows
>
> sqlplus 'sys as sysdba' and get the following.. ORA-01033 Oracle
> initialization or shutdown in progress
>
>
> Any help will be greatly appreciated.
>
>
> Thanks
>
> Anjan
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Larry Strickland
  INET: stricklandl_at_voyager.spjc.cc.fl.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).