Cannot connect to target database [message #322446] |
Fri, 23 May 2008 10:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #322460 is a reply to message #322458] |
Fri, 23 May 2008 10:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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...
|
|
|
Re: Cannot connect to target database [message #322467 is a reply to message #322460] |
Fri, 23 May 2008 11:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
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
|
|
|