Thursday May 21, 2015

Special Database Options

When you're installing Ops Center, you have two options for the product database: You can use an embedded database, that's automatically installed on the Enterprise Controller and managed by Ops Center, or you can use a remote database that you manage yourself.

With regards to the customer-managed database, I saw an important question recently: When you install this database, do you have to enable any of the advanced or special features? Some folks want to use the bare minimum installation for security reasons.

The answer here is that Ops Center only requires the base installation; no special features are used. As long as you're using one of the DB versions listed in the Certified Systems Matrix, you're golden.

Thursday Feb 26, 2015

Database License

I saw a question about Ops Center's database license recently:

"Ops Center comes with a license for an Oracle Database. What if I want to set up multiple databases in a RAC? Is that covered by this license?"

The answer here is that Ops Center only comes with a license for a single instance of an Oracle Database. This can be either the embedded database or a single customer-managed database. If you want to set up multiple databases in a RAC for use by Ops Center, you'll need separate licenses for all but one of them.

Thursday Jan 29, 2015

Database Versions

I've seen a few questions about what Oracle Database versions are supported with which versions of Ops Center, so I thought I'd clarify that point a bit.

 If you're using Ops Center 12.2.2, the latest version, and you have a customer-managed database, you can use Oracle Database 11.2.0.3 or 11.2.0.4. If you're using an embedded database, the upgrade to Ops Center 12.2.2 includes an upgrade of the embedded database to 11.2.0.4.

If you're using Ops Center 12.2.0 or 12.2.1, the supported database version is 11.2.0.3, for both embedded and customer-managed databases.

Thursday Sep 19, 2013

Moving the DB to a new location

I got a question about the database location:

"Ops Center installs an embedded Oracle database in /var, but we'd like to move it to another directory. Is this possible?"

So, theoretically you could change the location on an embedded database, by stopping the EC and doing some ZFS juggling to move the /var/opt/sun/xvm/oracle directory contents to a new directory and mounting it to /var/opt/sun/xvm/oracle, but there's an easier (and officially supported) way to do this.

The officially supported way is to switch to a customer-managed database. This database can be located anywhere you want, so you can give it as much space as you need.

Thursday May 30, 2013

How To: Access the Ops Center Database

Ops Center uses an Oracle Database to store product data. Normally you'll use the Ops Center UI and won't access the database directly, but it can occasionally be useful to see the database contents directly.

We've put together a How-To that explains how to view the database directly. You can make this connection either using Oracle SQL Developer, or from the command line using SQL*Plus. The How-To walks you through both procedures.

About

This blog discusses issues encountered in Ops Center and highlights the ways in which the documentation can help you

Search

Archives
« May 2015
SunMonTueWedThuFriSat
     
1
2
3
4
5
6
8
9
10
11
12
13
15
16
17
18
19
20
22
23
24
25
26
27
28
29
30
31
      
Today