Home » RDBMS Server » Backup & Recovery » RMAN connection (Oracle 11.2.0.3, linux)
RMAN connection [message #626084] Mon, 20 October 2014 08:30 Go to next message
patdev
Messages: 56
Registered: August 2008
Member
hi,

I have problem connecting to RMAN. I have database on Linux server. howerver when i log in to database serer and do rman target/
it works just fine.

RMAN-04005: error from target database:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

but when i try to do backup through backup chron job and do rman target user/pw@database it give me

But,., I can connect to database from everywhere.

what is the reason?

thanks
Re: RMAN connection [message #626085 is a reply to message #626084] Mon, 20 October 2014 08:34 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ The database is not started
2/ Your tnsnames.ora entry does not specify option UR=A
(3/ you are trying to connect to the correct database)

What is the current state of your database (DOWN, DISMOUNTED, MOUNTED, OPEN)?
What is the tnsnames.ora entry?

Re: RMAN connection [message #626086 is a reply to message #626084] Mon, 20 October 2014 08:46 Go to previous messageGo to next message
EdStevens
Messages: 981
Registered: September 2013
Senior Member
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor


see: http://edstevensdba.wordpress.com/2011/03/19/ora-12514/ (ora-12514 Listener does not know of requested service )
Re: RMAN connection [message #626088 is a reply to message #626086] Mon, 20 October 2014 09:01 Go to previous messageGo to next message
BlackSwan
Messages: 26194
Registered: January 2009
Location: SoCal
Senior Member
>what is the reason?

Problem Exists Between Keyboard And Chair.
Re: RMAN connection [message #627627 is a reply to message #626088] Thu, 13 November 2014 08:03 Go to previous messageGo to next message
sadock
Messages: 1
Registered: November 2014
Junior Member
tnsping database (alias) and see if it can resolve
Re: RMAN connection [message #627631 is a reply to message #627627] Thu, 13 November 2014 09:12 Go to previous message
EdStevens
Messages: 981
Registered: September 2013
Senior Member
Sadock -

First, the OP hasn't responded to a single reply since his initial post nearly a month ago. It appears he has abandoned the thread.

Second, you suggestion to try tnsping is a red herring. tnsping only checks that there is a listener at the specified location. Nothing more. It says nothing at all about what the listener knows or that state of any database at that location. And there is obviously a listener at that location, as the listener itself is reporting back that it doesn't know of the requested service.

see: tnsping-101
see: ora-12514 Listener does not know of requested service


Previous Topic: RMAN-06004,ORA-04061:, ORA-04065:, ORA-06508
Next Topic: Block corruption found during rman
Goto Forum:
  


Current Time: Fri Oct 19 02:46:19 CDT 2018