Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2004
    Posts
    4

    Cool Unanswered: oracle 10g without listener

    I want to install the database on a single pc for single user (moi).

    I do not want to use tns listener to set up the configuration.

    Mainly because the pc is connected to the net via broadband connection. And given the number of hackers about, I want to minimize my possiblities (even though I use firewalls etc. etc.)

    Nonetheless, I really want to know if its possible to do this and how?

    Because thus far I have not managed it, Up till 8i, it was easy to configure tnsnames without listener, since then it seems impossible.

    So if anyone knows, tell all....please.

    Thanks in advance

    xmlns (what a name to choose buy only keeping up with the technology, and any chance to mention xml)

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You don't need any tnsnames.ora file if you are using the BEQ protocol
    on the local DB server system and NOT running any Oracle (TNS) listener.
    All that is needed is to have ORACLE_HOME & ORACLE_SID properly set.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Apr 2004
    Posts
    4

    Unhappy

    Ok I understand that I need BEQ-Local

    Thats what I used to use once upon a time but there seems no obvious method of configuring it.

    I have now just installed on XP.

    The listener is configured automatically.

    Normally in the past (with versions upto 8i) I used to stop listener and edit tnsnames.ora to use beq-local.

    But since 9i and now 10g there is no option for beq-local.

    My main issue what do I need in tnsnames.ora (that still needs an entry)

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    What part of "You do not need any tnsnames.ora file" do you NOT understand?
    You do NOT need any Oracle Listener running.
    IGNORE them.
    Make sure that TWO_TASK is not set & the 2 others are correct.
    This is ALL you need!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Apr 2004
    Posts
    4
    I have tried all that

    NO tnsnames.ora
    NO listener service running
    Windows platform

    ORACLE_SID And ORACLE_HOME set in the registry properly

    Try connection via sql plus : ORA1254 - listener cannot resolve blah

    Every time I have used beq-local in the past, I have configured and set something in tnsnames.ora and connected without having any listener then.

    Now u say I can do this without tnsnames.ora and listener and I have, it doesnt work.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    What happens when you do something like the following:

    sqlplus
    'scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(Host=lo calhost.localdomain)
    (Port=1521))(CONNECT_DATA=(SID=DBSID)))'

    where you replace strings after equals signs with values correct for your site?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Apr 2004
    Posts
    4
    I tried

    scott/ tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(Host=MY COMPUTERNAME)(Port=1521))(CONNECT_DATA=(SID=ORCL)) )

    and got error

    Ora-12533 TNS illegal address parameter

Posting Permissions

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