Solved

Oracle11g

Posted on 2009-04-03
5
827 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 500 total points
ID: 24070584
Only 11g
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

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…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

617 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