OBR-SA RAC data source
Attempting to configure OBR to retrieve data from a Server Automation data source. Going through the documentation, I am instructed to
Create New SA/NA Data Source.
Resulting window pops that allows me to select an Oracle RAC database, and after building a connection descriptor as per the example:
(DESCRIPTION =(FAILOVER = ON)(BALANCE = ON)(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = dbhost1)(PORT = PORTNO))(ADDRESS = (PROTOCOL = TCP)(HOST = dbhost2)(PORT = PORTNO)))(CONNECT_DATA =(SERVICE_NAME = SERVICENAME)))
no matter what, it returns the error:
Please type a valid database instance.
If I swap the SERVICENAME for the Database Name, nothing changes, still throws the same error.
Am I missing something simple? Thanks,
SA-OBR integration does support ORACLE RAC and we have customers with this configuration. Based on past experience, I suggest that you try the following -
1. Confirm with DBA if the setup you are trying is actually an Oracle RAC. I have seen cases where it is actually a standalone ORACLE but the user was under the impression that it was an Oracle RAC.
2. Double-check with your DBA about the ORACLE parameters.
3. Try to add the data source as a standalone Oracle by providing details of only one node of the RAC and check if the connection is successful.
Let us know how it goes.
Oracle RAC is supported with SA-OBR integration, please go through the below section in content configuration guide on how to configure SA data source in OBR for Oracle RAC
Pre-registeringadataminerforSAasadatasource l SAOracledatabasestandaloneinstallation,below l SAOracledatabaseRACinstallation,onthenextpage l SA_Oracle_database_RAC_installation
1) It's RAC alright.
2) what paramers? The connect string? The OBR connect string is different than what we use internally, as the SCAN does not appear to be supported.
3) Did that already, and it's successful, but it's not useful: that negates the point in supporting RAC if it's single node only.
Do you have a working RAC connect string for OBR that I can look at?
MC: the whole point in me posting is that I've gone through that guide, and it DOes Not Work. "Supported" and "functional" are two different things.
I've configured my connection descriptor the way the guide says, and it throws an error: "