Oracle Error 00108
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have sbl-dbc-00108 JavaScript enabled. This tool uses JavaScript
Sbl-dbc-00105 In Siebel
and much of it will not work correctly without it sbl-dbc-00111 enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle 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 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
to the fact that the network protocol used by the the dispatcher does not support aynchronous operations. Action: Contact your ORACLE representative. Version 10g failed to set up dispatcher to accept connection asynchronously Cause: Most likely due to the fact that the network protocol used by the the dispatcher does not support aynchronous operations. Action: Contact your ORACLE representative. Version 9i failed to set https://community.oracle.com/community/developer/search.jspa?q=ORA-00108 up dispatcher to accept connection asynchronously Cause: The network protocol used by the dispatcher does not support asynchronous operations. Action: Contact Oracle Support Services. Version 8i failed to set up dispatcher to accept connection asynchronously Cause: The network protocol used by the dispatcher does not support asynchronous operations. Action: Contact Oracle http://www.oracle-error.com/8i/ora-00108.html Customer Support. This entry was posted in Oracle 10g Errors, Oracle 11g Errors, Oracle 8i Errors, Oracle 9i Errors, Oracle Database Server Messages. Bookmark the permalink. Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Currently you have JavaScript disabled. In order to post comments, please make sure JavaScript and Cookies are enabled, and reload the page. Click here for instructions on how to enable JavaScript in your browser. Search for: Recent Commentsabhi on ORA-24237oracle-error on ORA-24237abhi on ORA-24237Mike TAILOR on ORA-12154oracle-error on ORA-39776Support services ? Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support Archives April 2015 Categories EXP Messages Oracle 10g Errors Oracle 11g Errors Oracle 8i Errors Oracle 9i Errors Oracle Database Server Messages Recent Posts XML-30017 XML-30016 XML-30014 XML-30013 XML-30012 Oracle-Error.com 2016Zerif Lite pow
or search for a resolution mostly from Oracle Support, IT Toolbox, Siebel Unleashed etc. I have tried to http://www.error-codes.info/2011/02/sbl-dbc-00108-error-has-occurred.html search for all the solutions for a particular error code in http://earlruby.org/2010/04/running-oracles-csscan-utility-as-sysdba/ all the mentioned sites and put all the solutions in this site. Search This Blog SBL-DBC-00108: An error has occurred preparing a Sql statement. Applies to: Siebel Tools - Version: 7.5.3 [100] to 8.1.1.2 - Release: V7 to V8Information in this document applies to any platform. PurposeThis oracle error document is intended to provide cause and corrective action information about SiebelError Message SBL-DBC-00108: An error has occurred preparing a Sql statement.Please continue or ask your systems administrator to check your application configuration if the problem persists. ScopeThis document is informational and intended for any user. SBL-DBC-00108: An error has occurred preparing a Sql statement.Please continue or ask oracle error 00108 your systems administrator to check your application configuration if the problem persists.ExplanationThis error message can occur when a user navigates to a screen or view or executes a query in an applet. This error is generated when a SQL statement, usually a SELECT statement,failed to be prepared against the database server.In order to troubleshoot the error message it is important to review the error message returned by the database, which should be logged in the Siebel log files.It is important to obtain the failing SQL statement as well but SQL statements are not logged unless SQL tracing is enabled.- Start by spooling the SQL, using the /s option, if the error is reproducible in the dedicated client or mobile client. This spools all the SQL being generated by the application client to a log file and allows the SQL statement causing the error to be identified and reviewed. See Document 475564.1 Using the /S Option to Examine the SQL Generated by Siebel Enterprise Application for more information.- If the error is rep
to a new character set, you may have problems getting it to run "as sysdba". There are a number of articles on the web that explain how to do this, and most of the explanations don't work. Oracle.com says that you should use: CSSCAN /AS SYSDBA FULL=Y This gives the error: LRM-00108: invalid positional parameter value 'SYSDBA' failed to process command line parameters Scanner terminated unsuccessfully. Others recommend: csscan "SYS/[password] as sysdba" full=y tochar=AL32UTF8 array=1024000 process=16 Which results in: LRM-00108: invalid positional parameter value 'as' failed to process command line parameters Scanner terminated unsuccessfully. Various other guides on the web also fail to work. Trying to run csscan as "SYSTEM", as suggested by Tech Republic and Oracle UK, you get the error: CSS-00113: user system is not allowed to access data dictionary Trying to run csscan as "SYS", as suggested by Oracle Forums, results in the error: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER ORACLE-BASE shows a method for running csscan in a Windows environment: C:\>CSSCAN \"sys/password@db10g AS SYSDBA\" FULL=Y This might work in Windows, on a Linux server you get: CSS-00110: failed to parse userid Scanner terminated unsuccessfully. Here's how you do it. Log in as a user with DBA rights and do the following: > csscan full=y tochar=AL32UTF8 array=1024000 process=16 Character Set Scanner v2.1 : Release 10.2.0.0.0 - Production on Sat Apr 10 18:41:37 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Username: sys/[password] as sysdba That should run the database character scanner on your database. If you get the error: CSS-00107: Character set migration utility schema not installed Scanner terminated unsuccessfully. … then go back and install the character set migration utility schema, then try running csscan again. You can install the character set migration utility schema with: > cd $ORACLE_HOME/rdbms/admin > sqlplus /nolog SQL*Plus: Release 10.2.0.2.0 - Production on Sat Apr 10 18:40:04 2010 Copyright (c) 1982, 2005, Oracle. All Rights Reserved. SP2-0640: Not connected 18:40:04 nolog> connect / as sysdba Connected. Session altered. Elapsed: 00:00:00.00 18:40:08 sys> @csminst.sql If you get this error you can ignore it: grant READ on dire