Skip to Main Content
Forums

Analytics Software

Announcement

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

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

OBIA 11.1.1.10.2 HR payroll configuration issue

Sheikh ZakirullaJul 30 2018 — edited Jul 31 2018

Hi Experts,

I am working on OBIA 11.1.1.10.2 HR analytics OOTB data load with Oracle EBS 12.1.3 as source and ODI 11.1.1.9.0 as ETL tool. After successfull completion of dataload, I analysed that HR Payroll reports are not showing up data. Before running the full load, I added the payroll balance to the balance group using the create table query provided in oracle BIACF document.

I raised SR with oracle support on this issue and they concluded that since there is no data in the PAY_RUN_BALANCES table of EBS, OBIA ETL mappings cannot fetch data into the ware house tables. But the Customers says its not Mandatory for them to configure EBS to get data into the PAY_RUN_BALANCES table. And its optional for Saudi Arabia Legislation.

Now my question is, How to fix this HR payroll issue if the client doesn't keep its data in the PAY_RUN_BALANCES EBS table? Is there any way where I can populate HR payroll OOTB reports?

Your help and suggestions will be of great help.

@"Gianni Ceresa"

@"SriniVEERAVALLI"

@"Christian Berg"

Comments

sb92075
Answer
Can Oracle 11g RAC support 2 separate databases given that it asks for SCAN ip for cluster with a single Listener port number?
YES
Will the Oracle 11.2 database connections work successfully if I setup a mandatory DNS server within the Oracle RAC servers?
YES
Marked as Answer by 745782 · Sep 27 2020
745782
So, does this Listener port information provided during the Grid Infrastructure have anything to do with the (tns) Listener port # of the databases on the cluster? If so, do all databases (not 'instance') require to have the same Listener port #?

Can you direct me to a clear document on installing SCAN IP on the dns server and/or can you please explain a bit further on how SCAN IP resolves the address to the VIPs of the servers.

Thank you so much for your previous response and many more in advance!

Satish...
sb92075
http://download.oracle.com/docs/cd/E11882_01/install.112/e10812/concepts.htm#sthref790
damorgan
Please provide a link that indicates a single cluster can have two or more databases.

Multiple instances is one thing. I would appreciate a link showing a single cluster with multiple system tablespaces.
Hemant K Chitale
Why should a cluster not support multiple databases ?
Is there a catch in 11gR2 ?
damorgan
No Real Application Cluster technology has ever supported more than one database.

RAC is always 1 database with multiple instances.

If you have a second database then you have a second cluster.
Hemant K Chitale
No Real Application Cluster technology has ever supported more than one database.
Quite untrue.

I know that both you and Tom Kyte take the stand that a cluster should have only 1 instance per node.
That doesn't mean that it is not possible to have more than one database in a cluster -- i.e more than one instance in a node.

That doesn't mean that it must always be so. Installing a separate cluster and additional EE + RAC licences for a separate database can be quite expensive. Of course, your reply is "consolidate". That is another debate that has been going on for years.


A discussion on multiple databases on RAC is also at
http://www.freelists.org/post/oracle-l/multiple-databases-in-a-single-RAC-cluster


Hemant K Chitale

Edited by: Hemant K Chitale on Jan 12, 2010 11:15 AM
1 person found this helpful
745782
I've created multiple databases under 10g RAC, but not on 11g. It's definitely possible, but I had my doubts on whether I should provide the same Listener port (e.g., 1521) to all the databases that run under the 11.2 cluster when I give that port # during the SCAN IP configuration in Grid Infrastructure install.
Hemant K Chitale
I haven't done 11g RAC.

However I found this link :
http://sites.google.com/site/connectassysdba/oracle-rac-11-2-multiple-listener

referenced from this thread :
974062


Hemant K Chitale
1 person found this helpful
745782
Thank you very much Hemanth! The link you posted [http://sites.google.com/site/connectassysdba/oracle-rac-11-2-multiple-listener|http://sites.google.com/site/connectassysdba/oracle-rac-11-2-multiple-listener] and the ones before were very helpful!

Satish...
12cdb
I will give you an example:

Setup: 2 Nodes in the 11gR2 RAC on RHEL4

-- db1, db1 nodes

Install 11gR2 Grid and define SCAN name (which should be registered in DNS with 2 IPs as I have 2 nodes RAC) & port 1521

Install 11gR2 Database server.

Create Instance1 ( e.g. elevenone) using DBCA where ASM storage is used. - This will create a service with database name e.g. elevenone.localdomain

Create Instance2 (e.g. eleventwo) using DBCA where same ASM storage is used. - This will create another service eleventwo.localdomain

Now both instances can be accessed as:

sqlplus user/pwd@scan:1521/elevenone.localdomain

sqlplus usr/pwd@eleventwo.localdomain
1 - 11
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 28 2018
Added on Jul 30 2018
#business-intelligence-applications
2 comments
199 views