QUESTION POSED ON: 10 November 2005 Initially Oracle 8i was installed on my PC. Recently I installed Oracle Forms 6i, and from that day on I was not able to connect to the database. It is giving me the ORA-12203 error. Because the listener was not started I tried to start the listener service from control panel --> administrative tools --> services. It says the service cannot be started.
To continue reading for free, register below or login
Requires Membership to View
To read more you must become a member of SearchOracle.com
Well, I can't solve your problem but I can direct you where to begin looking. First, look for the listener log in $ORACLE_HOME/network/log. This may tell you why the listener will not start. Also check the database alert log to ensure that the database is starting. Sometimes the service will tell you it started when in fact it never gets to the point of being open. Try to manually start the listener. Open a command prompt. Set the oracle home and then start the listener.
C:> set ORACLE_HOME=C:oracleora8i (whatever yours is) C:> lsnrctl start
If this fails you will have the errors that caused it to fail. You can use the listener control utility to start, stop or check the status of the listener.
C:> lsnrctl status
Hope that will at least get you to the point of getting the listener error message to tell you why it will not start.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.