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!

Database login issue in sql developer.

Discussion in 'Other Development Tools' started by durgareddygade, Oct 28, 2015.

  1. durgareddygade

    durgareddygade Active Member

    Messages:
    38
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Guntur,Andhra Pradesh
    Hi Experts,
    As we are planning to move our database to new data centers, recently we have cloned 6 instances.
    All these contains new ip address and port details.
    Intiallly we are able to open all these instances in sql developer tool.
    Now while login in QA instances it is showing below error message.

    An errow was encounterd performing the requestd operation:
    IO Error : The network adapter could not establish the connection.
    vendor code :- 17002

    Note:- We are able to connect the same database from putty.
    We are facingn problem in sql developer tool.
    Please guide us.

    Regards
    Ashok
     
  2. ocprep

    ocprep Forum Advisor

    Messages:
    277
    Likes Received:
    76
    Trophy Points:
    410
    Location:
    Orlando, Florida
    My immediate suspicion would be a firewall issue. If port 1521 (or whichever port you have the instance using) has not been opened up, this is the error you would see.
     
  3. durgareddygade

    durgareddygade Active Member

    Messages:
    38
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Guntur,Andhra Pradesh
    Hi Morries,
    We verified with firewall team and they confirmed that ports are opend for this instance.
    We are able to connect database from putty.In sql developer only we are facing this issue.

    Regards
    Ashok
     
  4. ocprep

    ocprep Forum Advisor

    Messages:
    277
    Likes Received:
    76
    Trophy Points:
    410
    Location:
    Orlando, Florida
    If by 'connect using Putty', you mean connect to Port 1521 using Putty, then it's not a firewall issue. If you are connecting using a different port -- it's not testing the portion of the firewall involved here. If the firewall is not the issue, my next check would be for a mismatch between the connection created in SQL*Developer and what that instance has for its tnsnames,ora entry.
     
  5. DTSIGuy

    DTSIGuy Forum Advisor

    Messages:
    402
    Likes Received:
    58
    Trophy Points:
    410
    Location:
    Texas
    Did you create your connections in SQL Developer manually or is it using the TNS file? Have you tried either way?

    CJ
     
  6. durgareddygade

    durgareddygade Active Member

    Messages:
    38
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Guntur,Andhra Pradesh
    HI sir,
    Actually we created connections manually and tested.
    we have 6 instances for 2 clinets.for one client all three instances working properly.
    For another clinet we are unable to create any instances.
    we verified all the information provided in sql devloper was correct.

    Regards
    Ashok
     
  7. durgareddygade

    durgareddygade Active Member

    Messages:
    38
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Guntur,Andhra Pradesh
    we have verified the details enterd in sql developer.
    There is no mismatch of the tns entries.
    Can you plase guide us further.

    Regards
    Ashok
     
  8. ocprep

    ocprep Forum Advisor

    Messages:
    277
    Likes Received:
    76
    Trophy Points:
    410
    Location:
    Orlando, Florida
  9. dungskyvietnam

    dungskyvietnam Newly Initiated

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Hà nội
    My immediate suspicion would be a firewall issue. If port 1521