what is listner in oracle?????i want to create it on my pc!!!!!!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • abhu50
    New Member
    • Jun 2007
    • 20

    what is listner in oracle?????i want to create it on my pc!!!!!!

    hiiiiii
    i m newbie to dba but i have got assignment from my senior to create a litner on my pc and create a new username and password so if any one have knowledge abt it then try to tell me

    thankz in advance

    reg
    abhinav
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    You need not create a listner for oracle, if oracle is installed on your system there will be a listner configures on your system.

    It will be available in
    controlpanel--->administrati ve tools---------->services

    Actually listner is a service which is responsible for interaction between client and server.
    This listenser service should be running .
    and if u want to create a new user

    log in to SYS or SYSTEM or any othere user account which has create user system previlege

    then from that schema execute this

    [CODE=oracle]CREATE USER USERNAME IDDENTIFIED BY PASSWORD;[/CODE]
    it creates the user.

    next grant certain previleges

    [CODE=oracle]GRANT CONNECT,RESOURC E TO USERNAME;[/CODE]
    Now this user can connect and create his objects.

    Comment

    Working...