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

Connect Non SAP Oracle DB and MSSQL DB to SAP BW 7.0 Orace 10g system

Hi All,

Well I have a scenario, where I have to connect Non SAP Oracle 9i DB and MSSQL DB (2000, 2005) to SAP BW 7.0 Orace 10g system.

There are all together 4 Non SAP systems to be connected.

Up till now I have understood that in order to have to integrate Oracle 9i to BW system - TSNNames.ora has to be updated, then create new Logical system, then Create Source system in RSA1 with all the required information, Create user at Oracle 9i end.

As far as MSSQL Server is concerned - Client Software + DB Shared Library has to be installed in BW server.

Could anybody please guide me in the complete Basis Activities including above to complete the process.

I tried to create Source System, the initial screen has fields - Logical System, Source System & Type and Release.

I have created the Logical system through Tcode SALE

How to create Type and Release - for DB Oracle 9i & MSSQL 2000/2005.

Does OS version of DB & BW also matters ? Do we need to have that information as well.

Thanks & Regards

Rupali S

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 04, 2008 at 10:37 AM

    Hi,

    check the SAP Notes

    518241 --DB Connect in BW for an external Oracle database

    512739 BW external DB Connect for MS SQLServer

    Thanks,

    Ram

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 06, 2008 at 11:14 AM

    Hi,

    I am getting following error when I try to do TNSping

    C:\Documents and Settings\bitadm>tnsping HRPRN815

    TNS Ping Utility for 64-bit Windows: Version 10.2.0.2.0 - Production on 06-AUG-2

    008 16:40:58

    Copyright (c) 1997, 2005, Oracle. All rights reserved.

    Used parameter files:

    E:\usr\sap\BIT\SYS\profile\oracle\sqlnet.ora

    TNS-03505: Failed to resolve name

    This is my TNSnames.ora file content

    BIT.WORLD=

    (DESCRIPTION =

    (ADDRESS_LIST =

    (ADDRESS =

    (COMMUNITY = SAP.WORLD)

    (PROTOCOL = TCP)

    (HOST = poinmssapdev)

    (PORT = 1527)

    )

    )

    (CONNECT_DATA =

    (SID = BIT)

    (GLOBAL_NAME = BIT.WORLD)

    )

    )

    HRPRN815.VSHODC.LNTINFOTECH.COM =

    (DESCRIPTION =

    (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.25.8.79)(PORT = 1521))

    )

    (CONNECT_DATA =

    (SERVICE_NAME = HRPRN815)

    )

    )

    Do we need to manually update Listener.ora as well so as to function.

    All this is not letting me create Source system.

    Gives me following errors

    TNS-12514 TNS:listener could not resolve SERVICE_NAME given in connect

    descriptor

    Cause: The SERVICE_NAME in the CONNECT_DATA was not found in the

    listener's tables.

    Action: Check to make sure that the SERVICE_NAME specified is correct.

    TNS-12541 TNS:no listener

    Cause: The connection request could not be completed because the listener is

    not running.

    Action: Ensure that the supplied destination address matches one of the

    addresses used by the listener. Compare the TNSNAMES.ORA entry with the

    appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by

    way of an Interchange). Start the listener on the remote machine.

    Thanks & Regards

    Rupali S

    Add a comment
    10|10000 characters needed characters exceeded

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.