INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

NLS_CharacterSet update and Standby Databases

NLS_CharacterSet update and Standby Databases

(OP)
We have a bunch of databases that use the WE8ISO8859P1 character set. We needed to add the EURO symbol to our Currency setup, but that character isn't supported. The simple solution is to migrate to the WE8MSWIN1252 character set. Oracle has lots of documentation about this and I was able to update a test database in a relatively short time frame. I am confident in what needs to be done and how to do it, but I have a question. We also have a physical and a logical standby database that are updated from our production database. Does anyone know how I should go about updating the standby databases?

Thanks,
Charlie

RE: NLS_CharacterSet update and Standby Databases


Same way as if you would be "patching" the database, check out document id. 278641.1
3eyes

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

RE: NLS_CharacterSet update and Standby Databases

For your physical standby, if you are at Oracle 11.1.0.7 or higher, you can change the NLS_CHARACTERSET without recreating the physical standby. This is a new feature of Oracle 11g. The relevant document at support.oracle.com is 1124165.1

For your logical standby, I am quite pessimistic that you will be able to make the character set conversion on your primary database without dropping and recreating the logical standby. See, for example, note 1283764.1, which addresses this issue, although not for the exact character set conversion that you are contemplating.

RE: NLS_CharacterSet update and Standby Databases

(OP)
Thank you for replying to this thread. I was on a time crunch of sorts and had to plow away with this conversion on the primary database. I ended up deleting both standby's and recreating them. The character set change carried through to the standby creation. It was pretty transparent.

Thanks again

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close