Q

How do I start the listener service?

I installed Oracle Developer 9i DS in the C: drive and Oracle8 SQL for NT on the D: drive on a Windows operating system. 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?

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:

 C:>lsnrctl start

To determine the status of the listener from the command prompt, type:

 C:>lsnrctl status

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.

This was first published in January 2006

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close