Hi

I have installed Oracle 9i database and Oracle application server 10g on the same redhat adavance 3 server. The portal will default to the database installed for OracleAS. Is there any settings that I can do to make it access to my Oracle 9i database instead? I ahve already changed the tnsnames.ora to be able to access to the Oracle 9i database from both the 10g infrastructure and middle tier. I want to build reports from the portal. Thanks!