Home » RDBMS Server » Backup & Recovery » rman configuration (oracle 9i -os ibm-aix 5.3)
rman configuration [message #525337] Sat, 01 October 2011 03:35 Go to next message
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
Re: rman configuration [message #525338 is a reply to message #525337] Sat, 01 October 2011 03:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68051
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post result of
env | sort
(remove from the output irrelevant variables like "color" and so on.)

Regards
Michel
Re: rman configuration [message #525339 is a reply to message #525337] Sat, 01 October 2011 03:45 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you need to set the environment variable ORACLE_SID
or
use a valid tns entry.
Re: rman configuration [message #525340 is a reply to message #525339] Sat, 01 October 2011 03:59 Go to previous messageGo to next message
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
Re: rman configuration [message #525354 is a reply to message #525340] Sat, 01 October 2011 10:04 Go to previous messageGo to next message
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#
Re: rman configuration [message #525358 is a reply to message #525340] Sat, 01 October 2011 10:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68051
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: rman configuration [message #525428 is a reply to message #525358] Mon, 03 October 2011 01:34 Go to previous message
sathish16787
Messages: 56
Registered: September 2011
Location: mumbai
Member
problem is resolved i have set ORACLE_SID value properly
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:
  


Current Time: Tue Dec 07 00:29:15 CST 2021