This content has been marked as final. Show 40 replies
what are all the details you needed Svee. That is to send in mail to u
I also checked by re-installing the informatica server but then too the same problem
How to rectify the repository service problem.
Im sending u the details to ur gmail. kindly check it.
Thanks for your support.
You need to have Oracle client, using toad can connect to db server using hostname.
Pls mark correct if helps
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
In logs, it is 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.
Im not sure with the error svee. What could be the problem.
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
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\sampleIn 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\adminAlso in the original tnsnames.orA file i replaced all the entires with my connection db details like below
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.
OBIDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 172.16.5.3) (PORT = 1521) ) (CONNECT_DATA = (SID = OBIDB) (SERVICE_NAME = OBIDB) ) )
These are the original contents
My doubt, is whether due to this will be a problem. Svee.
# 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
Also i have setted the following environmental variables too in my windows environment.
Thanks for your lone support.
You need to edit the file at no need to look at the sample folder.
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.
i checked now with the tnsping OBIDB and it is resulting like below
Now it looks like it is being OKay. But again if i tried to create repository services means then too the same problem.
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 126.96.36.199.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:\>
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
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.
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 188.8.131.52.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:\>
What might be the problem.
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.
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?
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,
Edited by: Andy Coates on Oct 16, 2012 11:38 AM