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