-
Title
"ORA-12537: TNS:connection closed" while installing Performance Analysis -
Description
During Performance Analysis installation the following error comes up:
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ ERROR:
+ The database operation failed.
+ Connection Details:
+ Host: '<host name>'
+ Instance: '<SID>'
+ User: '<db user>'
+ TNS Listener Port: 1521
+ Generated the following exception:
+ ORA-12537: TNS:connection closed
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ -
Cause
Listener is not running on port 1521
-
Resolution
Make sure that all given details are correct: hostname, SID, db user and port.
To proof the connectivity you can do the following tests:
From the database server run:
ping <middleware server>
From the middleware server run:
ping <database server>
tnsping <SID>
SQL*Plus connect to the database