RE: RMAN giving error ORA-19550

  • From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <Harvinder.Singh@xxxxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 14 Sep 2006 07:58:17 -0400



Are you running Rman on the database server itself?  If so, just set the
ORACLE_SID and connect without using the "@qa1" option.

Secondly, you can always set up a second entry in your tnsnames.ora file
for the database and make it a dedicated connection.  Then use that
connection for Rman.


rman target sys/abc@qa1_dedicated nocatalog



Qa1_dedicated =  



      (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxx)(PORT = 1521))



      (SID = qa1)





Good Luck!






This transmission may contain confidential, proprietary, or privileged 
information which is intended solely for use by the individual or entity to 
whom it is addressed.  If you are not the intended recipient, you are hereby 
notified that any disclosure, dissemination, copying or distribution of this 
transmission or its attachments is strictly prohibited.  In addition, 
unauthorized access to this transmission may violate federal or State law, 
including the Electronic Communications Privacy Act of 1985.  If you have 
received this transmission in error, please notify the sender immediately by 
return e-mail and delete the transmission and its attachments.


From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Harvinder Singh
Sent: Wednesday, September 13, 2006 5:47 PM
Subject: RMAN giving error ORA-19550




We are using Shared server and when  trying to do rman backup getting

ORA-19550: cannot use backup/restore functions while using dispatcher


I modified the tnsnames.ora to add the following clause:

(server = dedicated)


But now getting the error:

C:\backup\Personal\OracleScripts>rman target sys/abc@qa1 nocatalog

Recovery Manager: Release - Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: initialization of internal recovery manager package failed

RMAN-04005: error from target database:

ORA-12154: TNS:could not resolve the connect identifier specified


How to fix this issue?




Other related posts: