[Spacewalk-list] Oracle migrating

[ŚLIPEK Krzysztof]

Hello,

I'm preparing to migrate spacewalk's oracle backend from express to full version on the other server and have a question is it good deal:

 

1.       stop all spacewalk services

2.       export database schema to dmp from source oracle

3.       import to destination oracle - database user, password, grants are the same

4.       change tnsnames.ora file in client on spacewalk server - maybe I can let same database sid, change database host ip address

5.       start spacewalk services

 

How about changing of oracle database sid?

 

Thanks for your help and best regards,

Chris

 


----------------------------------------------------------------------
BNP Paribas Bank Polska SA (dawniej Fortis Bank Polska SA) z siedzibą w Warszawie przy ul. Suwak 3, zarejestrowany w Sądzie Rejonowym dla m. st. Warszawy, XIII Wydział Gospodarczy, KRS pod numerem 6421, NIP: 676-007-83-01, kapitał zakładowy 1 206 175 300 zł, w całości wpłacony.
BNP Paribas Bank Polska SA (former Fortis Bank Polska SA) with its registered office in Warsaw at ul. Suwak 3, registered with the District Court for the capital city of Warsaw, XIII Commercial Division of the National Court Register (KRS) under No. 6421, VAT PL 6760078301, holding paid-up share capital of PLN 1,206,175,300.
BNP Paribas Bank Polska SA  disclaimer: http://www.bnpparibas.pl/legal/disclaimer.htm
----------------------------------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120125/77f816d1/attachment.htm>