09 octubre 2014

VMworld Eurpe 2014 .....tic tac tic tac



Cambiar la bbdd de #VMware #vSphere de SQL a ORACLE

Para apuntar la bbdd de VMware vSphere vCenter de un SQL a Oracle o viceversa, es necesario modificar el registro, con el servicio de vCenter previamente parado....claaaaaro!

Los parametros ha cambiar en la ruta
"HKEY_LOCAL_MACHINE - SOFTWARE - VMware, Inc. - VMware VirtualCenter-DB":



En el siguiente hilo se trata este tema: https://communities.vmware.com/thread/308260 donde podeis encontrar los pasos a seguir:


Then go to registry and browse to 
HKEY_LOCAL_MACHINE - SOFTWARE - VMware, Inc. - VMware VirtualCenter - DB

You will see 1,2,3,4,5.  Change them as follows:
1. Should be the name of your ODBC Connection name.
2. This is your oracle username you use.
3. This is for your password.  We can generate a hashed version of your password later, so don't touch.
4. This is the ODBC driver.  You should change it from "SQL Native Client" or whatever it is to "Oracle"
5. This is the version.  You should be able to leave this.

Now in cmd prompt run C:\Program Files\VMware\Infrastructure\VirtualCenter Server\vpxd.exe -p
Enter your Oracle password.
Now start your service.  If it starts correctly then all is well.

I have recently moved from Oracle to MSSQL 2008R2.  I opted to create a new vCenter server and migrate all of my data using PowerCLI scripts.  I feel this is a bit cleaner.