{"id":1304,"date":"2016-03-24T01:43:06","date_gmt":"2016-03-24T01:43:06","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1304"},"modified":"2016-03-24T01:43:06","modified_gmt":"2016-03-24T01:43:06","slug":"taf-%eb%9e%80","status":"publish","type":"post","link":"https:\/\/haisins.synology.me\/wordpress\/?p=1304","title":{"rendered":"TAF \ub780?"},"content":{"rendered":"

\n <\/p>\n

TAF – Connection Failover options
\n<\/strong><\/span><\/p>\n

 <\/p>\n

\n <\/p>\n

\uc804\uc81c \uc0ac\ud56d : Oracle Server\ub294 RAC\ub85c \uad6c\uc131\ub418\uc5b4\uc57c \ud55c\ub2e4.
\n<\/span><\/h4>\n

OCI\ub97c \uc774\uc6a9\ud558\uc9c0 \uc54a\uc740 Application\uc740 TAF\ub97c \uc704\ud55c \ud2b9\ubcc4\ud55c \uae30\ub2a5\uc744 \uc81c\uacf5 \ud558\uc9c0 \uc54a\uc73c\uba70, \uac1c\ubc1c\uc790\uac00 Logic\uc744 \uad6c\ud604\ud574\uc57c \ud55c\ub2e4.
\n<\/span><\/p>\n

TAF\ub97c \uc704\ud55c Server Configuration\uc740 \uc774 \ubb38\uc11c\uc5d0\uc11c \uace0\ub824\ud558\uc9c0 \uc54a\ub294\ub2e4. CONNECTION TIME FAIL OVER\ub294 \uc774 \ubb38\uc11c\uc5d0\uc11c \uace0\ub824\ud558\uc9c0 \uc54a\ub294\ub2e4. \uc704\uc758 \uc0ac\ud56d\ub4e4\uc744 \uc2dc\uac04\uc758 \uc5ec\uc720\uac00 \uc788\uc744 \uacbd\uc6b0\uc5d0\ub294 \uc791\uc131\ud55c\ub2e4.
\n<\/span><\/p>\n

 <\/p>\n

\n <\/p>\n

\n <\/p>\n

\uf051 TAF\ub294 RAC\ub97c \uc0ac\uc6a9\ud558\ub294 \ud658\uacbd\uc5d0\uc11c \uac00\uc6a9\uc131\uc744 \uadf9\ub300\ud654 \ud558\uae30 \uc704\ud574 \uc81c\uacf5 \ub418\ub294 \uae30\ub2a5\uc774\uba70, \ubaa8\ub4e0 Application\uc744 \uc801\uc6a9\ud558\uae30 \ubcf4\ub2e4\ub294 \uc911\uc694\ud55c Application\uc5d0 \ub300\ud574\uc11c\ub9cc \uc801\uc6a9\ud1a0\ub85d \ud55c\ub2e4.
\n<\/strong><\/span><\/p>\n

\uf051 TAF \uc801\uc6a9\uc2dc \uace0\ub824 \uc0ac\ud56d\ub4e4
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n
\n

\uad6c  \ubd84<\/strong><\/span><\/p>\n<\/td>\n

\n

  \ub0b4    \uc6a9<\/strong><\/span><\/p>\n<\/td>\n

\n

  \uace0\ub824\uc0ac\ud56d <\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

CTF(Connection Time FailOver)<\/strong><\/span><\/p>\n<\/td>\n

\n

\ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub85c \uc811\uc18d\ud558\ub294 \uc21c\uac04\uc5d0 Server, DB, Listener\ub4f1\uc774 \uac00\uc6a9\ud558 \uc9c0 \uc54a\uc744 \uacbd\uc6b0\uc5d0 \ub2e4\ub978 \ucabd Server\ub85c \uc811\uc18d\ud558\ub294 \uac83\uc744 \ub9d0\ud568.<\/strong><\/span><\/p>\n<\/td>\n

\n

OCI\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \ud504\ub85c\uadf8\ub7a8\uc740 \ub9e4\ub274\uc5bc \ud558\uac8c Logic\ub97c \uad6c\uc0ac\ud574\uc57c \ud55c\ub2e4.<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

TAF(Run Time FailOver)<\/strong><\/span><\/p>\n<\/td>\n

\n

\uc811\uc18d \ud6c4 \ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc0ac\uc6a9 \uc911\uc5d0 DB\ub098 Session\uc774 \uc7a5\uc560\uac00 \ubc1c\uc0dd \ud588 \uc744 \uacbd\uc6b0\uc5d0 \ub2e4\ub978 node\ub85c \uc811\uc18d\ud558\uc5ec \uc9c4\ud589\ud558\ub358 \uc791\uc5c5\uc744 \uacc4\uc18d\ud560 \uc218 \uc788\ub3c4 \ub85d \ud558\ub294 \uac83\uc744 \ub9d0\ud568.<\/strong><\/span><\/p>\n<\/td>\n

\n

OCI\ub97c \uc0ac\uc6a9\ud560 \uacbd\uc6b0\uc5d0\ub294 \uc624\ub77c\ud074\uc5d0\uc11c CallBack method\ub97c\uc9c0 \uc6d0\ud558\ub098 OCI\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uc744 \uacbd\uc6b0\uc5d0\ub294 Logic\uc73c\ub85c \uad6c\uc0ac\ud574\uc57c \ud568<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

FailOver \ubc29\ubc95<\/strong><\/span><\/p>\n<\/td>\n

\n

TAF\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 Failover \ubc29\ubc95\ub4e4\uc744 \ub9d0\ud568. Mode : session, select
\n<\/strong><\/span><\/p>\n

Method : Basic , Preconnect<\/strong><\/span><\/p>\n<\/td>\n

\n

Long s elect\uc218\ud589\uc911 \uc7a5\uc560 \ubc1c\uc0dd\uc2dc \uc218\ud589\ud558\ub358 \uc791\uc5c5\uc744 \ub118\uae30\uae30 \uc704\ud574\uc11c\ub294 ‘s elect’\ub85c \ud574\uc57c \ud558\uba70 ‘session’\uc73c\ub85c \ud558\uba74 session \ub9cc \ub118\uc5b4\uac00\uace0 SQL\uc740 \ub2e4\uc2dc \uc218\ud589\ud574\uc57c \ud568.
\n<\/strong><\/span><\/p>\n

Basic\uc740 \uc7a5\uc560 \ubc1c\uc0dd\uc2dc \ub2e4\uc2dc \uc811\uc18d\ud558\ub294 \ubc29\ubc95\uc774\uace0, preconnect\ub294 \ucd5c\ucd08 \uc811\uc18d\uc2dc \ub2e4\ub978 node\uc5d0 \ubbf8\ub9ac<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Language \ubcc4<\/strong><\/span><\/p>\n<\/td>\n

\n

\ubaa8\ub4e0 programming language \ub97c TAF\uac00 \uc9c0\uc6d0\ud558\uc9c0\ub294 \uc54a\uace0 OCI\ub97c\uc0ac\uc6a9\ud558\ub294 language \ub9cc\uc744 \uc9c0\uc6d0 \ud55c\ub2e4.<\/strong><\/span><\/p>\n<\/td>\n

\n

OCI\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 Language \uc758 \uacbd\uc6b0\uc5d0\ub294 \uc790\uccb4\uc801\uc73c\ub85c
\n<\/strong><\/span><\/p>\n

Logic\uc73c\ub85c \ucc98\ub9ac\ud574 \ud55c\ub2e4. Ex) java thin driver\uc0ac\uc6a9\uc2dc<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\uc7a5\uc560 \uc720\ud615\ubcc4 \uc0ac\uc6a9 \uc5ec\ubd80<\/strong><\/span><\/p>\n<\/td>\n

\n

\uc7a5\uc560 \uc720\ud615\ubcc4 TAF\ub97c \uc0ac\uc6a9\ud574\uc57c \ud560\uc9c0 \uacb0\uc815\ud55c\ub2e4.<\/strong><\/span><\/p>\n<\/td>\n

\n

\uc5ec\ub7ec \uac00\uc9c0 \uc7a5\uc560\uc5d0 \ub530\ub77c, TAF\ub97c \uc0ac\uc6a9\ud560 Error\uc640 \uc0ac\uc6a9\ud558\uc9c0\uc54a \uc744 Error\ub97c \uad6c\ubd84\ud558\uc5ec \uc801\uc6a9\ud574\uc57c \ud568.<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\uc801\uc6a9\ud560 Application \uc120\uc815<\/strong><\/span><\/p>\n<\/td>\n

\n

\uc704\uc758 \ub0b4\uc5ed\ub4e4\uc744 \ubaa8\ub450 \uace0\ub824\ud558\uc5ec CTF, TAF\ub97c \uc801\uc6a9\ud55c Application\uc744\uc120 \uc815\ud55c\ub2e4. \uc774\ub54c \ub108\ubb34 \ub9ce\uc740 Application\uc744 \uace0\ub824 \ud560 \uacbd\uc6b0\uc5d0\ub294 \uc0c1\ud669\uc758 \ubcf5 \uc7a1\ud568\uc5d0 \uc2dc\uc2a4\ud15c\uc758 \uc548\uc815\ud654\uc5d0 \ub098\uc05c \uc601\ud5a5\uc744 \uc904 \uc218 \uc788\ub2e4.<\/strong><\/span><\/p>\n<\/td>\n

\n

\ud504\ub85c\uadf8\ub7a8\uc758 \uc911\uc694\ub3c4\uc5d0 \ub530\ub77c CTF, TAF\ub97c \uc801\uc6a9\ud560 Application \uc744 \uc120\uc815\ud558\uba70, \ub2e4\uc591\ud55c Error\uc5d0 \ub300\ud55c \uc870\uce58\uc0ac\ud56d\uc744 \uc801\uc808\ud558\uac8c \uc801\uc6a9\ud574\uc57c \ud55c\ub2e4.<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

 <\/p>\n

\n <\/p>\n

TAF\uc5d0\ub294 \uc5ec\ub7ec \uac00\uc9c0 mode \ubc0f method\uac00 \uc788\ub294\ub370, \uac01 Application\uc5d0 \uc801\ud569\ud55c TAF\ubc29\ubc95\uc744 \uacb0\uc815\ud55c\ub2e4.
\n<\/span><\/h1>\n

\n <\/p>\n

\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
\n

Method\/ Mod<\/strong><\/span><\/p>\n<\/td>\n

\n

SESSION<\/strong><\/span><\/p>\n<\/td>\n

\n

SELECT<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

BASIC<\/strong><\/span><\/p>\n<\/td>\n

\n

\uc7a5\uc560 \ubc1c\uc0dd\uc2dc client\ub294 \uc790\ub3d9\uc801\uc73c\ub85c \ub2e4\ub978 node\ub85c Login\uc774 \ub41c\ub2e4. \ub9cc\uc57d \uc218\ud589\ud558\ub358 Select\ubb38\uc774 \uc788\uc744 \uacbd\uc6b0 \uc5d0\ub294 \ub2e4\uc2dc \uc218\ud589\ud574\uc57c \ud55c\ub2e4.<\/strong><\/span><\/p>\n<\/td>\n

\n

Query\ub97c \uc218\ud589\ud558\ub294 \ub3d9\uc548 \uc7a5\uc560\uac00 \ubc1c\uc0dd\ud558\uba74 \uc790\ub3d9\uc73c\ub85c \ub2e4\ub978 node\ub85c Log in\uc774 \ub418\uba70, \uc218\ud589\ud558\ub358 Query\ub97c \uc790\ub3d9\uc73c\ub85c \ub2e4\uc2dc \uc218\ud589\ud558\uac8c \ub41c\ub2e4.<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

PRECONNECT<\/strong><\/span> <\/p>\n<\/td>\n

\n

Client\ub294 \uc811\uc18d \uc2dc 2\uac1c\uc758 node\uc5d0 \ubaa8\ub450 \uc811\uc18d\ud55c\ub2e4.
\n<\/strong><\/span><\/p>\n

\uc774\ub7ec\ud55c \ubc29\uc2dd\uc740 \uc7a5\uc560 \ubc1c\uc0dd\uc2dc \uc811\uc18d\uc758 \ubd80\ud558\ub97c \uc904\uc77c \uc218 \uc788\ub2e4. \ubb3c\ub85c \uc591\ucabd node\uc5d0 \uc811\uc18d\ud558\uace0 \uc788\uc73c\ubbc0\ub85c \uc811\uc18d\uc5d0 \ub300\ud55c \ubd80\ub2f4
\n<\/strong><\/span><\/p>\n

\uc774 \uc874\uc7ac\ud55c\ub2e4.<\/strong><\/span><\/p>\n<\/td>\n

\n

Client\ub294 \uc811\uc18d \uc2dc 2\uac1c\uc758 node\uc5d0 \ubaa8\ub450 \uc811\uc18d\ud55c\ub2e4.<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

 <\/td>\n<\/tr>\n
 <\/td>\n<\/tr>\n
 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\n <\/p>\n

\uc81c\uc57d\uc0ac\ud56d :OCI(NET8)\uc744 \uc0ac\uc6a9\ud558\ub294 Application\uc5d0 \ud55c \ud574\uc11c \uc801\uc6a9\uac00\ub2a5 \ud558\ub2e4.
\n<\/span><\/h2>\n

\ub9cc\uc57d OCI\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 Application\uc740 Manual\ud558\uac8c \uc870\uce58\ud574\uc57c \ud568. \uc131\ub2a5 \uce21\uba74\uc5d0\uc11c Application Partitioning\ud6c4\uc5d0 TAF\ub85c Failover\ub294 RAC\uc758 \ubd80\ub2f4\uc744 \uc904 \uc218 \uc788\uc73c\ubbc0\ub85c \uc774\uc5d0 \ub300\ud55c \uace0\ub824\ub3c4 \ud544\uc694\ud568(ping\uc758 \ubd80\ud558)
\n<\/strong><\/span><\/p>\n

 <\/p>\n

\n <\/p>\n

\uf051 TAF Application \uc120\ud0dd \uae30\uc900
\n<\/span><\/h2>\n

\n <\/p>\n

\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
\n

\uc801\uc6a9 \uc5ec\ubd80<\/strong><\/span><\/p>\n<\/td>\n

\n

Application\uc758 \uc131\uaca9<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

TAF \uc801\uc6a9<\/strong><\/span><\/p>\n<\/td>\n

\n

24X365\ub85c \uc218\ud589\ub418\ub294 Application(daemon \ud615\ud0dc\uc758 \ud504\ub85c\uadf8\ub7a8\uc73c\ub85c \uc790\uccb4\uc801\uc73c\ub85c \uc7ac\uae30\ub3d9 \ud560 \uc218 \uc5c6\ub294Application)<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\uc911\uc694 Transaction\uc744 \ud3ec\ud568\ud558\ub294 Application<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

TAF \ubbf8\uc801\uc6a9<\/strong><\/span><\/p>\n<\/td>\n

\n

\ub2e8\uc21c \uc870\ud68c Web Application<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

C\/ S \ud658\uacbd\uc758 \uc870\ud68c Application<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

\ub2e4\uc2dc \uc2dc\uc791\ud574\ub3c4 \ub418\ub294 Transaction\uc744 \uac00\uc9c4 Application<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\n <\/p>\n

\n <\/p>\n

\uf051 Application TAF \uc801\uc6a9 \ub2e8\uacc4 Flow
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\n <\/p>\n


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

 <\/p>\n

\n <\/p>\n

\n <\/p>\n

\n <\/p>\n

\uf051 \uac1c\ubc1c \uc5b8\uc5b4\uc5d0 \ub530\ub978 TAF \uc0ac\uc6a9 \uc5ec\ubd80
\n<\/span><\/h1>\n

Java, C++, etc
\n<\/span><\/h3>\n

\n <\/p>\n

\uf051 TAF\ub97c \uc0ac\uc6a9 \uac00\ub2a5\ud55c Client Application Product
\n<\/strong><\/span><\/p>\n

\n <\/p>\n

\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n
\n

Product<\/strong><\/span><\/p>\n<\/td>\n

\n

\uad6c\ubd84 <\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Oracle Call Inte rface<\/strong><\/span><\/p>\n<\/td>\n

\n

Release 8<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

ODBC driver<\/strong><\/span><\/p>\n<\/td>\n

\n

Release 8.0.5<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

JDBC driver<\/strong><\/span><\/p>\n<\/td>\n

\n

Release 8 (thick driver only)<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Pro*C<\/strong><\/span><\/p>\n<\/td>\n

\n

Release 8i<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

SQL*Plus<\/strong><\/span><\/p>\n<\/td>\n

\n

Release 8.0.4<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Oracle Object for OLE<\/strong><\/span><\/p>\n<\/td>\n

\n

Release 8i(Planned)<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\n <\/p>\n

\n <\/p>\n

\uf051 \ud2b9\uc218\ud55c \uc0ac\uc6a9 \ud615\ud0dc\uc5d0 \ub530\ub978 \uace0\ub824\uc0ac\ud56d.
\n<\/strong><\/span><\/p>\n

Java\uc758 Connection Pool \ud615\ud0dc\uc758 Connection\uc5d0 \ub300\ud55c TAF \uad6c\ud604\ubc29\ubc95 \ubaa8\uc0c9.
\n<\/strong><\/span><\/p>\n

OCI\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 Application \uc740 \uc790\uccb4\uc801\uc73c\ub85c Error\ub97c \ud0d0\uc9c0 \ud558\uc5ec \ud504\ub85c\uadf8\ub7a8 \ub0b4\uc5d0 \uc11c Logic\uc73c\ub85c \ucc98\ub9ac\ud558\uc5ec\uc57c \ud55c\ub2e4.
\n<\/strong><\/span><\/p>\n

 <\/p>\n

\n <\/p>\n

\n <\/p>\n

    \n
  • \n

    \uc7a5\uc560 \ubc1c\uc0dd \uc2dc\uc810 \uc2dc\ub098\ub9ac\uc624
    \n<\/span><\/h1>\n<\/li>\n<\/ul>\n

    \n <\/p>\n


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

    \n <\/p>\n


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

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \uc7a5\uc560\uc758 \uc720\ud615\uc5d0 \ub530\ub77c TAF\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uc640 \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \uacbd\uc6b0\ub97c \uad6c\ubd84\ud558\uc5ec \ub098\ub204\uc5b4 \uace0\ub824\ud55c\ub2e4.
    \n<\/span><\/h1>\n


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

    \n\n\n\n\n<\/colgroup>\n\n\n\n\n\n
     <\/td>\n\n

    Error \ubc88\ud638<\/strong><\/span><\/p>\n<\/td>\n

    		\n

    Error \ub0b4\uc6a9<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

    \n

    \uc0ac\uc6a9\uc911 \uc7a5\uc560(TAF \ud568)<\/strong><\/span><\/p>\n<\/td>\n

    		\n

    ORA- 01034
    \n<\/strong><\/span><\/p>\n

    ORA- 3113, ORA- 3114
    \n<\/strong><\/span><\/p>\n

    ORA- 1033
    \n<\/strong><\/span><\/p>\n

    ORA- 25401
    \n<\/strong><\/span><\/p>\n

    ORA- 00020<\/strong><\/span><\/p>\n<\/td>\n

    		\n

    Oracle Not Available Instance Down Shutdown progress
    \n<\/strong><\/span><\/p>\n

    Cannot Continue Fetch(Fetch \uc911 Error)
    \n<\/strong><\/span><\/p>\n

    Maximum number of processes xx exceeded<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

    \n

    \uc811\uc18d \uc2dc \uc7a5\uc560(CTF \ud568)<\/strong><\/span><\/p>\n<\/td>\n

    		\n

    ORA- 12541
    \n<\/strong><\/span><\/p>\n

    ORA- 01034<\/strong><\/span><\/p>\n<\/td>\n

    		\n

    TNS:nolis tener Oracle Not Available<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

    \n

    \uc77c\ubc18 Error(TAF\ud558\uc9c0 \uc54a\uc74c)<\/strong><\/span><\/p>\n<\/td>\n

    		\n

    Others<\/strong><\/span><\/p>\n<\/td>\n

    		\n

    \uc77c\ubc18 SQL\uc218\ud589\uc2dc \ubc1c\uc0dd\ud558\ub294 Error\ub294 TAF\uc5d0 \uc801\uc6a9\ud558\uc9c0 \uc54a\ub294\ub2e4. Ex) extent error\ub098 unique violation error\ub4f1.<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

    \n <\/p>\n

    \n <\/p>\n

    \uc7a5\uc560\uc758 \ubcf5\uad6c\ub97c \uc704\ud55c \uc2dc\ub3c4\uc5d0 \ub300\ud55c \uc81c\ud55c(\uc608, 10\ud68c)\uc744 \ub450\uc5b4 \uc7a5\uae30\uc801\uc778 \uc7a5\uc560\uc2dc \ubd88\ud544\uc694\ud55c \uc790\uc6d0 \ub0ad\ube44\ub97c \uc608\ubc29\ud55c\ub2e4.
    \n<\/span><\/h3>\n

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

    \uf051 FailOver(TAF)\uc758 \uacbd\uc6b0\uc5d0 \uc544\ub798\uc758 \uba87 \uac00\uc9c0 \uc815\ubcf4\ub4e4\uc744 \uc783\uc5b4\ubc84\ub9ac\uac8c \ub418\ubbc0\ub85c, TAF\ub97c \uc801\uc6a9\ud558\uae30\ub85c\uc120\uc815 \ub41c Application\ub0b4\uc5d0\uc11c \uc783\uc5b4\ubc84\ub9b0 \uc815\ubcf4\uc5d0 \ub300\ud55c \ucc98\ub9ac Logic\uc744 \ub123\uc5b4\uc57c \ud55c\ub2e4.
    \n<\/span><\/h3>\n

    <\/span><\/div>\n

    \uf051 FailOver\ub420 \ub54c, RAC\ud658\uacbd \uc758 Global Loc\uc5d0 \ub300\ud55c remastering \uc791\uc5c5\uc73c\ub85c \uc57d\uac04\uc758 \uc9c0\uccb4 \ud604\uc0c1\uc774 \ub098\ud0c0\ub0a0 \uc218 \uc788\ub2e4.
    \n<\/strong><\/span><\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n
    \n

    \uc885 \ub958<\/strong><\/span><\/p>\n<\/td>\n

    		\n

    \ub0b4 \uc6a9<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

    \n

    PL\/ SQL Pac kage s tatus<\/strong><\/span><\/p>\n<\/td>\n

    		\n

    Package \uc758 global \ubcc0\uc218 \uac19\uc740 \uc815\ubcf4\ub294 \uc190\uc2e4\ub428<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

    \n

    Alter Sess ion Statement<\/strong><\/span><\/p>\n<\/td>\n

    		\n

    Alter s ess ion\uc744 \uc774\uc6a9\ud55c \uc791\uc5c5\uc740 \uc190\uc2e4 \ub418\uba70, \uc774\ub294 TAF\ud6c4\uc5d0 \ub2e4\uc2dc \uc801\uc6a9\ud558\uc5ec\uc218 \ud589 \ud574\uc57c \ud55c\ub2e4.<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

    \n

    \uc9c4\ud589\uc911\uc778 Trans action<\/strong><\/span><\/p>\n<\/td>\n

    		\n

    Trans action\uc740 \ubc18\ub4dc\uc2dc rollbac k\ud55c\ud6c4 \uc791\uc5c5\uc744 \uc9c4\ud589\ud560\uc218 \uc788\ub2e4.<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

    \n

    Cursor<\/strong><\/span><\/p>\n<\/td>\n

    		\n

    Cursor\ub97c \uc5f4\uace0 \uc5f0\uc18d\uc801\uc778 \uc791\uc5c5\uc744 \ud558\ub294 \uac83\uc740 e rro r\ub97c \ubc1c\uc0dd\ud560\uc218 \uc788\ub2e4. (ora-
    \n<\/strong><\/span><\/p>\n

    25401)<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

    \n

    Temporary table data<\/strong><\/span><\/p>\n<\/td>\n

    		\n

    Temporary table\uc744 \uc0ac\uc6a9\ud558\ub294 \uc815\ubcf4\ub294 \uc783\uc5b4\ubc84\ub9b0\ub2e4.<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

    \n

    Lob loc ator reads<\/strong><\/span><\/p>\n<\/td>\n

    		 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

     <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

     <\/p>\n

    \uf051 OCI\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uc758 CTF
    \n<\/strong><\/span><\/p>\n


    \n\t\t\t\t\t<\/strong><\/span><\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \uf051 OCI \uc5c6\uc774 CTF \uad6c\ud604
    \n<\/strong><\/span><\/p>\n


    \n\t\t\t\t\t<\/strong><\/span><\/p>\n

    \n <\/p>\n

    \uf051 OCI\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0\uc758 TAF
    \n<\/strong><\/span><\/p>\n


    \n\t\t\t\t\t<\/strong><\/span><\/p>\n

    \n <\/p>\n

    \uf051 OCI \uc5c6\uc774 TAF \uad6c\ud604
    \n<\/strong><\/span><\/p>\n

    \n\t\t\t<\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    TAF Sample \ud504\ub85c\uadf8\ub7a8
    \n<\/span><\/p>\n

    \n <\/p>\n

    Test\ud658\uacbd \ud658\uacbd Server : THVSD01, THVSD02\n<\/p>\n

    Java : Thick(OCI\uc5d0\uc11c \uc81c\uacf5\ub418\ub294 callback\uc774\uc6a9), Thin(Logic\uc73c\ub85c \ucc98\ub9ac)\n<\/p>\n

    User : oraerp01\n<\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    Listener.ora \ub0b4\uc5ed \ub0b4\uc5ed\n<\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    listener.ora(node 1)\n<\/p>\n

    \n <\/p>\n

    ERP01 =\n<\/p>\n

    (ADDRESS_LIST =\n<\/p>\n

    (ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCERP01))\n<\/p>\n

    (ADDRESS= (PROTOCOL= TCP)(Host= td01_net)(Port= 1812)) )\n<\/p>\n

    \n <\/p>\n

    listener.ora(node 2)\n<\/p>\n

    \n <\/p>\n

    ERP02 =\n<\/p>\n

    (ADDRESS_LIST =\n<\/p>\n

    (ADDRESS= (PROTOCOL= IPC)(KEY= EXTPROCERP01))\n<\/p>\n

    (ADDRESS= (PROTOCOL= TCP)(Host= td02_net)(Port= 1812)) )\n<\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    Tnsnames.ora\n<\/p>\n

    \n <\/p>\n

    TAF_ERP01=\n<\/p>\n

    (DESCRIPTION_LIST=\n<\/p>\n

    (DESCRIPTION=\n<\/p>\n

    (FAILOVER=on)\n<\/p>\n

    (ADDRESS_LIST =\n<\/p>\n

    (ADDRESS=(PROTOCOL=tcp)(HOST=TD01_net) (PORT=1812))\n<\/p>\n

    (ADDRESS=(PROTOCOL=tcp)(HOST=TD02_net) (PORT=1812))\n<\/p>\n

    )\n<\/p>\n

    (CONNECT_DATA=\n<\/p>\n

    (SERVICE_NAME=ERP)\n<\/p>\n

    (FAILOVER_MODE=\n<\/p>\n

    (BACKUP=TAF_ERP01)\n<\/p>\n

    (TYPE=SELECT)\n<\/p>\n

    (METHOD=BASIC)\n<\/p>\n

    ) ) )\n<\/p>\n

    )\n<\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    TAFwithOCI.java Sample\n<\/p>\n

    \n <\/p>\n

    \/\/OCI \ub97c \uc774\uc6a9\ud55c Sample\ub85c \ub85c\uc368 \uc368 CallBack Class \ub97c \uc774\uc6a9\ud558\uc5ec \ucc98\ub9ac\ud55c\ub2e4.\n<\/p>\n

    \/\/ You need to import java.sql and oracle.jdbc packages to use\n<\/p>\n

    \/\/ JDBC OCI failover callback\n<\/p>\n

    import java.sql.*;\n<\/p>\n

    import java.net.*;\n<\/p>\n

    import java.io.*;\n<\/p>\n

    import java.util.*;\n<\/p>\n

    import oracle.jdbc.OracleConnection;\n<\/p>\n

    import oracle.jdbc.OracleOCIFailover;\n<\/p>\n

    public class TAFwithOCI {\n<\/p>\n

    static final String user = “scott”;\n<\/p>\n

    static final String password = “tiger”;\n<\/p>\n

    static final String driver_class = “oracle.jdbc.driver.OracleDriver”;\n<\/p>\n

    static final String URL = “jdbc:oracle:oci8:@TAF_ERP01”;\n<\/p>\n

    public static void main (String[] args) throws Exception {\n<\/p>\n

    Connection conn = null;\n<\/p>\n

    CallBack fcbk= new CallBack();\n<\/p>\n

    String msg = null;\n<\/p>\n

    Statement stmt = null;\n<\/p>\n

    ResultSet rset = null;\n<\/p>\n

    \/\/ Load JDBC driver\n<\/p>\n

    try {\n<\/p>\n

    Class.forName(driver_class);\n<\/p>\n

    }\n<\/p>\n

    catch(Exception e) {\n<\/p>\n

    System.out.println(e);\n<\/p>\n

    }\n<\/p>\n

    \/\/ Connect to the database\n<\/p>\n

    conn = DriverManager.getConnection(URL, user, password);\n<\/p>\n

    \/\/ register TAF callback function\n<\/p>\n

    ((OracleConnection) conn).registerTAFCallback(fcbk, msg);\n<\/p>\n

    \/\/ Create a Statement\n<\/p>\n

    stmt = conn.createStatement ();\n<\/p>\n

    for (int i=0; i<30; i++) {\n<\/p>\n

    \/\/ Select the ENAME column from the EMP table\n<\/p>\n

    rset = stmt.executeQuery (” select to_char(sysdate,’YYYY MM DD HH24:MI:SS’)|| ” +\n<\/p>\n

    ” ‘[‘||instance_name||’][‘||host_name||’]’ from v$instance “);\n<\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    TAFwithOCI.java Sample\n<\/p>\n

    \n <\/p>\n

    \/\/ Iterate through the result and print the employee names\n<\/p>\n

    while (rset.next ())\n<\/p>\n

    System.out.println (rset.getString (1));\n<\/p>\n

    \/\/ Sleep one second to make it possible to shutdown the DB.\n<\/p>\n

    Thread.sleep(1000);\n<\/p>\n

    } \/\/ End for\n<\/p>\n

    rset.close();\n<\/p>\n

    stmt.close();\n<\/p>\n

    conn.close();\n<\/p>\n

    } \/\/ End Main()\n<\/p>\n

    } \/\/ End class jdemofo\n<\/p>\n

    \/* * Define class CallBack *\/\n<\/p>\n

    class CallBack implements OracleOCIFailover {\n<\/p>\n

    \/\/ TAF callback function\n<\/p>\n

    public int callbackFn (Connection conn, Object ctxt, int type, int event) {\n<\/p>\n

    \/*********************************************************************\n<\/p>\n

    * There are 7 possible failover event\n<\/p>\n

    * FO_BEGIN = 1 indicates that failover has detected a\n<\/p>\n

    * lost conenction and faiover is starting.\n<\/p>\n

    * FO_END = 2 indicates successful completion of failover.\n<\/p>\n

    * FO_ABORt = 3 indicates that failover was unsuccessful,\n<\/p>\n

    * and there is no option of retrying.\n<\/p>\n

    * FO_REAUTH = 4 indicates that a user handle has been re-\n<\/p>\n

    * authenticated.\n<\/p>\n

    * FO_ERROR = 5 indicates that failover was temporarily un-\n<\/p>\n

    * successful, but it gives the apps the opp-\n<\/p>\n

    * ortunity to handle the error and retry failover.\n<\/p>\n

    * The usual method of error handling is to issue\n<\/p>\n

    * sleep() and retry by returning the value FO_RETRY\n<\/p>\n

    * FO_RETRY = 6\n<\/p>\n

    * FO_EVENT_UNKNOWN = 7 It is a bad failover event\n<\/p>\n

    *********************************************************************\/\n<\/p>\n

    String failover_type = null;\n<\/p>\n

    switch (type) {\n<\/p>\n

    case FO_SESSION:\n<\/p>\n

    failover_type = “SESSION”;\n<\/p>\n

    break;\n<\/p>\n

    case FO_SELECT:\n<\/p>\n

    failover_type = “SELECT”;\n<\/p>\n

    break;\n<\/p>\n

    default:\n<\/p>\n

    failover_type = “NONE”;\n<\/p>\n

    }\n<\/p>\n

    \n <\/p>\n

    switch (event) {\n<\/p>\n

    case FO_BEGIN:\n<\/p>\n

    System.out.println(ctxt + “: “+ failover_type + ” failing over…”);\n<\/p>\n

    break;\n<\/p>\n

    case FO_END:\n<\/p>\n

    System.out.println(ctxt + “: failover ended”);\n<\/p>\n

    break;\n<\/p>\n

    case FO_ABORT:\n<\/p>\n

    System.out.println(ctxt + “: failover aborted.”);\n<\/p>\n

    break;\n<\/p>\n

    case FO_REAUTH:\n<\/p>\n

    System.out.println(ctxt + “: failover.”);\n<\/p>\n

    break;\n<\/p>\n

    case FO_ERROR:\n<\/p>\n

    System.out.println(ctxt + “: failover error gotten. Sleeping…”);\n<\/p>\n

    \/\/ Sleep for a while\n<\/p>\n

    try {\n<\/p>\n

    Thread.sleep(100);\n<\/p>\n

    }\n<\/p>\n

    catch (InterruptedException e) {\n<\/p>\n

    System.out.println(“Thread.sleep has problem: ” + e.toString());\n<\/p>\n

    }\n<\/p>\n

    return FO_RETRY;\n<\/p>\n

    default:\n<\/p>\n

    System.out.println(ctxt + “: bad failover event.”);\n<\/p>\n

    break;\n<\/p>\n

    }\n<\/p>\n

    return 0;\n<\/p>\n

    }\n<\/p>\n

    }\n<\/p>\n

    \n <\/p>\n

    \n <\/p>\n

    TAFwithLogic.java Sample\n<\/p>\n

    \n <\/p>\n

    \/\/ \uc7a5\uc560\uc5d0 \ub300\ud55c \ucc98\ub9ac\ub97c Application \uc5d0\uc11c Logic\uc73c\ub85c \ucc98\ub9ac\ud55c\ub2e4 \uc73c\ub85c \ucc98\ub9ac\ud55c\ub2e4\n<\/p>\n

    import java.io.*;\n<\/p>\n

    import java.util.*;\n<\/p>\n

    import java.sql.*;\n<\/p>\n

    import java.text.*;\n<\/p>\n

    public class TAFwithLogic\n<\/p>\n

    {\n<\/p>\n

    public static void main( String[] args ) throws Exception\n<\/p>\n

    {\n<\/p>\n

    DriverManager.registerDriver( new oracle.jdbc.driver.OracleDriver() );\n<\/p>\n

    Connection conn = null;\n<\/p>\n

    Statement stmt = null;\n<\/p>\n

    \/\/while ( true )\n<\/p>\n

    for(int i = 1; i < 100; i++)\n<\/p>\n

    {\n<\/p>\n

    if ( conn == null )\n<\/p>\n

    try\n<\/p>\n

    {\n<\/p>\n

    conn = DriverManager.getConnection( “jdbc:oracle:oci8:@TAF_ERP01”, “apps”, “apps” );\n<\/p>\n

    System.out.println ( “[” + DateFormat.getDateTimeInstance().format( new java.util.Date() ) +\n<\/p>\n

    “] Connection Success” );\n<\/p>\n

    }\n<\/p>\n

    catch ( SQLException e )\n<\/p>\n

    {\n<\/p>\n

    System.out.println ( “[” +\n<\/p>\n

    DateFormat.getDateTimeInstance().format( new java.util.Date() ) + “] Connect FAIL!!” );\n<\/p>\n

    System.out.println( e );\n<\/p>\n

    Thread.sleep( 1000 );\n<\/p>\n

    continue;\n<\/p>\n

    }\n<\/p>\n

    try\n<\/p>\n

    {\n<\/p>\n

    stmt = conn.createStatement();\n<\/p>\n

    \/\/ResultSet rs = stmt.executeQuery( “select sid froM v$session” );\n<\/p>\n

    ResultSet rs = stmt.executeQuery(\n<\/p>\n

    ” select to_char(sysdate,’YYYY MM DD HH24:MI:SS’)|| ” +\n<\/p>\n

    ” ‘[‘||instance_name||’][‘||host_name||’]’ from v$instance ” );\n<\/p>\n

    rs.next();\n<\/p>\n

    System.out.println(rs.getString(1));\n<\/p>\n

    stmt.close();\n<\/p>\n

    Thread.sleep( 1000 ); \/\/ wait 1 second\n<\/p>\n

    }\n<\/p>\n

    catch ( SQLException e ) \/\/ SQL \uc218\ud589\uc911\uc5d0 Error\uac00 \ubc1c\uc0dd\ud558 \uac00 \ubc1c\uc0dd\ud558 \uba74 \ub2e4\uc2dc \uc811\uc18d\ud55c\ub2e4 \ud55c\ub2e4.\n<\/p>\n

    {\n<\/p>\n

    System.out.println ( “[” +\n<\/p>\n

    DateFormat.getDateTimeInstance().format( new java.util.Date() ) + “] Select FAIL!!” );\n<\/p>\n

    System.out.println( e );\n<\/p>\n

    conn = null;\n<\/p>\n

    }\n<\/p>\n

    }\n<\/p>\n

    }\n<\/p>\n

    }<\/p>\n

     <\/p><\/p>\n","protected":false},"excerpt":{"rendered":"

      TAF – Connection Failover options     \uc804\uc81c \uc0ac\ud56d : Oracle Server\ub294 RAC\ub85c \uad6c\uc131\ub418\uc5b4\uc57c \ud55c\ub2e4. OCI\ub97c \uc774\uc6a9\ud558\uc9c0 \uc54a\uc740 Application\uc740 TAF\ub97c \uc704\ud55c \ud2b9\ubcc4\ud55c \uae30\ub2a5\uc744 \uc81c\uacf5 \ud558\uc9c0 \uc54a\uc73c\uba70, \uac1c\ubc1c\uc790\uac00 Logic\uc744 \uad6c\ud604\ud574\uc57c \ud55c\ub2e4. TAF\ub97c \uc704\ud55c Server Configuration\uc740 \uc774 \ubb38\uc11c\uc5d0\uc11c \uace0\ub824\ud558\uc9c0 \uc54a\ub294\ub2e4. CONNECTION TIME FAIL OVER\ub294 \uc774 \ubb38\uc11c\uc5d0\uc11c \uace0\ub824\ud558\uc9c0 \uc54a\ub294\ub2e4. \uc704\uc758 \uc0ac\ud56d\ub4e4\uc744 \uc2dc\uac04\uc758 \uc5ec\uc720\uac00 \uc788\uc744 \uacbd\uc6b0\uc5d0\ub294 \uc791\uc131\ud55c\ub2e4.   […]<\/p>\n","protected":false},"author":1,"featured_media":1305,"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":[25],"tags":[736,737,738,739],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/1\/cfile1.uf.2353B33A56F3462408334B.png?fit=669%2C583&ssl=1","amp_enabled":true,"_links":{"self":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1304"}],"collection":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1304"}],"version-history":[{"count":0,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1304\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/1305"}],"wp:attachment":[{"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}