 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
Pierre Dupuis
Joined: 22 Aug 2000 Posts: 85
|
|
Oracle Database profile with 8.1.6 |
|
When i try to create a database profile (with database interface) to access our oracle database 8.1.6 and i press "Test connection" button i received those messages:
1 - The procedure entry point xOCIReset coud not be located in the dynamic link library ora805.dll
2 - Connection to 'dwh_prd' failed. DBMS 084 is not supported in your current installation.
Those error append with all oracle database interface with and without AutoCommit and Asyncronous box checked.
Note: I did not tried with ODBC because i don't know how to set it up.
If you have some informations i will appreciate.
Please help.
Thaks.
|
|
Thu Aug 24, 2000 7:34 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
Re: Oracle Database profile with 8.1.6 |
|
You may need to reinstall your Oracle client software. This error may indicate that you have multiple conflicting versions of Oracle client. Have you tried Oracle 7.3 driver? : When i try to create a database profile (with database interface) to access : our oracle database 8.1.6 and i press "Test connection" button i : received those messages: 1 - The procedure entry point xOCIReset coud not : be located in the dynamic link library ora805.dll : 2 - Connection to 'dwh_prd' failed. DBMS 084 is not supported in your current : installation. : Those error append with all oracle database interface with and without : AutoCommit and Asyncronous box checked. : Note: I did not tried with ODBC because i don't know how to set it up. : If you have some informations i will appreciate. : Please help. : Thaks.
|
|
Thu Aug 24, 2000 8:23 am |
|
 |
Pierre Dupuis
Joined: 22 Aug 2000 Posts: 85
|
|
Re: Oracle Database profile with 8.1.6 |
|
: You may need to reinstall your Oracle client software. This error may : indicate that you have multiple conflicting versions of Oracle client. : Have you tried Oracle 7.3 driver? Have multiple conflicting versions of Oracle client is imposible because this is a new server where only 8.1.6 was installed. Does your software support (Database interface) support version 8.1.6? How i can use the Oracle 7.3 Driver?
|
|
Thu Aug 24, 2000 8:59 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
Re: Oracle Database profile with 8.1.6 |
|
Do you have Oracle client software installed on your server? Yes, 24x7 does support Oracle 8.1.6, but in order to connect to the database it requires standard SQL*Net8 and Oracle client (any version 7.3, or 8.0 or later) installed on the computer where 24x7 Scheduler is running. : Have multiple conflicting versions of Oracle client is imposible because this : is a new server where only 8.1.6 was installed. : Does your software support (Database interface) support version 8.1.6? : How i can use the Oracle 7.3 Driver?
|
|
Thu Aug 24, 2000 10:26 am |
|
 |
Pierre Dupuis
Joined: 22 Aug 2000 Posts: 85
|
|
Re: Oracle Database profile with 8.1.6 |
|
: Do you have Oracle client software installed on your server? : Yes, 24x7 does support Oracle 8.1.6, but in order to connect to the database : it requires standard SQL*Net8 and Oracle client (any version 7.3, or 8.0 : or later) installed on the computer where 24x7 Scheduler is running. Yes Oracle client and SQL*Net8 are already install on the server. If i try to connect to the database with SQL*PLUS it work fine. Please could you give me more details on how setup Oracle Database profile? (i.e. what i shoud have in the Database field and Server Field) Thanks.
|
|
Thu Aug 24, 2000 11:10 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
Re: Oracle Database profile with 8.1.6 |
|
SQL*Plus and other Oracle own tools don't use the client and talk to the SQl*Net/server directly. All other vendors, including us, have to use it. For the database field, leave it blank, as it is not used in Oracle. For the Server, enter "Connect string" it is the same in SQL*Plus and usually just the instance name (may be prefixed by communication protocol). Use "Async" only in very special cases, for example if you your query to be canceled if it does not end itself in the specified time Same for the "isolation level", leave it blank unless doing something really special. : Yes Oracle client and SQL*Net8 are already install on the server. : If i try to connect to the database with SQL*PLUS it work fine. : Please could you give me more details on how setup Oracle Database profile? : (i.e. what i shoud have in the Database field and Server Field) : Thanks.
|
|
Thu Aug 24, 2000 12:16 pm |
|
 |
Pierre Dupuis
Joined: 22 Aug 2000 Posts: 85
|
|
Re: Oracle Database profile with 8.1.6 |
|
: SQL*Plus and other Oracle own tools don't use the client and talk to the : SQl*Net/server directly. All other vendors, including us, have to use it. : For the database field, leave it blank, as it is not used in Oracle. : For the Server, enter "Connect string" it is the same in SQL*Plus : and usually just the instance name (may be prefixed by communication : protocol). : Use "Async" only in very special cases, for example if you your : query to be canceled if it does not end itself in the specified time : Same for the "isolation level", leave it blank unless doing : something really special. Now when i try the Test connection button the first message i received was: Connection to " failed. ORA-12560: TNS:protocol adapter error. When i repress the button i received a DR. Watson error. Do you have any idea?
|
|
Thu Aug 24, 2000 12:43 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
Re: Oracle Database profile with 8.1.6 |
|
Except from the Oracle manual ORA-12560: "TNS:protocol adapter error" Cause: The listener was unable to start a process connecting the user to the database server. Actions: Turn on Oracle tracing and re-execute the operation. Evaluate the contents of the trace file to diagnose the problem. Often it is caused by incorrect server "connect string" in 24x7 database profile or invalid configuration in Oracle TNSNAMES.ORA file. In the last case, use EZNet configuration utility to correct it. Please see your oracle documentation for more details : Now when i try the Test connection button the first message i received was: : Connection to " failed. ORA-12560: TNS:protocol adapter error. : When i repress the button i received a DR. Watson error. : Do you have any idea?
|
|
Thu Aug 24, 2000 2:23 pm |
|
 |
Pierre Dupuis
Joined: 22 Aug 2000 Posts: 85
|
|
Re: Oracle Database profile with 8.1.6 |
|
: Except from the Oracle manual : ORA-12560: "TNS:protocol adapter error" : Cause: The listener was unable to start a process connecting the user to the : database server. : Actions: Turn on Oracle tracing and re-execute the operation. Evaluate the : contents of the trace file to diagnose the problem. : Often it is caused by incorrect server "connect string" in 24x7 : database profile : or invalid configuration in Oracle TNSNAMES.ORA file. In the last case, use : EZNet configuration utility to correct it. : Please see your oracle documentation for more details I TOLD YOU THAT MY CONNECTION (DatabaseConnectEx)WORK THE FIRST TIME AND FAIL THE AT THE SECOND EXECUTION WITH A DR. WATSON ERROR SO I NEED TO RESTART 24X7. I DON'T THINK THAT MY TNSNAMES.ORA IS BAD BECAUSE THE CONNECTION WORK EVERYTIME I RESTART 24X7. WE PLAN TO BY YOUR PRODUCT FOR A FEW SERVER BUT OUR TESTING ARE NOT GOING VERY WELL. (see other problem in the forum) PLEASE COULD YOU HELP!!!!
|
|
Tue Aug 29, 2000 7:19 am |
|
 |
Pierre Dupuis
Joined: 22 Aug 2000 Posts: 85
|
|
Re: Oracle Database profile with 8.1.6 |
|
: Have multiple conflicting versions of Oracle client is imposible because this : is a new server where only 8.1.6 was installed. : Does your software support (Database interface) support version 8.1.6? : How i can use the Oracle 7.3 Driver? Does your product support multiple oracle net8 version?
|
|
Tue Aug 29, 2000 7:25 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
Re: Oracle Database profile with 8.1.6 |
|
I don't know why it fails on a second connect, but here is a workaround for this situation. Leave this job with "no schedule" schedule and schedule another "script" job instead. That job will execute the first one using Dim(pid, number) Run("24x7 /JOB[first job id here]", "", pid) This will start another instance of 24x7 that will run the job and exit. Therefore, it will ensure only one connection per instance. : I TOLD YOU THAT MY CONNECTION (DatabaseConnectEx)WORK THE FIRST TIME AND FAIL : THE AT THE SECOND EXECUTION WITH A DR. WATSON ERROR SO I NEED TO RESTART : 24X7. I DON'T THINK THAT MY TNSNAMES.ORA IS BAD BECAUSE THE CONNECTION : WORK EVERYTIME I RESTART 24X7. : WE PLAN TO BY YOUR PRODUCT FOR A FEW SERVER BUT OUR TESTING ARE NOT GOING : VERY WELL. (see other problem in the forum) : PLEASE COULD YOU HELP!!!!
|
|
Tue Aug 29, 2000 8:17 am |
|
 |
Pierre Dupuis
Joined: 22 Aug 2000 Posts: 85
|
|
Re: Oracle Database profile with 8.1.6 |
|
: I don't know why it fails on a second connect, but here is a workaround for : this situation. Leave this job with "no schedule" schedule and : schedule another "script" job instead. That job will execute the : first one using : Dim(pid, number) : Run("24x7 /JOB[first job id here]", "", pid) : This will start another instance of 24x7 that will run the job and exit. : Therefore, it will ensure only one connection per instance. I THINK YOU MISUNDERSTOOD!!!!! SEE ATTACH JOB BELOW. MY JOB IS SCHEDULE TO RUN EVERY HOURS AND TAKE 2 MINUTES. MY JOB RAN AT 7 THIS MORNING WITH NO PROBLEM WHEN MY JOB RERAN AT 8 MY JOB FAIL WHEN TRY TO A CONNECT TO DATABASE (DatabaseConnectEx) I GOT A DR. WATSON ERROR WITH A ACCESS VIOLATION. NO OTHER JOB ACCESS THE DATABASE SO NO MULTI CONNECTION PER INSTANCE IS POSSIBLE. MY JOB: // ******************************************************************* // Program: ChkCsiRj.JAL // Description: Check rejected record for CSI and send email to constant // recipient. // Date: 2000-08-22 // Autor: Pierre Dupuis // // Modification: // Date: // Autor: // ******************************************************************* // *** Constant *** Dim mail_recipient, string, "mtl_ecm_support_team" //Dim mail_recipient, string, "pierre_dupuis" Dim DBMS, string, "Oracle 8.0.4 - 8i" Dim server_name, string, "ecm_dev" Dim database_name, string, "ecm_dev" Dim database_user, string, "csi_fct" Dim database_password, string, "csi_fct" Dim sql_select,string, "select ID,SOURCE_FILE_NAME,LOADING_STATUS,NB_REJECTED_RECORDS from csi_loading_logs where loading_status != 0 and notice_ind = 0" Dim sql_update,string, "update csi_loading_logs set notice_ind=1 where id = " Dim message_status_1,string, "ID, SOURCE_FILE_NAME, LOADING_STATUS, NB_REJECTED_RECORDS: " Dim message_status_2,string, "ID, SOURCE_FILE_NAME, LOADING_STATUS, NB_REJECTED_RECORDS: " Dim message_status_3,string, "ID, SOURCE_FILE_NAME, LOADING_STATUS, NB_REJECTED_RECORDS: " Dim message_status_other,string, "ID, SOURCE_FILE_NAME, LOADING_STATUS, NB_REJECTED_RECORDS: " Dim subject_status_1,string, "ChkCSIRj: Rejected records found" Dim subject_status_2,string, "ChkCSIRj: All file was rejected" Dim subject_status_3,string, "ChkCSIRj: Adnormal end of program" Dim subject_status_other,string, "ChkCSIRj: Other errors" Dim rows, number Dim str_rows, string Dim message, string Dim subject, string Dim update, string Dim row_updated, number Dim res_id, string Dim res_source_file_name, string Dim res_loading_status, string Dim res_nb_rejected_records, string Dim empty, boolean Dim cmp, boolean Dim update_err, boolean Dim ind1, number // Connect to database //DatabaseConnectEx( "Oracle 8.0.4 - 8i","ecm_dev","ecm_dev" ,"csi","csi",FALSE ) DatabaseConnectEx( DBMS, server_name, database_name , database_user, database_password ,FALSE ) DatabaseRetrieve( sql_select, rows ) IsEqual( rows, 0, empty ) IfThen( empty, END ) // Get id and update notice_ind string (rows, str_rows) ForNext(ind1,1,rows,1,END_LOOP) DatabaseGet ind1,1,res_id DatabaseGet ind1,2,res_source_file_name DatabaseGet ind1,3,res_loading_status DatabaseGet ind1,4,res_nb_rejected_records // Check Status IsEqual( res_loading_status, 1, cmp) If( cmp, STATUS_1, CHECK_STATUS_2) STATUS_1: SET(message, message_status_1) SET(subject, subject_status_1) CHECK_STATUS_2: IsEqual( res_loading_status, 2, cmp) If( cmp, STATUS_2, CHECK_STATUS_3) STATUS_2: SET(message, message_status_2) SET(subject, subject_status_2) CHECK_STATUS_3: IsEqual( res_loading_status, 3, cmp) If( cmp, STATUS_3, OTHER_STATUS) STATUS_3: SET(message, message_status_3) SET(subject, subject_status_3) OTHER_STATUS: IsGreater res_loading_status, 3, cmp If( cmp, STATUS_OTHER, MAIL) STATUS_OTHER: SET(message, message_status_other) SET(subject, subject_status_other) MAIL: concat message,res_id,message concat message,",",message concat message,res_source_file_name,message concat message,",",message concat message,res_loading_status,message concat message,",",message concat message,res_nb_rejected_records,message // send email alert MailSend "", "", mail_recipient, subject, message // MessageBox(subject) // MessageBox(message) // Update notice_ind = 1 with ID Concat sql_update,res_id,update // MessageBox(update) DatabaseExecute update, row_updated //DatabaseExecute "commit", row_updated // Check Update // IsEqual( row_updated, 0, update_err ) // If( update_err, UPDATE_ERROR, NO_ERROR ) // UPDATE_ERROR: // messageBox("update error") // Concat message1, str_rows, message1 // MailSend "", "", mail_recipient, subject, message1// // NO_ERROR: END_LOOP: goto end END: // Normal end DatabaseDisconnect
|
|
Tue Aug 29, 2000 8:51 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
Re: Oracle Database profile with 8.1.6 |
|
Yes, I understood this very well. I suggested a workaround to avoid the "second" (sequential) connection and thus avoid seen the Dr.Watson. : I THINK YOU MISUNDERSTOOD!!!!! : SEE ATTACH JOB BELOW. : MY JOB IS SCHEDULE TO RUN EVERY HOURS AND TAKE 2 MINUTES. : MY JOB RAN AT 7 THIS MORNING WITH NO PROBLEM : WHEN MY JOB RERAN AT 8 MY JOB FAIL WHEN TRY TO A CONNECT TO DATABASE : (DatabaseConnectEx) I GOT A DR. WATSON ERROR WITH A ACCESS VIOLATION. : NO OTHER JOB ACCESS THE DATABASE SO NO MULTI CONNECTION PER INSTANCE IS : POSSIBLE. : MY JOB: // : ******************************************************************* : // Program: ChkCsiRj.JAL : // Description: Check rejected record for CSI and send email to constant : // recipient. : // Date: 2000-08-22 : // Autor: Pierre Dupuis : // : // Modification: // Date: // Autor: // : ******************************************************************* : // *** Constant *** : Dim mail_recipient, string, "mtl_ecm_support_team" : //Dim mail_recipient, string, "pierre_dupuis" : Dim DBMS, string, "Oracle 8.0.4 - 8i" : Dim server_name, string, "ecm_dev" : Dim database_name, string, "ecm_dev" : Dim database_user, string, "csi_fct" : Dim database_password, string, "csi_fct" : Dim sql_select,string, "select : ID,SOURCE_FILE_NAME,LOADING_STATUS,NB_REJECTED_RECORDS from : csi_loading_logs where loading_status != 0 and notice_ind = 0" : Dim sql_update,string, "update csi_loading_logs set notice_ind=1 where : id = " : Dim message_status_1,string, "ID, SOURCE_FILE_NAME, LOADING_STATUS, : NB_REJECTED_RECORDS: " : Dim message_status_2,string, "ID, SOURCE_FILE_NAME, LOADING_STATUS, : NB_REJECTED_RECORDS: " : Dim message_status_3,string, "ID, SOURCE_FILE_NAME, LOADING_STATUS, : NB_REJECTED_RECORDS: " : Dim message_status_other,string, "ID, SOURCE_FILE_NAME, LOADING_STATUS, : NB_REJECTED_RECORDS: " : Dim subject_status_1,string, "ChkCSIRj: Rejected records found" : Dim subject_status_2,string, "ChkCSIRj: All file was rejected" : Dim subject_status_3,string, "ChkCSIRj: Adnormal end of program" : Dim subject_status_other,string, "ChkCSIRj: Other errors" : Dim rows, number : Dim str_rows, string : Dim message, string : Dim subject, string : Dim update, string : Dim row_updated, number : Dim res_id, string : Dim res_source_file_name, string : Dim res_loading_status, string : Dim res_nb_rejected_records, string : Dim empty, boolean : Dim cmp, boolean : Dim update_err, boolean : Dim ind1, number : // Connect to database : //DatabaseConnectEx( "Oracle 8.0.4 - : 8i","ecm_dev","ecm_dev" : ,"csi","csi",FALSE ) : DatabaseConnectEx( DBMS, server_name, database_name , database_user, : database_password ,FALSE ) : DatabaseRetrieve( sql_select, rows ) : IsEqual( rows, 0, empty ) : IfThen( empty, END ) : // Get id and update notice_ind : string (rows, str_rows) : ForNext(ind1,1,rows,1,END_LOOP) : DatabaseGet ind1,1,res_id : DatabaseGet ind1,2,res_source_file_name : DatabaseGet ind1,3,res_loading_status : DatabaseGet ind1,4,res_nb_rejected_records : // Check Status : IsEqual( res_loading_status, 1, cmp) : If( cmp, STATUS_1, CHECK_STATUS_2) : STATUS_1: SET(message, message_status_1) : SET(subject, subject_status_1) : CHECK_STATUS_2: IsEqual( res_loading_status, 2, cmp) : If( cmp, STATUS_2, CHECK_STATUS_3) : STATUS_2: SET(message, message_status_2) : SET(subject, subject_status_2) : CHECK_STATUS_3: IsEqual( res_loading_status, 3, cmp) : If( cmp, STATUS_3, OTHER_STATUS) : STATUS_3: SET(message, message_status_3) : SET(subject, subject_status_3) : OTHER_STATUS: IsGreater res_loading_status, 3, cmp : If( cmp, STATUS_OTHER, MAIL) : STATUS_OTHER: SET(message, message_status_other) : SET(subject, subject_status_other) : MAIL: concat message,res_id,message : concat message,",",message : concat message,res_source_file_name,message : concat message,",",message : concat message,res_loading_status,message : concat message,",",message : concat message,res_nb_rejected_records,message : // send email alert : MailSend "", "", mail_recipient, subject, message : // MessageBox(subject) : // MessageBox(message) : // Update notice_ind = 1 with ID : Concat sql_update,res_id,update : // MessageBox(update) : DatabaseExecute update, row_updated : //DatabaseExecute "commit", row_updated : // Check Update : // IsEqual( row_updated, 0, update_err ) : // If( update_err, UPDATE_ERROR, NO_ERROR ) : // UPDATE_ERROR: // messageBox("update error") : // Concat message1, str_rows, message1 : // MailSend "", "", mail_recipient, subject, message1// : // NO_ERROR: END_LOOP: goto end : END: // Normal end : DatabaseDisconnect
|
|
Tue Aug 29, 2000 11:05 am |
|
 |
Pierre Dupuis
Joined: 22 Aug 2000 Posts: 85
|
|
Re: Oracle Database profile with 8.1.6 |
|
: Yes, I understood this very well. I suggested a workaround to avoid the : "second" (sequential) connection and thus avoid seen the : Dr.Watson. Ok. Sorry I missunderstood. I tried it and it's work fine. Do you plan to fix the problem permanently? Thanks for your help.
|
|
Tue Aug 29, 2000 11:33 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
Re: Oracle Database profile with 8.1.6 |
|
We are using some third party components for the Oracle connections. They say that there is a bug in some versions of the Oracle 8 OCI (part of Oracle 8 client). The OCI.DLL does not clean up the memory completely after connection is closed. As result of that the subsequent connection may fail. : Ok. Sorry I missunderstood. I tried it and it's work fine. : Do you plan to fix the problem permanently? : Thanks for your help.
|
|
Tue Aug 29, 2000 11:58 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|