Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cannot connect to target database

rysalkaMay 23 2008 — edited May 27 2008
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:


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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2008
Added on May 23 2008
11 comments
2,698 views