OraFAQ Forum: Server Administration » Oracle 10g -> 11g Upgrade

Home » RDBMS Server » Server Administration » Oracle 10g -> 11g Upgrade (Windows 2k3, 2k16)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 10g -> 11g Upgrade [message #671240]

Sat, 18 August 2018 01:42

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:

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?
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?
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

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Oracle 10g -> 11g Upgrade [message #671243 is a reply to message #671240]

Sat, 18 August 2018 13:12

John Watson
Messages: 8960
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.

Report message to a moderator

Re: Oracle 10g -> 11g Upgrade [message #676548 is a reply to message #671240]

Sat, 15 June 2019 04:10

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 07:00:13 CST 2024