Home » RDBMS Server » Server Administration » database links (10g)
database links [message #341644] Tue, 19 August 2008 14:29 Go to next message
jerrymail
Messages: 5
Registered: August 2007
Junior Member
We are moving our production server to a new box. It will have the same server name and database name.

Do I need to drop and create (recreate) the database links?

Also, do I need all the passwords to create them?

Thanks.

Jerry Razz

Report message to a moderator

Re: database links [message #341645 is a reply to message #341644] Tue, 19 August 2008 14:31 Go to previous messageGo to next message
jerrymail
Messages: 5
Registered: August 2007
Junior Member
This question goes both for the links on the database and also the links to the box/database.

Thanks again.

Jerry Razz

Report message to a moderator

Re: database links [message #341898 is a reply to message #341644] Wed, 20 August 2008 13:28 Go to previous messageGo to next message
jerrymail
Messages: 5
Registered: August 2007
Junior Member
please respond. Our migration is Friday.

Thanks.

Jerry

Report message to a moderator

Re: database links [message #341900 is a reply to message #341644] Wed, 20 August 2008 13:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

NOBODY here owes you any response!

You can have it good, fast or cheap; pick any two.

Report message to a moderator

Re: database links [message #341904 is a reply to message #341898] Wed, 20 August 2008 13:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If you don't know how to do it just pick up your phone and hire someone to do it.

Regards
Michel

Report message to a moderator

Re: database links [message #341910 is a reply to message #341644] Wed, 20 August 2008 13:59 Go to previous messageGo to next message
jerrymail
Messages: 5
Registered: August 2007
Junior Member
nice ...

Maybe someone like yourself could learn something from a response.

Jerry

Report message to a moderator

Re: database links [message #341916 is a reply to message #341910] Wed, 20 August 2008 14:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Maybe, even sure, but I will patiently wait for someone to post it and don't demand it.

If I have a serious problem and am in hurry I don't rely on forums to provide me the solution, I pay for it.

Regards
Michel

Report message to a moderator

Re: database links [message #341923 is a reply to message #341644] Wed, 20 August 2008 14:59 Go to previous messageGo to next message
jerrymail
Messages: 5
Registered: August 2007
Junior Member
It sounds like you (and maybe others) have an agenda here.

I've been a member of free Oracle foruns like lazydba for over 10 years, and I can't recall running into people before mentioning payment for answers. Although many refer newbies to Oracle manuals, which is OK by me.

Report message to a moderator

Re: database links [message #341927 is a reply to message #341923] Wed, 20 August 2008 15:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Who ask for payment here?

Regards
Michel

Report message to a moderator

Re: database links [message #341946 is a reply to message #341927] Wed, 20 August 2008 17:11 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Actually, one I throw in something for free :

Doing a migration of a "production" server before having done the same migration with a test server is a really, really, rally, rally, bad idea.

Unless the server is not really critical, in which case you can try to solve the problems one by one afterwards, when they occur.

Report message to a moderator

Re: database links [message #341965 is a reply to message #341644] Wed, 20 August 2008 22:44 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member
Quote:
Doing a migration of a "production" server before having done the same migration with a test server is a really, really, rally, rally, bad idea.


How can you say it's bad idea?

Babu

Report message to a moderator

Re: database links [message #341966 is a reply to message #341644] Wed, 20 August 2008 22:47 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member
Quote:
We are moving our production server to a new box. It will have the same server name and database name.

Do I need to drop and create (recreate) the database links?

Also, do I need all the passwords to create them?


No need to re-create your database link if new database name same as your old production server.

Babu

Report message to a moderator

Re: database links [message #341969 is a reply to message #341965] Wed, 20 August 2008 23:13 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
gentlebabu wrote on Wed, 20 August 2008 20:44

How can you say it's bad idea?

Babu



I my opinion doing anything nonstandard against/with/to the production environment without testing is begging Murphy to intervene & produce a nasty surprise.

You do not know, what you do not know.

Report message to a moderator

Re: database links [message #342033 is a reply to message #341969] Thu, 21 August 2008 02:17 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello Mr. Anacedent,

I was mistakenly understand abt Mr.ThomasG command. Sorry for that.

Babu

Report message to a moderator

Previous Topic: database locks with inactive sessions
Next Topic: Please Move to Server Administration Folder (moved from Suggestions & Feedback by bb)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 19:53:18 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.