Q

Can't get Oracle Discoverer and Oracle Client to work at the same time

I've installed both Oracle Discoverer 4.1 and Oracle Client 8.1.7.3. Whatever app I install first stops working...

after the other is installed. I have noticed that they both use the same reg settings within HKLMSoftwareOracle and that the later install overrides the settings for the first install. Is there a way of combining the two tnsnames.ora files or adding in a separate reg entry so that it will use both apps. I get errors ORA-12154 and ORA-12203. On any host, you can set the TNS_ADMIN environment variable to the location of the directory containing the tnsnames.ora and sqlnet.ora files. All Oracle client software on the system will then use the files in the directory you specify.

There's also a registry entry for TNS_ADMIN that you can make under HKLMSoftwareOracleHomeX (depending on which ORACLE_HOME you're trying to configure) that will work just the same as the environment variable.

See Metalink NOTE 111941.1 for more information.

This was last published in June 2004

Dig Deeper on Oracle database installation, upgrades and patches

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close