Solved

Oracle11g

Posted on 2009-04-03
5
819 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
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 video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

738 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