Home » RDBMS Server » Backup & Recovery » RMAN-04004: error fro recovery catalog database
RMAN-04004: error fro recovery catalog database [message #136201] Tue, 06 September 2005 12:53 Go to next message
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.

Re: RMAN-04004: error fro recovery catalog database [message #136204 is a reply to message #136201] Tue, 06 September 2005 13:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: RMAN-04004: error fro recovery catalog database [message #136230 is a reply to message #136204] Tue, 06 September 2005 16:29 Go to previous messageGo to next message
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??

Re: RMAN-04004: error fro recovery catalog database [message #136232 is a reply to message #136230] Tue, 06 September 2005 17:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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
Re: RMAN-04004: error fro recovery catalog database [message #136321 is a reply to message #136232] Wed, 07 September 2005 09:04 Go to previous messageGo to next message
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.
Re: RMAN-04004: error fro recovery catalog database [message #136323 is a reply to message #136321] Wed, 07 September 2005 09:12 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: RMAN-04004: error from recovery catalog database [message #637214 is a reply to message #136201] Wed, 13 May 2015 02:13 Go to previous messageGo to next message
Elí Venture
Messages: 1
Registered: May 2015
Location: México
Junior Member
Thank you very much Mahesh Rajendran
Your recommendatoins helped me alot .
Greetings.
Re: RMAN-04004: error fro recovery catalog database [message #637240 is a reply to message #136201] Wed, 13 May 2015 07:41 Go to previous messageGo to next message
EdStevens
Messages: 1376
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)
Re: RMAN-04004: error fro recovery catalog database [message #637241 is a reply to message #136204] Wed, 13 May 2015 07:43 Go to previous messageGo to next message
EdStevens
Messages: 1376
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.
Re: RMAN-04004: error fro recovery catalog database [message #637242 is a reply to message #136230] Wed, 13 May 2015 07:44 Go to previous messageGo to next message
EdStevens
Messages: 1376
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.
Re: RMAN-04004: error fro recovery catalog database [message #637244 is a reply to message #136321] Wed, 13 May 2015 07:46 Go to previous messageGo to next message
EdStevens
Messages: 1376
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.
Re: RMAN-04004: error fro recovery catalog database [message #637245 is a reply to message #136323] Wed, 13 May 2015 07:49 Go to previous messageGo to next message
EdStevens
Messages: 1376
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.


Re: RMAN-04004: error fro recovery catalog database [message #637248 is a reply to message #637245] Wed, 13 May 2015 07:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
this thread is almost a DECADE old
Re: RMAN-04004: error fro recovery catalog database [message #637266 is a reply to message #637248] Wed, 13 May 2015 20:56 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
BlackSwan wrote on Wed, 13 May 2015 07:54
this thread is almost a DECADE old


Ouch! You are correct. When it popped up as "new" I failed to notice that what was "new" was just a "thank you".


Previous Topic: backup and restore tablespace
Next Topic: transport_tablespace
Goto Forum:
  


Current Time: Thu Mar 28 06:49:42 CDT 2024