Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Allow deselecting database options during Oracle 12c multitenant installation

Pini DibaskSep 2 2015 — edited Jan 11 2016

I've noticed that during an installation of Oracle 12c with a container database (A.K.A multitenant), DBCA doesn't allow deselecting database options and force you to install all the optional database options.

dbca.png

I tried to figure if there's a workaround for this behaviour (DBCA 12.1.0.2 doesn't allow deselect database options) but it seems like it's by design and there's no workaround.

I think it would be nice if Oracle will allow deselecting database options because the design has a few disadvantages:

  1. It makes the installation process much longer
  2. It consumes more disk space
  3. Installing unneeded database options may raise the chances to hit potential bugs.

Comments

ctrieb

Yes, this is very important to change this quickly.

2 people found this helpful
BPeaslandDBA

They aren't really options if you have no choice in the manner.

3 people found this helpful
Pravin Takpire

it is really important and required. It may also lead to Licensing issues

regards

Pravin

2 people found this helpful
LudovicoCaldara

The workaround is to generate the scripts and then edit them to skip some options. Mike Dietrich blogged about it.

But I agree that DBCA should allow the selection.

I'm pretty convinced that this feature will come with the next release, after Oracle has announced that you can skip some options manually.

(Note: I'm guessing)

3 people found this helpful
Peter_L_

also see here

Doc ID 2001512.1

1 person found this helpful
Sven W.

The workaround is to generate the scripts and then edit them to skip some options. Mike Dietrich blogged about it.

But I agree that DBCA should allow the selection.

I'm pretty convinced that this feature will come with the next release, after Oracle has announced that you can skip some options manually.

(Note: I'm guessing)

Problem with using scripts is that some things are not supported anymore when using a script.

A workaround might be to use the script that the DBCA creates and then manipulate that one.

For example if you install the Database JSOn bundle patch 2, then this requires Oracle Text. Oracle Text btw. is not a license cost option.

Doc ID 1992767.1

"JSON functionality in 12.1.0.2.13 and above has a dependency on Oracle Text.

  • If the user plans to use the JSON functionality in DBBP13, then the user must make sure Oracle Text is installed before installing DBBP13. Please note, it is only supported to install Oracle Text by using DBCA. Manual installation/deinstallation of Oracle Text is not supported in 12.1.0.x. You now have to use the Database Configuration Assistant (DBCA) to add Oracle Text."
Sven W.

it is really important and required. It may also lead to Licensing issues

regards

Pravin 

Pravin Takpire wrote:
it is really important and required. It may also lead to Licensing issues
regards
Pravin

Would you backup this statement, by giving an example where installing all those options would lead to a licensing issue?

I think (but I'm not sure in all cases) that simply installing the options using DBCA will not violate any license. Also some of the "features" are needed to provide certain special functionality. That might be one of the reasons, why the feature can not be deactivated.

Example from https://docs.oracle.com/database/121/DBLIC/editions.htm#DBLIC116

The "Spatial and Graph Data" option is an extra cost option. However we can use the SDO_GEOMETRY datatype and also

"Single master/materialized view replication for SDO_GEOMETRY objects is supported with both Standard Edition, Standard Edition 2, and Enterprise Edition"

The problem with licenses arises once a developer or admin starts to use spatial features that are part of the extra cost option.

Installing does not hurt any license agreement, afaik.

1 - 7

Post Details

Added on Sep 2 2015
#active, #database-ideas, #database-ideas-ideas
7 comments
711 views