RMAN

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.
sikyalaSenior Database AdministratorAsked:
Who is Participating?
 
Pierrick LOUBIERIS Operational Excellence ManagerCommented:
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.
0
 
sikyalaSenior Database AdministratorAuthor 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!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.