OraFAQ Forum: Backup & Recovery » RMAN ACCESS ERROR

Home » RDBMS Server » Backup & Recovery » RMAN ACCESS ERROR

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

RMAN ACCESS ERROR [message #240300]

Thu, 24 May 2007 10:15

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

I am facing a very strange problem. I have create a OS user with DBA rights. When I am invoking rman I am getting this error - ORACLE_HOME is not set properly. But for last 30 hours, I have done all experiments with environmnet variables. This is the command =>

$ rman

Message file RMAN<lang>.msb not found

Verify that ORACLE_HOME is set properly

This is the ENV setup.

$ env | grep ORA
ORACLE_SID=FCC2
ORACLE_HOME=/apps/oracle/ora10g_home

$ env | grep PATH
PATH=/apps/oracle/ora10g_home/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/patanad1/bin:/usr/bin/X11:/sbin:.
LOCPATH=/usr/lib/nls/loc
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
$

I will be obliged for a solutions for my everest problem.

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240302 is a reply to message #240300]

Thu, 24 May 2007 10:17

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

CAN YOU PASTE ALL ERRORS LOG??

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240304 is a reply to message #240302]

Thu, 24 May 2007 10:20

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

Thanks for your quick response.
where this error log can be found?

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240306 is a reply to message #240304]

Thu, 24 May 2007 10:23

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Did you check it through as user sys like?

rman target /

[Updated on: Thu, 24 May 2007 10:23]

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240307 is a reply to message #240306]

Thu, 24 May 2007 10:26

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

yeah, i have tried.

$rman target /

$rman target backup/backup@FCC2

but the same error.

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240313 is a reply to message #240300]

Thu, 24 May 2007 10:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

please post results from
$ env | sort

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240314 is a reply to message #240307]

Thu, 24 May 2007 10:43

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

hey check it

http://www.tiplib.com/95/unix-permissions-problem-under-oracle

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240315 is a reply to message #240307]

Thu, 24 May 2007 10:44

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

Senior Member
Account Moderator

In certain systems, there is *another* rman utility.

[mag@kalyani mag]$ which rman
/usr/X11R6/bin/rman

Remove this reference in your PATH.
Set your ORACLE_HOME.
set your PATH=$PATH:$ORACLE_HOME/bin.
logout and login.
try again.

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240316 is a reply to message #240313]

Thu, 24 May 2007 10:46

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

AUTHSTATE=files
A__z=! LOGNAME
HOME=/home/patanad1
LANG=C
LC__FASTMSG=true
LIBPATH=/apps/oracle/crs_home/jdk/jre/bin:/apps/oracle/crs_home/jdk/jre/bin/classic:/apps/oracle/crs_home/jdk/jre/bin:/apps/oracle/cr s_home/lib32:/apps/oracle/crs_home/srvm/lib32:/apps/oracle/ora10g_home/lib:/apps/oracle/crs_home/lib:/apps/oracle/ora10g_home/lib32:/ usr/lib
LOCPATH=/usr/lib/nls/loc
LOGIN=patanad1
LOGNAME=patanad1
MAIL=/usr/spool/mail/patanad1
MAILMSG=[YOU HAVE NEW MAIL]
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
ODMDIR=/etc/objrepos
ORACLE_BASE=/apps/oracle
ORACLE_HOME=/apps/oracle/ora10g_home
ORACLE_SID=FCC2
ORAENV_ASK=NO
ORA_CRS_HOME=/apps/oracle/crs_home
PATH=/apps/oracle/ora10g_home/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/patanad1/bin:/usr/bin/X11:/sbin:.:/usr/local/bin
PWD=/apps/oracle/ora10g_home
SHELL=/usr/bin/ksh
SSH_CLIENT=132.129.12.70 1249 22
SSH_CONNECTION=132.125.14.70 1249 192.168.192.21 22
SSH_TTY=/dev/pts/2
TERM=xterm
TZ=AST4
USER=patanad1
_=/usr/bin/env

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240319 is a reply to message #240315]

Thu, 24 May 2007 10:50

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

I checked in this directory.

There is no rman.

would you help further?

[Updated on: Thu, 24 May 2007 11:14]

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240329 is a reply to message #240314]

Thu, 24 May 2007 11:12

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

buddy, I again used that command.. chmod -R o=g $ORACLE_HOME.
But no luck.

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240330 is a reply to message #240300]

Thu, 24 May 2007 11:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>USER=patanad1
FWIW - I only invoke "rman" when logged on as user "oracle"; which owns the $ORACLE_HOME tree & it works for me.

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240334 is a reply to message #240330]

Thu, 24 May 2007 11:30

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

Yeah, Me too. But it is necessary to log into RMAN using the ORACLE userid?? I want that my operator will run the RMAN script in night. I dont want him to log in as ORACLE user.

You understand my plight.

patanad1 has dba and oinstall rights (AIX OS).

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240336 is a reply to message #240334]

Thu, 24 May 2007 11:31

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Can you connect with sqlplus??

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240341 is a reply to message #240300]

Thu, 24 May 2007 11:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Yeah, Me too
If you mean by that statement rman performs as desired when invoked by user "oracle", this means the problem for user "patanad1" is strictly an OS permissions issue & does NOT really involve any Oracle software directly.

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240347 is a reply to message #240336]

Thu, 24 May 2007 11:52

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

See, I can log into SQLPLUS =>

$ whoami
patanad1
$ sqlplus backup_admin/password@FCC2

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Jan 1 12:37:17 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> EXIT
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

$ whoami

$ rman target backup_admin/password@FCC2
1163290 : map : Permission Denied
1163290 : map : Permission Denied

Message file RMAN<lang>.msb not found

Verify that ORACLE_HOME is set properly

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240349 is a reply to message #240341]

Thu, 24 May 2007 11:55

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

But I am able to open SQLPLUS. Why not RMAN with id other than ORACLE???

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240351 is a reply to message #240300]

Thu, 24 May 2007 11:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Post output from => ls -l $ORACLE_HOME/rdbms/mesg/rman*.msb

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240352 is a reply to message #240347]

Thu, 24 May 2007 12:06

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

http://202.99.120.116:82/gate/big5/publish.it168.com/2006/0919/20060919046401.shtml

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240354 is a reply to message #240351]

Thu, 24 May 2007 12:09

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

Hi,

It did not allowd me to see the listing with the userid patanad1.
I logged as root user. the listing is as below.

root@devdb_02:/apps/oracle/ora10g_home/rdbms/mesg:#ls -l rman*.*
-rw------- 1 ora10g dba 90624 Oct 27 2006 rmanus.msb
-rwx------ 1 ora10g dba 333956 Jun 30 2005 rmanus.msg

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240355 is a reply to message #240300]

Thu, 24 May 2007 12:11

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

DUH! so change the permission so that dba group has access.

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240357 is a reply to message #240354]

Thu, 24 May 2007 12:14

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

-rw-r--r-- 1 oracle dba 90624 Oct 30 2006 rmanus.msb
-rw-r----- 1 oracle dba 333956 Jun 28 2005 rmanus.msg

change the permissions and then check.

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240362 is a reply to message #240357]

Thu, 24 May 2007 12:25

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

should i change the permission of mesg directory too??

Now i have changed the file settings. but Still get the same error. But I can not list the mesg directory till now.

can you tell me the settings of your mesg directory?

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240363 is a reply to message #240362]

Thu, 24 May 2007 12:28

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

$ ls -lt /apps/oracle/ora10g_home/rdbms
total 2272
drwx------ 2 ora10g dba 1064960 Jan 1 13:12 audit
drwx------ 2 ora10g dba 4096 May 13 2007 log
drwx------ 2 ora10g dba 57344 May 13 2007 admin
drwx------ 2 ora10g dba 4096 May 13 2007 lib
drwx------ 4 ora10g dba 256 May 13 2007 install
drwx------ 2 ora10g dba 256 May 13 2007 demo
drwx------ 2 ora10g dba 256 May 13 2007 notes
drwx------ 2 ora10g dba 4096 May 13 2007 lib32
drwx------ 2 ora10g dba 4096 May 13 2007 jlib
drwx------ 2 ora10g dba 4096 May 13 2007 mesg
drwx------ 2 ora10g dba 4096 May 13 2007 public
drwx------ 2 ora10g dba 256 Jan 23 2007 doc
drwx------ 3 ora10g dba 256 Jan 23 2007 xml
-rw------- 1 ora10g dba 0 Jan 17 2007 label.info

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240366 is a reply to message #240363]

Thu, 24 May 2007 12:30

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

-rw-r--r-- 1 oracle dba 90624 Oct 30 2006 rmanus.msb
-rw-r----- 1 oracle dba 333956 Jun 28 2005 rmanus.msg

This is mine setting .you should change like this and then check.

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240368 is a reply to message #240366]

Thu, 24 May 2007 12:34

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

i changed the file settings. but still i can not access the mesg directory with userid patanad1.

so do i have to change the directory (chmod of group and others)??

[Updated on: Thu, 24 May 2007 12:35]

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240372 is a reply to message #240368]

Thu, 24 May 2007 12:42

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

can you paste again your settings??

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240373 is a reply to message #240300]

Thu, 24 May 2007 12:43

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

Dear friends,

I am at last got success..

Thank you very much.....

I am really indebted to you.

Please remember me when you want any help.

regards,

dillip

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240374 is a reply to message #240373]

Thu, 24 May 2007 12:44

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

how??by changing permissions??
can you post solution.

Report message to a moderator

Re: RMAN ACCESS ERROR [message #240383 is a reply to message #240373]

Thu, 24 May 2007 13:02

dillip777
Messages: 21
Registered: May 2007
Location: USA

Junior Member

when I was giving RMAN command, error output like this :

"$ rman

Message file RMAN<lang>.msb not found

Verify that ORACLE_HOME is set properly"

I was doing setting the environment variables. But there was no luck. But I took help of experts like you.

I changed to the root user and changed the access mode of two directory and three files as below :

There are two directories (admin, mesg) on $ORACLE_HOME/rdbms directory. For groups and others it was set as drwx------.

so I changed into
drwxr-xr-x 2 ora10g dba 57344 May 13 2007 admin
drwxr-xr-x 2 ora10g dba 4096 May 13 2007 mesg
(chmod 755 admin,mesg)

in admin directory there is a file called recover.bsq.

I changed that mode too (chmod 666 recover.bsq).

-rw-rw-rw- 1 ora10g dba 1892533 Oct 27 2006 recover.bsq

then chaged the mode of two files (rmanus.msb & rmanus.msg) in mesg ($ORACLE_HOME/rdbms/mesg )directory.

-rw-r--r-- 1 ora10g dba 90624 Oct 27 2006 rmanus.msb
-rw-r----- 1 ora10g dba 333956 Jun 30 2005 rmanus.msg

(chmod 644 rmanus.msb
chmod 640 rmanus.msg)

after that RMAN worked.

I really indebted to dreamzZ (the most valuable person), anacedent (clue master) and Mahesh Rajendran.

Thanks again to everybody who are in this room.

MORAL OF THE STORY : When a file is not found.. just check the user's right on that directory and concerned files. Oracle gives silly explanation which can take lot of energy and time. It is better to search files with root access. With normal user ID, I searched those files many times but could not find them.

[Updated on: Thu, 24 May 2007 14:48]

Report message to a moderator

Previous Topic:	Backing up and Restoring/Recovering an Oracle 9i Database
Next Topic:	connectin via RMAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 17:59:53 CST 2024