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
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk." Continue Reading
Can I use /var/opt/oracle/oratab to specify listener information? Continue Reading
How many database instances can be created on an Oracle server with an installation drive containing 15 GB free space? Continue Reading