Jump to content

Asp.net Sahakaram


nrikittu

Recommended Posts

na project lo oracle client 10g 32 bit DB kosam vaduthunaru, ORA 6413 connection not open ani error koduthundhi login avdam ani start debug kodithe. google chesthe upgrade oracle client to 11g ani antunaru stack overflow vatillo. Alaa chesthe application work avadhu oddu ma systems lo oracle 32 bit ye undhi 10g ani antunaru co team members llittle seniors to me am new here. uninstall chesi kotha ga try chesthunte kotha kotha errors osthunay system doesn't recognise oracle client ani.

 

system reimage chei anni software malli vestunadu network admin, registry tho emaina issue undemo ani..

 

emi cheyali application work avali ante, adhi avuthey kani co team members Knowledge Transfer start cheyali inka naku WEB DMS inka XML Engine paina vatillo Maintenance or Support work undochu.

Link to comment
Share on other sites

Maa office lo kuda same issue...oracle ...11g ki upgrade chestene..maa application ni upgrade cheyagalam.. dba s inka 10g using...emanna ante ..11g cheste users ki prob avvudi..valla applications pani cheyaavu ani..telling...chastunnam vellatho

Link to comment
Share on other sites

Odiamm ee issue thoo weekend anta chadagotukuna
1 which version is ur project using ? Point it to X84 right click on project properties > build
2 what is the version of dll system.oracleclient u have is it going to framework64 ? If so change it to framework/system.oracleclient
3 change settings in iis point to use 32 bit
4 if it doesn't work just install 64 bit and creat environment TNS_ADMIN variable and point tnsnames.ora this is what I did to solve

Link to comment
Share on other sites

Maa office lo kuda same issue...oracle ...11g ki upgrade chestene..maa application ni upgrade cheyagalam.. dba s inka 10g using...emanna ante ..11g cheste users ki prob avvudi..valla applications pani cheyaavu ani..telling...chastunnam vellatho

 

 

baa same ma dantlo kuda 11g upgraded now working fine.

Link to comment
Share on other sites

Odiamm ee issue thoo weekend anta chadagotukuna
1 which version is ur project using ? Point it to X84 right click on project properties > build
2 what is the version of dll system.oracleclient u have is it going to framework64 ? If so change it to framework/system.oracleclient
3 change settings in iis point to use 32 bit
4 if it doesn't work just install 64 bit and creat environment TNS_ADMIN variable and point tnsnames.ora this is what I did to solve

 

system reimage chesi oracle 11g install chesadu maa network admin, ipdu run avthundhi

Link to comment
Share on other sites

Odiamm ee issue thoo weekend anta chadagotukuna
1 which version is ur project using ? Point it to X84 right click on project properties > build
2 what is the version of dll system.oracleclient u have is it going to framework64 ? If so change it to framework/system.oracleclient
3 change settings in iis point to use 32 bit
4 if it doesn't work just install 64 bit and creat environment TNS_ADMIN variable and point tnsnames.ora this is what I did to solve

 

i believe its x86

Link to comment
Share on other sites

if the conn is not open error vaste...break point petti debug chei...

 

1) if using enterprise library then check if the connection string is getting passed and all that (coz if using enterprise lib the dbcontext will automatically open the connection when u instantiate this db context object)

 

2) conn is not open ante , you may have to explicitly open the connection, do this when u hit the break point where the connection is not open , stop the debugging and insert the code like this.

 

Assuming you instantiate the connection object like so:

 

oracledbconnection connObj = new oracledbconnection();

connObj.open(); // this will open the connection

 

// do what u have to do here

 

connObj.close(); // this will close the connection

connObj.Dispose();

 

 

Link to comment
Share on other sites

×
×
  • Create New...