Q
Problem solve Get help with specific problems with your technologies, process and projects.

Problems connecting to database after installing Forms

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.

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.
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.
This was last published in November 2005

Dig Deeper on Oracle Application Server

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close