Oracle Business Intelligence: 2018

Monday, 12 November 2018

OBIEE 12c File Locations

If you wonder, where are RPD, Catalog and all the other locations in OBIEE 12c. Here is the path to few files:

Live RPD Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/bidata/service_instances/ssi/metadata/datamodel/customizations

Catalog Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/bidata/service_instances/ssi/metadata/content

To Start, Stop or Start and Deploy RPD BI Sevices [start.sh, stop.sh, status.sh, datamodel.sh]:
[ORACLE_BI_HOME]/user_projects/domains/biee/bitools/bin

To Start/ Stop Weblogic Server, NodeManager
[startNodeManager.sh, stopNodeManager.sh, stopWeblogic.sh, startWeblogic.sh]:
[ORACLE_BI_HOME]/user_projects/domains/biee/bin

InstanceConfig.xml Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/biconfig/OBIPS

NQSConfig.INI Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/biconfig/OBIS

ssl Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/biconfig/core/ssl

ODBC.ini Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/bienv/core

obis.properties Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/bienv/OBIS

Catalog Manager:
[ORACLE_BI_HOME]/bi/bifoundation/web/catalogmanager

Cheers!
Bose

Saturday, 10 November 2018

OBIEE 12c with MySQL Community Edition Connectivity

This post brings the workaround on How to connect OBIEE 12c Environment with MySQL Server Community Edition.
This is Tested on OBIEE 12.2.1.3.0

Assumption :
OBIEE 12c comes with DataDirect Connections and support only for Enterprise Edition. But our requirement is to connect Community Edition as our DW is developed in there.

MySQL Community Edition ( i.e. FREE edition )
Server OS is Redhat 7 64-bit

Import tables in OBIEE Admin Tool
Download latest ODBC Driver and Install, set up DSN, , Create connection pool, Import metadata, Define business and presentation layers.

Problem:
Data Direct Drivers are shipped to connect OBIEE to MySQL. Unfortunately these do not work as you get a message "[nQSError: 16001] ODBC error state: S1000 code: 0 message: [DataDirect][ODBC MySQL Wire Protocol driver]Connections to MySQL Community Servers are not supported. Please contact MySQL to obtain a MySQL Enterprise or Commercial version.."

Solution:
Step1:
Use MySQL native ODBC instead of DataDirect ODBC.

You can get these from
http://dev.mysql.com/downloads/connector/odbc/#downloads

This is an rpm download and install, you need root privileges to do this. DO NOT DOWNLOAD THE ANSI driver as it does not work.
We have to download for Redhat 64bit Server:
mysql-connector-odbc-setup-8.0.13-1.el7.x86_64.rpm

Step2:
Update the configuration in ODBC.ini

Go to the following directory and update the ODBC.ini file like below:

ORACLE_BI_HOME/domains/biee/config/fmwconfig/bienv/core

Note: We can use either OBDC Driver (libmyodbc8w) or ANSI Driver(libmyodbc8a).

[MySQLDevTest]
Driver = /usr/lib64/libmyodbc8a.so
Description = Connector/ODBC 8.0 ANSI Driver DSN
SERVER = mysql.dbhostname.com
PORT = 3306
USER = username
Password = password
Database = dbname
OPTION = 3

Step3:

Go to the following directory and update the obis.properties file for LD_LIBRARY_PATH to point OBDC Driver.

ORACLE_BI_HOME/domains/biee/config/fmwconfig/bienv/OBIS

e.g.

"LD_LIBRARY_PATH" value="/usr/lib64:$ORACLE_HOME/common/ODBC/Merant/6.0SP1/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/clients/epm/Essbase/EssbaseRTC/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib"

Import Points to Note:

Connection Pool Name, ODBC.ini configuration in OBDC Data Sources name and MYSQL configuration name has to be same.

E.g: MySQLConnTest

Cheers!

Bose

Starting and Stopping OBIEE 12c Services in Linux

Go to the following directory:

/obiee/Oracle/Middleware/Oracle_Home/user_projects/domains/biee/bitools/bin

Run the below commands to start, stop or to know the status of entire services.

To Stop All the Services

[root@obiee bin] ./stop.sh

To Know the Status of All Services:

[root@obiee bin] ./status.sh

To Start all BI Services

[root@obiee bin] ./start.sh

To particularly start or stop one or few services use below commands

Syntax:

./start.sh -i service_name1, service_name2

e.g: [root@obiee bin] ./start.sh -i obis1

./stop.sh -i servicename1, servicename2

[root@obiee bin] ./stop.sh -i obis1

In Windows, instead of .sh use .cmd. for Example. start.cmd

Cheers!

Bose

Friday, 9 November 2018

Setting Java Home in Linux

Edit the .bashrc or .bash_profile file and add the below line:

[$] vi .bashrc

export JAVA_HOME="Enter_the_Java_Home_Directory"

e.g: export JAVA_HOME=/app/JDK/jdk1.8

Here is the complete steps:

https://access.redhat.com/documentation/en-US/JBoss_Communications_Platform/5.0/html/Platform_Installation_Guide/sect-Configuring_Java.html

After updating it, just source the file so it would be effective immediately and you could verify with the below command

[$] source .bashrc

[$] echo $JAVA_HOME

Cheers!
Bose

Friday, 2 November 2018

Starting and Stopping Oracle Listener in UNIX

Below oracle link is having enough thorough information handling Oracle Listener services in LINUX/UNIX

https://docs.oracle.com/cd/B28359_01/server.111/b32009/strt_stp.htm#UNXAR173

Thursday, 1 November 2018

UsageTracking in OBIEE 12c

UsageTracking:

The Oracle BI Server supports the accumulation of usage tracking statistics that can be used in a variety of ways such as database optimization, aggregation strategies, or billing users or departments based on the resources that they consume. The BI Server tracks usage at the detailed query level.

When you enable usage tracking, statistics for every query are inserted into a database table or are written to a usage tracking log file. If you use direct insertion, then the BI Server directly inserts the usage tracking data into a relational database table. It is recommended that you use direct insertion to write statistics to a database table.

When the BI Server starts, it validates the column names in the metadata against the list of valid columns in the usage tracking table. The following events occur:

To set up the usage tracking statistics database:

If we have the OBIEE in place already then we have RCU schmeas ready and Installed in our database which has all the tables required for Usagetracking

The RCU-created table names for usage tracking are S_NQ_ACCT, S_NQ_DB_ACCT, and S_NQ_INITBLOCK.

Setting up direct insertion usage tracking:

On the Oracle BI Server computer, open the NQSConfig.INI file in a text editor. You can find this file at:
BI_DOMAIN/config/fmwconfig/biconfig/OBIS
Make a backup copy of the file before editing.
In the [USAGE_TRACKING] section, update the following parameters:

Set ENABLE to YES.
Set DIRECT_INSERT to YES.
Set PHYSICAL_TABLE_NAME to the name of the fully-qualified database table for collecting query statistic information, as it appears in the Physical layer of the Oracle BI repository. For example:
```
PHYSICAL_TABLE_NAME = "My_DB"."DEV_BIPLATFORM"."S_NQ_ACCT";
```
Set CONNECTION_POOL to the name of the fully-qualified connection pool for the query statistics database, as it appears in the Physical layer of the Oracle BI repository. For example:
```
CONNECTION_POOL = "My_DB"."Usage Connection Pool";
```
Set INIT_BLOCK_TABLE_NAME to the name of the fully-qualified database table for inserting records that correspond to the initialization block statistics, as it appears in the Physical layer of the Oracle BI repository. For example:
```
INIT_BLOCK_TABLE_NAME = "My_DB"."DEV.BIPLATFORM"."S_NQ_INITBLOCK;
```
Set INIT_BLOCK_CONNECTION_POOL to the name of the fully-qualified connection pool for the table for inserting records that correspond to the initialization block statistics, as it appears in the Physical layer of the Oracle BI repository. For example:
```
INIT_BLOCK_CONNECTION_POOL = "My_DB"."Usage Connection Pool";
```

Save and close the file.
Restart the Oracle BI Server.

Note:

A sample usage tracking repository model is provided with the Oracle Business Intelligence installation at: ORACLE_HOME/bi/bifoundation/samples/usage_tracking.bar.

This path applies to 12c versions, but does not apply to earlier versions.

To use the sample usage tracking repository, you modify the connection pool to point to your database, then merge the usage tracking repository with your existing repository.

Refer here: https://docs.oracle.com/middleware/1221/biee/BIESG/usage_track.htm#BIESG189

Cheers!

Bose

Adding Environment Variable in bash_profile in Linux

In a oracle BI environment, I had the following variables but I had to create it every time when I login into putty.
So How can we create an environment variable so It will be always there in server even after my session ends and I can access it all the time.

ORACLE_BI_HOME
ORACLE_BI_DOMAIN_HOME
LD_LIBRARY_PATH

Here is the solution:

open a file and save all your environment variables in it and add that file in bash_profile file.

Here I have opened eraclebi_env.sh file to have all my variables added the path.

Now open your bash_profile and the environment file path to this profile file like mentioned in the below sceenshot.

Now run env or echo $env_name to check the variables.

Downloading and Uploading RPD in OBIEE 12c

Here is steps on how to download and upload RPD in OBIEE 12c

Upload RPD:

**********************************************************************

Step1:
Go to the following path
/obiee/Oracle/Middleware/Oracle_Home/user_projects/domains/biee/bitools/bin

[root@obiee bin]$ cd <$DOMAIN_HOME>/bi/bitools/bin

Step2:
Enter the following commands in shell to upload the RPD:

Syntax:
./datamodel.sh uploadrpd -I /home/bose/Sample.rpd -W RPDPasword -SI ssi -U weblogic -P WeblogicPassword

Example:
[bose@oracle bin]$ ./datamodel.sh uploadrpd -I /home/pcs_user/Sample.rpd -SI ssi -U weblogic -P Admin123 -W Admin123

Service Instance: ssi
Operation successful.
RPD upload completed successfully.

Download RPD:

*****************************************************

Step1:
Go to the following path
cd $ORACLE_BI_DOMAIN_HOME/bi/bitools/bin

[root@obiee bin]$ cd $DOMAIN_HOME/bi/bitools/bin

Step2:
Enter the following commands in shell to download the RPD

Syntax:
./datamodel.sh downloadrpd -O /home/bose/Sample1.rpd -W RPDPassword -SI ssi -U weblogic -P WeblogicPassword

Example:
[bose@oracle bin]$ ./datamodel.sh downloadrpd -O /home/bose/Sample.rpd -SI ssi -U weblogic -P Admin123 -W Admin123

Operation successful.
RPD download completed successfully.

If Your OBIEE is installed in Windows Server or using window shell script, Use datamodel.cmd instead of datamodel.sh

Syntax:

I - Input Directory

O - Output Directory

P - Admin Password

W - Repository Password

U - Admin User Name

SI - Service Instance

Cheers!

Bose

OBIEE 12c (12.2.1.4.0) is Awailable for Download

OBIEE 12c (12.2.1.4.0) Download Link:

https://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/default-4441820.html

OBIEE 12c (12.2.1.3.0) Download link:

https://www.oracle.com/technetwork/middleware/bi/downloads/default-3852322.html

OBIEE 12c Tutorials:

If would like to learn on creating BI Dashboards and RPD, then the following link will help us to learn.

https://www.oracle.com/technetwork/middleware/bi-enterprise-edition/tutorials/index.html

Cheers!

Bose

Wednesday, 31 October 2018

Oracle DB 11g Silent Installation

Following links will help us to do the silent installation of Oracle Database 11g with Linux.

https://oracle-base.com/articles/misc/oui-silent-installations

http://dbaora.com/install-oracle-in-silent-mode-11g-release-2-11-2/

https://www.eproseed.com/installation-and-oracle-database-creation-in-silent-mode/

Cheers!
Bose

Sunday, 14 October 2018

Creating Impersonated User in OBIEE 12c

Here is the steps to create Impersonate Users:

Precheck:
Please create the user in console to which you want to apply impersonator

Step1:

From the Weblogic Domain menu, select Security.
Click Application Policies.

Step2:

Click Application Policies.
Click Create to display the Create Application Grant page.

Step3:

In the Permissions section, click + Add .
Select Resource Types
Select oracle.bi.user from the Resource Type list.
Click Continue to display the Add Permission dialog.
Enter an asterisk (*) in the Resource Name field and click Next

Step4:

Select impersonate in the Permission Actions section.
Click Select.

Step5:

Now add a new grantee.
In the Grantee section click + Add to display the Add Principal dialog.

Step6:

We can choose to grant the newly created permission to either an application role or a user. In this example, we choose a user.
Select User from the drop-down list.

Step7:

Here I have selected the user BIImpersonatorUser that I have created in console.

Cheers!
Bose

Wednesday, 10 October 2018

Go URL with Parameters Example in OBIEE 12c (12.2.1.3.0)

This post will give the example on Go URL.

From OBIEE 12.2.1.3.0, Lightweight SSO is enabled. So we have to disable it first to work with Go URL. To Know and Disabling the Lightweight SSO, Refer Here

By default, you can add up to 100 parameters to the URL. However, you can adjust the number of parameters by modifying the Prompts/MaxPromptedURLParams setting in instanceconfig.xml.

&Action=Navigate

&P0=n where n is the number of columns you wish to filter, currently 1 - 6.

&P1=op where op is one of the following operators.

Operator	Meaning
eq	Equal to or in.
neq	Not equal to or not in.
lt	Less than.
gt	Greater than.
ge	Greater than or equal to.
le	Less than or equal to.
bwith	Begins with.
ewith	Ends with.
cany	Contains any (of the values in &P3).
call	Contains all (of the values in &P3).
like	You need to type %25 in place of the usual % wildcard. See the examples that follow.
top	&P3 contains 1+n, where n is the number of top items to display.
bottom	&P3 contains 1+n, where n is the number of bottom items to display.
bet	Between (&P3 must have two values).
null	Is null (&P3 must be 0 or omitted).
nnul	Is not null (&P3 must be 0 or omitted).
&P2=ttt.ccc	In this parameter, ttt is the table name and ccc is the column name. If the table or column contains spaces, it must be quoted with double-quotes. Spaces should be escaped as %20, for example, Measures."Dollar%20Sales".

Example:
http://localhost:9502/analytics/saw.dll?Go&Path=%2fshared%2fTest%2fAnalysis%2fSales&Options=rmf&Action=Navigate&P0=2&P1=eq&P2=%22Operating%20Unit%22.%22Operating%20Unit%20Name%22&P3=CAL&P4=eq&P5=Time.Year&P6=2+2016+2017

Decoding the above example:
It has Action=Navigate
P0=2 which means has 2 columns for parameters
p1=eq means Equal operator applied
P2=Opearting Unit Name column from Operating Unit Table
P3=Value of the P2. (example here is CAL)
P4=eq is another equal operator for another columns
P5=Year column from Time Table
P6=2+2016+2017 means Year has two values which 2016 and 2017

SQL Issued By BI is like:

WHERE ( ("Time"."Year" IN ('2016', '2017')) AND ("Operating Unit"."Operating Unit Name" = 'CAL')) FETCH FIRST 65001 ROWS ONLY

Complete Oracle Reference Guide - Click Here

Cheers!
Bose

Tuesday, 2 October 2018

Go URL in OBIEE 12c

Problem:

When we are trying to use Go URL functionality, It always comes to login page.

Why is it happening?

With 12c, 12.2.1.2+ A new feature called Light Weight SSO has been introduced.

When this feature is enabled, using "NQUser"/"NQPassword" in the URL is not possible or supported.

Lightweight SSO is implemented by default in new installations of Oracle BI EE release 12.2.1.3.0

Solution:

Disabling the Lightweight SSO will help us to overcome this issue and Report/Dashboard with Go URL will just fine without going to login page.

Steps to Disable Lightweight SSO:

Step1:

Stop all the BI Services. Go to the link to know Stop and Start BI 12c Services

Step2:

After stopping the BI Services, Go to the following path and execute WLST offline

[ORACLE_BI_HOME]/oracle_common/common/bin/wlst.sh

execute the 'disableBISingleSignOn' command to disable.

wls:/offline> disableBISingleSignOn('/path to your domain')

e.g:

wls:/offline> disableBISingleSignOn('$ORACLE_BI_HOME/user_projects/domains/bi')

Step3:

Now Start all the BI Services using ./start.sh (Linux) or Start.cmd (Windows) and check with the Go URL.

Cheers!

Bose

Tuesday, 1 May 2018

dbca.rsp file for for Oracle Database 12.1.0.2.0 Silent Installation

##############################################################################

## ##

## DBCA response file ##

## ------------------ ##

## ##

## Specify values for the variables listed below to customize Oracle ##

## Database Configuration installation. ##

## ##

## Each variable is associated with a comment. The comment identifies the ##

## variable type. ##

## ##

## Please specify the values in the following format : ##

## Type : Example ##

## String : "<value>" ##

## Boolean : True or False ##

## Number : <numeric value> ##

## StringList : {"<value1>","<value2>"} ##

## ##

## Examples : ##

## 1. dbca -progress_only -responseFile <response file> ##

## Display a progress bar depicting progress of database creation ##

## process. ##

## ##

## 2. dbca -silent -responseFile <response file> ##

## Creates database silently. No user interface is displayed. ##

## ##

## 3. dbca -silent -createDatabase -cloneTemplate ##

## -responseFile <response file> ##

## Creates database silently with clone template. The template in ##

## responsefile is a clone template. ##

## ##

## 4. dbca -silent -deleteDatabase -responseFile <response file> ##

## Deletes database silently. ##

##############################################################################

#-----------------------------------------------------------------------------

# GENERAL section is required for all types of database creations.

#-----------------------------------------------------------------------------

[GENERAL]

#-----------------------------------------------------------------------------

# Name : RESPONSEFILE_VERSION

# Datatype : String

# Description : Version of the database to create

# Valid values : "12.1.0"

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

RESPONSEFILE_VERSION = "12.1.0"

#-----------------------------------------------------------------------------

# Name : OPERATION_TYPE

# Datatype : String

# Description : Type of operation

# Valid values : "createDatabase" \ "createTemplateFromDB" \ "createCloneTemplate" \ "deleteDatabase" \ "configureDatabase" \ "addInstance" (RAC-only) \ "deleteInstance" (RAC-only) \ "createPluggableDatabase" \ "unplugDatabase" \ "deletePluggableDatabase" \ "configurePluggableDatabase"

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

OPERATION_TYPE = "createDatabase"

#-----------------------*** End of GENERAL section ***------------------------

#-----------------------------------------------------------------------------

# CREATEDATABASE section is used when OPERATION_TYPE is defined as "createDatabase".

#-----------------------------------------------------------------------------

[CREATEDATABASE]

#-----------------------------------------------------------------------------

# Name : GDBNAME

# Datatype : String

# Description : Global database name of the database

# Valid values : <db_name>.<db_domain> - when database domain isn't NULL

# <db_name> - when database domain is NULL

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

GDBNAME = "ORCL"

#-----------------------------------------------------------------------------

# Name : DATABASECONFTYPE

# Datatype : String

# Description : database conf type as Single Instance, Real Application Cluster or Real Application Cluster One Nodes database

# Valid values : SI\RAC\RACONENODE

# Default value : SI

# Mandatory : No

#-----------------------------------------------------------------------------

#DATABASECONFTYPE = "SI"

#-----------------------------------------------------------------------------

# Name : RACONENODESERVICENAME

# Datatype : String

# Description : Service is required by application to connect to RAC One

# Node Database

# Valid values : Service Name

# Default value : None

# Mandatory : No [required in case DATABASECONFTYPE is set to RACONENODE ]

#-----------------------------------------------------------------------------

#RACONENODESERVICENAME =

#-----------------------------------------------------------------------------

# Name : POLICYMANAGED

# Datatype : Boolean

# Description : Set to true if Database is policy managed and

# set to false if Database is admin managed

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#POLICYMANAGED = "false"

#-----------------------------------------------------------------------------

# Name : CREATESERVERPOOL

# Datatype : Boolean

# Description : Set to true if new server pool need to be created for database

# if this option is specified then the newly created database

# will use this newly created serverpool.

# Multiple serverpoolname can not be specified for database

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#CREATESERVERPOOL = "false"

#-----------------------------------------------------------------------------

# Name : SERVERPOOLNAME

# Datatype : String

# Description : Only one serverpool name need to be specified

# if Create Server Pool option is specified.

# Comma-separated list of Serverpool names if db need to use

# multiple Server pool

# Valid values : ServerPool name

# Default value : None

# Mandatory : No [required in case of RAC service centric database]

#-----------------------------------------------------------------------------

#SERVERPOOLNAME =

#-----------------------------------------------------------------------------

# Name : CARDINALITY

# Datatype : Number

# Description : Specify Cardinality for create server pool operation

# Valid values : any positive Integer value

# Default value : Number of qualified nodes on cluster

# Mandatory : No [Required when a new serverpool need to be created]

#-----------------------------------------------------------------------------

#CARDINALITY =

#-----------------------------------------------------------------------------

# Name : FORCE

# Datatype : Boolean

# Description : Set to true if new server pool need to be created by force

# if this option is specified then the newly created serverpool

# will be assigned server even if no free servers are available.

# This may affect already running database.

# This flag can be specified for Admin managed as well as policy managed db.

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#FORCE = "false"

#-----------------------------------------------------------------------------

# Name : PQPOOLNAME

# Datatype : String

# Description : Only one serverpool name needs to be specified

# if create server pool option is specified.

# Comma-separated list of serverpool names if use

# server pool. This is required to

# create Parallel Query (PQ) database. Applicable to Big Cluster

# Valid values : Parallel Query (PQ) pool name

# Default value : None

# Mandatory : No [required in case of RAC service centric database]

#-----------------------------------------------------------------------------

#PQPOOLNAME =

#-----------------------------------------------------------------------------

# Name : PQCARDINALITY

# Datatype : Number

# Description : Specify Cardinality for create server pool operation.

# Applicable to Big Cluster

# Valid values : any positive Integer value

# Default value : Number of qualified nodes on cluster

# Mandatory : No [Required when a new serverpool need to be created]

#-----------------------------------------------------------------------------

#PQCARDINALITY =

#-----------------------------------------------------------------------------

# Name : SID

# Datatype : String

# Description : System identifier (SID) of the database

# Valid values : Check Oracle12c Administrator's Guide

# Default value : <db_name> specified in GDBNAME

# Mandatory : No

#-----------------------------------------------------------------------------

SID = "orcl12c"

#-----------------------------------------------------------------------------

# Name : CREATEASCONTAINERDATABASE

# Datatype : boolean

# Description : flag to create database as container database

# Valid values : Check Oracle12c Administrator's Guide

# Default value : false

# Mandatory : No

#-----------------------------------------------------------------------------

CREATEASCONTAINERDATABASE =true

#-----------------------------------------------------------------------------

# Name : NUMBEROFPDBS

# Datatype : Number

# Description : Specify the number of pdb to be created

# Valid values : 0 to 252

# Default value : 0

# Mandatory : No

#-----------------------------------------------------------------------------

NUMBEROFPDBS =1

#-----------------------------------------------------------------------------

# Name : PDBNAME

# Datatype : String

# Description : Specify the pdbname/pdbanme prefix if one or more pdb need to be created

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

PDBNAME =PDB

#-----------------------------------------------------------------------------

# Name : PDBADMINPASSWORD

# Datatype : String

# Description : PDB Administrator user password

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

PDBADMINPASSWORD = "admin123"

#-----------------------------------------------------------------------------

# Name : NODELIST

# Datatype : String

# Description : Comma-separated list of cluster nodes

# Valid values : Cluster node names

# Default value : None

# Mandatory : No (Yes for RAC database-centric database )

#-----------------------------------------------------------------------------

#NODELIST=

#-----------------------------------------------------------------------------

# Name : TEMPLATENAME

# Datatype : String

# Description : Name of the template

# Valid values : Template file name

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

TEMPLATENAME = "General_Purpose.dbc"

#-----------------------------------------------------------------------------

# Name : OBFUSCATEDPASSWORDS

# Datatype : Boolean

# Description : Set to true if passwords are encrypted

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#OBFUSCATEDPASSWORDS = FALSE

#-----------------------------------------------------------------------------

# Name : SYSPASSWORD

# Datatype : String

# Description : Password for SYS user

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

SYSPASSWORD = "admin123"

#-----------------------------------------------------------------------------

# Name : SYSTEMPASSWORD

# Datatype : String

# Description : Password for SYSTEM user

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

SYSTEMPASSWORD = "admin123"

#-----------------------------------------------------------------------------

# Name : SERVICEUSERPASSWORD

# Datatype : String

# Description : Password for Windows Service user

# Default value : None

# Mandatory : If Oracle home is installed with windows service user

#-----------------------------------------------------------------------------

#SERVICEUSERPASSWORD = "password"

#-----------------------------------------------------------------------------

# Name : EMCONFIGURATION

# Datatype : String

# Description : Enterprise Manager Configuration Type

# Valid values : CENTRAL|DBEXPRESS|ALL|NONE

# Default value : NONE

# Mandatory : No

#-----------------------------------------------------------------------------

EMCONFIGURATION = "DBEXPRESS"

#-----------------------------------------------------------------------------

# Name : EMEXPRESSPORT

# Datatype : Number

# Description : Enterprise Manager Configuration Type

# Valid values : Check Oracle12c Administrator's Guide

# Default value : NONE

# Mandatory : No, will be picked up from DBEXPRESS_HTTPS_PORT env variable

# or auto generates a free port between 5500 and 5599

#-----------------------------------------------------------------------------

EMEXPRESSPORT = "5500"

#-----------------------------------------------------------------------------

# Name : RUNCVUCHECKS

# Datatype : Boolean

# Description : Specify whether to run Cluster Verification Utility checks

# periodically in Cluster environment

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#RUNCVUCHECKS = FALSE

#-----------------------------------------------------------------------------

# Name : DBSNMPPASSWORD

# Datatype : String

# Description : Password for DBSNMP user

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if EMCONFIGURATION is specified or

# the value of RUNCVUCHECKS is TRUE

#-----------------------------------------------------------------------------

DBSNMPPASSWORD = "admin123"

#-----------------------------------------------------------------------------

# Name : OMSHOST

# Datatype : String

# Description : EM management server host name

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

#-----------------------------------------------------------------------------

#OMSHOST =

#-----------------------------------------------------------------------------

# Name : OMSPORT

# Datatype : Number

# Description : EM management server port number

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

#-----------------------------------------------------------------------------

#OMSPORT =

#-----------------------------------------------------------------------------

# Name : EMUSER

# Datatype : String

# Description : EM Admin username to add or modify targets

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

#-----------------------------------------------------------------------------

#EMUSER =

#-----------------------------------------------------------------------------

# Name : EMPASSWORD

# Datatype : String

# Description : EM Admin user password

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

#-----------------------------------------------------------------------------

#EMPASSWORD=

#-----------------------------------------------------------------------------

# Name : DVCONFIGURATION

# Datatype : Boolean

# Description : Specify "True" to configure and enable Oracle Database vault

# Valid values : True/False

# Default value : False

# Mandatory : No

#-----------------------------------------------------------------------------

#DVCONFIGURATION = "false"

#-----------------------------------------------------------------------------

# Name : DVOWNERNAME

# Datatype : String

# Description : DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

#-----------------------------------------------------------------------------

#DVOWNERNAME = ""

#-----------------------------------------------------------------------------

# Name : DVOWNERPASSWORD

# Datatype : String

# Description : Password for DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

#-----------------------------------------------------------------------------

#DVOWNERPASSWORD = ""

#-----------------------------------------------------------------------------

# Name : DVACCOUNTMANAGERNAME

# Datatype : String

# Description : DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

#DVACCOUNTMANAGERNAME = ""

#-----------------------------------------------------------------------------

# Name : DVACCOUNTMANAGERPASSWORD

# Datatype : String

# Description : Password for DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

#DVACCOUNTMANAGERPASSWORD = ""

#-----------------------------------------------------------------------------

# Name : OLSCONFIGURATION

# Datatype : Boolean

# Description : Specify "True" to configure and enable Oracle Label Security

# Valid values : True/False

# Default value : False

# Mandatory : No

#-----------------------------------------------------------------------------

#OLSCONFIGURATION = "false"

#-----------------------------------------------------------------------------

# Name : DATAFILEJARLOCATION

# Datatype : String

# Description : Location of the data file jar

# Valid values : Directory containing compressed datafile jar

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

#DATAFILEJARLOCATION =

#-----------------------------------------------------------------------------

# Name : DATAFILEDESTINATION

# Datatype : String

# Description : Location of the data file's

# Valid values : Directory for all the database files

# Default value : $ORACLE_BASE/oradata

# Mandatory : No

#-----------------------------------------------------------------------------

#DATAFILEDESTINATION =

#-----------------------------------------------------------------------------

# Name : RECOVERYAREADESTINATION

# Datatype : String

# Description : Location of the data file's

# Valid values : Recovery Area location

# Default value : $ORACLE_BASE/flash_recovery_area

# Mandatory : No

#-----------------------------------------------------------------------------

#RECOVERYAREADESTINATION=

#-----------------------------------------------------------------------------

# Name : STORAGETYPE

# Datatype : String

# Description : Specifies the storage on which the database is to be created

# Valid values : FS (CFS for RAC), ASM

# Default value : FS

# Mandatory : No

#-----------------------------------------------------------------------------

#STORAGETYPE=FS

#-----------------------------------------------------------------------------

# Name : DISKGROUPNAME

# Datatype : String

# Description : Specifies the disk group name for the storage

# Default value : DATA

# Mandatory : No

#-----------------------------------------------------------------------------

#DISKGROUPNAME=DATA

#-----------------------------------------------------------------------------

# Name : ASMSNMP_PASSWORD

# Datatype : String

# Description : Password for ASM Monitoring

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

#ASMSNMP_PASSWORD=""

#-----------------------------------------------------------------------------

# Name : RECOVERYGROUPNAME

# Datatype : String

# Description : Specifies the disk group name for the recovery area

# Default value : RECOVERY

# Mandatory : No

#-----------------------------------------------------------------------------

#RECOVERYGROUPNAME=RECOVERY

#-----------------------------------------------------------------------------

# Name : CHARACTERSET

# Datatype : String

# Description : Character set of the database

# Valid values : Check Oracle12c National Language Support Guide

# Default value : "US7ASCII"

# Mandatory : NO

#-----------------------------------------------------------------------------

#CHARACTERSET = "US7ASCII"

#-----------------------------------------------------------------------------

# Name : NATIONALCHARACTERSET

# Datatype : String

# Description : National Character set of the database

# Valid values : "UTF8" or "AL16UTF16". For details, check Oracle12c National Language Support Guide

# Default value : "AL16UTF16"

# Mandatory : No

#-----------------------------------------------------------------------------

NATIONALCHARACTERSET= "AL32UTF8"

#-----------------------------------------------------------------------------

# Name : REGISTERWITHDIRSERVICE

# Datatype : Boolean

# Description : Specifies whether to register with Directory Service.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#REGISTERWITHDIRSERVICE= TRUE

#-----------------------------------------------------------------------------

# Name : DIRSERVICEUSERNAME

# Datatype : String

# Description : Specifies the name of the directory service user

# Mandatory : YES, if the value of registerWithDirService is TRUE

#-----------------------------------------------------------------------------

#DIRSERVICEUSERNAME= "name"

#-----------------------------------------------------------------------------

# Name : DIRSERVICEPASSWORD

# Datatype : String

# Description : The password of the directory service user.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService is TRUE

#-----------------------------------------------------------------------------

#DIRSERVICEPASSWORD= "password"

#-----------------------------------------------------------------------------

# Name : WALLETPASSWORD

# Datatype : String

# Description : The password for wallet to created or modified.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService is TRUE

#-----------------------------------------------------------------------------

#WALLETPASSWORD= "password"

#-----------------------------------------------------------------------------

# Name : LISTENERS

# Datatype : String

# Description : Specifies list of listeners to register the database with.

# By default the database is configured for all the listeners specified in the

# $ORACLE_HOME/network/admin/listener.ora

# Valid values : The list should be comma separated like "listener1,listener2".

# Mandatory : NO

#-----------------------------------------------------------------------------

LISTENERS = "listener1"

#-----------------------------------------------------------------------------

# Name : VARIABLESFILE

# Datatype : String

# Description : Location of the file containing variable value pair

# Valid values : A valid file-system file. The variable value pair format in this file

# is <variable>=<value>. Each pair should be in a new line.

# Default value : None

# Mandatory : NO

#-----------------------------------------------------------------------------

#VARIABLESFILE =

#-----------------------------------------------------------------------------

# Name : VARIABLES

# Datatype : String

# Description : comma separated list of name=value pairs. Overrides variables defined in variablefile and templates

# Default value : None

# Mandatory : NO

#-----------------------------------------------------------------------------

#VARIABLES =

#-----------------------------------------------------------------------------

# Name : INITPARAMS

# Datatype : String

# Description : comma separated list of name=value pairs. Overrides initialization parameters defined in templates

# Default value : None

# Mandatory : NO

#-----------------------------------------------------------------------------

#INITPARAMS =

#-----------------------------------------------------------------------------

# Name : SAMPLESCHEMA

# Datatype : Boolean

# Description : Specifies whether or not to add the Sample Schemas to your database

# Valid values : TRUE \ FALSE

# Default value : FASLE

# Mandatory : No

#-----------------------------------------------------------------------------

SAMPLESCHEMA=TRUE

#-----------------------------------------------------------------------------

# Name : MEMORYPERCENTAGE

# Datatype : String

# Description : percentage of physical memory for Oracle

# Default value : None

# Mandatory : NO

#-----------------------------------------------------------------------------

MEMORYPERCENTAGE = "40"

#-----------------------------------------------------------------------------

# Name : DATABASETYPE

# Datatype : String

# Description : used for memory distribution when MEMORYPERCENTAGE specified

# Valid values : MULTIPURPOSE|DATA_WAREHOUSING|OLTP

# Default value : MULTIPURPOSE

# Mandatory : NO

#-----------------------------------------------------------------------------

DATABASETYPE = "MULTIPURPOSE"

#-----------------------------------------------------------------------------

# Name : AUTOMATICMEMORYMANAGEMENT

# Datatype : Boolean

# Description : flag to indicate Automatic Memory Management is used

# Valid values : TRUE/FALSE

# Default value : TRUE

# Mandatory : NO

#-----------------------------------------------------------------------------

#AUTOMATICMEMORYMANAGEMENT = "TRUE"

#-----------------------------------------------------------------------------

# Name : TOTALMEMORY

# Datatype : String

# Description : total memory in MB to allocate to Oracle

# Valid values :

# Default value :

# Mandatory : NO

#-----------------------------------------------------------------------------

TOTALMEMORY = "3072"

#-----------------------*** End of CREATEDATABASE section ***------------------------

#-----------------------------------------------------------------------------

# createTemplateFromDB section is used when OPERATION_TYPE is defined as "createTemplateFromDB".

#-----------------------------------------------------------------------------

[createTemplateFromDB]

#-----------------------------------------------------------------------------

# Name : SOURCEDB

# Datatype : String

# Description : The source database from which to create the template

# Valid values : The format is <host>:<port>:<sid>

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

SOURCEDB = "myhost:1521:orcl"

#-----------------------------------------------------------------------------

# Name : SYSDBAUSERNAME

# Datatype : String

# Description : A user with DBA role.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

SYSDBAUSERNAME = "system"

#-----------------------------------------------------------------------------

# Name : SYSDBAPASSWORD

# Datatype : String

# Description : The password of the DBA user.

# You can also specify the password at the command prompt instead of here.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

#SYSDBAPASSWORD = "password"

#-----------------------------------------------------------------------------

# Name : TEMPLATENAME

# Datatype : String

# Description : Name for the new template.

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

TEMPLATENAME = "My Copy TEMPLATE"

#-----------------------*** End of createTemplateFromDB section ***---------------

#-----------------------------------------------------------------------------

# createCloneTemplate section is used when OPERATION_TYPE is defined as "createCloneTemplate".

#-----------------------------------------------------------------------------

[createCloneTemplate]

#-----------------------------------------------------------------------------

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID from which to create the template.

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

SOURCEDB = "orcl"

#-----------------------------------------------------------------------------

# Name : SYSDBAUSERNAME

# Datatype : String

# Description : A user with DBA role.

# Default value : none

# Mandatory : YES, if no OS authentication

#-----------------------------------------------------------------------------

#SYSDBAUSERNAME = "sys"

#-----------------------------------------------------------------------------

# Name : SYSDBAPASSWORD

# Datatype : String

# Description : The password of the DBA user.

# You can also specify the password at the command prompt instead of here.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

#SYSDBAPASSWORD = "password"

#-----------------------------------------------------------------------------

# Name : TEMPLATENAME

# Datatype : String

# Description : Name for the new template.

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

TEMPLATENAME = "My Clone TEMPLATE"

#-----------------------------------------------------------------------------

# Name : DATAFILEJARLOCATION

# Datatype : String

# Description : Location of the data file jar

# Valid values : Directory where the new compressed datafile jar will be placed

# Default value : $ORACLE_HOME/assistants/dbca/templates

# Mandatory : NO

#-----------------------------------------------------------------------------

#DATAFILEJARLOCATION =

#-----------------------*** End of createCloneTemplate section ***-------------------

#-----------------------------------------------------------------------------

# DELETEDATABASE section is used when DELETE_TYPE is defined as "deleteDatabase".

#-----------------------------------------------------------------------------

[DELETEDATABASE]

#-----------------------------------------------------------------------------

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

SOURCEDB = "orcl"

#-----------------------------------------------------------------------------

# Name : SYSDBAUSERNAME

# Datatype : String

# Description : A user with DBA role.

# Default value : none

# Mandatory : YES, if no OS authentication

#-----------------------------------------------------------------------------

#SYSDBAUSERNAME = "sys"

#-----------------------------------------------------------------------------

# Name : SYSDBAPASSWORD

# Datatype : String

# Description : The password of the DBA user.

# You can also specify the password at the command prompt instead of here.

# Default value : none

# Mandatory : YES, if no OS authentication

#-----------------------------------------------------------------------------

#SYSDBAPASSWORD = "password"

#-----------------------*** End of deleteDatabase section ***------------------------

#-----------------------------------------------------------------------------

# GENERATESCRIPTS section

#-----------------------------------------------------------------------------

[generateScripts]

#-----------------------------------------------------------------------------

# Name : TEMPLATENAME

# Datatype : String

# Description : Name of the template

# Valid values : Template name as seen in DBCA

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

TEMPLATENAME = "New Database"

#-----------------------------------------------------------------------------

# Name : GDBNAME

# Datatype : String

# Description : Global database name of the database

# Valid values : <db_name>.<db_domain> - when database domain isn't NULL

# <db_name> - when database domain is NULL

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

GDBNAME = "orcl12.us.oracle.com"

#-----------------------------------------------------------------------------

# Name : SCRIPTDESTINATION

# Datatype : String

# Description : Location of the scripts

# Valid values : Directory for all the scripts

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

#SCRIPTDESTINATION =

#-----------------------------------------------------------------------------

# Name : EMCONFIGURATION

# Datatype : String

# Description : Enterprise Manager Configuration Type

# Valid values : CENTRAL

# Default value : NONE

# Mandatory : No

#-----------------------------------------------------------------------------

#EMCONFIGURATION = "NONE"

#-----------------------------------------------------------------------------

# Name : OMSHOST

# Datatype : String

# Description : EM management server host name

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

#-----------------------------------------------------------------------------

#OMSHOST =

#-----------------------------------------------------------------------------

# Name : OMSPORT

# Datatype : Number

# Description : EM management server port number

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

#-----------------------------------------------------------------------------

#OMSPORT =

#-----------------------------------------------------------------------------

# Name : EMUSER

# Datatype : String

# Description : EM Admin username to add or modify targets

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

#-----------------------------------------------------------------------------

#EMUSER =

#-----------------------------------------------------------------------------

# Name : EMPASSWORD

# Datatype : String

# Description : EM Admin user password

# Default value : None

# Mandatory : Yes, if CENTRAL is specified for EMCONFIGURATION

#-----------------------------------------------------------------------------

#EMPASSWORD=

#-----------------------*** End of deleteDatabase section ***--------------------

#-----------------------------------------------------------------------------

# CONFIGUREDATABASE section is used when OPERATION_TYPE is defined as "configureDatabase".

#-----------------------------------------------------------------------------

[CONFIGUREDATABASE]

#-----------------------------------------------------------------------------

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

#SOURCEDB = "orcl"

#-----------------------------------------------------------------------------

# Name : SYSDBAUSERNAME

# Datatype : String

# Description : A user with DBA role.

# Default value : none

# Mandatory : YES, if no OS authentication

#-----------------------------------------------------------------------------

#SYSDBAUSERNAME = "sys"

#-----------------------------------------------------------------------------

# Name : SYSDBAPASSWORD

# Datatype : String

# Description : The password of the DBA user.

# You can also specify the password at the command prompt instead of here.

# Default value : none

# Mandatory : YES, if no OS authentication

#-----------------------------------------------------------------------------

#SYSDBAPASSWORD =

#-----------------------------------------------------------------------------

# Name : REGISTERWITHDIRSERVICE

# Datatype : Boolean

# Description : Specifies whether to register with Directory Service.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#REGISTERWITHDIRSERVICE= TRUE

#-----------------------------------------------------------------------------

# Name : UNREGISTERWITHDIRSERVICE

# Datatype : Boolean

# Description : Specifies whether to unregister with Directory Service.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#UNREGISTERWITHDIRSERVICE= TRUE

#-----------------------------------------------------------------------------

# Name : REGENERATEDBPASSWORD

# Datatype : Boolean

# Description : Specifies whether regenerate database password in OID/Wallet

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#REGENERATEDBPASSWORD= TRUE

#-----------------------------------------------------------------------------

# Name : DIRSERVICEUSERNAME

# Datatype : String

# Description : Specifies the name of the directory service user

# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified

#-----------------------------------------------------------------------------

#DIRSERVICEUSERNAME= "name"

#-----------------------------------------------------------------------------

# Name : DIRSERVICEPASSWORD

# Datatype : String

# Description : The password of the directory service user.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified

#-----------------------------------------------------------------------------

#DIRSERVICEPASSWORD= "password"

#-----------------------------------------------------------------------------

# Name : WALLETPASSWORD

# Datatype : String

# Description : The password for wallet to created or modified.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the any of the reg/unreg/regenPasswd options specified

#-----------------------------------------------------------------------------

#WALLETPASSWORD= "password"

#-----------------------------------------------------------------------------

# Name : ENABLESECURITYCONFIGURATION

# Datatype : String

# Description : Database Security Settings

# Valid values : true|false

# Default value : true

# Mandatory : No

#-----------------------------------------------------------------------------

#ENABLESECURITYCONFIGURATION = "true"

#-----------------------------------------------------------------------------

# Name : DBSNMPPASSWORD

# Datatype : String

# Description : Password for DBSNMP user

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if EMCONFIGURATION is specified

#-----------------------------------------------------------------------------

#DBSNMPPASSWORD = "password"

#-----------------------------------------------------------------------------

# Name : DVCONFIGURATION

# Datatype : Boolean

# Description : Specify "True" to configure and enable Oracle Database vault

# Valid values : True/False

# Default value : False

# Mandatory : No

#-----------------------------------------------------------------------------

#DVCONFIGURATION = "false"

#-----------------------------------------------------------------------------

# Name : DVOWNERNAME

# Datatype : String

# Description : DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

#-----------------------------------------------------------------------------

#DVOWNERNAME = ""

#-----------------------------------------------------------------------------

# Name : DVOWNERPASSWORD

# Datatype : String

# Description : Password for DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

#-----------------------------------------------------------------------------

#DVOWNERPASSWORD = ""

#-----------------------------------------------------------------------------

# Name : DVACCOUNTMANAGERNAME

# Datatype : String

# Description : DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

#DVACCOUNTMANAGERNAME = ""

#-----------------------------------------------------------------------------

# Name : DVACCOUNTMANAGERPASSWORD

# Datatype : String

# Description : Password for DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

#DVACCOUNTMANAGERPASSWORD = ""

#-----------------------*** End of CONFIGUREDATABASE section ***------------------------

#-----------------------------------------------------------------------------

# ADDINSTANCE section is used when OPERATION_TYPE is defined as "addInstance".

#-----------------------------------------------------------------------------

[ADDINSTANCE]

#-----------------------------------------------------------------------------

# Name : DB_UNIQUE_NAME

# Datatype : String

# Description : DB Unique Name of the RAC database

# Valid values : <db_unique_name>

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

DB_UNIQUE_NAME = "orcl12c.us.oracle.com"

#-----------------------------------------------------------------------------

# Name : INSTANCENAME

# Datatype : String

# Description : RAC instance name to be added

# Valid values : Check Oracle12c Administrator's Guide

# Default value : <sid_prefix>+<highest_current_thread+1>

# Mandatory : No

#-----------------------------------------------------------------------------

#INSTANCENAME = "orcl1"

#-----------------------------------------------------------------------------

# Name : NODENAME

# Datatype : String

# Description : Node on which to add new instance

# (in 10gR2, instance addition is supported on 1 node at a time)

# Valid values : Cluster node name

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

NODENAME=

#-----------------------------------------------------------------------------

# Name : OBFUSCATEDPASSWORDS

# Datatype : Boolean

# Description : Set to true if passwords are encrypted

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#OBFUSCATEDPASSWORDS = FALSE

#-----------------------------------------------------------------------------

# Name : SYSDBAUSERNAME

# Datatype : String

# Description : A user with DBA role.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

SYSDBAUSERNAME = "sys"

#-----------------------------------------------------------------------------

# Name : SYSDBAPASSWORD

# Datatype : String

# Description : The password of the DBA user.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

#SYSDBAPASSWORD = "password"

#-----------------------------------------------------------------------------

# Name : SERVICEUSERPASSWORD

# Datatype : String

# Description : Password for Windows Service user

# Default value : None

# Mandatory : If Oracle home is installed with windows service user

#-----------------------------------------------------------------------------

#SERVICEUSERPASSWORD = "password"

#-----------------------*** End of ADDINSTANCE section ***------------------------

#-----------------------------------------------------------------------------

# DELETEINSTANCE section is used when OPERATION_TYPE is defined as "deleteInstance".

#-----------------------------------------------------------------------------

[DELETEINSTANCE]

#-----------------------------------------------------------------------------

# Name : DB_UNIQUE_NAME

# Datatype : String

# Description : DB Unique Name of the RAC database

# Valid values : <db_unique_name>

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

DB_UNIQUE_NAME = "orcl12c.us.oracle.com"

#-----------------------------------------------------------------------------

# Name : INSTANCENAME

# Datatype : String

# Description : RAC instance name to be deleted

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes

#-----------------------------------------------------------------------------

INSTANCENAME = "orcl12c"

#-----------------------------------------------------------------------------

# Name : NODENAME

# Datatype : String

# Description : Node on which instance to be deleted (SID) is located

# Valid values : Cluster node name

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

#NODENAME=

#-----------------------------------------------------------------------------

# Name : OBFUSCATEDPASSWORDS

# Datatype : Boolean

# Description : Set to true if passwords are encrypted

# Valid values : TRUE\FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#OBFUSCATEDPASSWORDS = FALSE

#-----------------------------------------------------------------------------

# Name : SYSDBAUSERNAME

# Datatype : String

# Description : A user with DBA role.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

SYSDBAUSERNAME = "sys"

#-----------------------------------------------------------------------------

# Name : SYSDBAPASSWORD

# Datatype : String

# Description : The password of the DBA user.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

#SYSDBAPASSWORD = "password"

#-----------------------*** End of DELETEINSTANCE section ***------------------------

#----------------------------------------------------------------------------------

# CREATEPLUGGABLEDATABASE section is used when OPERATION_TYPE is defined as "createPluggableDatabase".

#----------------------------------------------------------------------------------

[CREATEPLUGGABLEDATABASE]

#----------------------------------------------------------------------------------

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

SOURCEDB = "orcl"

#----------------------------------------------------------------------------------

# Name : PDBNAME

# Datatype : String

# Description : The name of new pluggable database

# This pdb name must not be same as sourcedb name.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

PDBNAME = "PDB1"

#----------------------------------------------------------------------------------

# Name : CREATEASCLONE

# Datatype : Boolean

# Description : specify true or false for PDB to be create as Clone.

# : When "true" is passed a new PDB GUID is generated for the plugged in PDB

# Default value : true

# Mandatory : NO

#-----------------------------------------------------------------------------

# CREATEASCLONE = "TRUE"

#----------------------------------------------------------------------------------

# Name : CREATEPDBFROM

# Datatype : String

# Description : specify the source of pdb to be plugged

# Valid values : DEFAULT | FILEARCHIVE | RMANBACKUP | USINGXML

# Default value : DEFAULT

# Mandatory : NO

#-----------------------------------------------------------------------------

# CREATEPDBFROM = "DEFAULT"

#----------------------------------------------------------------------------------

# Name : PDBARCHIVEFILE

# Datatype : String

# Description : Full path and name for pdbArchive file

# Default value : None

# Mandatory : Mandatory when creating new PDB using FILEARCHIVE

#-----------------------------------------------------------------------------

# PDBARCHIVEFILE = ""

#----------------------------------------------------------------------------------

# Name : PDBBACKUPFILE

# Datatype : String

# Description : Full path and name for pdb back up file

# Default value : None

# Mandatory : Mandatory when creating new PDB using RMANBACKUP

#-----------------------------------------------------------------------------

# PDBBACKUPFILE = ""

#----------------------------------------------------------------------------------

# Name : PDBMETADATAFILE

# Datatype : String

# Description : Full path and name for pdb metadata file

# Default value : None

# Mandatory : Mandatory when creating new PDB using RMANBACKUP or USINGXML

#-----------------------------------------------------------------------------

# PDBMETADATAFILE = ""

#----------------------------------------------------------------------------------

# Name : PDBUSEMULTIPLEBACKUP

# Datatype : boolean

# Description : Flag that can used to create PDB from single or multiple backupsets

# Default value : true

# Mandatory : Optional when creating new PDB using RMANBACKUP or USINGXML

#-----------------------------------------------------------------------------

# PDBUSEMULTIPLEBACKUP =

#----------------------------------------------------------------------------------

# Name : PDBADMINUSERNAME

# Datatype : String

# Description : PDB Administrator user name

# Default value : None

# Mandatory : Mandatory only when creating new DEFAULT PDB

#-----------------------------------------------------------------------------

# PDBADMINUSERNAME = ""

#----------------------------------------------------------------------------------

# Name : PDBADMINPASSWORD

# Datatype : String

# Description : PDB Administrator user password

# Default value : None

# Mandatory : Mandatory only when creating new DEFAULT PDB

#-----------------------------------------------------------------------------

# PDBADMINPASSWORD = ""

#----------------------------------------------------------------------------------

# Name : CREATENEWPDBADMINUSER

# Datatype : String

# Description : When Plugging a pdb from FILEARCHIVE or RMANBACKUP

# a new PDB Administrator user can be created using this option

# This option should be given along with pdbadmin username and password

# Default value : False

# Mandatory : NO

#-----------------------------------------------------------------------------

# CREATENEWPDBADMINUSER = ""

#----------------------------------------------------------------------------------

# Name : SOURCEFILENAMECONVERT

# Datatype : String

# Description : This clause specifies how to locate files listed in an XML file

# describing a Pluggable Database if they reside in a location different

# from that specified in the XML file.

# This clause is valid when creating Pluggable database in USINGXML option

# Valid values : (<filename_pattern>, <replacement_filename_pattern>,....)

# Default value : "NONE"

# Mandatory : NO

#-----------------------------------------------------------------------------

# SOURCEFILENAMECONVERT = ""

#----------------------------------------------------------------------------------

# Name : FILENAMECONVERT

# Datatype : String

# Description : This clause specifies how to generate names of files

# for the Pluggable Database being created using names of existing files

# This clause is valid when creating Pluggable database in USINGXML option

# Valid values : (<filename_pattern>, <replacement_filename_pattern>,....)

# Default value : "NONE"

# Mandatory : NO

#-----------------------------------------------------------------------------

# FILENAMECONVERT = ""

#----------------------------------------------------------------------------------

# Name : COPYPDBFILES

# Datatype : Boolean

# Description : If COPY is specified, it will indicate that datafiles need to be copied.

# : This option can be true only when FILENAMECONVERT is specified or

# CDB files are Oracle Managed Files(OMF)

# Valid values : TRUE \ FALSE

# Default value : False

# Mandatory : NO

#-----------------------------------------------------------------------------

# COPYPDBFILES = ""

#----------------------------------------------------------------------------------

# Name : PDBDATAFILEDESTINATION

# Datatype : String

# Description : common location for PDB datafile area

# Default value : None

# Mandatory : NO

#-----------------------------------------------------------------------------

# PDBDATAFILEDESTINATION = ""

#----------------------------------------------------------------------------------

# Name : USEMETADATAFILELOCATION

# Datatype : Boolean

# Description : Specify true if datafile path defined in Meta datafile within PDB

# archive file is to be used to un-archive datafile.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : NO

#-----------------------------------------------------------------------------

# USEMETADATAFILELOCATION = ""

#-----------------------------------------------------------------------------

# Name : REGISTERWITHDIRSERVICE

# Datatype : Boolean

# Description : Specifies whether to register with Directory Service.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#REGISTERWITHDIRSERVICE= TRUE

#-----------------------------------------------------------------------------

# Name : DIRSERVICEUSERNAME

# Datatype : String

# Description : Specifies the name of the directory service user

# Mandatory : YES, if the value of registerWithDirService is TRUE

#-----------------------------------------------------------------------------

#DIRSERVICEUSERNAME= "name"

#-----------------------------------------------------------------------------

# Name : DIRSERVICEPASSWORD

# Datatype : String

# Description : The password of the directory service user.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService is TRUE

#-----------------------------------------------------------------------------

#DIRSERVICEPASSWORD= "password"

#-----------------------------------------------------------------------------

# Name : WALLETPASSWORD

# Datatype : String

# Description : The password for wallet to created or modified.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService is TRUE

#-----------------------------------------------------------------------------

#WALLETPASSWORD= "password"

#-----------------------------------------------------------------------------

# Name : LBACSYSPASSWORD

# Datatype : String

# Description : Password for LBACSYS user

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService are TRUE

#-----------------------------------------------------------------------------

#LBACSYSPASSWORD= "password"

#----------------------------------------------------------------------------------

# Name : CREATEUSERTABLESPACE

# Datatype : Boolean

# Description : Specify true if a default user tablespace need to be created in new PDB

# Valid values : TRUE \ FALSE

# Default value : TRUE

# Mandatory : NO

#-----------------------------------------------------------------------------

# CREATEUSERTABLESPACE = ""

#-----------------------------------------------------------------------------

# Name : DVCONFIGURATION

# Datatype : Boolean

# Description : Specify "True" to configure and enable Oracle Database vault

# Valid values : True/False

# Default value : False

# Mandatory : No

#-----------------------------------------------------------------------------

#DVCONFIGURATION = "false"

#-----------------------------------------------------------------------------

# Name : DVOWNERNAME

# Datatype : String

# Description : DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

#-----------------------------------------------------------------------------

#DVOWNERNAME = ""

#-----------------------------------------------------------------------------

# Name : DVOWNERPASSWORD

# Datatype : String

# Description : Password for DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

#-----------------------------------------------------------------------------

#DVOWNERPASSWORD = ""

#-----------------------------------------------------------------------------

# Name : DVACCOUNTMANAGERNAME

# Datatype : String

# Description : DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

#DVACCOUNTMANAGERNAME = ""

#-----------------------------------------------------------------------------

# Name : DVACCOUNTMANAGERPASSWORD

# Datatype : String

# Description : Password for DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

#DVACCOUNTMANAGERPASSWORD = ""

#-----------------------*** End of createPluggableDatabase section ***------------------------

#----------------------------------------------------------------------------------

# UNPLUGDATABASE section is used when OPERATION_TYPE is defined as "unplugDatabase".

#----------------------------------------------------------------------------------

[UNPLUGDATABASE]

#----------------------------------------------------------------------------------

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

SOURCEDB = "orcl"

#----------------------------------------------------------------------------------

# Name : PDBNAME

# Datatype : String

# Description : The name of new pluggable database

# This pdb name must not be same as sourcedb name.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

PDBNAME = "PDB1"

#----------------------------------------------------------------------------------

# Name : ARCHIVETYPE

# Datatype : String

# Description : The unplugged database datafile backup will in tar.gz or rman backup

# This pdb name must not be same as sourcedb name.

# Valid values : TAR | RMAN

# Default value : TAR

# Mandatory : NO

#-----------------------------------------------------------------------------

ARCHIVETYPE = "TAR"

#----------------------------------------------------------------------------------

# Name : PDBARCHIVEFILE

# Datatype : String

# Description : Full path and name for pdbArchive file

# Default value : None

# Mandatory : NO

#-----------------------------------------------------------------------------

# PDBARCHIVEFILE = ""

#----------------------------------------------------------------------------------

# Name : PDBBACKUPFILE

# Datatype : String

# Description : Full path and name for pdb back up file

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

# PDBBACKUPFILE = ""

#----------------------------------------------------------------------------------

# Name : PDBMETADATAFILE

# Datatype : String

# Description : Full path and name for pdb metadata file

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

# PDBMETADATAFILE = ""

#-----------------------------------------------------------------------------

# Name : UNREGISTERWITHDIRSERVICE

# Datatype : Boolean

# Description : Specifies whether to unregister with Directory Service.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#UNREGISTERWITHDIRSERVICE= TRUE

#-----------------------------------------------------------------------------

# Name : DIRSERVICEUSERNAME

# Datatype : String

# Description : Specifies the name of the directory service user

# Mandatory : YES, if the value of unregisterWithDirService is TRUE

#-----------------------------------------------------------------------------

#DIRSERVICEUSERNAME= "name"

#-----------------------------------------------------------------------------

# Name : DIRSERVICEPASSWORD

# Datatype : String

# Description : The password of the directory service user.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of unregisterWithDirService is TRUE

#-----------------------------------------------------------------------------

#DIRSERVICEPASSWORD= "password"

#-----------------------------------------------------------------------------

# Name : WALLETPASSWORD

# Datatype : String

# Description : The password for wallet to created or modified.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of unregisterWithDirService is TRUE

#-----------------------------------------------------------------------------

#WALLETPASSWORD= "password"

#-----------------------*** End of unplugDatabase section ***------------------------

#----------------------------------------------------------------------------------

# DELETEPLUGGABLEDATABASE section is used when OPERATION_TYPE is defined as "deletePluggableDatabase".

#----------------------------------------------------------------------------------

[DELETEPLUGGABLEDATABASE]

#----------------------------------------------------------------------------------

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

SOURCEDB = "orcl"

#----------------------------------------------------------------------------------

# Name : PDBNAME

# Datatype : String

# Description : The name of new pluggable database

# This pdb name must not be same as sourcedb name.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

PDBNAME = "PDB1"

#-----------------------*** End of deletePluggableDatabase section ***---------------

#----------------------------------------------------------------------------------

# CONFIGUREPLUGGABLEDATABASE section is used when OPERATION_TYPE is defined as "configurePluggableDatabase".

#----------------------------------------------------------------------------------

[CONFIGUREPLUGGABLEDATABASE]

#----------------------------------------------------------------------------------

# Name : SOURCEDB

# Datatype : String

# Description : The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

SOURCEDB = "orcl"

#----------------------------------------------------------------------------------

# Name : PDBNAME

# Datatype : String

# Description : The name of new pluggable database

# This pdb name must not be same as sourcedb name.

# Default value : none

# Mandatory : YES

#-----------------------------------------------------------------------------

PDBNAME = "PDB1"

#-----------------------------------------------------------------------------

# Name : DVCONFIGURATION

# Datatype : Boolean

# Description : Specify "True" to configure and enable Oracle Database vault

# Valid values : True/False

# Default value : False

# Mandatory : No

#-----------------------------------------------------------------------------

#DVCONFIGURATION = "false"

#-----------------------------------------------------------------------------

# Name : DVOWNERNAME

# Datatype : String

# Description : DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

#-----------------------------------------------------------------------------

#DVOWNERNAME = ""

#-----------------------------------------------------------------------------

# Name : DVOWNERPASSWORD

# Datatype : String

# Description : Password for DataVault Owner

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : Yes, if DataVault option is chosen

#-----------------------------------------------------------------------------

#DVOWNERPASSWORD = ""

#-----------------------------------------------------------------------------

# Name : DVACCOUNTMANAGERNAME

# Datatype : String

# Description : DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

#DVACCOUNTMANAGERNAME = ""

#-----------------------------------------------------------------------------

# Name : DVACCOUNTMANAGERPASSWORD

# Datatype : String

# Description : Password for DataVault Account Manager

# Valid values : Check Oracle12c Administrator's Guide

# Default value : None

# Mandatory : No

#-----------------------------------------------------------------------------

#DVACCOUNTMANAGERPASSWORD = ""

#-----------------------------------------------------------------------------

# Name : OLSCONFIGURATION

# Datatype : Boolean

# Description : Specify "True" to configure and enable Oracle Label Security

# Valid values : True/False

# Default value : False

# Mandatory : No

#-----------------------------------------------------------------------------

#OLSCONFIGURATION = "false"

#-----------------------------------------------------------------------------

# Name : REGISTERWITHDIRSERVICE

# Datatype : Boolean

# Description : Specifies whether to register with Directory Service.

# Valid values : TRUE \ FALSE

# Default value : FALSE

# Mandatory : No

#-----------------------------------------------------------------------------

#REGISTERWITHDIRSERVICE= TRUE

#-----------------------------------------------------------------------------

# Name : DIRSERVICEUSERNAME

# Datatype : String

# Description : Specifies the name of the directory service user

# Mandatory : YES, if the value of registerWithDirService is TRUE

#-----------------------------------------------------------------------------

#DIRSERVICEUSERNAME= "name"

#-----------------------------------------------------------------------------

# Name : DIRSERVICEPASSWORD

# Datatype : String

# Description : The password of the directory service user.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService is TRUE

#-----------------------------------------------------------------------------

#DIRSERVICEPASSWORD= "password"

#-----------------------------------------------------------------------------

# Name : WALLETPASSWORD

# Datatype : String

# Description : The password for wallet to created or modified.

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of registerWithDirService is TRUE

#-----------------------------------------------------------------------------

#WALLETPASSWORD= "password"

#-----------------------------------------------------------------------------

# Name : LBACSYSPASSWORD

# Datatype : String

# Description : Password for LBACSYS user

# You can also specify the password at the command prompt instead of here.

# Mandatory : YES, if the value of olsConfiguration and registerWithDirService are TRUE

#-----------------------------------------------------------------------------

#LBACSYSPASSWORD= "password"

#-----------------------------------------------------------------------------

# Name : EMCONFIGURATION

# Datatype : String

# Description : Enterprise Manager Configuration Type

# Valid values : DBEXPRESS|NONE

# Default value : NONE

# Mandatory : No

#-----------------------------------------------------------------------------

#EMCONFIGURATION = "NONE"

#-----------------------------------------------------------------------------

# Name : EMEXPRESSPORT

# Datatype : Number

# Description : Enterprise Manager Configuration Type

# Valid values : Check Oracle12c Administrator's Guide

# Default value : NONE

# Mandatory : No, will be picked up from DBEXPRESS_HTTPS_PORT env variable

# or auto generates a free port between 5500 and 5599

#-----------------------------------------------------------------------------

#EMEXPRESSPORT = ""

#-----------------------*** End of configurePluggableDatabase section ***------------

Oracle Business Intelligence

Search This Blog

Monday, 12 November 2018

OBIEE 12c File Locations

Saturday, 10 November 2018

OBIEE 12c with MySQL Community Edition Connectivity

Starting and Stopping OBIEE 12c Services in Linux

Friday, 9 November 2018

Setting Java Home in Linux

Friday, 2 November 2018

Starting and Stopping Oracle Listener in UNIX

Thursday, 1 November 2018

UsageTracking in OBIEE 12c

Adding Environment Variable in bash_profile in Linux

Downloading and Uploading RPD in OBIEE 12c

OBIEE 12c (12.2.1.4.0) is Awailable for Download

Wednesday, 31 October 2018

Oracle DB 11g Silent Installation

Sunday, 14 October 2018

Creating Impersonated User in OBIEE 12c

Wednesday, 10 October 2018

Go URL with Parameters Example in OBIEE 12c (12.2.1.3.0)

Tuesday, 2 October 2018

Go URL in OBIEE 12c

Tuesday, 1 May 2018

dbca.rsp file for for Oracle Database 12.1.0.2.0 Silent Installation

What is Oracle Database Link and How to create database link (DB Link)

Recent Posts