Question on view

[Chintz]

I have 2 instances on the production server "PROD_A" & "PROD_B". I have a view on my PROD_A instance:

CREATE OR REPLACE VIEW SCOTT.ABC_DETAILS
(COMPANY, FREEQTY, ACTUALSTARTDATE)
AS
SELECT COMPANY, FREEQTY, ACTUALSTARTDATE
FROM TIM.ABCDETAILS@PROD_B;

So, realistically this view resides on PROD_A and gets populated with data from PROD_B.
At the same time I have another server that has the standby databases for both these environments.
The problem I am having is that instead of pulling the data from the primary PROD_B database it is pulling it from the standby PROD_B database.
I checked the tnsnames file on the server it is pointing to the correct server.

WHere else should I look?

Any input will be greatly appreciated.

Chintz

[alapps]

Connections to the production instances should be made via virtual IP.

See below:

   Primary            Standby

db1.domain.tld    db2.domain.tld





            \    /

        db.domain.tld (interface db.domain.tld brought up on primary)

              |

              |

              |

              |

              |

connections made via db.domain.tld