OraFAQ Forum: Backup & Recovery » rman configuration

Home » RDBMS Server » Backup & Recovery » rman configuration (oracle 9i -os ibm-aix 5.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

rman configuration [message #525337]

Sat, 01 October 2011 03:35

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

i am trying to configure rman for newly created database .when i entered

rman target /

it is throwing following error

[/u01/app/oracle/product]rman target /

Recovery Manager: Release 9.2.0.8.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-12162: TNS:service name is incorrectly specified

Report message to a moderator

Re: rman configuration [message #525338 is a reply to message #525337]

Sat, 01 October 2011 03:44

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post result of
env | sort
(remove from the output irrelevant variables like "color" and so on.)

Regards
Michel

Report message to a moderator

Re: rman configuration [message #525339 is a reply to message #525337]

Sat, 01 October 2011 03:45

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you need to set the environment variable ORACLE_SID
or
use a valid tns entry.

Report message to a moderator

Re: rman configuration [message #525340 is a reply to message #525339]

Sat, 01 October 2011 03:59

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

to o/p of env | sort

AUTHSTATE=compat
A__z=! LOGNAME
HOME=/home/oracle
LANG=en_US
LC__FASTMSG=true
LIBPATH=/u01/app/oracle/product/lib32:/u01/app/oracle/product/lib:/usr/lib:/lib
LOCPATH=/usr/lib/nls/loc
LOGIN=oracle
LOGNAME=oracle
MAIL=/usr/spool/mail/oracle
MAILMSG=[YOU HAVE NEW MAIL]
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
ODMDIR=/etc/objrepos
ORACLE_HOME=/u01/app/oracle/product
ORACLE_SID=TEST
PATH=/u01/app/oracle/product/bin:/usr/ccs/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/oracle/bin:/usr/bin/X11:/sbin:.
PWD=/u01/app/oracle/product
SHELL=/usr/bin/ksh
SSH_CLIENT=172.1.15.210 4687 22
SSH_CONNECTION=172.1.15.210 4687 172.1.17.43 22
SSH_TTY=/dev/pts/0
TERM=xterm
TZ=CST6CDT
USER=oracle
_=/usr/bin/env

Report message to a moderator

Re: rman configuration [message #525354 is a reply to message #525340]

Sat, 01 October 2011 10:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>[/u01/app/oracle/product]rman target /
>ORA-12162: TNS:service name is incorrectly specified

connecting to local DB should NEVER throw TNS related error.
Above indicates a serious mis-configuration exists at OS/Networking level.
Root cause has nothing to do with Oracle.
Oracle is victim; not culprit

issue following OS commands

uname -a
cat /etc/hosts

COPY commands above & the results then PASTE all back here

can you successfully ping both hostname & host's IP#

Report message to a moderator

Re: rman configuration [message #525358 is a reply to message #525340]

Sat, 01 October 2011 10:17

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The environment varriables you posted and the error you mentioned are not compatible.

Execute both commands in the same shell and post the result:
env | sort
rman target /
Copy and paste the whole shell session INCLUDING the command lines.

Regards
Michel

Report message to a moderator

Re: rman configuration [message #525428 is a reply to message #525358]

Mon, 03 October 2011 01:34

sathish16787
Messages: 56
Registered: September 2011
Location: mumbai

Member

problem is resolved i have set ORACLE_SID value properly

Report message to a moderator

Previous Topic:	Making a copy of existing Source tables for BI Reporting
Next Topic:	RMAN-00554: initialization of internal recovery manager package failed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 15:51:52 CST 2024