RE: RMAN giving error ORA-19550

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 14 Sep 2006 07:58:17 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF681618@EXCNYSM0A1AJ.nysemail.nyenet>

Harvinder,

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_at_qa1_dedicated nocatalog

Qa1_dedicated =

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

)

(CONNECT_DATA =
(SID = qa1)

(SERVER = DEDICATED)
)

)

Good Luck!

Tom

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Harvinder Singh Sent: Wednesday, September 13, 2006 5:47 PM To: ORACLE-L
Subject: RMAN giving error ORA-19550

Hi,

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

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_at_qa1 nocatalog

Recovery Manager: Release 10.1.0.3.0 - Production

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?

Thanks

--Harvinder

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

Received on Thu Sep 14 2006 - 06:58:17 CDT