Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Posts
    2

    Unhappy Unanswered: I'm going mad about this :(

    Something strange....
    I have a central server with Oracle 8 installed on him.
    And three another servers which are located in other towns.
    My central server connects to them thru proxy server (Wingate) which
    are connected to outer world by fiber.
    I use a TCP mapping method on proxy server.
    So, when i connect to first:
    connect proxy_ip port 1522 -> mapped to first_server_ip port 1521
    So, when i connect to second:
    connect proxy_ip port 1523 -> mapped to second_server_ip port 1521
    So, when i connect to third:
    connect proxy_ip port 1524 -> mapped to third_server_ip port 1521
    When this system running i got connection only to third server.
    For first and second i'm getting an error in log - ORA-12525.
    Nothing helps. BUT! The working server (third) is a Linux server, first and second running on NT. So, what i must to do? Where is a difference?
    Can you help, please?

  2. #2
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    Check if the WinGate allows Oracle tools such as Tnsping and SQL*Plus to access the network. I guess the problem is that Windows doesn't support shared sockets, and what port redirect is happening in the background. To read more about Windows, Firewalls and Oracle Click here


    Hope that helps,

    clio_usa - OCP - DBA


  3. #3
    Join Date
    Apr 2003
    Posts
    2

    Unhappy hmm...

    [SIZE=1]Originally posted by clio_usa
    Check if the WinGate allows Oracle tools such as Tnsping and SQL*Plus to access the network. I guess the problem is that Windows doesn't support shared sockets, and what port redirect is happening in the background. To read more about Windows, Firewalls and Oracle Click here
    WinGate allows Tnsping and SQLPlus. But real connection I may establish only to Linux based server.
    That is strange. Must be a solution to set a stable port for answer under
    Windows. But I can't find. I see that peoples meet this problem too, but nobody really solved it?

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Thumbs up

    Yeap.

    It's a Windows problem. Oracle recommends to add USE_SHARED_SOCKET variable and set it to TRUE in the registry in the ORACLE, but that doesn't help either. It's simple because Windows is doing port redirecting when replying.

    One solution is to use proxy which can route the Net8 traffic or Connection Manager.


    Hope that helps,

    clio_usa - OCP - DBA


Posting Permissions

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