Home » RDBMS Server » Backup & Recovery » target database connection error (oracle 9.2.0 , solaris 8)
target database connection error [message #293553] Mon, 14 January 2008 01:30 Go to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
hi all,

I am using Oracle 9.2.0 in solaris 8.
I have created one catalog database on a separate server and production is on separate.
when i am trying to connect to target database
RMAN> rman catalog lman/lman target sys/$4$@rman
instead of onnecting to target database it is onnecting to same catalog database.

can anybody tell me whatis the exact procedure to connect to target database in separate server.



Thank U.

Report message to a moderator

Re: target database connection error [message #293555 is a reply to message #293553] Mon, 14 January 2008 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Give an alias that points to the target database.
I doubt that "rman" is an alias for the target, it rather seems to be an alias for the catalog, doesn't it?

Regards
Michel

Report message to a moderator

Re: target database connection error [message #293558 is a reply to message #293555] Mon, 14 January 2008 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Reported message

Reported By: sushilkumarmohanty On: Mon, 14 January 2008 08:43 In: RDBMS Server » Backup & Recovery » target database connection error
Reason Thanks for ur response. But when I am pinging $ tnsping rman it pings to the target database. I am not getting what to do. Thank U.


Don't report the message, click on REPLY button not on "Report message to a moderator" link.

You have to copy and paste what you did and not describing it.

Regards
Michel

Report message to a moderator

Re: target database connection error [message #293568 is a reply to message #293558] Mon, 14 January 2008 02:28 Go to previous messageGo to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
Hi,

When I am pinging
bash-2.03$ tnsping rman

TNS Ping Utility for Solaris: Version 9.2.0.1.0 - Production on 14-JAN-2008 07:3
8:20

Copyright (c) 1997 Oracle Corporation. All rights reserved.

Used parameter files:
/ora0/app/oracle/product/OraHome1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = flash)(PORT = 1521))) (CONNECT_DATA = (SID = rman) (SERVER = DEDICATED))
)
OK (40 msec)

My target server is flash.
My target and catalog databse both have same sid rman.

But when I am connecting using rman

bash-2.03$ rman catalog lman/lman target sys/$4$@rman

Recovery Manager: Release 9.2.0.1.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: RMAN (DBID=1529266785)
connected to recovery catalog database

Can you plz tell me how to solve this problem.



Thank U.

Report message to a moderator

Re: target database connection error [message #293586 is a reply to message #293568] Mon, 14 January 2008 03:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What I see is perfectly correct: RMAN is doing what you asked it to do, there is no problem.

Please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Re: target database connection error [message #293593 is a reply to message #293586] Mon, 14 January 2008 03:46 Go to previous messageGo to next message
sushilkumarmohanty
Messages: 27
Registered: January 2008
Location: Bangalore
Junior Member
Thanks.

Report message to a moderator

Re: target database connection error [message #293944 is a reply to message #293553] Tue, 15 January 2008 13:50 Go to previous message
dzt52r
Messages: 19
Registered: July 2007
Location: PA
Junior Member
on server where catalog database resides.
create an alias in tnsnames file, call it targrm that
points to target database.
then
rman catalog lman/lman target sys/$4$@targrm

This will connect you to both the catalog and target databases.

Report message to a moderator

Previous Topic: How to startup Oracle without backups of archive log & control file
Next Topic: What are the minimums server specs to run a recovery catalog?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 11:30:47 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.