OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Database migration (Oracle 11gr2,Linux 5.7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database migration [message #600326]

Mon, 04 November 2013 23:46

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

We have migrated databases from physical servers to virtual servers .Currently application is pointing to virtual DB servers and is being used.We have moved all databases and scripts related ( that was automated in cronjob ) and everything to virtual server from physical sever.

Now my client does not want these databases in physical server since it is a shared server ( means other application database is also installed in same physical servers).

My question here is

1. Shall i just shutdown all database or better to remove it from physical servers ?
or
2. Lock all account in databases ?

Its a RAC database with 3 node cluster

Kindly advice.

With Regards,

Report message to a moderator

Re: Database migration [message #600327 is a reply to message #600326]

Mon, 04 November 2013 23:54

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>1. Shall i just shutdown all database or better to remove it from physical servers ?
which metric measures "better"?

how will you or I decide which post contains best solution?

Report message to a moderator

Re: Database migration [message #600328 is a reply to message #600327]

Tue, 05 November 2013 00:02

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Blackswan,

Quote:

how will you or I decide which post contains best solution?

Can you be little bit clear, then who has to decide it ?

Thanks

[Updated on: Tue, 05 November 2013 00:03]

Report message to a moderator

Re: Database migration [message #600330 is a reply to message #600328]

Tue, 05 November 2013 00:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Jack14 wrote on Mon, 04 November 2013 22:02

Blackswan,

Quote:
how will you or I decide which post contains best solution?

Can you be little bit clear, then who has to decide it ?

Thanks

What is "it"?

what differentiates "best" solution from those which are not "best"?

Report message to a moderator

Re: Database migration [message #600333 is a reply to message #600330]

Tue, 05 November 2013 00:13

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

I really did not get you . can you be more clear on what you are saying ?

Report message to a moderator

Re: Database migration [message #600334 is a reply to message #600333]

Tue, 05 November 2013 00:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I don't know what the problem is or what a solution needs to be.

Report message to a moderator

Re: Database migration [message #600355 is a reply to message #600334]

Tue, 05 November 2013 03:38

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

If the client doesn't want the DB's on the physical servers then presumably you need to remove them.
So our question is why are you suggesting option 2 at all? what's the point?

Report message to a moderator

Re: Database migration [message #600372 is a reply to message #600355]

Tue, 05 November 2013 09:57

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Quote:

So our question is why are you suggesting option 2 at all? what's the point?

I am just asking you whether we need to lock all user accounts in database ?

Thanks

Report message to a moderator

Re: Database migration [message #600373 is a reply to message #600372]

Tue, 05 November 2013 10:11

cookiemonster
Messages: 13966
Registered: September 2008
Location: Rainy Manchester

Senior Member

And I'm asking what's the point of locking the accounts if you're going to remove the db from the server?

If you're about to demolish a building are you worried about going around locking the doors?

Report message to a moderator

Re: Database migration [message #600411 is a reply to message #600373]

Wed, 06 November 2013 02:50

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Cookiemaster
Quote:

If you're about to demolish a building are you worried about going around locking the doors?

Yes,you are correct.There is no meaning in locking all user accounts when database is no longer in use.Just had a doubts on this and wanted to clarify on this.

Thanks everyone who answered my question.

[Updated on: Wed, 06 November 2013 02:51]

Report message to a moderator

Previous Topic:	Database parameter comparison
Next Topic:	Changing CHARACTER SET

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 09 00:12:14 CST 2025