This discussion is archived
1 2 3 Previous Next 40 Replies Latest reply: Oct 16, 2012 3:39 AM by Andy Coates Go to original post RSS
  • 30. Re: Pre-requisites for the OBIA
    Saro Explorer
    Currently Being Moderated
    what are all the details you needed Svee. That is to send in mail to u

    Saro
  • 31. Re: Pre-requisites for the OBIA
    Saro Explorer
    Currently Being Moderated
    Hi Svee,

    I also checked by re-installing the informatica server but then too the same problem

    How to rectify the repository service problem.

    Regards,
    Saro
  • 32. Re: Pre-requisites for the OBIA
    Saro Explorer
    Currently Being Moderated
    Dear Svee,

    Im sending u the details to ur gmail. kindly check it.

    Thanks for your support.

    Regards,
    Saro
  • 33. Re: Pre-requisites for the OBIA
    Srini VEERAVALLI Guru
    Currently Being Moderated
    You need to have Oracle client, using toad can connect to db server using hostname.

    Pls mark correct if helps
  • 34. Re: Pre-requisites for the OBIA
    Saro Explorer
    Currently Being Moderated
    Hi svee,

    Like you said i installed the oracle client and also in the tnsnames.ora file i mentioned by db related entries in it. After that i reinstalled the informatica server alone first(but dint do the client).

    Once the server in installed, i went to the administration to create the repository services, but then also the same error like
    Could not execute action...
    
    The PowerCenter Repository Service was created, but the service could not be enabled. You must enable the service before you can create content. The following error occurred while attempting to create the content. Error - [DOM_10079] Cannot start service [Oracle_BI_DW_Base] on any node specified for the service. Check the service log and resolve any error listed for the service. Then restart the service.
    In logs, it is like
    OBJM_54538: Unable to connect to repository Oracle_BI_DW_Base on database OBIDB.world
    
    REP_51002: 
    Failed to logon to database server
    Database Driver error
    Function Name: logon
    ORA - 12154:TNS:couldnot resolve the connect identifier specified
    Im not sure with the error svee. What could be the problem.

    Note:

    Soon after Oracle client is installed i went to the below path to find the tnsnames.oRA file
    C:\app\Administrator\product\11.2.0\client_1\network\admin\sample
    In the above path i copied the tnsnames.oRA file and i pasted that file in the below location
    C:\app\Administrator\product\11.2.0\client_1\network\admin
    Also in the original tnsnames.orA file i replaced all the entires with my connection db details like below
    OBIDB = 
      (DESCRIPTION = 
        (ADDRESS = 
          (PROTOCOL = TCP)
          (HOST = 172.16.5.3)
          (PORT = 1521)
        )
        (CONNECT_DATA = 
          (SID = OBIDB)
          (SERVICE_NAME = OBIDB)
        )
      )
    Previously, in my original tnsnames.orA file which is present under the location C:\app\Administrator\product\11.2.0\client_1\network\admin\sample. i copied that file to the location C:\app\Administrator\product\11.2.0\client_1\network\admin and replaced the original below contents with the above db details that i specified.

    These are the original contents
    # This file contains the syntax information for 
    # the entries to be put in any tnsnames.ora file
    # The entries in this file are need based. 
    # There are no defaults for entries in this file
    # that Sqlnet/Net3 use that need to be overridden 
    #
    # Typically you could have two tnsnames.ora files
    # in the system, one that is set for the entire system
    # and is called the system tnsnames.ora file, and a
    # second file that is used by each user locally so that
    # he can override the definitions dictated by the system
    # tnsnames.ora file.
    
    # The entries in tnsnames.ora are an alternative to using
    # the names server with the onames adapter.
    # They are a collection of aliases for the addresses that 
    # the listener(s) is(are) listening for a database or 
    # several databases.
    
    # The following is the general syntax for any entry in 
    # a tnsnames.ora file. There could be several such entries 
    # tailored to the user's needs.
    
    <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
    My doubt, is whether due to this will be a problem. Svee.

    Also i have setted the following environmental variables too in my windows environment.

    BI_HOME--------->C:\BIHome\user_projects\domains\bifoundation_domain
    INFA_HOME----->C:\Informatica\9.1.0
    MW_HOME------>C:\BIHome
    ORACLE_HOME->C:\BIHome\Oracle_BI1
    ORACLE_INSTANCE-->C:\BIHome\instances\instance1

    Thanks for your lone support.

    Regards,
    Saro
  • 35. Re: Pre-requisites for the OBIA
    Srini VEERAVALLI Guru
    Currently Being Moderated
    You need to edit the file at no need to look at the sample folder.
    C:\app\Administrator\product\11.2.0\client_1\network\admin

    make sure tns entry is working using tnsping <tnsname> in command prompt.
    You need to create a repository then go for new content during the creation of the rep service.
  • 36. Re: Pre-requisites for the OBIA
    Saro Explorer
    Currently Being Moderated
    Hi svee,

    i checked now with the tnsping OBIDB and it is resulting like below
    Microsoft Windows [Version 5.2.3790]
    (C) Copyright 1985-2003 Microsoft Corp.
    
    C:\Documents and Settings\Administrator>cd\
    
    C:\>tnsping obidb
    
    TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 11-OCT-2
    012 18:35:23
    
    Copyright (c) 1997, 2010, Oracle.  All rights reserved.
    
    Used parameter files:
    C:\app\Administrator\product\11.2.0\client_1\network\admin\sqlnet.ora
    
    
    Used TNSNAMES adapter to resolve the alias
    Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.
    5.3) (PORT = 1521)) (CONNECT_DATA = (SID = OBIDB) (SERVICE_NAME = OBIDB)))
    OK (30 msec)
    
    C:\>
    Now it looks like it is being OKay. But again if i tried to create repository services means then too the same problem.

    But i have a doubt svee, if i set ORACLE_HOME = C:\app\Administrator\product\11.2.0\client_1 as a environmental variable in windows environment and after that if i give tnsping obidb means then it is pinging like above.

    Suppose if i set ORACLE_HOME = C:\BIHome\Oracle_BI1 as a environmental variable in windows environment and if i tried tnsping obidb means, then it is not pinging resulting in below error like
    Microsoft Windows [Version 5.2.3790]
    (C) Copyright 1985-2003 Microsoft Corp.
    
    C:\Documents and Settings\Administrator>cd\
    
    C:\>tnsping obidb
    
    TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 11-OCT-2
    012 18:43:38
    
    Copyright (c) 1997, 2010, Oracle.  All rights reserved.
    
    Used parameter files:
    C:\BIHome\Oracle_BI1\network\admin\sqlnet.ora
    
    
    Used TNSNAMES adapter to resolve the alias
    Message 3513 not found;  product=NETWORK; facility=TNS
    OK (0 msec)
    
    C:\>
    So, which one needs to be set as a ORACLE_HOME whether the client location or the BI location. If i set BI location as a oracle home then tns is not pinging and  getting the above error, but if i set client location as a oracle home then the tns is pinging, but couldn't create the repository service as it is resulting in same error svee.

    What might be the problem.

    Regards,
    Saro
  • 37. Re: Pre-requisites for the OBIA
    user13073875 Newbie
    Currently Being Moderated
    bump
  • 38. Re: Pre-requisites for the OBIA
    Saro Explorer
    Currently Being Moderated
    Hi Svee,

    Finally the informatica repository service got created with the help of the oracle 32bit client like you said.

    Thanks for your entire effort in solving this issue.

    Not sure, why the oracle 64bit client dint worked. Letz see whether the Oracle will have a fix for that.

    Thanks a lot.

    Regards,
    Saro
  • 39. Re: Pre-requisites for the OBIA
    968587 Newbie
    Currently Being Moderated
    Hi,
    I have downloaded below Informatica 9 setup:

    Oracle Business Intelligence Data Warehouse Administration Console 10.1.3.4.1 for Microsoft Windows and Informatica PowerCenter and PowerConnect Adapters 9.0.1 for Windows x86 (32-bit) (Part 1 of 2)

    I am not able install, could you please help me? Can you provide steps?
  • 40. Re: Pre-requisites for the OBIA
    Andy Coates Journeyer
    Currently Being Moderated
    Please can you create a new thread as this one has already been answered.

    Please can you provide more details? Why are you unable to install the DAC and Informatica Servers? Do you have any error messages? Can you provide the exact part numbers you downloaded from eDelivery e.g. V12345-01 etc

    Please mark if helpful / correct,
    Andy

    www.project.eu.com

    Edited by: Andy Coates on Oct 16, 2012 11:38 AM
1 2 3 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points