Download Oracle Client 10.2.0.4 Windows 7 High Quality
Download ---> https://urllio.com/2t8bBx
I am trying to connect to an Oracle 10.2.0.4 database from Windows 7 OS - 64 bit usingAccess 2010 32 bit and Oracle 32 bit client version 10.2.0.1 installed on PC.My user requires a 64 bit Windows 7 OS for other needs.
Hi Babu,\\n\\nMOPatch supports 10.2.0.4 of Oracle. Please review SAP Notes 1027012 and 306408. \\n\\nI know that you also need to download the newest version of OPatch to be able to effectively patch the system and perform all the post-processing of patches.\\n\\nHope this helps.\",\"author\":{\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false},\"parentAuthor\":{\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false},\"id\":7509102,\"creationDate\":1278938016000,\"activeRevisionId\":8700796,\"lastActivity\":1278938016000,\"parentId\":7505813,\"originalParentId\":7485921,\"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},\"liked\":false,\"moderatorComment\":false}]},\"7509469\":{\"rootParentId\":7509469,\"commentsCount\":2,\"comments\":[{\"body\":\"Hi Experts !\\n\\nAs I applied Mo Latest Patch successfull but now I want to set the Paramaters . As I refered the notes but iam unable to understand 830576 ,1171650\\n\\n\\noptimpeek_user_binds and optimizer_index_cost_adj\\n\\nfixcontrol DB parameters\\n-\\n\\n'4728348:OFF'\\n'5099019:ON'\\n'5705630:ON'\\n'5765456:3'\\n'6221403:ON'\\n'6329318:ON'\\n'6399597:ON'\\n'6430500:ON'\\n'6440977:ON'\\n'6626018:ON'\\n'6670551:ON'\\n'6972291:ON'\\n'7325597:ON'\\n'7692248:ON'\\n'7891471:ON'\\n'9196440:ON'\\n'9495669:ON'\\n\\nAny one could you pls send the steps to perform to set the parameters with queries. Eagerly waiting for your reply\\n\\nMany Thanks\\n\\nThanks\\nMai\",\"author\":{\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false},\"parentAuthor\":{\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false},\"id\":8287125,\"creationDate\":1302974989000,\"activeRevisionId\":9319519,\"lastActivity\":1302974989000,\"parentId\":7523309,\"originalParentId\":7485921,\"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},\"liked\":false,\"moderatorComment\":false}]}}"); const simplifiedQuestionView = JSON.parse("true"); (function() { window.pageContext = mergeDeep(pageContext, { question: { id: 7485921, plug: "oracle-upgrade-from-10201-to-10204", votes: 0, questionTitle: "Oracle upgrade from 10.2.0.1 to 10.2.0.4", 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: true }, childToViewInfo: { id: "" }, comments: JSON.parse("{\"7486156\":{\"rootParentId\":7486156,\"commentsCount\":10,\"comments\":[{\"body\":\"Hi Babu,\\n\\nMOPatch supports 10.2.0.4 of Oracle. Please review SAP Notes 1027012 and 306408. \\n\\nI know that you also need to download the newest version of OPatch to be able to effectively patch the system and perform all the post-processing of patches.\\n\\nHope this helps.\",\"author\":{\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false},\"parentAuthor\":{\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false},\"id\":7509102,\"creationDate\":1278938016000,\"activeRevisionId\":8700796,\"lastActivity\":1278938016000,\"parentId\":7505813,\"originalParentId\":7485921,\"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},\"liked\":false,\"moderatorComment\":false}]},\"7509469\":{\"rootParentId\":7509469,\"commentsCount\":2,\"comments\":[{\"body\":\"Hi Experts !\\n\\nAs I applied Mo Latest Patch successfull but now I want to set the Paramaters . As I refered the notes but iam unable to understand 830576 ,1171650\\n\\n\\noptimpeek_user_binds and optimizer_index_cost_adj\\n\\nfixcontrol DB parameters\\n-\\n\\n'4728348:OFF'\\n'5099019:ON'\\n'5705630:ON'\\n'5765456:3'\\n'6221403:ON'\\n'6329318:ON'\\n'6399597:ON'\\n'6430500:ON'\\n'6440977:ON'\\n'6626018:ON'\\n'6670551:ON'\\n'6972291:ON'\\n'7325597:ON'\\n'7692248:ON'\\n'7891471:ON'\\n'9196440:ON'\\n'9495669:ON'\\n\\nAny one could you pls send the steps to perform to set the parameters with queries. Eagerly waiting for your reply\\n\\nMany Thanks\\n\\nThanks\\nMai\",\"author\":{\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false},\"parentAuthor\":{\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false},\"id\":8287125,\"creationDate\":1302974989000,\"activeRevisionId\":9319519,\"lastActivity\":1302974989000,\"parentId\":7523309,\"originalParentId\":7485921,\"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},\"liked\":false,\"moderatorComment\":false}]}}"), answerPager: { answersCount: 3, page: 1, pageSize: 10, pageCount: 1, sort: "votes" }, answers: JSON.parse("[{\"body\":\"Hi ,\\n\\nFollow below to Upgrade/apply patchset in Oracle\\n\\n- Upgrade the db server to 10.2.0.4 using patchset\\n- Install the latest interim patch for 10.2.0.4\\n- Install the latest generic patches\\n- Upgrade instance client to 10.2.0.4\\n\\n ORACLE UPGRADE FROM 10.2.0.2 TO 10.2.0.4 \\n ========================================================\\n Upgrade the db server to 10.2.0.4 using patchset\\n ==========================================================\\n\\n Change Directory: /oracle//102_64/OPatch\\n \\n \\n\\n opatch lsinventory -all\\n\\n \\n - Download and Extract the Installation Software\\n\\n $ unzip p6810189_10204_LINUX-x86-64.zip\\n $ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/bin/OPatch:$PATH:\\n $ ORACLE_HOME=/oracle/CRJ/102_64\\n $ ORACLE_SID= CRJ\\n $ export ORACLE_HOME ORACLE_SID\\n \\n - Stopping All Processes for a Single Instance Installation\\n Login as ora and type below commands\\n \\n\\n emctl stop dbconsole\\n\\n \\n\\n isqlplusctl stop\\n\\n \\n\\n lsnrctl stop\\n\\n \\n\\n $ srvctl stop service -d db_name [-s service_name_list [-i inst_name]](For multiple nodes)\\n\\n\\n - start Oracle Universal Installer, where patchset_directory is the directory where you unpacked the patch set software:\\n\\n \\n\\n cd patchset_directory/Disk1\\n\\n \\n\\n ./runInstaller\\n\\n\\n Post Installation Task\\n ======================\\n\\n - Change directory to /oracle//102_64\\n \\n \\n\\n Run the Script u201Croot.shu201D\\n\\n \\n - Updating Oracle Time Zone Definitions\\n \\n SQL> SELECT version FROM v$timezone_file;\\n \\n -Upgrading Oracle Database Upgrade Assistant\\n \\n u2022 Log in as the Oracle software owner user.\\n u2022 Set the values for the environment variables $ORACLE_HOME, $ORACLE_SID and $PATH.\\n u2022 For single-instance installations, if you are using Automatic Storage Management, start the Automatic Storage Management instance.\\n u2022 For Oracle single-instance installations, start the listener as follows:\\n $ lsnrctl start\\n u2022 Run Oracle Database Upgrade Assistant either in the interactive or noninteractive mode:\\n\\n \\n\\n dbua\\n\\n\\n Edit the file /etc/oratab\\n Make a entry of :/oracle//102_64:Y\\n After installation finished\\n Login to Oracle as sysdba with sys user.\\n Shutdown the db[Shut abort]\\n Start the db [startup]\\n SQL> STARTUP UPGRADE\\n\\n Run the Pre-Upgrade Information Tool\\n ====================================\\n If you are upgrading database manually, then you should analyze it by running the Pre-Upgrade Information Tool.\\n The Pre-Upgrade Information Tool is a SQL script that ships with Oracle Database 10.2. Complete the following procedure to run the Pre-Upgrade Information Tool:\\n 1. Start the database in the UPGRADE mode:\\n 2. SQL> STARTUP UPGRADE\\n 3. Set the system to spool results to a log file for later analysis:\\n 4. SQL> SPOOL upgrade_info.log \\n 5. Run the Pre-Upgrade Information Tool:\\n 6. SQL> @?/rdbms/admin/utlu102i.sql\\n 7. Turn off the spooling of script results to the log file:\\n 8. SQL> SPOOL OFF\\n \\n\\n Upgrading a Release 10.2 Database\\n -================================\\n For single-instance installations, start the listener as follows:\\n $ lsnrctl start\\n SQL> SPOOL patch.log\\n SQL> @?/rdbms/admin/catupgrd.sql\\n SQL> SPOOL OFF\\n SQL> SHUTDOWN IMMEDIATE\\n SQL> STARTUP\\n @?/rdbms/admin/utlrp.sql\\n \\n #:ora > emca -upgrade db\\n \\n Running changePerm.sh Script on an Oracle Database Server Home\\n ===============================================================\\n cd $ORACLE_HOME/install\\n \\n #ora changePerm.sh\\n \\n Install the latest interim patch for 10.2.0.4\\n =============================================\\n Patch number : 4695511 \\n \\n #ora opatch apply /oracle//Desktop/patch/4695511\\n\\n Install the latest generic patches\\n ==================================\\n Patch number :\\n 6862947\\n 6705635\\n 9254968\\n \\n \\n\\n opatch apply /oracle/CRJ/Desktop/patch/6862947\\n\\n\\n \\n Upgrade instance client to 10.2.0.4\\n ===================================\\n We install patches 6944036, 6826661, 6775231 \\n \\n\\n SAPCAR u2013xvf OCL_BASIC_10204_64_V2.SAR \\n\\n Then copy the output to /oracle/client/10x_64/\\n ln -s /oracle/client/10x_64/instantclient_10204 /oracle/client/10x_64/instantclient\",\"author\":{\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false},\"id\":7509469,\"posted\":1278944051000,\"votes\":1,\"isAccepted\":true,\"isLocked\":false,\"userVoted\":\"\",\"relations\":{\"score\":1,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"accepted\":true,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false},\"attachments\":[]},{\"body\":\"First of all - Oracle 10.2.0.1 is not supported by SAP. You should run your system on 10.2.0.2 as a minimum.Secondly: if you upgrade to 10.2.0.4 you just install the latest patch set from the market place in order to get you db directly from 10.2.0.1 to 10.2.0.4. After that you apply the latest SAP bundle patch and adapt the db settings accordingly (check notes 871096 and 830576).\",\"author\":{\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false},\"id\":7486156,\"posted\":1278150648000,\"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\":\"Why don't you read standard install/upgrade guide?\",\"author\":{\"username\":\"former.member\",\"displayName\":\"Former Member\",\"groupIcons\":[],\"suspended\":true,\"isCurrentUser\":false},\"id\":8288070,\"posted\":1303105617000,\"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/7485921/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/7485921/answers.rss', answersAndComments: '/feed/7485921/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 Jul 03, 2010 at 05:58 AM Oracle upgrade from 10.2.0.1 to 10.2.0.4 300 Views Follow RSS Feed hi All, 2b1af7f3a8