SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Oracle Database profile with 8.1.6
Goto page 1, 2  Next
 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Oracle Database profile with 8.1.6
Author Message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Oracle Database profile with 8.1.6 Reply with quote

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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Oracle Database profile with 8.1.6 Reply with quote

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 View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Oracle Database profile with 8.1.6 Reply with quote

: 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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Oracle Database profile with 8.1.6 Reply with quote

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 View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Oracle Database profile with 8.1.6 Reply with quote

: 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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Oracle Database profile with 8.1.6 Reply with quote

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 View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Oracle Database profile with 8.1.6 Reply with quote

: 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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Oracle Database profile with 8.1.6 Reply with quote

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 View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Oracle Database profile with 8.1.6 Reply with quote

: 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 View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Oracle Database profile with 8.1.6 Reply with quote

: 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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Oracle Database profile with 8.1.6 Reply with quote

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 View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Oracle Database profile with 8.1.6 Reply with quote

: 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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Oracle Database profile with 8.1.6 Reply with quote

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 View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Oracle Database profile with 8.1.6 Reply with quote

: 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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Re: Oracle Database profile with 8.1.6 Reply with quote

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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.