Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

what version of oracle?

April 26, 2017Oracle version

0

Posted

what version of oracle?

1 Answer

0

Posted

——————————————————- You stated: java.sql.SQLException: ORA-12154: TNS:could not resolve service name —————————————————————— Most probable case: This may happen when a Java client requests a database connection but the database server has not started or not listening. Solution1. Make sure the service name in the host string is correct. e.g. jdbc:oracle:oci8:@kesdee.world Solution2. Start the Oracle Server Solution3. Start the Listener. Under MS-DOS: lsnrctl.exe start Soution4. The tnsname specified in jdbc url is incorrect, check if the names match in ORACLE_HOME/network/admin/tnsnames.ora Your problem must be solved by now:if not go down further!!!! ——————————————————————– If not solved yet:RUN THE FOLLOWING CHECKS: 1>You mustve missed some vital info in SQLNET.ORA: for egs: NAMES.DEFAULT_DOMAIN entry missed Due to which you cannot start the application and the T