Home » RDBMS Server » Server Administration » Oracle 10g -> 11g Upgrade (Windows 2k3, 2k16)
Oracle 10g -> 11g Upgrade [message #671240] Sat, 18 August 2018 01:42 Go to next message
chris2018
Messages: 16
Registered: February 2017
Junior Member
All,

there is a Oracle Express Edition (XE) 10g Release 2 (10.2.0.1) (Western European) version. It uses single-byte LATIN 1 charset WE8MSWIN1252. Is there any reason, one would chose this version over the universal one?

My actual questions:

  1. Is the unmanaged (?) Oracle .NET provider (Oracle.DataAccess.dll) considering the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_XE\ODP.NET key, so that I can switch from WE8MSWIN1252 to UTF-8?

  2. Does the charset used internally by the ASP.NET 3.5 c# application matter? Where do I find it? Or is the ODP.NET provider guessing the input charset? Or is it always UTF-8?

  3. Is it possible to resize the columns from byte to char, expdmp the WE8MSWIN1252 database version 10 and import it to UTF-8 version 11?
Thank you in advance.

- Chris


[EDITED by LF: fixed formatting]

[Updated on: Tue, 21 August 2018 00:13] by Moderator

Report message to a moderator

Re: Oracle 10g -> 11g Upgrade [message #671242 is a reply to message #671240] Sat, 18 August 2018 08:49 Go to previous messageGo to next message
BlackSwan
Messages: 26614
Registered: January 2009
Location: SoCal
Senior Member
Oracle database character set should only be established at database creation time.
If you decide to attempt to change character set on existing database, I suggest that you be sure to have a good DB backup prior to making change.
export from WE8MSWIN1252 database & import into UTF-8 database would be a wise choice.
Re: Oracle 10g -> 11g Upgrade [message #671243 is a reply to message #671240] Sat, 18 August 2018 13:12 Go to previous messageGo to next message
John Watson
Messages: 8046
Registered: January 2010
Location: Global Village
Senior Member
Release 12 comes with the Database Migration Assistant For Unicode. There is not a 12c XE edition, but XE 18c is due out in October. Why not delay your upgrade until then? You can go to the latest release and you will then have the tool you need.
Re: Oracle 10g -> 11g Upgrade [message #676548 is a reply to message #671240] Sat, 15 June 2019 04:10 Go to previous message
Moindba
Messages: 1
Registered: June 2019
Junior Member
There are multiple ways to perform rolling upgrade. But you must identify which one will work for your environment. Below are the two common methods used

Method 1: Transient logical standby database

Convert existing physical standby to logical standby using KEEP IDENTITY clause
Upgrade Logical standby first
Return the Logical standby back to physical standby
Method 2: DBMS_ROLLING_UPGRADE package

Only available from 12c
Its automation of transient logical standby process

Previous Topic: Question about - Implement Oracle RAC
Next Topic: Second listener on 19c (Linux)
Goto Forum:
  


Current Time: Mon Nov 11 23:41:16 CST 2019