We help IT Professionals succeed at work.

RMAN

sikyala
sikyala asked
on
Medium Priority
755 Views
Last Modified: 2013-12-11
When I type rman Target sys/password@oracle_sid

I get the following error:

Recovery Manager: Release 9.2.0.1.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  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 service name


I don't know how to resolve this error. The listener and the database are running.
Comment
Watch Question

IS Operational Excellence Manager
Commented:
Assuming OS authentification is enabled, you just have to set your environment variable ORACLE_SID on the database server, then :
rman target /

If you wish to use Oracle Net authentification, or if you must connect from a remote client (not directly on the DB server), you have to edit the file TNSNAMES.ORA located in <ORACLE_HOME>/network/admin and configure host, port and service to reach.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
sikyalaSenior Database Administrator

Author

Commented:
You are right the problem was I didn't have a tnsnames.ora file. Once I created it and put an entry for the database in it. RMAN worked. Thank You!
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.