Home » RDBMS Server » Backup & Recovery » Cannot connect to target database (10.2.0.3.0)
Cannot connect to target database [message #322446] Fri, 23 May 2008 10:14 Go to next message
lotusdeva
Messages: 198
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
REGISTER DATABASE, Restrictions and Usage Notes:
Quote:
The target database must be mounted or open.

Regards
Michel
Re: Cannot connect to target database [message #322460 is a reply to message #322458] Fri, 23 May 2008 10:56 Go to previous messageGo to next message
lotusdeva
Messages: 198
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...
Re: Cannot connect to target database [message #322467 is a reply to message #322460] Fri, 23 May 2008 11:49 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
It is open...

Wrong:
Quote:
connected to target database (not started)


Quote:
Maybe it is a problem because I am accessig target database remotely?

Or maybe you are not accessing the database you think.

Regards
Michel
Previous Topic: recovery from datafiles only in noarchivelog mode
Next Topic: why can not recover this datafile?
Goto Forum:
  


Current Time: Sun Dec 04 08:29:10 CST 2016

Total time taken to generate the page: 0.04200 seconds