Solved

Help with setting up Oracle database for Vmware Vcenter server

Posted on 2011-02-17
12
1,874 Views
Last Modified: 2013-12-19
Hey everyone,

  I am trying to setup vcenter server to run on an Oracle database in a test environment.  I am having problems with the setup of the Oracle database.  I am an Oracle noob and dont have a lot of database exp; so I am probably missing some easy steps.  Below are the instructions from Vmware on how to setup an Oracle database.

I have made it through steps 1 and 2; I believe I have done them correctly.  But once again I am an Oracle noob.  Steps 3 - 6 appear to be optional so I have skipped them.  Step 7 I downloaded a generic Oracle ODBC driver and tried to connect it to the newly created database.  But I am having no luck.  It is possible I am not properly configuring the connection and/or the database is not properly setup.  Again, please see the instructions below.

Your help is appreciated!


 

1) Create the vCenter Server database. Logon to a SQL Plus session with the system account and run the following script to create the database:
 
CREATE SMALLFILE TABLESPACE "VPX" DATAFILE '/u01/app/oracle/oradata/vcdb/vpx01.dbf'

SIZE 1G AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT

SPACE MANAGEMENT AUTO;


2) Run following SQL command to Create a vCenter Server database user with the correct permissions. (In this example, VPXADMIN is the username.)

CREATE USER "VPXADMIN" PROFILE "DEFAULT" IDENTIFIED BY "oracle" DEFAULT TABLESPACE

"VPX1" ACCOUNT UNLOCK;
      grant connect to VPXADMIN;
      grant resource to VPXADMIN;
      grant create view to VPXADMIN;
      grant create sequence to VPXADMIN;
      grant create table to VPXADMIN;
      grant create materialized view to VPXADMIN;
      grant execute on dbms_lock to VPXADMIN;
      grant execute on dbms_job to VPXADMIN;
      grant unlimited tablespace to VPXADMIN;

3) Open a SQLPlus window with a user having schema owner rights on the vCenter Server database. (optional)

4) Locate the dbschema scripts in the vCenter Server installation package bin/dbschema directory. (optional)

5) Run the scripts in sequence on the database in SQLPlus.  (<path> is the directory path to the bin/dbschema folder) (optional)

      @<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
      @<path>/process_license_snapshot_oracle.sql

6) For all supported editions of Oracle Server, Run these additional scripts to set up scheduled jobs on the database.(optional)

      @<path>/job_schedule1_oracle.sql
      @<path>/job_schedule2_oracle.sql
      @<path>/job_schedule3_oracle.sql
      @<path>/job_cleanup_events_oracle.sql
      @<path>/job_topn_past_day_oracle.sql
      @<path>/job_topn_past_week_oracle.sql
      @<path>/job_topn_past_month_oracle.sql
      @<path>/job_topn_past_year_oracle.sql

7) On the machine on which you intend to install vCenter Server, create a data source name (DSN) that points to the database server with the vCenter Server schema.

8) Run the vCenter Server installer and, when prompted, provide the database user login.
0
Comment
Question by:wyrickits
  • 4
  • 3
  • 2
  • +1
12 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 334 total points
ID: 34917487
3-6 appear to me to actually set up the database objects.

You mentioned you downloaded a generic Oracle odbc driver?  When you installed Oracle you could have selected the ODBC drivers as part of the initial install.  You shouldn't have to download additional ones.

Do you not see any Oracle ODBC drivers when you are trying to create the DSN?

0
 

Author Comment

by:wyrickits
ID: 34917528
Okay so you would recommend running steps 3 - 6?

I must have missed the ODBC driver install when I installed Oracle 11g.  Whats the best way to go about installing the driver after the install?  Add/remove programs and change the installation?

Thx!
0
 

Author Comment

by:wyrickits
ID: 34917587
Also, I did not see any Oracle ODBC drivers after the install; so I downloaded one from easysoft.
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 334 total points
ID: 34918080
>>Okay so you would recommend running steps 3 - 6?

Don't know.  I've never setup vCenter.

>>Whats the best way to go about installing the driver after the install?  

rerun the Oracle installer.  I forget the exact option but the parrent selection should meniton Data rpoviders.  ODBC is a selection under that.

>>so I downloaded one from easysoft.

To talk to an Oracle database, you need Oracle installed drivers from Oracle corporation (One exception is JDBC but that is a different issue).
0
 
LVL 16

Assisted Solution

by:danm66
danm66 earned 166 total points
ID: 34920627
creating the schema is optional as the install can do it, but you must install the oracle client on the VC for it to be able to connect to the DB.
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

Author Comment

by:wyrickits
ID: 35384357
never figured it out. please close
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35384429
Arbitrarily deleting a question to bypass the new question lock is not proper use of the site.

If you needed further assistance on this all you had to do is ask.  Since you never responded from the last two Expert posts, we have to conclude we helped answer the question.
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35386893
I suggest split:

http:#a34917487
http:#a34918080

Since the asker mentions "I have made it through steps 1 and 2", the comment in http:#a34920627 doesn't seem relevant.
0
 
LVL 16

Expert Comment

by:danm66
ID: 35387529
My brief post was in direct response to:

 
>>Okay so you would recommend running steps 3 - 6?

Don't know.  I've never setup vCenter.

Either way, the points don't matter to me so do as you please.
0
 

Expert Comment

by:WhackAMod
ID: 35446423
Starting closing process on behalf of the asker.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Will try to explain how to use the VMware feature TAGs in the VMs and create Veeam Backup Jobs using TAGs. Since this article is too long, I will create second article for the Veeam tasks.
In this step by step tutorial with screenshots, we will show you HOW TO: Enable SSH Remote Access on a VMware vSphere Hypervisor 6.5 (ESXi 6.5). This is important if you need to enable SSH remote access for additional troubleshooting of the ESXi hos…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now