Home » RDBMS Server » Backup & Recovery » RMAN ACCESS ERROR
RMAN ACCESS ERROR [message #240300] Thu, 24 May 2007 10:15 Go to next message
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.
Re: RMAN ACCESS ERROR [message #240302 is a reply to message #240300] Thu, 24 May 2007 10:17 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
CAN YOU PASTE ALL ERRORS LOG??
Re: RMAN ACCESS ERROR [message #240304 is a reply to message #240302] Thu, 24 May 2007 10:20 Go to previous messageGo to next message
dillip777
Messages: 21
Registered: May 2007
Location: USA
Junior Member

Thanks for your quick response.
where this error log can be found?
Re: RMAN ACCESS ERROR [message #240306 is a reply to message #240304] Thu, 24 May 2007 10:23 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.

Re: RMAN ACCESS ERROR [message #240313 is a reply to message #240300] Thu, 24 May 2007 10:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
please post results from
$ env | sort
Re: RMAN ACCESS ERROR [message #240314 is a reply to message #240307] Thu, 24 May 2007 10:43 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
hey check it

http://www.tiplib.com/95/unix-permissions-problem-under-oracle
Re: RMAN ACCESS ERROR [message #240315 is a reply to message #240307] Thu, 24 May 2007 10:44 Go to previous messageGo to next message
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.
Re: RMAN ACCESS ERROR [message #240316 is a reply to message #240313] Thu, 24 May 2007 10:46 Go to previous messageGo to next message
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
Re: RMAN ACCESS ERROR [message #240319 is a reply to message #240315] Thu, 24 May 2007 10:50 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: RMAN ACCESS ERROR [message #240330 is a reply to message #240300] Thu, 24 May 2007 11:21 Go to previous messageGo to next message
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.
Re: RMAN ACCESS ERROR [message #240334 is a reply to message #240330] Thu, 24 May 2007 11:30 Go to previous messageGo to next message
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).
Re: RMAN ACCESS ERROR [message #240336 is a reply to message #240334] Thu, 24 May 2007 11:31 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Can you connect with sqlplus??
Re: RMAN ACCESS ERROR [message #240341 is a reply to message #240300] Thu, 24 May 2007 11:38 Go to previous messageGo to next message
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.
Re: RMAN ACCESS ERROR [message #240347 is a reply to message #240336] Thu, 24 May 2007 11:52 Go to previous messageGo to next message
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

Re: RMAN ACCESS ERROR [message #240349 is a reply to message #240341] Thu, 24 May 2007 11:55 Go to previous messageGo to next message
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???
Re: RMAN ACCESS ERROR [message #240351 is a reply to message #240300] Thu, 24 May 2007 11:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Post output from => ls -l $ORACLE_HOME/rdbms/mesg/rman*.msb
Re: RMAN ACCESS ERROR [message #240352 is a reply to message #240347] Thu, 24 May 2007 12:06 Go to previous messageGo to next message
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
Re: RMAN ACCESS ERROR [message #240354 is a reply to message #240351] Thu, 24 May 2007 12:09 Go to previous messageGo to next message
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
Re: RMAN ACCESS ERROR [message #240355 is a reply to message #240300] Thu, 24 May 2007 12:11 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
DUH! so change the permission so that dba group has access.
Re: RMAN ACCESS ERROR [message #240357 is a reply to message #240354] Thu, 24 May 2007 12:14 Go to previous messageGo to next message
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.
Re: RMAN ACCESS ERROR [message #240362 is a reply to message #240357] Thu, 24 May 2007 12:25 Go to previous messageGo to next message
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?
Re: RMAN ACCESS ERROR [message #240363 is a reply to message #240362] Thu, 24 May 2007 12:28 Go to previous messageGo to next message
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
Re: RMAN ACCESS ERROR [message #240366 is a reply to message #240363] Thu, 24 May 2007 12:30 Go to previous messageGo to next message
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.
Re: RMAN ACCESS ERROR [message #240368 is a reply to message #240366] Thu, 24 May 2007 12:34 Go to previous messageGo to next message
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 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
can you paste again your settings??
Re: RMAN ACCESS ERROR [message #240373 is a reply to message #240300] Thu, 24 May 2007 12:43 Go to previous messageGo to next message
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
Re: RMAN ACCESS ERROR [message #240374 is a reply to message #240373] Thu, 24 May 2007 12:44 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
how??by changing permissions??
can you post solution.
Re: RMAN ACCESS ERROR [message #240383 is a reply to message #240373] Thu, 24 May 2007 13:02 Go to previous message
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:
  


Current Time: Mon Dec 02 08:21:24 CST 2024