가장 널리 알려진 상업용 RelationalDatabase Management System

관련정보

• [http://www.puschitz.com/InstallingOracle9i.shtml installing 9i on redhat7]

[Python] interface

• DCOracle2 : http://www.zope.org/Members/matt/dco2

• cx_oracle : http://www.computronix.com/utilities.shtml

CharacterSet변경문제

SQL> alter system enable restricted session;

System altered.

SQL> alter system set job_queue_processes = 0;

System altered.

SQL> alter system set aq_tm_processes = 0;

System altered.

SQL> alter database open;

Database altered.

SQL> alter database character set WE8ISO8859P1;

Database altered.

SQL> select VALUE$ from PROPS$ where NAME = 'NLS_CHARACTERSET';

VALUE$
--------------------------------------------------------------------------------
WE8ISO8859P1

혹은 [http://database.sarang.net/?inc=read&aid=18388&criteria=oracle&subcrit=&id=&limit=20&keyword=character&page=3 관련질답]

일반적인 접속절차 및 인코딩변경

# su - oracle
$ export ORACLE_SID=sid
$ echo $ORACLE_SID
sid
$ sqlplus /nolog
> connect / as sysdba
> shutdown
> startup mount exclusive
> alter database enable restricted session
> alter database set job_queue_processes = 0
> alter database open
> alter database character set internal_use utf8
> alter database national character set internal_use utf8
> select * from nls_database_parameters where parameter like '%CHARACTERSET%'

> update sys.props$ set values$='UTF-8';
> where name='NLS_CHARACTERSET';
 
> update sys.props$ set values$='UTF-8';
where name='NLS_NCHAR_CHARACTERSET';
 
> update sys.props$ set values$='UTF-8';
where name='NLS_LANGUAGE';

> shutdown immediate

CategoryProgram