please help a newbie
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: please help a newbie

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    20

    Unhappy

    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.
    Share on Google+

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Go to your services and start the listener. otherwise on the dos prompt issue

    lsnrctl start
    lsnrctl status
    This would start the listener.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Share on Google+

  3. #3
    Join Date
    Mar 2001
    Posts
    20
    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
    Share on Google+

  4. #4
    Join Date
    Mar 2001
    Posts
    20
    on the dos promt the comands give me: bad command or file name (at c:\windows>)
    Share on Google+

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Control Panel ---> Services --->

    Under Service name see <SID>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]
    Reddy,Sam
    Share on Google+

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    Life is a journey, not a destination!

    Share on Google+

  7. #7
    Join Date
    Mar 2001
    Posts
    20

    Question

    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?
    Share on Google+

  8. #8
    Join Date
    Jan 2001
    Location
    Vancouver, Canada
    Posts
    87
    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.
    Share on Google+

  9. #9
    Join Date
    Mar 2001
    Posts
    20
    thank you - i will try that. if it doesn't work I will be here tomorrow same time.
    Share on Google+

  10. #10
    Join Date
    Mar 2001
    Posts
    20

    lsnrclt missing?

    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.
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width