OraFAQ Forum: Backup & Recovery » RMAN-06403 ORA-01034 When registering database in RMAN

Home » RDBMS Server » Backup & Recovery » RMAN-06403 ORA-01034 When registering database in RMAN

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

RMAN-06403 ORA-01034 When registering database in RMAN [message #246952]

Fri, 22 June 2007 10:47

TLegend33
Messages: 203
Registered: March 2005

Senior Member

I'm running oracle 10.2 on RHEL4. I have a local development db which also contains the recovery catalog. I can backup my local development db without issue using RMAN. For some reason, when I attempt to register a remote database to be backed up via RMAN I get the below error:

[oracle@tony admin]$ rman target / catalog rman/rman@t_dev

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Jun 22 11:18:04 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database (not started)
connected to recovery catalog database

RMAN> register database;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 06/22/2007 11:18:19
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

My ORACLE_SID is correctly defined in my environment and I can successfully tnsping the remote db. I can also properly connect to the remote db via sqlplus. Here is a sample entry from tnsnames.ora:

TEST_DEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = dev_host)(Port = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST_DEV)
)
)

My sqlnet.ora is:
# sqlnet.ora Network Configuration File: /home/oracle/ora10_2/network/admin/sqln
et.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES)

Any thoughts?

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #246955 is a reply to message #246952]

Fri, 22 June 2007 10:52

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Database Backup and Recovery Reference, Chapter 2 RMAN Commands, REGISTER page, "Restrictions and Usage Notes" section:

Quote:

The target database must be mounted or open

Of course, the recovery catalog database must be open.

Regards
Michel

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #246975 is a reply to message #246955]

Fri, 22 June 2007 12:05

TLegend33
Messages: 203
Registered: March 2005

Senior Member

Both database are open.

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #246977 is a reply to message #246975]

Fri, 22 June 2007 12:13

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

did you create catalog tablespace ???

CREATE CATALOG TABLESPACE 'YOUR_TABLESPACE_FOR_RC';

[Updated on: Fri, 22 June 2007 12:14]

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247019 is a reply to message #246975]

Fri, 22 June 2007 19:27

ebrian
Messages: 2794
Registered: April 2006

Senior Member

TLegend33 wrote on Fri, 22 June 2007 13:05

Both database are open.

Apparently, RMAN doesn't think so:

TLegend33 wrote on Fri, 22 June 2007 11:47

connected to target database (not started)

Can you make a SQL*Plus connection without specifying the tns alias (ie. sqlplus / as sysdba) and issue a select instance_name, status from v$instance;

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247319 is a reply to message #247019]

Mon, 25 June 2007 09:45

TLegend33
Messages: 203
Registered: March 2005

Senior Member

I cannot make a SQL*Plus connection without specifying the tns alias. I continue to get the below error:

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247323 is a reply to message #247319]

Mon, 25 June 2007 09:53

Michel Cadot
Messages: 68651
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And so the database is not open.

Regards
Michel

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247324 is a reply to message #246952]

Mon, 25 June 2007 09:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

cut & paste results of
ps -ef | grep pmon

[Updated on: Mon, 25 June 2007 09:55] by Moderator

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247327 is a reply to message #247323]

Mon, 25 June 2007 10:05

TLegend33
Messages: 203
Registered: March 2005

Senior Member

Yet, when I do specify the tns alias I am able to make a SQL*Plus connection. The target database is up and running. It appears I've got a tnsnames authentication issue that I can't determine.

[Updated on: Mon, 25 June 2007 10:09]

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247328 is a reply to message #246952]

Mon, 25 June 2007 10:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You seem to be clue resistant.
>Yet, when I do specify the tns alias I am able to make a SQL*Plus connection. The target database is up and running.
Using TNS alias implies using SQL*Net to make the connection.
Either
1) SQL*Net is connecting to a different database
or
2) your local OS user does not have privs to access local DB.

Since you choose to NOT answer via cut & paste, I choose to let you flail away & You're On Your Own (YOYO)!

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247330 is a reply to message #247328]

Mon, 25 June 2007 10:28

TLegend33
Messages: 203
Registered: March 2005

Senior Member

Hi, I had answered the post prior to yours, sorry I did not respond specifically to your post in a concise and prompt enough manner. Below is the information requested:

1) SQL*Net is connecting to the correct database when I use:
username/password@test_dev

2) How would OS permissions raise this error when I can connect to the remote databse using the connect string listed above?

Here is the cut & paste output:

user@server:/export/home/user> ps -ef | grep pmon
oracle 28961 1 0 May 22 ? 6:23 ora_pmon_TEST_DEV
user 4497 4485 0 11:29:52 pts/16 0:00 grep pmon

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247332 is a reply to message #246952]

Mon, 25 June 2007 10:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>2) How would OS permissions raise this error when I can connect to the remote databse using the connect string listed above?

When using SQL*Net to access the DB, effectively the user "oracle" is doing the work.

>user@server:/export/home/user> ps -ef | grep pmon

I suspect that "user" in line above is NOT the same username used to install the Oracle software.
If so, this is why the error.

What is cut & paste output from
env | sort

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247335 is a reply to message #247332]

Mon, 25 June 2007 10:50

TLegend33
Messages: 203
Registered: March 2005

Senior Member

This is from my local machine that has the recovery catalog:

[oracle@mypc admin]$ env | sort
_=/bin/env
CLASSPATH=/opt/oraInventory/Components/oracle/swd/jre/1.1.7://home/oracle/ora10_2/jlib:/home/oracle/ora10_2/jre/1.1.7
CVS_RSH=ssh
DISPLAY=:0.0
EXP=//home/oracle/ora10_2/admin/T_DEV/exp
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=mypc
INPUTRC=/etc/inputrc
KDEDIR=/usr
KDE_IS_PRELINKED=1
KDE_NO_IPV6=1
LANG=en_US.UTF-8
LD_LIBRARY_PATH=/usr/lib:/lib:/usr/ccs/lib:/usr/ucblib:/home/oracle/ora10_2/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
OLDPWD=/home/oracle
ORACLE_DOC=/home/oracle/ora10_2/doc
ORACLE_HOME=/home/oracle/ora10_2
ORACLE_SID=T_DEV
ORACLE_TERM=vt100
ORA_NLS=/home/oracle/ora10_2/ocommon/nls/admin/data
ORATAB=/var/opt/oracle/oratab
PATH=/opt/bin:/opt/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/ucb:/usr/bin:/usr/sbin:/usr/ccs/bin:/bin:/usr/openwin/bin: /home/oracle/ora10_2/bin:/usr/local/bin:/home/oracle/bin:/usr/ucb:/usr/bin:/usr/sbin:/usr/ccs/bin:/bin:/usr/openwin/bin:/home/oracle/ ora10_2/bin:/usr/local/bin
PWD=/home/oracle/ora10_2/network/admin
SHELL=/bin/bash
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
TERM=xterm
TMPDIR=/tmp
TMP=/tmp
TNS_ADMIN=/home/oracle/ora10_2/network/admin
USER=oracle
XAUTHORITY=/home/oracle/.xauthWpAAlI

This is from the remote server that contains the target DB:

user@server:/d7/opt/network/admin> env | sort
CLASSPATH=/opt/oraInventory/Components/oracle/swd/jre/1.1.7://d7/opt//jlib:/d7/opt//jre/1.1.7
EDITOR=vi
HOME=/export/home/user
HOSTNAME=server
HOSTTYPE=sparc
LD_LIBRARY_PATH=/usr/lib:/lib:/usr/ccs/lib:/usr/ucblib:/d7/opt//lib
LOGNAME=user
MACHTYPE=sparc-sun-solaris
MAIL=/var/mail//user
OLDPWD=/d7/opt
ORACLE_DOC=/d7/opt//doc
ORACLE_HOME=/d7/opt/
ORACLE_SID=TEST_DEV
ORACLE_TERM=vt100
ORATAB=/var/opt/oracle/oratab
ORA_NLS=/d7/opt//ocommon/nls/admin/data
OSTYPE=solaris
PATH=/opt/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:.:/bin::/usr/ucb:/usr/bin:/usr/sbin:/usr/ccs/bin:/bin:/usr/openwin/bin:/d7 /opt//bin:/usr/local/bin
PWD=/d7/opt/network/admin
SHELL=/usr/bin/bash
SHLVL=1
SSH_CLIENT=111.222.3.44 12345 12
SSH_CONNECTION=111.222.3.44 12345 999.888.7.66 22
SSH_TTY=/dev/pts/16
TERM=xterm
TNS_ADMIN=/d7/opt//network/admin
TZ=US/Eastern
USER=user
_=/usr/bin/env

My user installed the Oracle software on my PC. Another user installed the Oracle software on the remote server that contains the target DB.

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247339 is a reply to message #246952]

Mon, 25 June 2007 11:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

While logged onto system that contains the target DB, do cut & paste of the following:

ls -l $ORACLE_HOME

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247342 is a reply to message #246952]

Mon, 25 June 2007 11:25

TLegend33
Messages: 203
Registered: March 2005

Senior Member

user@server:/export/home/server> ls -l $ORACLE_HOME
total 168
drwxr-xr-x 4 oracle dba 512 Dec 7 2006 OPatch
drwxr-xr-x 7 oracle dba 512 Dec 7 2006 assistants
drwxr-xr-x 2 oracle dba 5632 Dec 7 2006 bin
drwxr-xr-x 3 oracle dba 512 Dec 7 2006 cdata
drwxr-xr-x 4 oracle dba 512 Dec 7 2006 cfgtoollogs
drwxr-xr-x 4 oracle dba 512 Dec 7 2006 clone
drwxr-xr-x 2 oracle dba 512 Dec 7 2006 config
drwxr-xr-x 6 oracle dba 512 Dec 7 2006 crs
drwxr-xr-x 7 oracle dba 512 Dec 7 2006 css
drwxr-xr-x 10 oracle dba 512 Dec 7 2006 ctx
drwxr-xr-x 2 oracle dba 512 May 22 17:34 dbs
drwxr-xr-x 3 oracle dba 512 Dec 7 2006 demo
drwxr-xr-x 3 oracle dba 512 Dec 7 2006 diagnostics
drwxr-xr-x 3 oracle dba 512 Dec 7 2006 has
drwxr-xr-x 7 oracle dba 512 Dec 7 2006 hs
drwxr-xr-x 5 oracle dba 512 Dec 7 2006 install
-rwxr-xr-x 1 oracle dba 38 Dec 7 2006 install.platform
drwxr-xr-x 2 oracle dba 512 Dec 7 2006 instantclient32
drwxr-xr-x 12 oracle dba 512 Dec 7 2006 inventory
drwxr-xr-x 7 oracle dba 512 Dec 7 2006 javavm
drwxr-xr-x 4 oracle dba 512 Dec 7 2006 jdbc
drwxr-xr-x 7 oracle dba 512 Dec 7 2006 jdk
drwxr-xr-x 2 oracle dba 1536 Dec 7 2006 jlib
drwxr-xr-x 3 oracle dba 512 Dec 7 2006 jre
drwxr-xr-x 13 oracle dba 512 Dec 7 2006 ldap
drwxr-xr-x 3 oracle dba 5632 Dec 7 2006 lib
drwxr-xr-x 4 oracle dba 3584 Dec 7 2006 lib32
drwxr-xr-x 3 oracle dba 512 Dec 8 2006 log
drwxr-xr-x 6 oracle dba 512 Dec 7 2006 md
drwxr-xr-x 2 oracle dba 512 Dec 7 2006 mesg
drwxr-xr-x 7 oracle dba 512 Dec 7 2006 mgw
drwxr-xr-x 13 oracle dba 512 Dec 7 2006 network
drwxr-xr-x 6 oracle dba 512 Dec 7 2006 nls
drwxr-xr-x 15 oracle dba 512 Dec 7 2006 oc4j
drwxr-xr-x 6 oracle dba 512 Dec 7 2006 odbc
drwxr-xr-x 5 oracle dba 512 Dec 7 2006 olap
drwxr-xr-x 7 oracle dba 512 Dec 7 2006 opmn
-rwxr-xr-x 1 oracle dba 41 Apr 25 2005 oraInst.loc
drwxr-xr-x 4 oracle dba 512 Dec 7 2006 oracore
drwxr-xr-x 8 oracle dba 512 Dec 7 2006 ord
drwxr-xr-x 7 oracle dba 512 Dec 7 2006 oui
drwxr-xr-x 4 oracle dba 512 Dec 7 2006 owm
drwxr-xr-x 6 oracle dba 512 Dec 7 2006 perl
drwxr-xr-x 7 oracle dba 512 Dec 7 2006 plsql
drwxr-xr-x 8 oracle dba 512 Dec 7 2006 precomp
drwxr-xr-x 7 oracle dba 512 Dec 7 2006 racg
drwxr-xr-x 14 oracle dba 512 Dec 7 2006 rdbms
drwxr-xr-x 4 oracle dba 512 Dec 7 2006 relnotes
-rwxr-xr-x 1 oracle dba 9477 Dec 7 2006 root.sh
-rwxr-xr-x 1 oracle dba 0 Jun 7 2005 root.sh.old
drwxr-xr-x 3 oracle dba 512 Dec 7 2006 slax
drwxr-xr-x 3 oracle dba 512 Dec 7 2006 sqlj
drwxr-xr-x 9 oracle dba 512 Dec 7 2006 sqlplus
drwxr-xr-x 13 oracle dba 512 Dec 7 2006 srvm
drwxr-xr-x 13 oracle dba 512 Dec 7 2006 sysman
drwxr-xr-x 3 oracle dba 512 Dec 7 2006 tg4ifmx
drwxr-xr-x 3 oracle dba 512 Dec 7 2006 tg4ingr
drwxr-xr-x 3 oracle dba 512 Dec 7 2006 tg4sybs
drwxr-xr-x 3 oracle dba 512 Dec 7 2006 tg4tera
drwxr-xr-x 4 oracle dba 512 Dec 7 2006 uix
drwxr-xr-x 3 oracle dba 512 Dec 7 2006 wwg
drwxr-xr-x 6 oracle dba 512 Dec 7 2006 xdk

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247344 is a reply to message #246952]

Mon, 25 June 2007 11:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

If/when you are logged directly on the database server as user "oracle", you'll be able to invoke sqlplus & access the database.

HTH & YMMV

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247413 is a reply to message #247344]

Mon, 25 June 2007 15:24

TLegend33
Messages: 203
Registered: March 2005

Senior Member

Yes, when I am directly logged on to the database server as user 'oracle' I can invoke sqlplus and access the database.
I'm confused, did you post a suggestion or are you signing off on this issue?

Report message to a moderator

Re: RMAN-06403 ORA-01034 When registering database in RMAN [message #247619 is a reply to message #247413]

Tue, 26 June 2007 10:01

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Since you are trying to connect to a remote database, you need construct your RMAN connection as:

$ rman target sys/password@test_dev catalog rman/rman@t_dev

Report message to a moderator

Previous Topic:	question about recover until restore point
Next Topic:	stored RMAN script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 09:34:23 CDT 2024