I installed Oracle Developer 9i DS in the C: drive and Oracle8 SQL for NT on the D: drive on a Windows operating...
system. How can I start the listener service in Oracle? When I start the Forms Developer and compile it, I get the message "FRM-10142, start the oracle listener." Please tell me how I can start the listener? Please also tell me how I can build a connection between Developer and SQL.
The Oracle database listener can be started either from the command prompt or from the Services panel. To start the listener from the command prompt, type:
To determine the status of the listener from the command prompt, type:
You can also start the listener from the Services panel. Look for a service called OracleOraDb10g_homeTNSListener (or something similar to this), right-click on the service and choose 'Start.'
The Oracle Technology Network Web site has all the official Oracle documentation from Oracle 7 right up to Oracle 10g R2. This is where I look first for Oracle documentation and installation guides. Access to the Web site is free but you must register to create an account. To find the Oracle8 documentation on OTN, click on Documentation, choose 'More …' and scroll down the page to 'Previously Released Oracle Documentation' and click on 'Oracle8 Database.' Here you will find all required documentation for Oracle8.
Dig Deeper on Oracle database installation, upgrades and patches
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ... Continue Reading
I'm getting errors while installing the Database Configuration Assistant. Continue Reading