ORA-12203 Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORA-12203 Error

Hybrid View

  1. #1
    Join Date
    Aug 2000
    Location
    Straham NH
    Posts
    73
    All I am having a problem as follows. The database server is Windows NT4 SP6. Database version 8.1.7.1 (pathes 1 - 5). The machine resides between two firewalls. I can connect to the machine using SQL plus from a the local machine, or from a machine in the same segment of the network (between the two firewalls). Howerver when I try an connect from a machine that is outside this segment I get an ORA-12203 message. I can view the firewall logs and I call back seems to be generating random ports. The listener is listening on port 1526.


    Gary
    Share on Google+

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Can you post the message that goes with the ORA-12203?

    I cannot find the error on Technet in the 8i error messages and I'm too lazy to dig for it.

    Thanks.
    David Knight
    OCP DBA 8i, 9i, 10g
    Share on Google+

  3. #3
    Join Date
    Aug 2000
    Location
    Straham NH
    Posts
    73
    ORA-12203 TNS:unable to connect to destination
    This is the message...I don't think it is realy of mch help though.
    Share on Google+

  4. #4
    Join Date
    Mar 2001
    Posts
    314
    Try using a dedicated connection (add a server=dedicated to the net service name).

    -amar
    Share on Google+

  5. #5
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Can you "ping" the machine from outside of the firewall?

    Here is an idea. Check the port in the TNS file on the server. You will need to open this port on the firewall to the services you are using, for example TCP/IP.

    If those services are not available, you have no connection.

    By the way, do you have firewall software like Checkpoint or F5 or is it homegrown?

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g
    Share on Google+

  6. #6
    Join Date
    Aug 2000
    Location
    Straham NH
    Posts
    73
    I can not ping through the firewall to the server address. I can ping from the machine on the same segment OK. I can TNSPING the database from outside the firewall. But can not connect with SQL plus.
    Share on Google+

  7. #7
    Join Date
    Dec 2000
    Posts
    14

    I had the same problem earlier but now i fixed this. I found some documentation on metalink.

    Oracle listener will listen the client request through firewall because 1521 or 1526 ports are open in firewall from client to server but since oracle generates random port fro return and could not be defined in firewall.

    USE_SHARED_SOCKET will take care of this issue. The only disatvantage with this is whenever listener restarts then Oracle will loose every request received from client prior to restart.

    On NT side

    add USE_SHARED_SOCKET value is TRUE in ORACLE HOME ( N : 0,1,2 etc.. Mostly it should be 0 ) registry.

    I hope this will fix your issue.

    Subbarao
    Subbarao Manchikanti
    Share on Google+

  8. #8
    Join Date
    Aug 2000
    Location
    Straham NH
    Posts
    73
    I have already set that value in the registry (use_shared_socket reg_sz type = TRUE). Also found a document that suggested set an MTS_DISPATCHER value in the init.ora file (we are using decicated server) that would list the ip address and port to resond on.

    Both of these are in place and I'm still gettint ORA-12203 from outside the firewall.
    Share on Google+

  9. #9
    Join Date
    Aug 2000
    Location
    Straham NH
    Posts
    73
    I found the answer in Doc ID:124140.1. I placed the USE_SHARED_SOCKET registry seting in the wrong place. In version 8.0.x the setting was in the software\oracle hive location. With 8i it is in the software\oracle\homeX location.

    Gary
    Share on Google+

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