migrating solaris DB servers to AIX - resources ?

zxmaus · #1 (**permalink**) 2 Weeks Ago

Hi Guys,

I have a new project where I have to migrate about 150+ database environments from various solaris systems running Solaris 8 / 10 and residing on very different sun boxes (from 25k down to ancient/unsupported hardware) to AIX (power6).

As special bonus for me, about half of these DBs are supposed to become migrated to Oracle once stable as Sybase DBs on AIX.

I know that I can use the RPE2 values to estimate the cpu requirements - but since the memory needs on Solaris seem pretty different from AIX, is there any safe way to estimate at least roughly the memory needs on AIX? For Sybase I can probably choose the value that's assigned to ASE and add 2-4 GB memory for the system and should be safe - but what do I do with oracle since here the memory usage seems to be highly depending on the DB connections and what they're doing?

Has anybody done similar tasks in the past and would be happy to share experiences.

Thank you and regards
zxmaus

Padow · #2 (**permalink**) 2 Weeks Ago

I'm in the midst of a similar project. I used the following script to determine shared memory usage on Solaris hosts for Sybase and Oracle. I ran this several times a day on each host, though the numbers really didn't change much. I found this to be much better than utilizing what the DB was configured to use, as this will show what the DB actually utilizes.

Code:

if ipcs -ma | grep sybase > /dev/null ; then
  echo Sybase
  ipcs -ma  | grep sybase | awk '{ T+=($10/1024/1024) } END { print T }'
elif ipcs -ma | grep oracle > /dev/null ; then
  echo Oracle
  ipcs -ma  | grep oracle | awk '{ T+=($10/1024/1024) } END { print T }'
fi

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Resources for the Solaris OS and OpenSolaris on HP Servers	iBot	Solaris BigAdmin RSS	0	05-29-2009 08:30 AM
Resources for the Solaris OS on IBM Servers	iBot	Solaris BigAdmin RSS	0	05-27-2009 08:30 AM
Resources for the Solaris OS on Dell Servers	iBot	Solaris BigAdmin RSS	0	05-27-2009 08:30 AM
Resources for the Solaris OS on IBM and Dell Servers	iBot	Solaris BigAdmin RSS	0	11-24-2008 03:30 PM
Migrating to Itanium 2 Servers: Part 1 - Dr. Dobb's Journal	iBot	UNIX and Linux RSS News	0	08-23-2007 02:10 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by