i have a problem related to oracle's services. the fact is that the oracle database is running successfully without any problem but the problem lies in the oracle's tnslistener service. this tnslistener service when started for the first time, gets starts but within a few seconds it stopped automatically with the message as "the service has no work to do and hence it is stopped".
while starting the same service again, it gives an error message as "Error 1067: the service terminated unexpectedly".
Without using this service, i also could not be able to connect to the oracle databse using ODBC. it gives the same error as "tnslistener is not running".
It also gives an error number as "ORA-12560. TNSLISTENER is not running".
please help, as i can't figure out how correct these errors, and also be able to connect to the database using ODBC. any suggestion recommended
while starting the same service again, it gives an error message as "Error 1067: the service terminated unexpectedly".
Without using this service, i also could not be able to connect to the oracle databse using ODBC. it gives the same error as "tnslistener is not running".
It also gives an error number as "ORA-12560. TNSLISTENER is not running".
please help, as i can't figure out how correct these errors, and also be able to connect to the database using ODBC. any suggestion recommended