BioHackersNet|
Size: 1783
Comment:
|
Size: 1392
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 5: | Line 5: |
| * [http://www.oracleclub.com/profile/OracleFirst.jsp 오라클공부를 처음 시작하시는 분들께...] | |
| Line 6: | Line 7: |
| [Python] interface * DCOracle2 : http://www.zope.org/Members/matt/dco2 * cx_oracle : http://www.computronix.com/utilities.shtml |
[Python]으로 연동하여 쓸 경우, [cx_Oracle] 사용. |
| Line 10: | Line 9: |
| CharacterSet변경문제 | ---- Oracle 시작과 종료 |
| Line 12: | Line 12: |
| 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 |
# su - oracle $ export ORACLE_SID=ORANLRI $ sqlplus "/as sysdba" > startup > exit |
| Line 39: | Line 19: |
| 혹은 [http://database.sarang.net/?inc=read&aid=18388&criteria=oracle&subcrit=&id=&limit=20&keyword=character&page=3 관련질답] | CharacterSet변경문제, 혹은 [http://database.sarang.net/?inc=read&aid=18388&criteria=oracle&subcrit=&id=&limit=20&keyword=character&page=3 관련질답] |
| Line 41: | Line 21: |
| ---- 일반적인 접속절차 및 인코딩변경 |
가장 널리 알려진 상업용 RelationalDatabase Management System
관련정보
[http://www.puschitz.com/InstallingOracle9i.shtml installing 9i on redhat7]
[http://www.oracleclub.com/profile/OracleFirst.jsp 오라클공부를 처음 시작하시는 분들께...]
[Python]으로 연동하여 쓸 경우, [cx_Oracle] 사용.
Oracle 시작과 종료
# su - oracle $ export ORACLE_SID=ORANLRI $ sqlplus "/as sysdba" > startup > exit
CharacterSet변경문제, 혹은 [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 value$='UTF-8' where name='NLS_CHARACTERSET'; > update sys.props$ set value$='UTF-8' where name='NLS_NCHAR_CHARACTERSET'; > update sys.props$ set value$='UTF-8' where name='NLS_LANGUAGE'; > commit; > shutdown immediate > startup > exit