25408 Oracle Error
Contents |
Library mySQL Code ora-25408 rac Library PHP Code Library JavaScript Code Library Oracle Terms & Definitions
Rman Ora-25408: Can Not Safely Replay Call
Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle
Ora-25408 Peoplesoft
Magazines Online Learning Center PSOUG Presentations Advanced Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-25408 Error Description: Can not safely replay call Error Cause: The oracle error ora-25408 can not safely replay call connection was lost while doing this call. It may not be safe to replay it after failover. Action: Check to see if the results of the call have taken place, and then replay it if desired. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 133 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this
Ora-25408 Sap
page. Please enter a title. You can not post a blank ora-25402 message. Please type your message and try again. More discussions in RAC, ASM & Clusterware Installation All PlacesDatabasePerformance failover & AvailabilityRAC, ASM & Clusterware Installation 4 Replies Latest reply on Jul 15, 2016 7:44 PM by Mudasir Hakak What can cause "ORA-25408: can not safely replay call" with http://psoug.org/oraerror/ORA-25408.htm all instances in RAC running ok ? paolo_castle Jul 1, 2016 11:54 PM Hello, I am getting "ORA-25408: can not safely replay call" using DRCP pooled connections on a 2 nodes RAC SE ( 12c ) Connections are on a service properly configured for TAF , but when I look at instance activity I can see that https://community.oracle.com/thread/3946441 both instances are up since months ... no failover should have occurred.Do you know in what cases connections could get the ORA-25408 even if instaces keep running smoothly ? Thank you in advance,Paolo Castelletti I have the same question Show 0 Likes(0) 1103Views Tags: none (add) ora-25408Content tagged with ora-25408, rac taf 12cContent tagged with rac taf 12c This content has been marked as final. Show 4 replies 1. Re: What can cause "ORA-25408: can not safely replay call" with all instances in RAC running ok ? SVM1225 Jul 2, 2016 5:20 AM (in response to paolo_castle) Hi ,You may refer below discussion for the same.ORA-25408 can not safely replay call Like Show 0 Likes(0) Actions 2. Re: What can cause "ORA-25408: can not safely replay call" with all instances in RAC running ok ? paolo_castle Jul 2, 2016 9:07 PM (in response to SVM1225) Thanks, but in this thread author assumes that failover has occurred when the error appears.Can failover occurr without any instance failure or server process failure shown i
in Engine log 50170000000OvNKAA0 Technote (troubleshooting) Problem(Abstract) After making http://www.ibm.com/support/docview.wss?uid=swg21471728 a database change, you may see the errors below: 06:00:15 [1112082784] ERROR ODBC [S1000] [DataDirect][ODBC Oracle driver][Oracle]ORA-25408: can not safely replay call (DBError=25408) 06:00:15 http://stackoverflow.com/questions/21378115/oracle-rac-failover-with-clob-query [1112082784] ERROR MPI_EnvSeqGetNext: SQLExecute(1) failed, rc=-1. 06:00:15 [1112082784] ERROR MPI_EnvSeqGetNext: ODBC error, disconnecting. 06:00:15 [1151183200] ERROR MPI_EnvSeqGetNext: reconnecting ... 06:00:15 [1112082784] ERROR USR=rwuser, oracle error IXN=MEMPUT, ERR=EODBC, MSG=unable to generate audrecno sequence. 06:00:15 [1112082784] ERROR MPI_IxnExec_ODBC: ixn failed due to ODBC error. 06:00:15 [1112082784] ERROR MPI_IxnExec_ODBC: disconnecting from database server. 06:00:16 [1112082784] ERROR MPI_SrvCtxPoolOnDbxError: disconnecting free database connections. 06:00:16 [1151183200] AUDIT MEMPUT: member XYZ-09:xxxxxxxxx, being processed. 06:00:16 [1112082784] ERROR ODBC [S1000] [DataDirect][ODBC Oracle can not safely driver][Oracle]ORA-25408: can not safely replay call Resolving the problem It appears that the MEMPUT was successful, but took a while (probably due to an Oracle failover): 06:00:16 [1151183200] AUDIT MEMPUT: member XYZ-09:xxxxxxxxxx, being processed. 06:00:17 [1151183200] AUDIT MEMPUT: member XYZ-09:xxxxxxxxxx, created. 06:00:17 [1151183200] TIMER IXN=MEMPUT, USR=zzzzzz, elapsed = 1.382 seconds. The Master Data Engine will listen indefinitely for a response from the Oracle listener. However, if the Oracle listener does return an ODBC error, then the MDE will return one to the calling application and report an ODBC error in the engine log (as reported in this case). Timeouts to the database are owned by the ODBC driver or the database server itself. In a scenario where nodes in a cluster will be shut down, the requests will continue to be sent to the cluster. The RAC controller will dutifully cache thos
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle RAC Failover with CLOB query up vote 3 down vote favorite All. We have an Oracle RAC cluster installation and we are using TAF to test the RAC failover on SELECT. We use OCI driver instant client version 11.2, and RAC with 2 replica nodes. We tried a simple OCI based application written in C to connect to our DB and retrieve all the records from a table. Everything works fine if we do not include a CLOB column in the SELECT. If we perform a SELECT on a CLOB column and we iterate over the result-set to print its content, the OCI driver seems not to be able to properly recover the query when a node goes down. The following error code is consistently raised: ORA-25408: can not safely replay call during either OCILobLocatorIsInit / OCILobGetLength / OCILobRead. After this error, the iteration on OCIStmtFetch resumes but the record that got the failover exception is not resumed. Is this the expected behavior of the OCI driver failover implementation? Or do we need to modify/enhance the way we are retrieving the buffer data from the CLOB? This is an snipped of the OCI calls we are using: checkerr(errhp, OCIStmtExecute(svchp, stmthp, errhp, (ub4)1, (ub4)0, (OCISnapshot*)NULL, (OCISnapshot*)NULL, (ub4)OCI_DEFAULT), __LINE__); do { checkerr(errhp, OCILobLocatorIsInit((dvoid*)envhp, errhp, lobl, &flag), __LINE__); checkerr(errhp, OCILobGetLength(svchp, errhp, lobl, &loblen), __LINE__); amtp = loblen; checkerr(errhp, OCILobRead(svchp, errhp, lobl, &amtp, 1, (dvoid*)buf, (loblen < MAX_SIZE ? loblen : MAX_SIZE), 0, 0, 0, SQLCS_IMPLICIT), __LINE__); buf[amtp]='\0'; printf("value=%d, text=%s\n", custno, buf); } while ( (status = OCIStmtFetch(stmthp, errhp, (ub4)1, (ub4)OCI_FETCH_NEXT, (ub4)OCI_DEFAULT)) == OCI_SUCCESS || status == OCI_SUCCESS_WITH_INFO); The typical program output is similar to: value = 306, text=ID_#306 value = 307, text=ID_#307 Error - ORA-25408: can not safely replay call value = 30