DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: installing oracle 9i on winxp

  1. #1
    Join Date
    Apr 2003
    Posts
    6

    installing oracle 9i on winxp

    hello there,
    im in real need for help guys, ive been trying for more than 2 weeks now to make it work on my pc but i cant manage to get it working.
    whenever i try to load SQLplus its gives me a TNS error, i tired setting up a listener but it keeps on telling me that its not working whenever i test it.
    can someone plz guide me through the installation.

  2. #2
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    Post the error message

  3. #3
    Join Date
    Apr 2003
    Posts
    6
    ORA-12541: TNS:no listener

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    listener.ora and tnsnames.ora please

  5. #5
    Join Date
    Apr 2003
    Posts
    6
    emmmm i dont quite understand, u want the content of those files? if so give me some time while i look them up coz i dont even know where to look for them :-P

  6. #6
    Join Date
    Apr 2003
    Posts
    6
    # TNSNAMES.ORA Network Configuration File: c:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
    # Generated by Oracle configuration tools.

    HOPE =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = max)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = test)
    )
    )


    # LISTENER.ORA Network Configuration File: c:\oracle\ora90\NETWORK\ADMIN\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = max)(PORT = 1521))
    )

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you need to add an entry into your listener.ora file for that database

    something like this



    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = max)(PORT = 1521))
    )

    STARTUP_WAIT_TIME_listener = 0
    CONNECT_TIMEOUT_listener = 10
    TRACE_LEVEL_listener = OFF
    SID_LIST_listener =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = test)
    (GLOBAL_DBNAME = test.world)
    (ORACLE_HOME = /u1/app/oracle8/product/8.1.5)
    )
    )




    change your oracle home as appropriate.

    Then stop and start your listener

  8. #8
    Join Date
    May 2002
    Posts
    2,645
    HOPE =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = max)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = test)
    )
    )


    Why would you want to use HOPE and test? If you are going to do that, you should have used HOPE and less.

  9. #9
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by stecal
    Why would you want to use HOPE and test? If you are going to do that, you should have used HOPE and less.
    lol ... you're in fine form today i see.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  10. #10
    Join Date
    Apr 2003
    Posts
    6
    Originally posted by davey23uk
    you need to add an entry into your listener.ora file for that database

    something like this



    LISTENER =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = max)(PORT = 1521))
    )

    STARTUP_WAIT_TIME_listener = 0
    CONNECT_TIMEOUT_listener = 10
    TRACE_LEVEL_listener = OFF
    SID_LIST_listener =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = test)
    (GLOBAL_DBNAME = test.world)
    (ORACLE_HOME = /u1/app/oracle8/product/8.1.5)
    )
    )




    change your oracle home as appropriate.

    Then stop and start your listener


    i tired that, still giving me the same error.... btw, shouldnt this be set by the wizards? why does it have to be entered like this?!!?1/

    @stecal: heheheh nice call man, i just didnt want to make it that "clear" ;-) guess it shows anyways huh ??

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