Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Unanswered: tns listner question

    On oracle 9i, can a database connection be achieved without having to use listener.

    essentially i am not sure if the running listener is secure on xp, i.e. stop anyone from connecting over the internet (even though i have a firewall).

    in 8/8i, there was beq-local which allowed connections without having a listener running, just wondering if a similar protocol can be used, the only ones I can see are TCP, TCP with SSL and IPC

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: tns listner question

    Originally posted by hotkee
    On oracle 9i, can a database connection be achieved without having to use listener.

    essentially i am not sure if the running listener is secure on xp, i.e. stop anyone from connecting over the internet (even though i have a firewall).

    in 8/8i, there was beq-local which allowed connections without having a listener running, just wondering if a similar protocol can be used, the only ones I can see are TCP, TCP with SSL and IPC
    The short answer is YES.

    IPC is another name for BEQ

    As long as you are logged onto the DB server box itself,
    no listener is needed to connect to the Oracle database.

  3. #3
    Join Date
    Sep 2003
    Posts
    4

    trying IPC doesnt work though

    Thanks for the reply...I have gone into net manager and tried to configure a service using IPC but it keeps saying "no listener" when I try to test.

    would appreciate it if someone could provide a dummy entry to connect to a database using IPC (say with sid=ORCL)

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: trying IPC doesnt work though

    Originally posted by hotkee
    Thanks for the reply...I have gone into net manager and tried to configure a service using IPC but it keeps saying "no listener" when I try to test.

    would appreciate it if someone could provide a dummy entry to connect to a database using IPC (say with sid=ORCL)
    What part of "NO LISTENER" do you not understand?

    NOTHING involving SQL*Net is required to access an
    Oracle DB if/when you are logged directly onto the
    system upon which the database itself is running.

    If ORACLE_HOME & ORACLE_SID environmental variables
    are properly set to correct values, then when SQLPLUS is
    invoked it will automagically "connect" to the database.

  5. #5
    Join Date
    Sep 2003
    Posts
    4

    re: tnsnames

    ORACLE_HOME=D:\oracle\ora92
    ORACLE_SID=ORCL

    clean installation, entered an entry into tnsnames to use protocol IPC,

    ORCL_CON =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = ORCL)
    (PRESENTATION = RO)
    )
    )

    works fine IF tns listener is running, but I do not want listener to run, I simply want it to be like beq-local in 8/8i where you could configure a connection and not use listener.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1

    Re: re: tnsnames

    Originally posted by hotkee
    ORACLE_HOME=D:\oracle\ora92
    ORACLE_SID=ORCL

    clean installation, entered an entry into tnsnames to use protocol IPC,

    ORCL_CON =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
    (SID = ORCL)
    (PRESENTATION = RO)
    )
    )

    works fine IF tns listener is running, but I do not want listener to run, I simply want it to be like beq-local in 8/8i where you could configure a connection and not use listener.
    If TWO_TASK is set, then unset it.

    EXACTLY what are you using to access the database &
    exactly how are you doing this.

    With the listener shutdown,
    what happens when from the COMMAND window you enter:

    SQLPLUS scott/tiger

  7. #7
    Join Date
    Sep 2003
    Posts
    4

    tnsnames

    TWO_TASK environment variable doesnt exist so not set.

    I have been using SQL*Plus to access the database to test this out.

    If switch of tns listener off, then go into sqlplus with scott/tiger it just complains

    ORA-12541: TNS no listener

    It just seems impossible to make this work without a listener.

Posting Permissions

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