{"id":1294,"date":"2016-02-11T00:42:52","date_gmt":"2016-02-11T00:42:52","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1294"},"modified":"2016-02-11T00:42:52","modified_gmt":"2016-02-11T00:42:52","slug":"client%ec%97%90%ec%84%9c-%ec%a0%91%ec%86%8d%ed%95%9c-ip%eb%a5%bc-%ec%95%8c%ec%95%84%eb%82%b4%eb%8a%94-%eb%b0%a9%eb%b2%95db-%ed%8a%b8%eb%a6%ac%ea%b1%b0%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%98%eb%8a%94","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1294","title":{"rendered":"Client\uc5d0\uc11c \uc811\uc18d\ud55c IP\ub97c \uc54c\uc544\ub0b4\ub294 \ubc29\ubc95(DB \ud2b8\ub9ac\uac70\ub97c \uc774\uc6a9\ud558\ub294 \ubc29\ubc95)"},"content":{"rendered":"

\uc624\ub77c\ud074\uc5d0 \uc811\uc18d\ud55c \ud074\ub77c\uc774\uc5b8\ud2b8 IP\ub97c \ucd94\uc801\ud568\uc73c\ub85c\uc368 \uc624\ub77c\ud074\uc5d0 \uc601\ud5a5\uc744 \uc904 \uc218 \uc788\ub294 \ud074\ub77c\uc774\uc5b8\ud2b8\uc758 <\/span>\uac01\uc885 \uc815\ubcf4\ub97c \uac80\uc0c9\ud558\uc5ec \ud29c\ub2dd \ubc0f \ubb38\uc81c\uc810\uc744 \ud574\uacb0\ud558\ub294\ub370 \ub2e4\uc591\ud558\uac8c \uc774\uc6a9\ub420 \uc218 \uc788\ub2e4. <\/span>

<\/span><\/p>\n


<\/span><\/p>\n


<\/span><\/p>\n

1. sys \uc0ac\uc6a9\uc790\ub85c \uc624\ub77c\ud074\uc5d0 \uc811\uc18d\ud55c\ub2e4. <\/span>
  <\/span>
    $ sqlplus internal <\/span>

  <\/span>
2. \ub2e4\uc74c\uc5d0 \uc81c\uc2dc\ud55c \ud2b8\ub9ac\uac70\ub97c \uc0dd\uc131\ud55c\ub2e4. <\/span>


SQL> drop table sqlclient; <\/span>
SQL> create table sqlclient ( ipno varchar2(20), sid number,  name varchar2(64)); <\/span>


SQL> create or replace procedure ip_ins is <\/span>
        curInfo    varchar2(80); <\/span>
        v_sid      number; <\/span>
        v_sno      number; <\/span>
        v_ipno    varchar2(20); <\/span>
        v_name    varchar2(64); <\/span>
        sessionid  varchar2(20); <\/span>
    begin <\/span>
        sessionid := dbms_session.unique_session_id(); <\/span>
        dbms_application_info.read_client_info(curInfo); <\/span>
        dbms_application_info.set_client_info(sessionid); <\/span>
        select  sid,  machine <\/span>
        into    v_sid,  v_name <\/span>
        from    v$session <\/span>
        where  client_info = sessionid; <\/span>
        dbms_application_info.set_client_info(curInfo); <\/span>
        — <\/span>
        v_ipno := sys_context(‘USERENV’,’IP_ADDRESS’); <\/span>
        if    v_ipno is not null then <\/span>
                insert into sqlclient <\/span>
                values    (v_ipno, v_sid, v_name ); <\/span>
                commit; <\/span>
        end if; <\/span>
    exception <\/span>
        when  dup_val_on_index then <\/span>
                update sqlclient <\/span>
                set    sid = v_sid ,  name  = v_name <\/span>
                where  ipno = v_ipno; <\/span>
                commit; <\/span>
      — when  others then <\/span>
      —        null; <\/span>
        end; <\/span>
    \/ <\/span>


SQL> create or replace trigger db_logon <\/span>
        after logon on database <\/span>
        begin <\/span>
          sys.ip_ins; <\/span>
      end; <\/span>
        \/ <\/span>

3. \ud074\ub77c\uc774\uc5b8\ud2b8\uc5d0\uc11c TCP\/IP\ub85c \uc624\ub77c\ud074\uc5d0 \uc811\uc18d\ud55c \ud6c4 \uc815\ubcf4\ub97c \uc870\ud68c\ud55c\ub2e4. <\/span>

    SQL > connect sys\/<\/span>
    SQL > select * from sqlclient;<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\uc624\ub77c\ud074\uc5d0 \uc811\uc18d\ud55c \ud074\ub77c\uc774\uc5b8\ud2b8 IP\ub97c \ucd94\uc801\ud568\uc73c\ub85c\uc368 \uc624\ub77c\ud074\uc5d0 \uc601\ud5a5\uc744 \uc904 \uc218 \uc788\ub294 \ud074\ub77c\uc774\uc5b8\ud2b8\uc758 \uac01\uc885 \uc815\ubcf4\ub97c \uac80\uc0c9\ud558\uc5ec \ud29c\ub2dd \ubc0f \ubb38\uc81c\uc810\uc744 \ud574\uacb0\ud558\ub294\ub370 \ub2e4\uc591\ud558\uac8c \uc774\uc6a9\ub420 \uc218 \uc788\ub2e4.  1. sys \uc0ac\uc6a9\uc790\ub85c \uc624\ub77c\ud074\uc5d0 \uc811\uc18d\ud55c\ub2e4.       $ sqlplus internal   2. \ub2e4\uc74c\uc5d0 \uc81c\uc2dc\ud55c \ud2b8\ub9ac\uac70\ub97c \uc0dd\uc131\ud55c\ub2e4. SQL> drop table sqlclient; SQL> create table sqlclient ( ipno varchar2(20), sid number,  name varchar2(64)); SQL> create or replace procedure ip_ins is       […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[626,703,704,705,706],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1294"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1294"}],"version-history":[{"count":0,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1294\/revisions"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1294"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}