OraFAQ Forum: Backup & Recovery » RMAN-04004: error fro recovery catalog database

Home » RDBMS Server » Backup & Recovery » RMAN-04004: error fro recovery catalog database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RMAN-04004: error fro recovery catalog database [message #136201]

Tue, 06 September 2005 12:53

elimunoz
Messages: 7
Registered: September 2005
Location: Ecuador

Junior Member

Hi, i have a problem, i am configure the RMAN, i have Oracle 9i in Red hat advanced server.

RMAN> CONNECT CATALOG rman/cat@catdb
i receive the following message:
RMAN-00571:=================================================
RMAN-00569:=========ERROR MESSAGE STACK FOLLOWS=============
RMAN-00571:=================================================
RMAN-04004: error from recovery catalog database: ORA-12154: TNS: could not resolve service name

I don`t know what is the problem.
help me please.
Thanks.

Report message to a moderator

Re: RMAN-04004: error fro recovery catalog database [message #136204 is a reply to message #136201]

Tue, 06 September 2005 13:17

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>rman/cat@catdb
does the catdb service string works?
can you connect the same with sqlplus?
can you tnsping?
Check for the availability of the listener.

Report message to a moderator

Re: RMAN-04004: error fro recovery catalog database [message #136230 is a reply to message #136204]

Tue, 06 September 2005 16:29

elimunoz
Messages: 7
Registered: September 2005
Location: Ecuador

Junior Member

I have response with tnsping.

How i do the catdb service string works?
And how check for the availability of the listener??

Report message to a moderator

Re: RMAN-04004: error fro recovery catalog database [message #136232 is a reply to message #136230]

Tue, 06 September 2005 17:47

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

tnsping checks for the availablity of the listener. Not the database.
try a simple sqlplus connection ( from the machine where you invoke rman).
sqlplus rman/cat@catdb

Report message to a moderator

Re: RMAN-04004: error fro recovery catalog database [message #136321 is a reply to message #136232]

Wed, 07 September 2005 09:04

elimunoz
Messages: 7
Registered: September 2005
Location: Ecuador

Junior Member

I try to connect with the sql but not is posible.
O don´t know why?
I`m trying to configure the RMAN in my server oracle.

Report message to a moderator

Re: RMAN-04004: error fro recovery catalog database [message #136323 is a reply to message #136321]

Wed, 07 September 2005 09:12

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You cannot do an sqlplus session,simlarly RMAN cannot do the backup.
Seems your RMANDB listener has some problem.
1. Did you create the listener for catdB?
Is the listener up and available?
2. DId you create proper tnsentries in tnsnames.ora to talk to catdb?
3. search this forum / google for ORA-12154
You would get a million hits.

Report message to a moderator

Re: RMAN-04004: error from recovery catalog database [message #637214 is a reply to message #136201]

Wed, 13 May 2015 02:13

Elí Venture
Messages: 1
Registered: May 2015
Location: México

Junior Member

Thank you very much Mahesh Rajendran
Your recommendatoins helped me alot .
Greetings.

Report message to a moderator

Re: RMAN-04004: error fro recovery catalog database [message #637240 is a reply to message #136201]

Wed, 13 May 2015 07:41

EdStevens
Messages: 1375
Registered: September 2013

Senior Member

elimunoz wrote on Tue, 06 September 2005 12:53

RMAN-04004: error from recovery catalog database: ORA-12154: TNS: could not resolve service name

I don`t know what is the problem.
help me please.
Thanks.

see: http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/ (ora-12154 TNS:could not resolve the connect identifier specified)

Report message to a moderator

Re: RMAN-04004: error fro recovery catalog database [message #637241 is a reply to message #136204]

Wed, 13 May 2015 07:43

EdStevens
Messages: 1375
Registered: September 2013

Senior Member

[quote title=Mahesh Rajendran wrote on Tue, 06 September 2005 13:17]>>rman/cat@catdb
does the catdb service string works?[/quote}

What does that mean, "does the catdb service string works?"

Quote:

Check for the availability of the listener.

The listener has nothing to do with this. With the reported error, the request never left the client and never got anywhere near a listener.

Report message to a moderator

Re: RMAN-04004: error fro recovery catalog database [message #637242 is a reply to message #136230]

Wed, 13 May 2015 07:44

EdStevens
Messages: 1375
Registered: September 2013

Senior Member

elimunoz wrote on Tue, 06 September 2005 16:29

I have response with tnsping.

And if you had actually shown that response, you could get some more intelligent assistance.

Report message to a moderator

Re: RMAN-04004: error fro recovery catalog database [message #637244 is a reply to message #136321]

Wed, 13 May 2015 07:46

EdStevens
Messages: 1375
Registered: September 2013

Senior Member

elimunoz wrote on Wed, 07 September 2005 09:04

I try to connect with the sql but not is posible.
O don´t know why?

"but not is possible" is not an actionable message.
If you had shown the results of that attempt -- like your full sqlplus command and the full result -- people could actually address your problem.

Report message to a moderator

Re: RMAN-04004: error fro recovery catalog database [message #637245 is a reply to message #136323]

Wed, 13 May 2015 07:49

EdStevens
Messages: 1375
Registered: September 2013

Senior Member

Mahesh Rajendran wrote on Wed, 07 September 2005 0
9:12

You cannot do an sqlplus session,simlarly RMAN cannot do the backup.
Seems your RMANDB listener has some problem.

Listener has a problem? And on what do you base that assumption?
The reported error message means the request never got anywhere near a listener.
The beyond the reported error message, the OP has presented ZERO diagnostics.
So there is absolutely NOTHING to implicate the listener.

Report message to a moderator