I encountered sudden VirtualCenter service shutdown due to DB error. However, DB connectivity is fine I went to oracle odbc on my server and tested the same... after this vCenter service is not starting up. Please find the event viewer error message below. I have couple of questions more which i have included after the error message.
Event Type: Error
Event Source: VMware VirtualCenter Server
Event Category: None
Event ID: 1000
Time: 11:04:07 PM
The description for Event ID ( 1000 ) in Source ( VMware VirtualCenter Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: An unrecoverable problem has occurred, stopping the VMware VirtualCenter service. Check database connectivity before restarting. Error: Error[VdbODBCError] (-1) "ODBC error: (HY000) - [ODBC][Ora]ORA-01653: unable to extend table VPX_OWNER.VPX_EVENT_ARG by 128 in tablespace VPX_DATA
" is returned when executing SQL statement "INSERT INTO VPX_EVENT_ARG (EVENT_ID, ARG_ID, ARG_TYPE, ARG_DATA, OBJ_TYPE, OBJ_NAME) VALUES (?, ?, ?, ?, ?, ?)".
Is oracle a good Database for vCenter installation? What are the best practices related to Oracle hosting a vCenter metadata DB?
I am only able to find best practices and fine tuning tips for SQL we dont have a robust SQL environment and Oracle is on a highly available environment hence that is recommended by enterprise security team and DB team
What happens if you restart the vCenter database instance on your oracle server, and start the VirtualCenter Server Service on your vCenter box?
Sorry, haven't had a great deal of experience with vCenter running on Oracle, as most customers have used MS SQL
Thanks guys ...
As u assumed capablanca it was due that the table space was less ... we increased the same and it fixed the issue.
Thanks a ton guys.