OraFAQ Forum: Backup & Recovery » Cannot connect to target database

Home » RDBMS Server » Backup & Recovery » Cannot connect to target database (10.2.0.3.0)

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

Cannot connect to target database [message #322446]

Fri, 23 May 2008 10:14

lotusdeva
Messages: 201
Registered: March 2005

Senior Member

Hello, I was wondering if anyone ran into the same problem. I have target database on one server and then the recovery catalog on another server. I am in the process of registering target database with the catalog and I got these issues:

1. Target database is up and running:

SQL> startup
ORACLE instance started.

Total System Global Area  738197504 bytes
Fixed Size                  2032928 bytes
Variable Size             553655008 bytes
Database Buffers          167772160 bytes
Redo Buffers               14737408 bytes
Database mounted.
Database opened.
SQL> select name from v$database;

NAME
---------
TEST

2. I have added an entry for TEST in the tnsnames.ora on the server where recovery catalog is located (because I am running RMAN remotelly)

3. Trying to register target db (TEST) with recovery catalog (again, I am doing it on the server where recovery catalog is located):

prod> export ORACLE_SID=TEST
prod> rman target / catalog rman/psswd@catdb

Recovery Manager: Release 10.2.0.3.0 - Production on Fri May 23 10:59:50 2008

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 05/23/2008 11:02:13
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory

But my target database is up and running, what can be wrong? Thank you!

[Updated on: Fri, 23 May 2008 10:50]

Report message to a moderator

Re: Cannot connect to target database [message #322458 is a reply to message #322446]

Fri, 23 May 2008 10:50

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

Senior Member
Account Moderator

Quote:

The target database must be mounted or open.

Regards
Michel

Report message to a moderator

Re: Cannot connect to target database [message #322460 is a reply to message #322458]

Fri, 23 May 2008 10:56

lotusdeva
Messages: 201
Registered: March 2005

Senior Member

It is open...

SQL> startup
ORACLE instance started.

Total System Global Area  738197504 bytes
Fixed Size                  2032928 bytes
Variable Size             553655008 bytes
Database Buffers          167772160 bytes
Redo Buffers               14737408 bytes
Database mounted.
Database opened.

SQL> select name from v$database;

NAME
---------
TEST

Maybe it is a problem because I am accessig target database remotely? Alghough, I have created an entry in the tnsnames.ora for the target database...

Report message to a moderator