Oracle Sql Error 2068
Contents |
following severe error from dblink If this is your first visit, be sure to check out the ora-02068 ora-03113 FAQ by clicking the link above. You may have to oracle sql error codes register before you can post: click the register link above to proceed. To start viewing messages, 02068 zip code select the forum that you want to visit from the selection below. Results 1 to 5 of 5 Thread: ORA-02068: following severe error from dblink
Ora-03135: Connection Lost Contact
Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-17-2009,08:27 AM #1 prathapsingh View Profile View Forum Posts Junior Member Join Date Sep 2009 Posts 2 ORA-02068: following severe error from dblink Dear friends, My database (oracle ora-06512 9.2.0.8.0) will call another database's (oracle 9i cluster) view through DB Link to get some data. If we are to access the data for the first time in a particular session, it gives the output within a second. But if we access the data after 45mins in the same session(already connection is open), the query is running for 9 mins it throws an oracle error. There is no network issue also(solaris 5.8 server). select * from where =; synonym is created in my database for remote database view (schema_name.view_name@dblink_name) please find the Oracle error below: ORA-02068: following severe error from RAMBOMAX ORA-03113: end-of-file on communication channel SID EVENT STATE WAIT_TIME SECONDS_IN_WAIT P1 P2 P3 SQL_HASH_VALUE --- -------------------------------------------------------------------------------- ----- -------------------------------------------------------------------------------- --------------- -- -- -- -------------------------------------------------------------------------------- 547 SQL*Net message to client WAITED KNOWN TIME -1 0 1413697536 1 0 951575186 283 SQL*Net message from dbli WAITING 0 441 675562835 1 0 3503340408 298 SQL*Net message fr
them. SQLSTATE Codes Code Condition Oracle Error 00000 successful completion ORA-00000 01000 warning 01001 cursor ora-00054 operation conflict 01002 disconnect error 01003 null value eliminated
Ora-00942
in set function 01004 string data - right truncation 01005 insufficient item descriptor areas
Ora-01017
01006 privilege not revoked 01007 privilege not granted 01008 implicit zero-bit padding 01009 search condition too long for info schema 0100A query http://www.dbasupport.com/forums/showthread.php?60266-ORA-02068-following-severe-error-from-dblink expression too long for info schema 02000 no data ORA-01095 ORA-01403 07000 dynamic SQL error 07001 using clause does not match parameter specs 07002 using clause does not match target specs 07003 cursor specification cannot be executed 07004 using clause required for dynamic parameters 07005 prepared statement https://docs.oracle.com/cd/E15817_01/appdev.111/b31228/appd.htm not a cursor specification 07006 restricted datatype attribute violation 07007 using clause required for result fields 07008 invalid descriptor count SQL-02126 07009 invalid descriptor index 08000 connection exception 08001 SQL client unable to establish SQL connection 08002 connection name in use 08003 connection does not exist SQL-02121 08004 SQL server rejected SQL connection 08006 connection failure 08007 transaction resolution unknown 0A000 feature not supported ORA-03000 .. 03099 0A001 multiple server transactions 21000 cardinality violation ORA-01427 SQL-02112 22000 data exception 22001 string data - right truncation ORA-01401 ORA-01406 22002 null value - no indicator parameter ORA-01405 SQL-02124 22003 numeric value out of range ORA-01426 ORA-01438 ORA-01455 ORA-01457 22005 error in assignment 22007 invalid date-time format 22008 date-time field overflow ORA-01800 .. 01899 22009 invalid time zone displacement value 22011 substring error 22012 division by zero ORA-01476 22015 interval field overflow 22018 invalid charac
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=ORA-02068 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 page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle oracle sql VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace oracle sql error depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x