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

    Unanswered: ORA-12592 TNS bad packet

    Hello,

    Two concurrent threads are executing an Proc/C++ program which insert data into Oracle 9.0
    I always get this error of
    ORA-12592 TNS bad packet when both of them are inserting into the database at the same time. One thread insets data into table1 and second thread into table 2 which has a refrential integrity constraint on table1.
    Since the client program and database are on the same machine, I cannot understand why I should get a packet error.

    Can someone tell me what the problem is and how to solve them....
    Thanks
    AK

  2. #2
    Join Date
    Apr 2003
    Posts
    6
    Have the fk an index created on it? Sure not.

    The error probably is you have not desiggned correctly the application, so a deadlock take place and one of the two sessions is killed.

    Cheers

  3. #3
    Join Date
    Apr 2003
    Posts
    2

    TNS BAD PACKET

    Thanks for your reply.
    But there is not deadlock at all.
    Table1 is not depended on table2.
    Table1's primary key is deviceid which is referenced by table2.
    My script for creating the table is
    create table tbDeviceDescription
    (
    txtDeviceID varchar(10) primary key,
    txtDeviceType varchar(14) references tbDevice,
    txtDeviceName varchar(100),
    txtDeviceLocation varchar(100),
    txtroomid varchar(10) references tbroom,
    numPositionX number,
    numPositionY number,
    numPositionZ number,
    numPositionH number,
    numPositionP number,
    numPositionR number
    );

    create table tbTransLoad
    (
    numTransID int primary key,
    txtDeviceID varchar(10) references tbDeviceDescription,
    txtStatus varchar(21),
    txtPropertyValue int,
    dtTransDateTime date,
    txtCommandSource varchar(30)
    );

    And insert is done in the usual Proc/C++ Exec SQl insert.....
    I am not able to see any problems anywhere.....
    Thanks....

  4. #4
    Join Date
    Jul 2010
    Posts
    1
    I would check the firewall between the client and the database server.

Posting Permissions

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