Re: ora 1033 logging on to standby

A few questions

1.) Is it a RAC database? RAC dbs often have config env variables set to tell it where to find the TNSNAMES.ORA (TNS_ADMIN variable) - make sure that its set correctly if its RAC
srvctl getenv database -d <db name>

2.) Make sure sqlplus from primary to standby works using "sys_at_dbname as sysdba"

3.) Make sure md5sum reports the same value for the password file on both primary and standby

4.) Make sure sqlnet.ora files are the same on both primary & standby as far as encryption requirements

Chris

On Fri, Sep 17, 2021 at 8:30 AM Howard Latham <howard.latham_at_gmail.com> wrote:

> oracle 19.11
> redhat 7.9
>
> We've had this problem many times and usually its something to do with the
> password file. We know that is ok because we can connect to the the
> databases using /_at_dbname
>
> Anyone got any good ideas on solving this?
>
> Best Wishes
>
> Howard A. Latham
>
>
>

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