Message "NET: Invalid SID"
Message "NET: Invalid SID"
Hello CoreLab Team!
we've got problems with OraDirect (4.25.23.0) with an exception message saying "NET: Invalid SID". What is this? We are using a connection string in the format:
Data Source=servername;Direct=true;Port=1521;SID=database;User Id=user;Password=password
What are we doing wrong? Is this a known issue in the version (see above) we are using?
Regards from Munich,
Andreas Tremel
we've got problems with OraDirect (4.25.23.0) with an exception message saying "NET: Invalid SID". What is this? We are using a connection string in the format:
Data Source=servername;Direct=true;Port=1521;SID=database;User Id=user;Password=password
What are we doing wrong? Is this a known issue in the version (see above) we are using?
Regards from Munich,
Andreas Tremel
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
You can get a valid SID from the file “tnsnames.ora”, where SID is taken from SERVICE_NAME parameter. Path to the file: (\network\ADMIN\tnsnames.ora).
In this example connection string contains such SID:
tnsnames.ora
------------------
ORA920 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl920)
)
)
In this example connection string contains such SID:
Code: Select all
"...;SID=orcl920;..."
------------------
ORA920 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SERVER)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl920)
)
)
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
Code: Select all
user id=scott;server=ORA1010;direct=False;port=1521 // via client
user id=scott;server=db;direct=True;sid=orcl1010;port=1521 //direct
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
Hello Alexey,
ok, this issue is getting strange. Only SOME operations / transactions fail with the sid-error, not all of them. It seems that larger transactions with many INSERT or SELECT statements fail, while smaller ones work perfectly.
Could that be an error in the OraDirect component?
Regards,
Andreas
ok, this issue is getting strange. Only SOME operations / transactions fail with the sid-error, not all of them. It seems that larger transactions with many INSERT or SELECT statements fail, while smaller ones work perfectly.
Could that be an error in the OraDirect component?
Regards,
Andreas
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
Hello Andreas,
Do you use distributed transactions?
Does any other application use distributed transactions?
Do you have firewall on the server side?
Probably the server closes some connections because of large size of the packages sent.
Try to localize the problem by splitting large transactions (where you have the exception) into a bunch of smaller ones.
Do you use distributed transactions?
Does any other application use distributed transactions?
Do you have firewall on the server side?
Probably the server closes some connections because of large size of the packages sent.
Try to localize the problem by splitting large transactions (where you have the exception) into a bunch of smaller ones.
Hello Alexey,
no, we don't use distributed transactions, on my test server there are no other applications running. No, there is no server-side firewall, although we have one at the router.
I understand, splitting the transactions will probably identify the cause. However, the transactions we're using are atomic - I can under no circumstances split them in the final version of the product. Unfortunately, your suggestion won't help us. Can the problem be somehow reproduced by the development team of CoreLab? We need a solution, and it's becoming to get urgent.
Regards,
Andreas
no, we don't use distributed transactions, on my test server there are no other applications running. No, there is no server-side firewall, although we have one at the router.
I understand, splitting the transactions will probably identify the cause. However, the transactions we're using are atomic - I can under no circumstances split them in the final version of the product. Unfortunately, your suggestion won't help us. Can the problem be somehow reproduced by the development team of CoreLab? We need a solution, and it's becoming to get urgent.
Regards,
Andreas
-
- Posts: 729
- Joined: Thu 13 Dec 2007 10:24
Do you use RAC?
Of course you won't split transactions in the final version.
But currently, that might help to find the source of the problem.
If you say that sometimes it works ok and sometimes it fails with the error message.
Yes, we can try to reproduce the problem, but we need a test project.
Please send it to my email (alexeyman*crlab*com).
We will try find out the reason of the problem in the nearest time.
Of course you won't split transactions in the final version.
But currently, that might help to find the source of the problem.
If you say that sometimes it works ok and sometimes it fails with the error message.
Yes, we can try to reproduce the problem, but we need a test project.
Please send it to my email (alexeyman*crlab*com).
We will try find out the reason of the problem in the nearest time.