Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
 
Search the VMware Knowledge Base (KB)   View by Article ID
 

vCenter Server 4.1 installation rolls back when updating the database (1028651)

Symptoms

  • A vCenter Server 4.1 installation rolls back when updating the database.
  • In the vpxd.log (located at C:\Documents and Settings\All Users\Application Data\VMware\VirtualCenter\logs), you see the error:
Section for VMware VirtualCenter, pid=2584, version=4.1.0, build=build-258902, option=Release
[2010-09-23 15:54:45.580 03752 info 'App'] Current working directory: C:\Windows\system32
[2010-09-23 15:54:45.580 03752 info 'App'] Log path: C:\ProgramData\VMware\VMware VirtualCenter\Logs
[2010-09-23 15:54:45.580 03752 info 'App'] Initializing SSL
[2010-09-23 15:54:45.580 03752 info 'Libs'] Using system libcrypto, version 9080CF
[2010-09-23 15:54:47.299 03752 info 'App'] Vmacore::InitSSL: doVersionCheck = true, handshakeTimeoutUs = 120000000
[2010-09-23 15:54:47.315 03752 info 'App'] [VpxdVdb] Converted munged password in registry
[2010-09-23 15:55:18.440 03752 error 'App'] A database error occurred: "ODBC error: (HY000) - [Oracle][ODBC][Ora]ORA-06550: line 17, column 2:
PLS-00201: identifier 'DBMS_JOB' must be declared
ORA-06550: line 17, column 2:
PL/SQL: Statement ignored
ORA-06550: line 25, column 1:
PLS-00201: identifier 'DBMS_JOB' must be declared
ORA-06550: line 25, column 1:
PL/SQL: Statement ignored
" is returned when executing SQL statement "declare varjobid int;
        v_job_number number(10);
TYPE cur_type IS REF CURSOR;
objectcursor cur_type;
Begin
 open objectcursor for
select job
from user_jobs
where what = 'begin stats_rollup1_proc; Purge_Stat1_proc; end;';
Loop
        fetch objectcursor into varjobid;
        exit when objectcursor%NOTFOUND;
        dbms_job.remove (job => varjobid);
End Loop;
Close objectcursor;
begin
dbms_job.submit(
        job => v_job_number,
   what=> 'begin stats_rollup1_proc; Purge_Stat1_proc; end;',
   next_date=>sysdate+1/24,
   int"
[2010-09-23 15:55:18.565 03752 error 'App'] [VpxdLdap] Failed to init tableDef: Vdb instance is not initialized or terminated
[2010-09-23 15:55:18.565 03752 error 'App'] [VpxdLdap] Failed to initialize LDAP backups

Resolution

This issue can occur if the appropriate dbschema scripts are not executed against this Oracle vCenter Server database. For more information about these scripts, see step 3 and 4 in Use a Script to Create the Oracle Database Schema (Optional) in the ESX and vCenter Server Installation Guide
 
To resolve this issue:  
  1. Open a SQL*Plus window with a user that has schema owner rights on the vCenter Server database.
  2. Locate the dbschema scripts in the vCenter Server installation package at /<installation directory>/vpx/dbschema.
  3. In SQL*Plus, run these scripts in sequence on the database:
Note: <path> is the directory path to the /<installation directory>/vpx/dbschema folder.
 
@<path>/VCDB_oracle.SQL
@<path>/load_stats_proc_oracle.sql
@<path>/purge_stat1_proc_oracle.sql
@<path>/purge_stat2_proc_oracle.sql
@<path>/purge_stat3_proc_oracle.sql
@<path>/purge_usage_stats_proc_oracle.sql
@<path>/stats_rollup1_proc_oracle.sql
@<path>/stats_rollup2_proc_oracle.sql
@<path>/stats_rollup3_proc_oracle.sql
@<path>/cleanup_events_oracle.sql
@<path>/delete_stats_proc_oracle.sql
@<path>/load_usage_stats_proc_oracle.sql
@<path>/TopN_DB_oracle.sql
@<path>/calc_topn1_proc_oracle.sql
@<path>/calc_topn2_proc_oracle.sql
@<path>/calc_topn3_proc_oracle.sql
@<path>/calc_topn4_proc_oracle.sql
@<path>/clear_topn1_proc_oracle.sql
@<path>/clear_topn2_proc_oracle.sql
@<path>/clear_topn3_proc_oracle.sql
@<path>/clear_topn4_proc_oracle.sql
@<path>/rule_topn1_proc_oracle.sql
@<path>/rule_topn2_proc_oracle.sql
@<path>/rule_topn3_proc_oracle.sql
@<path>/rule_topn4_proc_oracle.sql

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 1 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)
  • 1 Ratings
Actions
KB: