RMAN and dynamic listener [message #110921] |
Fri, 11 March 2005 02:08 |
Uwe
Messages: 260 Registered: February 2003 Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi all,
I found out the the RMAN in 9i is not workable if I use dynamic listener method in listener.ora.
Has anyone figured out if there is a way to use dynamic listener with RMAN at RESTORE?
Backup seems to be possible, but restore break if auxilliary database is not in static listening.
any hints welcome, I will post this the next days at metalink to clearify with oracle.
thanks
Uwe
|
|
|
Re: RMAN and dynamic listener [message #110922 is a reply to message #110921] |
Fri, 11 March 2005 02:33 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
Are you referring to a dynamic listener as a listener that uses Dynamic Service Registration (where PMON registers with the listener, no SID_LIST_listener_name in listener.ora)?
If so, try to start the instance and force registration before the restore:
SQL> ALTER SYSTEM REGISTER;
System altered.
Best regards.
Frank
|
|
|
Re: RMAN and dynamic listener [message #112138 is a reply to message #110922] |
Wed, 23 March 2005 04:03 |
Uwe
Messages: 260 Registered: February 2003 Location: Zürich, Switzerland
|
Senior Member |
|
|
Hello Frank,
I just tried your suggestion to register the database via sqlplus.
the listener shows :
Instance "AMRFREZ", status BLOCKED, has 1 handler(s) for this service...
But if I start RMAN I got the following problems. So RMAN is not workable with the dynamic listener and needs the static one.
The DB is blocked, because to restore/recover with RMAN the database needs to be nomount.
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN>
connected to target database: AMRPROD (DBID=3497542973)
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04006: error from auxiliary database: ORA-12519: TNS:no appropriate service
handler found
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22
> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42
> 43> 44>
executing command: SET until clause
using target database controlfile instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 03/23/2005 09:51:56
RMAN-06174: not connected to auxiliary database
RMAN>
Recovery Manager complete.
Restore done
I will open up a tar on Metalink to get this clarified. I think this two strategies are blocking technologies.
kind regs
Uwe
|
|
|
Re: RMAN and dynamic listener [message #112140 is a reply to message #112138] |
Wed, 23 March 2005 04:34 |
Frank Naude
Messages: 4580 Registered: April 1998
|
Senior Member |
|
|
Hi,
Can you connect to the Clone DB using SQL*Plus? If you cannot, then RMAN wouldn't have a chance either. To test, try:
sqlplus "sys/password@clonedb as sysdba"
If you cannot, try to define a static listener as well to see if it solves the problem. If a static listener solves the problem, you've proved that dynamic service registration indeed doesn't work and you can send a test case to Oracle Support so they can log it as a BUG.
Best regards.
Frank
|
|
|
Re: RMAN and dynamic listener [message #112142 is a reply to message #112140] |
Wed, 23 March 2005 04:40 |
Uwe
Messages: 260 Registered: February 2003 Location: Zürich, Switzerland
|
Senior Member |
|
|
I havn't tried this, but I will try in some hours. We do need the recovery now for testing our library. it will run aound 5 hrs.
After this i will test if I could connect via sqlplus - but i guess it will work. We've registerd the DB's via Oracle Names Services.
I have send the question parallel to Oracle via Metalink. Maybe they identify a problem with this.
regards
Uwe
|
|
|
Re: RMAN and dynamic listener [message #115389 is a reply to message #112142] |
Mon, 11 April 2005 02:57 |
Uwe
Messages: 260 Registered: February 2003 Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi Frank,
I guess the oproblem is that the state of the listener is BLOCKED.
I tried with a new Database to clone, but if I try to connect I got ORA-12519
12519, 00000, "TNS:no appropriate service handler found"
// *Cause: The listener could not find any available service handlers that
// are appropriate for the client connection.
// *Action: Run "lsnrctl services" to ensure that the instance(s) have
// registered with the listener, and are accepting connections.
I will raise a call to determine that Oracle does not work that way. Maybe they're not realy aware of this feature *smile*
Uwe
|
|
|