Cannot connect to target database
rysalkaMay 23 2008 — edited May 27 2008Hello, 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!