Solved

RMAN

Posted on 2006-10-23
2
738 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.
0
Comment
Question by:sikyala
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Accepted Solution

by:
Pierrick LOUBIER earned 500 total points
ID: 17796581
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
 

Author Comment

by:sikyala
ID: 17796610
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question