I have Cognos Environment set up here in India with Content Store setup against Oracle box in Linux environement with oracle datadump in it and I have package imported and running cognos applications.
Now I have to run the cognos applications against US datawarehouse database server. Ususally we create data source connection and specify the connection information and run applications.
I have got the Package along with the data sources and logins and I imported them into my environment and when I am trying to query the package, i am getting problems in accessing it.
So now I have TNSNAMES.ORA entry for our development data warehouse in US and how and where I can configure my machine and how to tnsping the database.
Please see the error that I am getting when accessing the package or testing the data source.
Pls let me know more info i have to provide