Diff for "Oracle" - BioHackersNet

Differences between revisions 2 and 8 (spanning 6 versions)

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

관련정보

[http://www.puschitz.com/InstallingOracle9i.shtml installing 9i on redhat7]
[http://www.oracleclub.com/profile/OracleFirst.jsp 오라클공부를 처음 시작하시는 분들께...]

[Python] interface

DCOracle2 : http://www.zope.org/Members/matt/dco2
cx_oracle : http://www.computronix.com/utilities.shtml

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

CategoryProgram

-  ⇤ ← Revision 2 as of 2005-11-11 19:33:53 → 
  Size: 1763
  Editor: 203
  Comment:
+   ← Revision 8 as of 2007-07-11 16:41:57 → ⇥
  Size: 1464
  Editor: 152
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 5:
+ * [http://www.oracleclub.com/profile/OracleFirst.jsp 오라클공부를 처음 시작하시는 분들께...]
-Line 10:
+Line 11:
-CharacterSet변경문제
+----
Oracle 시작과 종료
-Line 12:
+Line 14:
-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 21:
-혹은 [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 23:
-----
일반적인 접속절차 및 인코딩변경
-Line 52:
+Line 32:
-> 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%'
+> 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%';
-Line 59:
+Line 39:
-> 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';
+> 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';
-Line 68:
+Line 43:
+> commit;
-Line 69:
+Line 45:
+> startup
> exit