Q
Problem solve Get help with specific problems with your technologies, process and projects.

Problem with Oracle Client

What am I missing? I can't run a DBCON report from any of my application servers. It only runs in the central instance. Is it something related to my AS Oracle Client? They currently run ORA_CLI 8.0.5 (4.6C kernel on HP-UX11_64 and Oracle 9.2.0.5).
I do not think I need the .dbenv_ .csh and .sh profiles on the ora environment variables, since this profiles normally point to the ORACLE_HOME in the Central Instance.
I tried setting up the listener.ora on a local AS /network/admin but it did not work. Also, tnsping doesn't even exist in the AS. Is there any additional setup configuration of the Oracle Client I need to run in each AS prior to achieve a DBCON to a remote Oracle database?
You should install the Oracle Client on your central instance and application servers. The ORA_NLS33 parameters should point to the Oracle Client instead of the ORACLE_HOME directory. Have a look at OSS NOTE 180430, Installing the Oracle Client software for Unix. For Oracle 9.2.0, you need to install the Oracle Client 8.1.7 64 bit.
In addition, have a look at OSS NOTE 780891 -- it is not really applicable to this situation, but it explains how the connection works.
This was last published in February 2005

Dig Deeper on SAP Basis administration and NetWeaver administration

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

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close