| A problem of ora-03106 and ora-03121, thanks! [message #116556] |
Wed, 20 April 2005 10:59  |
GuteNacht
Messages: 16
Registered: April 2005
|
Junior Member |
|
|
Hello,
sever: windows2000server + oracle 8.1.7
client: windows2000professional
sqlplus 3.3 (is the version too low?)
when I used the client computer (sql*plus) to connect the server, the error came out:
ora-03106 fatal two-task communication protocol error.
I wonder if it is the version problem.
How to settle down it? To refine some parameters or just install a new higher version in the client?
Thank you!
By the way, when I input the username and password in the sql*plus enviroment at the first time, the ora-03106 error came out, but when I input the username and pwd again, another error ora-03121:no interface driver connected - function not performed.
I wonder why these two?
Thank you very much!
Regards,
Norah
|
|
|
|
| Re: A problem of ora-03106 and ora-03121, thanks! [message #116560 is a reply to message #116556] |
Wed, 20 April 2005 11:15  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
First check your Orcale service is on or not , goto control pannel then goto services then try to find out OracleService<databasename>, if you find it then turn it on, If you dont find it then create new service to connect with database.
Regards
meaning of ora-03121
ORA-03121 no interface driver connected - function not performed
This message occurs usually because the SQL*Net driver is not loaded into memory or there is a mismatch of the version of the driver. A user program linked with an obsolete library may also cause this message. Only programs provided by Oracle Corporation should use this interface.
from sunil
|
|
|
|
|
|
|
|
| Re: A problem of ora-03106 and ora-03121, thanks! [message #116710 is a reply to message #116645] |
Thu, 21 April 2005 09:42 |
GuteNacht
Messages: 16
Registered: April 2005
|
Junior Member |
|
|
| sunil_v_mishra wrote on Thu, 21 April 2005 03:17 |
hi,
First of all tell me are you able to solve your problem or not
sunil
|
Well, The only way I have thought is to install a new higher sql*plus.
I wonder if there is another way.
I greatly appreciate it.
Regards
Norah
|
|
|
|
| Re: A problem of ora-03106 and ora-03121, thanks! [message #116782 is a reply to message #116710] |
Fri, 22 April 2005 01:00 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
As you are trying to install new higher version of sql*plu ... then i want to tell u few things ....
If your are installing for learning purpose .. then its better to format your PC then install operating system and on it try to install oracle again from scratch.
from:-sunil
|
|
|
|
| Re: A problem of ora-03106 and ora-03121, thanks! [message #117407 is a reply to message #116782] |
Wed, 27 April 2005 02:14 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
Some reasons why you may get this error:
Troubleshooting
===============
Two-task common errors are generally RDBMS related issues, but could be caused by a problem with SQL*Net, or an application (i.e. Pro*C).
ORA-03106
======== Possible reasons for the ORA-03106 errors include:
1. Incompatibilities between the client application and the RDBMS server.
For example, version incompatibilities, or a client trying to use a feature not supported by the database kernel.
2. When using database links or gateways.
3. Network or SQL*Net problems.
4. Corruptions.
5. PL/SQL - language related.
In your case, most obvious reason can be point 1. Do upgrade the SQL client and then check.
Well, One more way to resolve this is to
Try synching the NLS_LANG variable on the client and server.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
