Skip to Content
author's profile photo Former Member
0
Former Member

SAP - External Oracle Database Connection

Posted on Apr 09, 2004 at 07:02 AM 22 Views

I have installed Oracle Client 9.2.0.4.0 on my Linux RedHat.

Now I have SAP System and Oracle Client in the same computer.

I check the file tnsname.ora and it's ok.

Then I tryed to run tnsping and it connect to remote oracle database on Win NT.

I inserted the tnsname (alias) in the conn info field of DBCON table but I still have the same connection problem in the Native Sql EXEC SQL CONNECT TO 'identifier' statement!

Maybe the ABAP Program does not have the environment variable set for Oracle (ex. ORACLE_HOME, ORACLE_BASE),

so it can't find the tnsnames.ora file?

Can anyone help me?

Thank's in advance.

Andrea

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 09, 2004 at 07:06 PM
    0

    Did you enter the user name and password in the DBCO transaction (dbcon table)?

    I used this snipped of code to connect to an external Vertex database ...

    REPORT ZCONNECT.

    DATA: BEGIN OF wa,

    LOCNAMESTATE(30) TYPE C,

    LOCGEOSTATE(2) TYPE N,

    END OF wa.

    EXEC SQL.

    CONNECT TO 'VERTEX' AS 'V'

    ENDEXEC.

    EXEC SQL.

    SET CONNECTION 'V'

    ENDEXEC.

    EXEC SQL PERFORMING LOOP_OUTPUT.

    SELECT LOCNAMESTATE, LOCGEOSTATE

    INTO :wa

    FROM locstate

    ENDEXEC.

    FORM LOOP_OUTPUT.

    WRITE: /, wa.

    ENDFORM.

    Good luck ...

    ---Hugo

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Apr 10, 2004 at 12:53 PM

      I don't know how can I resolve this problem.

      I need to access to SAP NOTES (link in the website help.sap.com) but it request a login/password that I don't have.

      I try to register to SAP Service MarketPlace to receive login/password but the system give me an error "the specified data was not sufficient to generate the user ID request"!

      Can you help me?

      Thank's.

      Andrea

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.