Scribd
Upload
38 views2 pages

7

Bijender and Pierre discuss recreating a database with the correct NLS settings of AL32UTF8 for NLS_CHARACTERSET and UTF8 for NLS_NCHAR_CHARACTERSET. Pierre sends Bijender an email with the correct configuration details. Bijender drops and will recreate the databases on both servers with these settings. Pierre asks Bijender to only create the UCMDBDATA tablespace on one server as Pierre will create it himself on the other server for testing. They confirm the partitioning and dbms_lob options are installed on both servers.

Uploaded by

bsrathi
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
38 views2 pages

7

Bijender and Pierre discuss recreating a database with the correct NLS settings of AL32UTF8 for NLS_CHARACTERSET and UTF8 for NLS_NCHAR_CHARACTERSET. Pierre sends Bijender an email with the correct configuration details. Bijender drops and will recreate the databases on both servers with these settings. Pierre asks Bijender to only create the UCMDBDATA tablespace on one server as Pierre will create it himself on the other server for testing. They confirm the partitioning and dbms_lob options are installed on both servers.

Uploaded by

bsrathi
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 2

7:40 PMSINGH

Hello Pierre, All done, please check and let me know.


7:43 PMDEMOGUE

Bijender SCE/CSO

Hi bijender the NLS_CHARACTERSET and

Pierre SCE/CSO

NLS_NCHAR_CHARACTERSET
are wrong

NLS_CHARACTERSET must be set to AL32UTF8 and NLS_NCHAR_CHARACTERSET must be set to UTF8 and tablespace UCMDBDATA does'nt exist? 7:46 PMSINGH Bijender SCE/CSO

database concersion form existing to UTF8 was not possiable. so i created the new database with database charset UTF8 but in the ticket it was mentioned UTF8 not AL32UTF8. So. now you need NLS_CHARACTERSET must be set to AL32UTF8 NLS_NCHAR_CHARACTERSET must be set to UTF8 todo so I have to refresh the both databases again.
7:52 PMSINGH

nls charactrset is now UTF8

Bijender SCE/CSO

SQL> select value$ from sys.props$ where name='NLS_CHARACTERSET'; VALUE$ -------------------------------------------------------------------------------UTF8


7:55 PMDEMOGUE

why not AL32UTF8? I send you an e-mail with customer values we have to clone this configuration
7:57 PMSINGH

Pierre SCE/CSO

but i get request for UTF8 see " TO/2011.133365" ok so what next, if i do it again It will take approx 3 hours to complete . should i re-create the DB again with both charset , please confirm.
8:00 PMDEMOGUE 8:01 PMSINGH

Bijender SCE/CSO

I send you the mail with informations ok it would be better. i got your mail.
8:02 PMDEMOGUE

Pierre SCE/CSO

Bijender SCE/CSO Pierre SCE/CSO Pierre SCE/CSO

if needed to recreate db with these informations yes, recreate it


8:09 PMDEMOGUE 8:09 PMSINGH

it is clear for you Bijender? yes..


8:09 PMDEMOGUE 8:11 PMSINGH

Bijender SCE/CSO Pierre SCE/CSO

the informations into the mail


8:13 PMDEMOGUE

don't worry, Now i have complete info. ok thanks

Bijender SCE/CSO

Pierre SCE/CSO

could you use the following lines to create the tablespace

create tablespace UCMDBDATA datafile '/oradata/UCMDB1/data1/ucmdbdata01.dbf' size 10G EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
8:14 PMSINGH

ok i do it on both db.
8:17 PMDEMOGUE

Bijender SCE/CSO Pierre SCE/CSO Pierre SCE/CSO

no do it only on udatabase server i'll create myself the tablespace on udatabase2 for tests
8:32 PMDEMOGUE 8:33 PMSINGH

it is ok for udatabase because i be connected on it but i already droped the database on both servers.
8:35 PMDEMOGUE

Bijender SCE/CSO

One question Bijender have you activate the partitioning option and the package dbms_lob it is installed ?
8:35 PMSINGH 8:38 PMSINGH

Pierre SCE/CSO

let me check ..

Bijender SCE/CSO Bijender SCE/CSO

it is installed in both servers. it is the part of oracle Enterprize version


8:40 PMDEMOGUE

ok partitioning option is actived?


8:41 PMSINGH

Pierre SCE/CSO

you can crete the partition tables.

Bijender SCE/CSO

You might also like