top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

REP_51002 Failed to logon to Databse Server, ORA-12154: TNS:could not resolve the connect identifier specified

0 votes
1,742 views

When i try to create a repository service i am getting the below error.

Domain setting:

jdbc:informatica:oracle://localhost:1521;ServiceName=orcl;
MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true

Error:

REP_51002
Failed to logon to Databse Server
Database driver error
Function Name : Logon
ORA-12154: TNS:could not resolve the connect identifier specified
Database driver error
Function Name : Connect

Database Error: Failed to connect to database using user [apps] and connection string [orcl.world].

posted Aug 18, 2014 by Ela

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Please check the values you entered for database services.

Just test the tnsping and sqlplus connection to the repo db

As long as your infa server is able to reach the oracle server and authenticate

Use the same user while creating repo service

Check ld-library-path env variable

answer Aug 19, 2014 by Shweta Singh
Similar Questions
+2 votes

unable to connect to the DB using Taod it throws below error:

ORA-12571 TNS packet writer failure

Please help.

0 votes

While Installing Informatica i am getting this ERROR....

The command to create the domain failed. Select OK to correct the domain information and try the command again. Select Continue to continue the installation without creating the domain. You can run the command to create the domain after installation. Review the log files for more information.

Informatica_9.0.1_Services_HotFix2.log [LOG FILES SAY'S]

Domain name: : Domain_SONY 
Node host name: : SONY 
Node name: : node01_SONY 
Node port number: : 6005 
NODE_ADDRESS : SONY:6005
LOGS_DIRECTORY : C:\Informatica\9.0.1\isp\logs 
BACKUP_DIRECTORY : C:\Informatica\9.0.1\server\infa_shared\Backup 
DOMAIN_USER : Administrator 
  DOMAIN_PSSWD : ***** 
    NODEOPTIONS_XML : C:\Informatica\9.0.1\isp\bin\nodeoptions.xml 
Exit Code : -1

OutPut : [ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002} Cannot create domain, operation failed with error: [INFASETUP_10000] C:\Informatica\9.0.1\tomcat\conf\server.xml (The system cannot find the file specified).]. Error :

I Think i need to fix server.xml file but HOW?
ANY HELP WOULD BE APPRECIATED..

+1 vote

While Installing Informatica i am getting this ERROR....

The command to create the domain failed. Select OK to correct the domain information and try the command again. Select Continue to continue the installation without creating the domain. You can run the command to create the domain after installation. Review the log files for more information.

Informatica_9.0.1_Services_HotFix2.log [LOG FILES SAY'S]
Domain name: : Domain_SONY 
Node host name: : SONY 
Node name: : node01_SONY 
Node port number: : 6005 
NODE_ADDRESS : SONY:6005
LOGS_DIRECTORY : C:\Informatica\9.0.1\isp\logs 
BACKUP_DIRECTORY : C:\Informatica\9.0.1\server\infa_shared\Backup 
DOMAIN_USER : Administrator 
  DOMAIN_PSSWD : ***** 
    NODEOPTIONS_XML : C:\Informatica\9.0.1\isp\bin\nodeoptions.xml 

 Exit Code : -1 

OutPut : [ICMD_10033] Command [defineDomain] failed with error [[INFASETUP_10002} Cannot create domain, operation failed with error: [INFASETUP_10000] C:\Informatica\9.0.1\tomcat\conf\server.xml (The system cannot find the file specified).]. Error :

 I Think i need to fix server.xml file but HOW?  

ANY HELP WOULD BE APPRECIATED..

+1 vote

in my case, i have an expression transformation which uses the default function ERROR('transformation') to skip the records in which date value coming inside is not in the correct format. In this, the skipped rows are not written to the reject files, so that we are getting the reconcilation problem. I need the skipped rows to be written to the bad files.Please help me how can i achieve this.

+2 votes

I want to know how to rename the ODBC data source in informatica.

...