Hi Experts,

I had a problem with the controlfile while creating the database. My doubt is, Can we give both character set and National character set together in a controlfile. Following is the script for controlfile please check it and let me know if it was anything wrong.

CREATE DATABASE GOLDDBB
USER SYS IDENTIFIED BY gold21!
USER SYSTEM IDENTIFIED BY gold221!
LOGFILE
GROUP 1 (
'/redo/oracle/oradata/golddbb/redo11.log',
'/redo/oracle/oradata/golddbb/redo12.log'
) SIZE 1535M BLOCKSIZE 512,
GROUP 2 (
'/redo/oracle/oradata/golddbb/redo21.log',
'/redo/oracle/oradata/golddbb/redo22.log'
) SIZE 1535M BLOCKSIZE 512,
GROUP 3 (
'/redo/oracle/oradata/golddbb/redo31.log',
'/redo/oracle/oradata/golddbb/redo32.log'
) SIZE 1535M BLOCKSIZE 512,
GROUP 4 (
'/redo/oracle/oradata/golddbb/redo41.log',
'/redo/oracle/oradata/golddbb/redo42.log'
) SIZE 1535M BLOCKSIZE 512,
GROUP 5 (
'/redo/oracle/oradata/golddbb/redo51.log',
'/redo/oracle/oradata/golddbb/redo52.log'
) SIZE 1535M BLOCKSIZE 512,
GROUP 6 (
'/redo/oracle/oradata/golddbb/redo61.log',
'/redo/oracle/oradata/golddbb/redo62.log'
) SIZE 1535M BLOCKSIZE 512
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 2336
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL32UTF8
DATAFILE '/data1/oracle/oradata/golddbb/data/system01.dbf' SIZE 2048M
AUTOEXTEND OFF NEXT 10M MAXSIZE 10G
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
FLASHBACK ON
SYSAUX DATAFILE '/data1/oracle/oradata/golddbb/data/sysaux01.dbf' SIZE 2048M
AUTOEXTEND OFF NEXT 10M MAXSIZE 10G
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON
DEFAULT TEMPORARY TABLESPACE TEMP1 TEMPFILE
'/undotmp/oracle/oradata/golddbb/temp/TEMP01.dbf ' SIZE 30720M
AUTOEXTEND ON NEXT 10M MAXSIZE 40G TABLESPACE GROUP
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M
UNDO TABLESPACE UNDOTBS1 DATAFILE /undotmp/oracle/oradata/golddbb/undo/UNDOTBS01.dbf SIZE 30720M AUTOEXTEND ON NEXT 5M MAXSIZE 40G
ONLINE
RETENTION NOGUARANTEE
BLOCKSIZE 8K
FLASHBACK ON
;


Whenever i run the controlfile, it giving error message like Character set is invalid. Any one please let me get out of this problem


Thanks in advance
Dileep Kumar N