please help a newbie

I just installed oracle personal edition on a win 98 platform. everything seems fine but I cann't connect to the database. I get an error message (ODBC Test): there is no listener (but there is one for the database) Please help.

Go to your services and start the listener. otherwise on the dos prompt issue

lsnrctl start
lsnrctl status
This would start the listener.

Sam

sorry for my lack of knowledge: what do you mean with go to your services: net8 assistant? thank you though I can't wait to try that once I know where

on the dos promt the comands give me: bad command or file name (at c:\windows>)

Control Panel ---> Services --->

Under Service name see Listener is running. If not, Highlight it and start.

Make sure you have your ORACLE_HOME is in the path. If you don't have you get bad command error message.

[Edited by sreddy on 03-08-2001 at 06:27 PM]

Since I don't have a 98 system, I'm gussing this.

start -> settings --> control pannel --> services
|
|--> Administrative tools --> services

Other wise check the status of the listener from your MSDOS.

Sam

but the only thing in any of these paths is the ODBC Data Source Administrator and that doesn't have any way to check on listeners and as I said under the ms dos promt these commands are not understood by the system. thanks for your efforts. I hate it. any other ideas?

Hey, Do the following step by step .....

1. Start Oracle database
2. Goto DOS prompt c:> and type lsnrclt
3. type start (enter)
4. Listener should start successfully. In windows 98 this is the only way you can check listener. you can close dos windows after listener started successfully.
5. What is the name of your front end tool.
6. Goto Control Panel > ODBC and double click
7. Select Oracle ODBC driver and follow instructions.
8. After configuration you will get a window asking for service name ,username and password.
Enter username = system and password=manager.
Run Net8 easy configuration and create a service name also known as database alias (less than 8 characters).

Any questions ?????? (have fun) !!!!!

mohammad
DBA - Oracle Corp.

thank you - i will try that. if it doesn't work I will be here tomorrow same time.

just tried that. same problem: under dos c:> lsnrclt start does not work.

dos returns bad command or file name for lsnrclt.
is it possible that the program that is supposed to be invoked does not exist on my machine. I have downloaded the 8i Personal Edition from the oracle website and installed the typical installation no my win 98 second edition laptop.

Hi there

The lsnrctl command gives you "bad command" as the lsnrctl executable file is not in the environment PATH variable.
Find where lsnrctl.exe is. lets say it is in c:\oracle\personal\bin. Add it to the environment variable PATH by typing
PATH=%PATH%;c:\oracle\personal\bin;%PATH%

Now the command should work from c:
try this out and see itf it helps.
Have a great day
REgards
Ram.S

or you are misstyping

it's

LSNRCTL not LSNRCLT

if you have problem setting paths in dos go to orawin95 (I think personal oracle installs in that directory) then bin then start from there since all executables are under directory orawin95/bin

I think that you may have picked up on a typographical error in the earlier threads. I don't have Oracle on a windows platform, but the listener control utility I have seen has always been called lsnrctl *not* lsnrclt

HTH

David.

Mullrich24: I am also a newbie at this sort of stuff but I did notice that you typed lsnrclt instead of lsnrctl. I don't know if it was a typo or not but try the latter.

Paula

I'm very sure that should have been a typo. The command is

LSNRCTL and not LSNRCLT. check pando's posting on this.

Sam

I think your Oracle installation was not complete.
Net 8 must not have been installed.
can you please check this ........
START
SEARCH
For Files or Folders
type in the file name as
Listener.ora

If you find the file then start the listener as explained by others.
Else Reinstall Oracle.

Nalanda

thanks everyone. I located and launched the lsnrctl program. then started the listener. after that I was able to make a connection to the db. thanks everyone

Marc