top of page

Group

Public·222 members

BODS and Oracle: How to Solve the Missing OCI.DLL Error



  • I do apologies, but I don't understand what \\\"Oracle Process ID\\\" and \\\"Fine Tune of Oracle Application\\\" mean.You stated \\\"If it was TNS connectivity (DLL ) issue then in that case you cannot connect \\\"Local Repository\\\" - which I assume is the issue Mahi experiencing.As Charles suggested below you need to check if appropriate Oracle client has been installed (x64), then you need th check if more that one client is installed. If so check if ORACLE_HOME points to the correct one. Then, check if PATH variable contains the directory where Oracle binaries are, to test put the right directory in the beginning of the line.You check then if correct OCI.DLL returned, when executing `where ODI.DLL` command from command prompt.Then, you test from outside of Data Services if connection is possible by using tnsping and sqlplus - is it possible to connect?Make sure you are checking all the above from DS Job Server machine as you are experiencing the issue during the job execution.Thank you,Viacheslav.\",\"author\":\"username\":\"viacheslav.novozhilov\",\"displayName\":\"Viacheslav Novozhilov\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"daya.jha\",\"displayName\":\"Daya Jha\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":10215654,\"creationDate\":1376571445000,\"activeRevisionId\":10878915,\"lastActivity\":1376571448000,\"parentId\":10212063,\"originalParentId\":10201623,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"moderatorComment\":false,\"liked\":false}]}}"); const simplifiedQuestionView = JSON.parse("true"); (function() window.pageContext = mergeDeep(pageContext, question: id: 10201623, plug: "cannot-find-nt-oracle-server-dll-ocidll-ensure-tha", votes: 0, questionTitle: "Cannot find NT Oracle Server DLL . Ensure that Oracle has been installed and the PATH variable points to the correct", isClosed: false, isLocked: false, isRedirected: false, redirectedFromTitle: "", redirectedFromId: "", closedStatusData: JSON.parse(""), userVoted: false, relations: JSON.parse("\"canClose\":false,\"canUnredirect\":false,\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"canReopen\":false,\"type\":\"question\",\"canVoteUpOrCancel\":false,\"canViewRevisions\":true,\"canUnlock\":false,\"reported\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canCancelReport\":false,\"canComment\":true,\"isCurrentUserAuthor\":false,\"canViewReports\":false"), isQuestionAccepted: false , childToViewInfo: id: "" , comments: JSON.parse("\"10205332\":\"rootParentId\":10205332,\"commentsCount\":3,\"comments\":[\"body\":\"I do apologies, but I don't understand what \\\"Oracle Process ID\\\" and \\\"Fine Tune of Oracle Application\\\" mean.You stated \\\"If it was TNS connectivity (DLL ) issue then in that case you cannot connect \\\"Local Repository\\\" - which I assume is the issue Mahi experiencing.As Charles suggested below you need to check if appropriate Oracle client has been installed (x64), then you need th check if more that one client is installed. If so check if ORACLE_HOME points to the correct one. Then, check if PATH variable contains the directory where Oracle binaries are, to test put the right directory in the beginning of the line.You check then if correct OCI.DLL returned, when executing `where ODI.DLL` command from command prompt.Then, you test from outside of Data Services if connection is possible by using tnsping and sqlplus - is it possible to connect?Make sure you are checking all the above from DS Job Server machine as you are experiencing the issue during the job execution.Thank you,Viacheslav.\",\"author\":\"username\":\"viacheslav.novozhilov\",\"displayName\":\"Viacheslav Novozhilov\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"daya.jha\",\"displayName\":\"Daya Jha\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":10215654,\"creationDate\":1376571445000,\"activeRevisionId\":10878915,\"lastActivity\":1376571448000,\"parentId\":10212063,\"originalParentId\":10201623,\"likeCount\":0,\"visibility\":\"full\",\"depth\":0,\"attachments\":[],\"canVoteUpOrCancel\":false,\"relations\":\"canReport\":false,\"visibility\":\"full\",\"canEdit\":false,\"canUseDelete\":false,\"isLiked\":false,\"type\":\"comment\",\"canVoteUpOrCancel\":false,\"canConvertToAnswer\":false,\"canBeModerated\":false,\"canViewRevisions\":false,\"showInReply\":false,\"reported\":false,\"canCancelReport\":false,\"canDelete\":false,\"canVoteDownOrCancel\":false,\"canComment\":false,\"canViewReports\":false,\"isCurrentUserAuthor\":false,\"moderatorComment\":false,\"liked\":false]"), answerPager: answersCount: 3, page: 1, pageSize: 10, pageCount: 1, sort: "votes" , answers: JSON.parse("[\"body\":\"Hi Mahi\\n\\n\\nInstall the 64-bit Oracle Drivers on the client machine.\\n\\nBasically, the Data Services client and the Oracle client have to have the same bit version. They either have to be both 32 bit or both 64 bit for things to work.\\n\\nRegards\\n\\nCharles\",\"author\":\"username\":\"charles.archibong\",\"displayName\":\"Charles Archibong\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":10212714,\"posted\":1376471095000,\"votes\":1,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":1,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"1. Are you able to access the database from the Job Server machine without SAP Data Services (tnsping, sqlplus)? 2. What is the output of the command `where oci.dll` on the Job Server machine?Thank you,Viacheslav.\",\"author\":\"username\":\"viacheslav.novozhilov\",\"displayName\":\"Viacheslav Novozhilov\",\"groupIcons\":[\"name\":\"employee\",\"title\":\"This user is an SAP Employee\",\"priority\":21],\"suspended\":false,\"isCurrentUser\":false,\"id\":10202253,\"posted\":1375978118000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hi Mahi,For ORACLE Instant Client Configuration in Developer Machine please refer below thread. i think this issue is due to Oracle Please tune Oracle Application , you can see the same error in Oracle logs (TNS Error) it was due to less number of process id and memory issue see the below points. We are also getting the same error after fine tuning in \\\"Oracle\\\" Side issue is resolved.Suggestion Oracle Point of View : Try increasing processes for the database in the init file. Then stop and start the database.You may need to Increase memory/swap spaceYou may need to increase max processes per user at the kernel levelIt may be a problem with not enough file handles/descriptors available at the kernel level.Hope this will help you.Thanks,Daya\",\"author\":\"username\":\"daya.jha\",\"displayName\":\"Daya Jha\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":10205332,\"posted\":1376208790000,\"votes\":0,\"isAccepted\":false,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[]]"), answerForm: formAction: "/answers/10201623/post.json", textareaName: "body", textareaErrors: "", isAttachmentsEnabled: true, answerEditorialGuideline: title: "Before answering", content: "You should only submit an answer when you are proposing a solution to the poster\'s problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.", links: [ title: "Rules of Engagement", href: " -of-engagement.html", ] , answerMinBodyLength: '10', answerMaxBodyLength: '20000' , currentUser: sapInternalId: '', permissions: canVoteUpOrCancel: false, canVoteDownOrCancel: false, canModerate: false, , isVotedUp: false, isVotedDown: false , alerts: alertModeratorMinLength : "It should be given a proper explanation about why the content is inappropriate.", alertModeratorMinLengthValue : "10", alreadyReportedMessage : "You already have an active moderator alert for this content." , url: profileApiBaseUrl: ' -api.services.sap.com', followUnfollowQuestion: '/sap/nodeSubscription.json', isFollowingQuestion: '/sap/isFollowingNode.json', vote: voteUp: '/commands/0/voteup.json', voteDown: '/commands/0/votedown.json', cancelVote: '/commands/0/cancelvote.json' , rss: answers: '/feed/10201623/answers.rss', answersAndComments: '/feed/10201623/comments-and-answers.rss' , authorizeUploadContext: type: 'answer' , atMention: userSearchServiceUrl: ' ', currentUserName: '', useNewUSSCORS: true, atMentionDelayMs: 100, showMentionInRedactor: true , attachmentSettings: commentMaxAttachments: '2', answerMaxAttachments: '10', commentMaxAttachmentSizeBytes: '1048576', answerMaxAttachmentSizeBytes: '1048576', commentAttachmentsSizeBytesTotal: '2097152', answerAttachmentsSizeBytesTotal: '10485760' , editor: editorClipboardUploadEnabled: true ) )(); Home

  • Community

  • Ask a Question

  • Write a Blog Post

Login / Sign-up Search Questions and Answers 0 Former Member Aug 08, 2013 at 12:41 PM Cannot find NT Oracle Server DLL . Ensure that Oracle has been installed and the PATH variable points to the correct 3338 Views Follow RSS Feed Hi All,




bods cannot find nt oracle server dll oci.dll


About

Welcome to the group! You can connect with other members, ge...

Members

bottom of page