Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpsp

939393Sep 3 2012 — edited Sep 3 2012

Hi Guru's,

My DB Version: 10.1.0.2.0
OS Version: Windows Server 2003

I am using SQL Loader to load text files into DB. But whenever queries are running on the system side by side i am getting TNS protocol error. but when there are no queries runn and only loading is done in between the Loading i am gettng TNS Protocol Adapter error. When i check alert log file i am getting error as :

skgpspawn failed:category = 27143, depinfo = 9261, op = spdcr, loc = skgpspawn

continously

but i am getting TNS protocol adapter error on loading screen

even at this time if i am able to connect to database with sys dba account i am getting the sam tns error

but after few minutes the error is removed and i am able to connect to db and if i restart the loading is also started but again in mid of loading the problem again occurs.

i google and make change in the sqlnet file by setting tme out parameter =0 but it will not help
even i search this forum previous post about the same problem but not getting any solution for the same

Can anyone please guide over the same