Character Sets

[scm7kag]

Hi,

I am attempting to install oracle 9.2. At the start of the installation the setup prompts to chose a charcter set.

The one that I need to use is W8DEC however this does not appear in the drop down list box.

Does anyone know how I can install the db with this character set.

 

[SantaMufasa]

SCM,

I tend not to use Oracle's GUI db-build packages since they include, by default, too much undesirable "fluff" (IMHO). Therefore, I build my own databases (by hand), which, in your case might include the following code (that I would run from SQL*Plus):

create database SCM92
	controlfile reuse
	logfile group 1 ('/dbsrv/oracle/data1/oradata/SCM92/SCM92log1a.ora',
			 '/dbsrv/oracle/data1/oradata/SCM92/SCM92log1b.ora')
			size 30M reuse,
		group 2 ('/dbsrv/oracle/data1/oradata/SCM92/SCM92log2a.ora',
			 '/dbsrv/oracle/data1/oradata/SCM92/SCM92log2b.ora')
			size 30M reuse,
		group 3 ('/dbsrv/oracle/data1/oradata/SCM92/SCM92log3a.ora',
			 '/dbsrv/oracle/data1/oradata/SCM92/SCM92log3b.ora')
			size 30M reuse
	datafile '/dbsrv/oracle/data1/oradata/SCM92/SCM92system01.dbf' size 80M reuse
	character set [b]W8DEC[/b];
*********************************************************************************

In addition to this code, I do the following:

1) Cause the SYSTEM tablespace datafile to AUTOEXTEND as needed.
2) Create rollback/UNDO tablespace and segments.
3) Create TEMP tablespace.
4) Change passwords on my SYS and SYSTEM users.
5) And create the Oracle Data Dictionary by running these scripts:
@$ORACLE_HOME/rdbms/admin/catalog
@$ORACLE_HOME/rdbms/admin/catproc
@$ORACLE_HOME/rdbms/admin/catblock.sql
@$ORACLE_HOME/rdbms/admin/catexp.sql
@$ORACLE_HOME/rdbms/admin/utlxplan.sql
@$ORACLE_HOME/rdbms/admin/utltkprf.sql
@$ORACLE_HOME/sqlplus/admin/plustrce
(then connect as SYSTEM to run…)
@$ORACLE_HOME/sqlplus/admin/pupbld

Certainly more information here than you asked for, but this is how I CREATE my Oracle databases.


Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.