1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

ORACLE 10g client-server communication issue reg.

Discussion in 'Server Administration and Options' started by laxman, Oct 12, 2009.

  1. laxman

    laxman Forum Expert

    Likes Received:
    Trophy Points:
    Dear Sir,

    We are having Oracle 10g server, running under Windows Vista Business Edition. There will be about 20 users workin g on the client side connected through local area network. The problem is the server connection is getting disconnected frequently. Then we have to go to the service in the server and restart the iSQL *PLUS to restore the service. We could not able to identify the exact reason for the problem. we unable to find suitable solution for this problem. May i request you to kindly do the needful to trouble shoot this problem.

  2. zargon

    zargon Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    Aurora, CO
    I will make a wild guess and presume your Vista server is using DHCP rather than a fixed IP address. If this is the case then it's likely you're losing connections because of this dynamic IP scheme. You should be running this server with a fixed, static IP address which is not (the loopback address). You have investigated the listener log for errors? You do have client-side sqlnet tracing enabled? If not, do so else you may never find the actual cause of this issue (presuming you are running with a fixed IP address).

    You did install the software according to the certification instructions?

    "Oracle Database 10g Release 2 ( for Microsoft Windows Vista (32-bit) and Microsoft Windows Server 2008 (32-bit)" media must be used to install Oracle Database on Windows Vista or Windows Server 2008.
    Do not use Oracle Database 10g Release 2 ( to install the database on Windows Vista and Windows Server 2008.
    Do not apply this media to any other Microsoft Windows 32-bit OS's.
    Use Oracle Database 10gR2 ( to install
    See MetaLink Note 742060.1 Release Schedule of Current Database Patch Sets "

    If not then your issue is due to an unsupported and uncertified installation.