=====================================================================
 
EMMA3 version 3.7.1 released on 2023-05-02
Copyright (C) 1995-2023 INFOBANK CORP.  All rights reserved.  
 
No part of this product may be reproduced in any form 
or by any means without written permission from:
 
INFOBANK CORP.
12th floor, Uspace1 A-dong, 660, Daewangpangyo-ro Bundang-gu Seongnam-si, Gyeonggi-do, Korea

=====================================================================

  EMMA V.3 ġ, Ǵ   Ǵ    
FAQ ̴.



1. Ű 
---------------------------------------------------------------------
  ġ  emma Ͽµ, " EMMA startDaemon [%18s] ALERT: 
  init failure, {} ib.frame.c.f: .\cert\zibvir3_pri.der 
  (  ã  ϴ) "   
  ޽ ߻ϸ, Ű  ʾ ߻ ̴.
  Ű regkey Ͽ   ִ.


2. ȭ Ȯ
---------------------------------------------------------------------
  Infobank G/W  ȵ  ȭ üũѴ.

  ȭ Ȯ
  + 
    - DNS lookup ɽ
      telnet auth.infobank.net 12001
    - DNS lookup Ұɽ
      Infobank    ڷκ  IP ûϿ Ѵ. 

  + GW  üũ
    - Infobank    ڷκ  GW  ȮѴ.
      ) ũ  1 : 192.168.0.0.1 / 3000  Ѵٸ
          telnet 192.168.0.0.1 3000


3. DB Stored Procedure ġ 
---------------------------------------------------------------------
  " java.sql.SQLException: ORA-06550: line 1, column 7:
  PLS-00201: identifier 'EMMA_PKG_COM.SP_EM_COMMON_CHECKPRIVILEGE' must be declared "
   ޽ µǸ, DB Package Ǵ Stored Procedure ġǾ 
   ʾ ߻ ̴.  Ǵ DB ν 
   ָ ȴ.


4. Unixȯ濡 ѱ (???)   ó
---------------------------------------------------------------------
  - ȯ溯 LANG Ѵ.
  - 밳  "ko", "ko_KR", "ko_KR.eucKR", "korean"

  - AIX(ko_KR)         : export LANG=ko_KR
  - Solaris(ko)        : export LANG=ko
                 setenv LANG ko_KR(cshrc)
  - SunOS          : export LANG=ko_KR.EUC
  - Linux(ko_KR.eucKR) : export LANG=ko_KR.eucKR
  - HP-UX(ko_KR.eucKR) : export LANG=ko_KR.eucKR

  Oracle NSL_LANG :
  - SET NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949
  - SET NLS_LANG=KOREAN_KOREA.KO16MSWIN949
   Linux : export NLS_LANG=AMERICAN_AMERICA.KO16MSWIN949


5. Ŭ  
---------------------------------------------------------------------
  EMMA  Ʒ  ޽ ߻ϴ  Ŭ  ̺ 
    ߻ϴ ̴. ̶ ش  ̺  
  Ʒ ɾ  οϸ ȴ.
  - oralce9i  : grant create any table to user_emma;
  - oracle10g : grant create table to user_emma;

  - Error Log :
    java.sql.SQLException: ORA-01031:  մϴ
    ORA-06512: "EMMA.EMMA_PKG_COM",  152
    ORA-06512:  1
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)


6. MySQL ѱ  
---------------------------------------------------------------------
  MySQL Console show variables; ɾ   

  character_set_database euckr 
  db0.url = jdbc:mysql://localhost:3306/freeweb_emma?useUnicode=true&noAccessToProcedureBodies=true

  character_set_database utf8 
  db0.url = jdbc:mysql://localhost:3306/freeweb_emma?useUnicode=true&noAccessToProcedureBodies=true&characterEncoding=utf8

  character_set_database latin1   
  db0.url = jdbc:mysql://localhost:3306/freeweb_emma?useUnicode=true&noAccessToProcedureBodies=true
  db0.charset = UTF-8


7. Windows ȯ濡     ġ    
---------------------------------------------------------------------
  Windows   ġ  񽺸 ϱ   
     ȴ. ̰ Service  Ͽ ־
  Ѵ.

  Windows    
    - sc create SMS_SVC1 binpath= "C:\Infobank\EMMA\emmasvc.exe" displayName= "SMS_SVC1" type= own start= auto
    - sc delete SMS_SVC1