Teamcenter Database creation error - "Database connection through listener failed. Fix the error and run EM Configuration Assistant again. "

While creating Teamcenter Database, we will get below error. Even though Listener is configured properly.

 =======================================================================

Error:

Database connection through listener failed. Fix the error and run EM Configuration Assistant again. Listener port 1521 provided is incorrect. Provide the correct port. Listener is not up. Start the Listener. Database service dbservice is not registered with listener. Register the database service. Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset ORACLE_HOSTNAME environment variable. Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=. /etc/hosts does not have correct entry for hostname.

========================================================================



Solution:


Go to  your Oracle Home ( C:\TCDATABASE\product\11.2.0\dbhome_1\NETWORK\ADMIN  )  and edit listener.ora


Make changes as below:

> Start all Oracle services.