Oracle11g

Hi all,
If someone have complete step by step documentation for upgrading from Oracle 10g (10.2.0.3.0) to Oracle 11g on Windows 2000.Please let me know.please also let me know which of these recommended for upgradation i.e. DBUA or Manual scripting.I am very new to this.
N_sharma27Asked:
Who is Participating?
 
morsunConnect With a Mentor Commented:
Only 11g
0
 
morsunCommented:
I paste a lines from other discussion in here http://forums.oracle.com/forums/thread.jspa?threadID=700498:
"please call the OUI (Oracle Universal Installer) of your 11g installation (I'd just assume that you've installed the 11g software into a seperate Oracle Home on your box, e.g. C:\oracle\ora102 and c:\oracle\ora11g are existing?).
Then click on INSTALLED PRODUCTS (at the bottom of the screen) and choose the right TAB called "ENVIRONMENT" - make sure your 11g Home is on TOP (otherwise use the up-down-arrows to move it up, mark it and click APPLY - wait for a few seconds until you'll get control back).

Next step would be:
Call the DBUA from your 11g installation and check which databases it'll display. Does it display then 10g database SID? (ORCL or something like you've set before).
Did you follow the upgrade guidelines (running script %ORACLE_HOME11\rdbms\admin}utlu111i.sql from 10g's SQL*Plus connected as SYS AS SYSDBA against your 10g database? It'll check for instance for Timezone V4 patches (without them no upgrade will be possible to 11g).
Did you create a new 11g listener?

Please have a look into these metalink notes (goto ADVANCED SEARCH in ML and just cut&paste the note number):
Note:601807.1 Upgrade Companion 11g
Note:556477.1 Complete Checklist for Upgrades to 11gR1 using DBUA
Note:429825.1 Complete Checklist for Manual Upgrades to 11gR1"
0
 
morsunCommented:
Detailed info about logged users:
SELECT s.username, s.program, s.logon_time
FROM v$session s, v$process p, sys.v_$sess_io si
WHERE s.paddr = p.addr(+)
AND si.sid(+) = s.sid
AND s.type = 'USER';

Open in new window

0
 
morsunCommented:
Please disregard my previous post, it should be for different question :)
0
 
N_sharma27Author Commented:
hi,
As you wrote, I had called OUI from Oracle11g and after that i clicked product Install and then clicked Environment TAB and i saw 2 check box named as OracleDB11g_home1 at the top and 2nd one is
OracleDB10g_home1 .The question is that should i  checked /click both of the Check boxes or only i have click only OracleDB11g_home1  check box.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.