Error when trying to log into Informatica admin console and also onto Oracle database

0
votes

I installed Informatica server 9.6.1 ; when I try to log into admin console I am getting an error page - "ERR_CONNECTION_REFUSED"

Although the installation I got some error message but when I went aheadsaid it was successful and when I tried logging into admin console it didn't work.

The error message box during Informatica installation:enter image description here

After installing informatica server am even unable to access oracle database. I tried logging in using username sys as sysdba but I keep on getting this error message - "Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection"

Could anyone tell how do I fix this problem; for sure I haven't forgotten my password.

Appreciate your response.

INFORMATICA EXCEPTIONS LOG:

http://www.filedropper.com/informaticaexceptions

INFORMATICA CATALINA.OUT: http://www.filedropper.com/informaticacatalina

ORACLE TNSPING:

Microsoft Windows [Version 10.0.10240]
(c) 2015 Microsoft Corporation. All rights reserved.

C:\Users\naveed>tnsping orcl count

TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 04-FEB-2
016 23:49:55

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:
C:\app\oracle12c\product\12.1.0\dbhome_1\network\admin\sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =  localhos
t)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =   orcl)))

TNS-12541: TNS:no listener

Regards, Dexter.

1
etldata-warehouseinformaticaoracle12cinformatica-powercenter
Are you sure the database and Informatica server are running? - Samik
When I clicked on Informatica Start Services it didnot throw any errors....and as far as oracle database is concerned it should be running because just before informatica installation I was able to access it. Plz let me know if there is any other way of checking this....Thanks - Dex
You can check the services running from the task manager window. - Samik
You have to make sure the database is up an running before starting the Informatica services. - Samik
Did you check the informatica server logs, could you post the errors in that? Also did you try doing a tnsping to your Oracle database and check that it is successful? - vmachan

1 Answers

1
votes

Your inputs for tnsping clearly states that the listener is not up TNS-12541: TNS:no listener Bring up the listener and connect to Oracle first also check for the Oracle_home if that's correct.