Thursday Feb 25, 2016

Supported Remote Database Versions

I saw a couple of questions recently about database versions. One of the recent changes in Ops Center 12.3.1 was support for Oracle Database 12.1.0.2. If you have an embedded database, the database is automatically upgraded when you upgrade OC to 12.3.1.

The questions, though, were about what happens if you have a customer-managed database.

"If I'm upgrading to 12.3.1 with a customer-managed database, do I have to upgrade the DB to 12.1.0.2?"

 Nope. Oracle Database 11.2.0.3.0 or 11.2.0.4.0 are still supported for the remote DB, so you don't have to upgrade.

"What about a fresh installation?"

The same is true for a new installation. You can take a look at the Cert Matrix to see what's supported for what.

Thursday Dec 17, 2015

Changing the Remote Database Location

One of the benefits of using a customer-managed database with Ops Center is greater control over the database - you decide how it should be backed up, what system you want it on, and so on. This gives you the ability to move the database to a new system as well. But that raises a question - how do you get Ops Center to use the new DB location?

This is a process that you complete from the command line. There are a few big steps:

  1. Shut down the Enterprise Controller.
  2. Point the EC to the new DB location.
  3. Export the data from the old DB.
  4. Import the data on the new DB.
  5. Start the EC again.

Here's a link to the document that explains these steps in detail.

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
« June 2016
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
  
       
Today