creating universe on Oracle 11g

[Former Member]

Hi All,

         i need to create universe on Oracle 11g data base. we are using SAP BO 4.0 sp6. we installed Oracle 11g in one server and SAP BO in another server. do we need to do any configuration between those servers?

and what version of oracle client needs to installed on SAP BO server and any configuration required between SAP BO Server and Oracle client.

if any one knows the integration between Oracle system and SAP BO please help me ASAP.

Thanks,

Ramana

[Former Member · Accepted solution]

Hi Rama,

You need to have Oracle client with TNS entry of your BO CMS database(if you are using Oracle as your CMS repository database)

If you are using Oracle for your reporting database than you need to have the TNS entry of the schemas in you tns file in BO server.

Additionaly are you using clinet tools IDT or UDT for creating universe on BO server or any third machine for client tools.

If you are using BO server for creating universe than you need to install 32 bit drivers also  for oracle as client tools will use 32 bit middleware.

You can see the supported versions in below link.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/f0134dbb-8f10-3010-5084-cf90dbb35...

Thanks

Gaurav

[Former Member · Accepted solution]

Hi Gaurav,

      we are using sybase as CMS Repository database. and  i am using oracle as database for reporting and we are creating universe through IDT.

Thanks

Ramana

[Former Member · Accepted solution]

In that case you just need tns entries of your reporting database in BO server and yes 32 bit Oracle client for your client tools usage(IDT,UDT or Webi)

Thanks

Gaurav

[Former Member · Accepted solution]

Hi Gaurav,

can you please explain in details step by step?

what are the tns entries?

do i need to install Oracle client on SAP BO server?

Thanks,

Ramana

[Former Member · Accepted solution]

Hi Ramana,

Yes you have to install Oracle client on BO server and since you are using IDT or Universe designer in BO server you have to install 32 bit Oracle client.

TNS entries are the service names that will be required to have communication between your Oracle client(on BO server) and Oracle server.

You can take help of your Oracle DBA to get the service name from Oracle server and use it on your tns file, which will be created once you install Oracle client on your BO server.

Thanks

Gaurav

[Former Member · Accepted solution]

Hi Gaurav,

i installed oracle client in BO server side,. i found three "tnsnames.ora" files. i opened one file which is located

C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN

it contains

XE =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = XE)

    )

  )

EXTPROC_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

    )

    (CONNECT_DATA =

      (SID = PLSExtProc)

      (PRESENTATION = RO)

    )

  )

ORACLR_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

    )

    (CONNECT_DATA =

      (SID = CLRExtProc)

      (PRESENTATION = RO)

    )

  )

another one "tnsnames.oRA"

it's location is

C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\sample

<alias>= [ (DESCRIPTION_LIST =  # Optional depending on whether u have

  # one or more descriptions

  # If there is just one description, unnecessary ]

   (DESCRIPTION=

     [ (SDU=2048) ] # Optional, defaults to 2048

  # Can take values between 512 and 32K

     [ (ADDRESS_LIST=    # Optional depending on whether u have

  # one or more addresses

  # If there is just one address, unnecessary ]

       (ADDRESS=

  [ (COMMUNITY=<community_name>) ]

  (PROTOCOL=tcp)

  (HOST=<hostname>)

  (PORT=<portnumber (1521 is a standard port used)>)

       )

       [ (ADDRESS=

   (PROTOCOL=ipc)

   (KEY=<ipckey (PNPKEY is a standard key used)>)

  )

       ]

       [ (ADDRESS=

   [ (COMMUNITY=<community_name>) ]

   (PROTOCOL=decnet)

   (NODE=<nodename>)

   (OBJECT=<objectname>)

  )

       ]

              ... # More addresses

     [ ) ] # Optional depending on whether ADDRESS_LIST is used or not

     [ (CONNECT_DATA=

  (SID=<oracle_sid>)

  [ (GLOBAL_NAME=<global_database_name>) ]

       )

     ]

     [ (SOURCE_ROUTE=yes) ] 

   )

   (DESCRIPTION=    

     [ (SDU=2048) ] # Optional, defaults to 2048

  # Can take values between 512 and 32K

     [ (ADDRESS_LIST= ] # Optional depending on whether u have more

  # than one address or not

  # If there is just one address, unnecessary

       (ADDRESS

  [ (COMMUNITY=<community_name>) ]

  (PROTOCOL=tcp)

  (HOST=<hostname>)

  (PORT=<portnumber (1521 is a standard port used)>)

       )

       [ (ADDRESS=

   (PROTOCOL=ipc)

   (KEY=<ipckey (PNPKEY is a standard key used)>)

          )

       ]

       ... # More addresses

     [ ) ] # Optional depending on whether ADDRESS_LIST 

  # is being used

     [ (CONNECT_DATA=

  (SID=<oracle_sid>)

  [ (GLOBAL_NAME=<global_database_name>) ]

       )

     ]

     [ (SOURCE_ROUTE=yes) ]

   )

   [ (CONNECT_DATA=

       (SID=<oracle_sid>)

       [ (GLOBAL_NAME=<global_database_name>) ]

     )

   ]

   ...   # More descriptions

  [ ) ] # Optional depending on whether DESCRIPTION_LIST is used or not

here we don't have Oracle DBA. in which file do i need to change the tns entries and what are the entries do i need to change.

we created one database on oracle server and we given sid.

can you please help me which file do i need to change.

Thanks,

Ramana

[Former Member · Accepted solution]

Hi,

You need to make the change in the first file, second one is just a sample.

The entry you have to add is the one you will get from oracle server tns file from similar location.

Go to oracle server ,find the tns file in server , look for the schema name you want to use , copy that entry and paste it in client tns file.

For a moment forget about BO , if you have oracle server in one machine and oracle client on your local machine, how would your system identify to whichoracle server,it needs to connect, that is there as on you need those tns entries.

Thanks

Gaurav

[Former Member]

Hi,

Let say you have 3 systems A,B,C

Oracle 11g server is on A, BO server is on B, and you are using system C (as Client)

Follow these Steps:

1.Create a system DSN (ODBC connection) for Oracle 11g on your client machine C (also TNS entry etc)

2.Hope you have already installed BO client on machine C

3.Check the connectivity of oracle 11g server by running any query on client machine C (optional)

4.Open IDT create a relational connection for oracle 11 client (on C)

5.Give the parameters and test connection.

6.Once the test is successful now you can create universe by fetching the tables/data form database.

For IDT help:

Let me Know if you want any further help on any of the steps mentioned above.

Hope it helps!

Thanks,

Shardendu