Solved

Latest Oracle Service Pack

Posted on 2006-06-16
1
1,062 Views
Last Modified: 2013-12-11
Hi,

What is the latest Service Pack for Oracle 10g. Could someone please give me a brief description on it too thanks.

Joel
0
Comment
Question by:alcojoe
1 Comment
 
LVL 6

Accepted Solution

by:
Pradeepgv03 earned 500 total points
ID: 16926448
Hi Joel

I think by service pack you mean Patchsets. Need not read rest if not !!!

THere are bugs in Oracle softwre.When some of them are discovered Oracle will release  a "bundle of patch" called patchset. We need to apply this on top of the base realse to fix the issues.

FOr ex 10G release 1 (10.1) has got 10.1.0.5 as the latest patchset now.
for 10G release 2 10Gr2 oracle has comeout with 10.2.0.2 as the latest patchset.
You can download the patchset from metalink.oracle.com and install on top of the base release that you already would be having. Instllaing is simple.. need to just follow the instructions given in readme. (it is installed using same OUI).
Oracle always recommends its customers to be on latest patchset.

Hope this helps.
Regards,
Pradeep George,
Oracle Certified Master (OCM 9i).


0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Need a replacement data type in Oracle 6 77
grouping on time windows 6 51
passing parameters to sql script oracle 4 42
ORA-00923: FROM keyword not found where expected 3 64
Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question