My Oracle Support Banner

Steps to connect BICS to a Pluggable Database (PDB) (Doc ID 2072368.1)

Last updated on NOVEMBER 20, 2019

Applies to:

Oracle Business Intelligence Cloud Service - Version 15.2.4.0.0 to 15.2.4.0.0 [Release 15]
Information in this document applies to any platform.

Purpose

 

This document provides some tips on connecting BICS to a PDB in a 12c DBaaS instance.

 

The issue at hand is that BICS connects to databases via a SID.  However starting in Oracle 12c databases, PDB (pluggable databases) will be common and it is normal to connect to them via a Service Name rather than a SID.  For applications which do not allow you to connect via a Service Name, it is possible to log into DBaaS and enable it to use SIDs to connect to PDB’s. 

This document provides instructions for creating a new pluggable database user and configuring the database listener to accept connections to pluggable databases using the Service Name as the SID.

Scope

 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 This document provides some tips on connecting BICS to a PDB in a 12c DBaaS instance.
Scope
Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.