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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

Thanks I am able to connect Oracle 9i to BW system.

I had to update Host file, TNSnames.ora file.

Thanks & Regards

Rupali S

[Former Member]

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

[Former Member]

Hi Ram,

I have already gone through these Notes, But dont have step by step basis related procedure.

Thanks

Rupali S