Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle11g

Posted on 2009-04-03
5
Medium Priority
?
849 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
  • 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
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.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

972 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