top of page
enuntulisuclei

Oracle Database 10g Release 2 10.2.0.5: The Ultimate Guide for Developers and DBAs



Installing Enterprise Manager 10g Grid Control Release 2 (10.2.0.5) requires previous release of Grid Control to be 10.2.0.1.0.or higher. If you do not have a previous release, but want to have a 10.2.0.5.0 Grid Control environment, then first install 10.2.0.1.0 Grid Control and then upgrade it to 10.2.0.5.0.




Oracle Database 10g Release 2 10.2.0.5 Download ^NEW^



Download the GridControl_10.2.0.5_.zip patch set installation archive to any directory on the host where Oracle Management Service is running. The patch set can be downloaded from the following location:


------------------------------------------------------------------------------------------------ 2.2 Preinstallation steps before upgrading to Oracle Enterprise Manager Grid Control 10.2.0.5.0 ------------------------------------------------------------------------------------------------ 1. Oracle recommends that you back up the Oracle home that will be upgraded using this Patch Set. In the case of a Management Repository, Oracle recommends that you back up the repository database before applying the Patch set because the Patch Set makes changes to the repository that cannot be rolled back. Also, back up the Oracle Inventory directory.


If your Additional management agent version is 10.1.0.x and you want to upgrade it to 10.2.0.5 version then you have to first download the 10.2.0.5.0 Agent Software from the Oracle Technology Network (OTN):-


Direct upgrade to Oracle 10g is only supported if your database is running one of the following releases: 8.0.6, 8.1.7, 9.0.1, or 9.2.0. If not, you will have to upgrade the database to one of these releases or use a different upgrade option (like export/ import).


After the Full (Base) Release 2 is installed, you can upgrade using the Patch Installer (Agent, OMS, and Management Packs) for Release 5 (10.2.0.5). This Release 5 patch can also be downloaded from the same direct Enterprise Manager Downloads page on OTN as follows:


Once the DBVisualizer tool is downloaded and installed, you next need to determine which database your PI system is using. To check this log onto your PI system (ABAP stack) and check System -> Status.


When I get tis failure message do Ihave to install the 10.2.0.5 Version to use the database properly on Windows 7 or can I leave it at the Version 10.2.0.4?BTW: Thank you very much for the post!


After upgrading to Oracle Database 12c Release 1 (12.1) from INDIRECT database upgrade release like Oracle Database9i Release 2 (9.2) or Oracle Database 10g Release 1 (10.1), the CONNECT role has only the CREATE SESSION privilege; the other privileges granted to the CONNECT role in earlier releases are revoked during the upgrade. To identify which users and roles in your database are granted the CONNECT role, use the following query:


During the upgrade to Oracle Database 12c any passwords in database links are encrypted.To downgrade to the original release, all of the database links with encrypted passwords must be dropped prior to the downgrade.Consequently, the database links do not exist in the downgraded database.If you anticipate a requirement to be able to downgrade to your original release, then save the information about affected database links from the SYS.LINK$ table, so that you can re-create the database links after the downgrade.


Note: If there is a pre-existing user in the database with same name as the 12.1 oracle-supplied users or roles, then move the data of that user to a different schema before dropping the pre-existing user.


Previous versions of the listener are not supported for use with an Oracle Database 12c Release 1 (12.1) database.However, it is possible to use the new version of the listener with previous versions of Oracle Databases.If you are upgrading from 10.2.0.5 or upgrading manually without using DBUA, run Oracle Net Configuration Assistant before upgrading the Oracle RAC database.


The COMPATIBLE initialization parameter controls the compatibility level of your database.When you are certain that you no longer need the ability to downgrade your database to its original release


  • hi Basis TCS,1. I hope, if you download 51036975 then no need to change the tag.2. If oracle and their patches(Generic, MSWin) successfully applied and you did not get the error in OPatch, then you have to run catupgrd.sql and utlrp.sql files.For any further query, please feel free to contact megud to see that your problem is resolved and completed this thread for other SCN users.\",\"author\":\"username\":\"ma.jamil\",\"displayName\":\"MA JAMIL\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"basis.tcs\",\"displayName\":\"BASIS TCS\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9228147,\"creationDate\":1334557089000,\"activeRevisionId\":10073066,\"lastActivity\":1334557089000,\"parentId\":9227319,\"originalParentId\":9213054,\"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: 9213054, plug: "installation-oracle-10g-on-windows-server-2008-r2", votes: 0, questionTitle: "Installation Oracle 10g on windows server 2008 R2", 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("\"9213694\":\"rootParentId\":9213694,\"commentsCount\":13,\"comments\":[\"body\":\"hi Basis TCS,1. I hope, if you download 51036975 then no need to change the tag.2. If oracle and their patches(Generic, MSWin) successfully applied and you did not get the error in OPatch, then you have to run catupgrd.sql and utlrp.sql files.For any further query, please feel free to contact megud to see that your problem is resolved and completed this thread for other SCN users.\",\"author\":\"username\":\"ma.jamil\",\"displayName\":\"MA JAMIL\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"parentAuthor\":\"username\":\"basis.tcs\",\"displayName\":\"BASIS TCS\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9228147,\"creationDate\":1334557089000,\"activeRevisionId\":10073066,\"lastActivity\":1334557089000,\"parentId\":9227319,\"originalParentId\":9213054,\"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: 2, page: 1, pageSize: 10, pageCount: 1, sort: "votes" , answers: JSON.parse("[\"body\":\"Hi\\n\\nWhich product/solution you're planning to install? (eg: ECC,PI,etc). To ge the details on OS & DB availability for a particular product you need to check the following link:\\n\\nservice.sap.com/pam\\n\\nAs for the confusion in downloading and installing oracle patches kindly refer the below sapnote:\\n\\n1431752 - Oracle 10.2.0: Patches/Patch Collections for 10.2.0.5\\n\\nAlso refer the sapnote:1654734 for additional info on oracle patchset.\\n\\nRegards,\",\"author\":\"username\":\"imran.mohammed4\",\"displayName\":\"Imran Mohammed\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9213694,\"posted\":1333958778000,\"votes\":2,\"isAccepted\":true,\"isLocked\":false,\"userVoted\":\"\",\"relations\":\"score\":2,\"canCancelAccept\":false,\"canUnlock\":false,\"canUseDelete\":false,\"accepted\":true,\"canVoteDownOrCancel\":false,\"canLock\":false,\"canAccept\":false,\"type\":\"answer\",\"canVoteUpOrCancel\":false,\"isCurrentUserAuthor\":false,\"attachments\":[],\"body\":\"Hi, Below are the correct media to install 10g. 51031678_1 ORACLE RDBMS 10.2 Windows 1 of 5 51031678_2 ORACLE RDBMS 10.2 Windows 2 of 5 51031678_3 ORACLE RDBMS 10.2 Windows 3 of 5 51031678_4 ORACLE RDBMS 10.2 Windows 4 of 5 51031678_5 ORACLE RDBMS 10.2 Windows 5 of 5 However, i dont think you need ORACLE RDBMS Patch 10.2.0.4 where you can upgrade to ORACLE RDBMS Patch 10.2.0.5 directly. Once your database is patched to 10.2.0.5, you can apply generic patches on top of it. Generic patches just like updated software packages where contain bug fixes and etc. Hope it helps,Nicholas Chang\",\"author\":\"username\":\"nicholas.chang\",\"displayName\":\"Nicholas Chang\",\"groupIcons\":[],\"suspended\":false,\"isCurrentUser\":false,\"id\":9214066,\"posted\":1333962421000,\"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/9213054/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/9213054/answers.rss', answersAndComments: '/feed/9213054/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 BASIS TCS Apr 08, 2012 at 06:52 AM Installation Oracle 10g on windows server 2008 R2 1044 Views Follow RSS Feed Dear SAP Gurus , 2ff7e9595c


2 views0 comments

Recent Posts

See All

Comments


bottom of page