Am Montag, den 18.04.2005, 14:46 -0500 schrieb jungwolf: > On 4/17/05, Justis Durkee <justisd@(protected)> wrote: > > I ran into this very same problem just the other day. > > > > In order to connect to the nomount aux db, you have to set up a static > > service for the listener in listener.ora. > > > > SID_LIST_LISTENER = > > (SID_DESC= > > (global_dbname=...) > > (sid_name=standy_sid) > > (oracle_home=...) > > ) > > ) > > > > Then reload the listener configuration, lsnrctl reload. > > Maurice, please let us know if this fixes the problem. It should > because, if I remember correctly, dynamic registration with the > listener doesn't happen until the database is mounted. That's > probably not the right terminology. The effect is, the listener > doesn't pass connections to an instance using dynamic registration > until the instance is in mount state. > > So, since duplicating a database with rman requires the auxiliary to > be nomount, you're stuck with either running rman from the auxiliary > server (and using a local connection) or putting a static entry in > listener.ora as Justis suggests.
I was not able to test it till now but i will try it the next days and give feedback to this list.
> As you said: > >rman target / catalog rman/rman@(protected) auxiliary sys/PASSWORD@(protected) > >makes the problem. Setting the ORACLE_SID to STANDBY( alias in the > >tnsnames) and using > >rman target / catalog rman/rman@(protected) auxiliary sys/password > >works for the connection ! RMAN says: > > The first doesn't work because rman is trying to go through the > listener, and the second does work because it is bypassing the > listener with a local connection.
Yes, that's the problem.
Th@(protected) to all trying to help me, i will give you some feedback asap.
-- To unsubscribe, email: suse-oracle-unsubscribe@(protected) For additional commands, email: suse-oracle-help@(protected) Please see http://www.suse.com/oracle/ before posting
