Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    4

    Unanswered: oracle setup problem

    Hi !!! to all the people in the forum..

    I am new bie in the oracle..

    Why when i use the toad to connect database and then i can not start my tomcat web server ?? is the tomcat conflict with the toad or the oracle ??

    And some time when i try to connect database using the toad the toad show error " no tns listener " i restart the listener but still the same why this happen ?? how to solve this problem??

    *(old oracle database from other lab)
    how to create a new user and create the privillage?
    how to delete the user ??

    Please help me ..

    Thanks alot.......
    From newbie

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: oracle setup problem

    Originally posted by ~lhoo+~
    Hi !!! to all the people in the forum..

    I am new bie in the oracle..

    Why when i use the toad to connect database and then i can not start my tomcat web server ?? is the tomcat conflict with the toad or the oracle ??

    And some time when i try to connect database using the toad the toad show error " no tns listener " i restart the listener but still the same why this happen ?? how to solve this problem??

    *(old oracle database from other lab)
    how to create a new user and create the privillage?
    how to delete the user ??

    Please help me ..

    Thanks alot.......
    From newbie
    TOAD has nothing to do with tomcat. Check the Tomcat's error log for reason why tomcat failed during startup.

    how to create a new user

    for example:
    CREATE USER test IDENTIFIED BY mypassword;

    how to delete the user ??
    DROP USER test CASCADE

    For further informations try documentation at http://tahiti.oracle.com
    Last edited by ika; 04-01-04 at 05:36.

  3. #3
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    For priviledge

    USE grant command.
    U need to choose what are the priviledges u wnat to give to ur users.
    eg:
    GRANT CONNECT,RESOURCE,DBA TO USERNAME;

    Simply by revoke command u can withdraw priviledges

    REVOKE DBA FROM USERNAME;

  4. #4
    Join Date
    Mar 2004
    Posts
    4

    Re: oracle setup problem

    Thanks alot
    ika,
    Yes i know that the toad is nothing to do with the tomcat but the problem is that when i start the toad the tomcat can not be start and when I start the tomcat then the toad can not connect to the database.
    Why this happen ??

    how can I make connection to the database using the jsp page?
    Can you give me some sample code ??

    Thanks alot to all of you.....

    From new bie

Posting Permissions

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