OBIEE 11g Information About the Use of Variables in the Connection Pool
(Doc ID 1925713.1)
Last updated on MARCH 14, 2019
Applies to:
Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.1 and later
Information in this document applies to any platform.
Symptoms
- You have created Static variables in the repository, such as
- HOSTNAME ='xxxx'
- PORT ='yyyy'
- SERVICE_NAME ='zzzz'
- Edit the Connection Pool->"data source name", like:
-
- (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUEOF(HOSTNAME))(PORT=VALUEOF(PORT))))(CONNECT_DATA=(SID=VALUEOF(SERVICE_NAME))))
- Then import metadata from Oracle RDBMS, it failed with the "can't connect" error.
- Edit the connection pool->"data source name" without Static variables. Hard code then entry like:
- (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx)(PORT=yyyy)))(CONNECT_DATA=(SID=zzzz)))
- This can import the metadata from Oracle RDBMS.
- Edit the "data source name" again and test using an entry like:
- (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=VALUEOF(HOSTNAME))(PORT=VALUEOF(PORT))))(CONNECT_DATA=(SID=VALUEOF(SERVICE_NAME))))
- Import metadata is not possible, but "Tools/Update All Rows" is OK.
Cause
| |
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.