Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Oracle11g

Posted on 2009-04-03
5
Medium Priority
?
842 Views
Last Modified: 2013-11-11
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.
0
Comment
Question by:N_sharma27
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
LVL 8

Expert Comment

by:morsun
ID: 24067466
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
 
LVL 8

Expert Comment

by:morsun
ID: 24067498
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
 
LVL 8

Expert Comment

by:morsun
ID: 24067506
Please disregard my previous post, it should be for different question :)
0
 

Author Comment

by:N_sharma27
ID: 24069710
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
 
LVL 8

Accepted Solution

by:
morsun earned 2000 total points
ID: 24070584
Only 11g
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to take different types of Oracle backups using RMAN.

722 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