Home » RDBMS Server » Server Administration » Database migration (Oracle 11gr2,Linux 5.7)
Database migration [message #600326] Mon, 04 November 2013 23:46 Go to next message
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,
Re: Database migration [message #600327 is a reply to message #600326] Mon, 04 November 2013 23:54 Go to previous messageGo to next message
BlackSwan
Messages: 22787
Registered: January 2009
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?
Re: Database migration [message #600328 is a reply to message #600327] Tue, 05 November 2013 00:02 Go to previous messageGo to next message
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 Go to previous messageGo to next message
BlackSwan
Messages: 22787
Registered: January 2009
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"?
Re: Database migration [message #600333 is a reply to message #600330] Tue, 05 November 2013 00:13 Go to previous messageGo to next message
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 ?
Re: Database migration [message #600334 is a reply to message #600333] Tue, 05 November 2013 00:16 Go to previous messageGo to next message
BlackSwan
Messages: 22787
Registered: January 2009
Senior Member
I don't know what the problem is or what a solution needs to be.
Re: Database migration [message #600355 is a reply to message #600334] Tue, 05 November 2013 03:38 Go to previous messageGo to next message
cookiemonster
Messages: 10961
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?

Re: Database migration [message #600372 is a reply to message #600355] Tue, 05 November 2013 09:57 Go to previous messageGo to next message
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

Re: Database migration [message #600373 is a reply to message #600372] Tue, 05 November 2013 10:11 Go to previous messageGo to next message
cookiemonster
Messages: 10961
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?
Re: Database migration [message #600411 is a reply to message #600373] Wed, 06 November 2013 02:50 Go to previous message
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:
  


Current Time: Wed Sep 17 20:43:58 CDT 2014

Total time taken to generate the page: 0.06468 seconds