PowerPoint -O80_PSO_AFO.PDF

Size: px

Start display at page:

Download "PowerPoint -O80_PSO_AFO.PDF"

ひさともくまじ
7 years ago
Views:

1 Oracle8 Core Tecnology Seminar ~ E: Oracle8 ~

3 Node1 Node2 Users Oracle8 Server Users tnsnames.ora

4 PL/SQL V8 OCI(Oracle Call Interface) KILL Shadow Process

5 SELECT SESSION NONE BASIC PRECONNECT SELECT SESSION SELECT NONE BASIC PRECONNECT

6 Client Instance1 Instance2 1 2TakeOver PRECONNECT

7 Users LISTENER tnsnames.ora SMON 2 Failover Architecture 2(SMON ORA-3113ORA-3114

8 DBA SVRMGR>SHUTDOWN TRANSACTIONAL DBA SVRMGR>ALTER SYSTEM DISCONNECT SESSION sid,serial# POST_TRANSACTION; SHUTDOWN IMMEDIATE

9 Why? ALTER SESSION 1 2

10 (cont d) sample sb4 callback_fn(svchp,envhp,fo_ctx,fo_type,fo_event) dvoid *svchp; dvoid *envhp; dvoid *fo_ctx; ub4 fo_type; ub4 fo_event; { switch (fo_event) { case OCI_FO_BEGIN: { printf( Failing Over... Please stand by n ); break; } case OCI_FO_END: { printf( Failover ended... ); } fo_event OCI_FO_BEGIN OCI_FO_END OCI_FO_ABORT OCI_FO_REAUTH

$OCI_FO_BEGIN: { printf( Failing Over.$

11 (cont d) sample int register_callback(srvhp,errhp) dvoid *srvhp; dvoid *errhp; { OCIFocbkStruct failover; failover.callback_function = &callback_fn; if (OCIAttrSet(srvhp,(ub4) OCI_HTYPE_SRV, (dvoid*) &failover,(ub4) 0, (ub4) OCI_ATTR_FOCBK,errhp)!=OCI_SUCCESS) return(2); return(0); }

callback_function = &callback_fn; if (OCIAttrSet(srvhp,(ub4)

12 Oracle8 Server EE R Node1 Node2 Users (OCI AP) Oracle8 Server Node1: Host testspi SID tog8036 Node2: Host testspi7 SID tog ,000 SELECT 5

13 dbname = tog803 : local_listener = (ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=testspi6)(PORT=1521)) event = trace name context forever, level 4 thread = 4 instance_number = 4 LISTENER.ORA LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL=tcp)(HOST=testspi6)(PORT=1521)) SID 1. LOCAL_LISTENER 2. LISTENER.ORA SID event

context forever, level 4 thread = 4 instance_number = 4 LISTENER.

14 Method=BASIC TNSNAMES.ORA conn_basic = (DESCRIPTION_LIST = (DESCRIPTION = ( ADDRESS = (PROTOCOL=tcp)(HOST=testspi6)(PORT=1521)) (CONNECT_DATA = (SID=tog8036)(SERVER=DEDICATED) (FAILOVER_MODE=(TYPE=select)(METHOD=basic)))) (DESCRIPTION = ( ADDRESS = (PROTOCOL=tcp)(HOST=testspi7)(PORT=1521)) (CONNECT_DATA = (SID=tog8037)(SERVER=DEDICATED) (FAILOVER_MODE=(TYPE=select)(METHOD=basic)))) )

(PROTOCOL=tcp)(HOST=testspi6)(PORT=1521)) (CONNECT_DATA = (SID=tog8036)(SERVER=DEDICATED)

15 Method=BASIC (cont d) NODE1 NODE2 GV$SESSION User INST_ID SERIAL# USERNAME FO_TYPE FO_METHOD FO O8NFEV SELECT BASIC NO INST_ID SERIAL# USERNAME FO_TYPE FO_METHOD FO O8NFEV SELECT BASIC YES NODE1 NODE1 NODE (*)INST_ID SERIAL# USERNAME Oracle (*)FAILOVER_TYPE (*)FAILOVER_METHOD (*)FAILED_OVER YES NO

------------ ------------ ------------ --- 5 37 O8NFEV SELECT BASIC YES NODE1 NODE1 NODE2 ----------------------------------

16 Method=PRECONNECT TNSNAMES.ORA conn_preconn = (DESCRIPTION = ( ADDRESS = (PROTOCOL=tcp)(HOST=testspi6)(PORT=1521)) (CONNECT_DATA = (SID=tog8036)(SERVER=DEDICATED) (FAILOVER_MODE=(TYPE=select)(METHOD=preconnect)(BACKUP=conn_bk)))) conn_bk = (DESCRIPTION = ( ADDRESS = (PROTOCOL=tcp)(HOST=testspi7)(PORT=1521)) (CONNECT_DATA = (SID=tog8037)(SERVER=DEDICATED)))

(CONNECT_DATA = (SID=tog8036)(SERVER=DEDICATED)

17 Method=PRECONNECT (cont d) NODE1 NODE2 Pre-Established GV$SESSION User INST_ID SERIAL# USERNAME FO_TYPE FO_METHOD FO O8NFEV SELECT PRECONNECT NO Primary 5 51 O8NFEV SELECT NONE NO Backup INST_ID SERIAL# USERNAME FO_TYPE FO_METHOD FO O8NFEV SELECT PRECONNECT YES NODE1 NODE2 NODE1 TakeOver)

NO Primary 5 51 O8NFEV SELECT NONE NO Backup INST_ID SERIAL# USERNAME FO_TYPE FO_METHOD FO --------

18 CPU Type=SELECT,Method=BASIC CPU

19 dbname = tog803 : mts_dispatchers = tcp,1 mts_max_dispatchers = 5 mts_servers = 1 mts_max_servers = 10 mts_service=fail_over mts_multiple_listeners = true mts_listener_address = (ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=testspi6)(PORT=1521)) mts_listener_address = (ADDRESS_LIST = (ADDRESS=(PROTOCOL=tcp)(HOST=testspi7)(PORT=1521)) thread = 4 instance_number = 4 MTS MTS_SERVICE SID DB_NAME

(ADDRESS=(PROTOCOL=tcp)(HOST=testspi6)(PORT=1521)) mts_listener_address = (ADDRESS_LIST =

20 (cont d) LISTENER.ORA LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL=tcp)(HOST=testspi6)(PORT=1521)) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (ORACLE_HOME=/home/tog803/app/oracle/product/8.0.3) (SID_NAME = tog8036) (SID_DESC = (ORACLE_HOME=/home/tog803/app/oracle/product/8.0.3) (SID_NAME = fail_over) )

21 Method=BASIC TNSNAMES.ORA conn_basic conn_basic = (DESCRIPTION = (ADDRESS_LIST = (( ADDRESS ADDRESS = (PROTOCOL=tcp)(HOST=testspi6)(PORT=1521)) (( ADDRESS ADDRESS = (PROTOCOL=tcp)(HOST=testspi7)(PORT=1521))) (CONNECT_DATA = (SID=fail_over)(SERVER=SHARED) (FAILOVER_MODE=(TYPE=select)(METHOD=basic))) ))

22 Method=PRECONNECT TNSNAMES.ORA conn_preconn = (DESCRIPTION = (ADDRESS_LIST = ( ADDRESS = (PROTOCOL=tcp)(HOST=testspi6)(PORT=1521))) (CONNECT_DATA = (SID=fail_over)(SERVER=SHARED) (FAILOVER_MODE=(TYPE=select)(METHOD=preconnect)(BACKUP=conn_bk)))) conn_bk = (DESCRIPTION = ( ADDRESS = (PROTOCOL=tcp)(HOST=testspi7)(PORT=1521)) (CONNECT_DATA = (SID=tog8037)(SERVER=SHARED)))

23 Shutdown Transactional DBA SVRMGR>SHUTDOWN TRANSACTIONAL NODE1 NODE2 Update User1 Commit Shutdown User1 2 User1 Tips

24 SVRMGR>ALTER SYSTEM DISCONNECT SESSION sid,serial# POST_TRANSACTION; NODE1 NODE2 2 Alter System.. Post_transaction Oracle8 Server Tips: SID,SERIAL# OS SID,SERIAL# SQL> SELECT SID,SERIAL#,USERNAME FROM V$SESSION 2>WHERE PROCESS= ; SID SERIAL# USERNAME SYSTEM

25 Type=SESSION NODE1 NODE2 User NODE1 NODE1 NODE2

26 NODE1 NODE2 NODE3 Coord Query Slave0 Slave1 Slave3 ORA PQ Oracle8 Server PQORA-12805

27 NODE1 NODE2 Select User1 Select Update 3600 Table User1 User2 Select User

28 PL/SQL NODE1 NODE2 PL/SQL Block ORA- Oracle8 Server ORA PL/SQL ORA-25408

29 SELECT empno, ename From emp; Client SELECT empno, ename From emp; empno name empno name 7369 smith 7369 smith 7499 allen 7521 ward Instance1 Instance allen 7521 ward 7566 jones 7566 jones 7654 martin 7654 martin 7698 scott 7698 scott 7782 clark 7782 clark

30 (cont d) NODE1 NODE2 NODE1 NODE2 5 rows. 19,990 rows Oracle8 Server Oracle8 Server

31 Method=BASIC

32 V8 OCI DBA Callback

橡ExCtrlPDF.PDF

橡ExCtrlPDF.PDF THE Database FOR Network Computing Oracle Oracle Oracle Oracle Oracle Oracle (Oracle Object for OLE Oracle Developer) SQL Oracle8 Enterprise Edition R8.0.5 for Windows NT Oracle8 Enterprise Edition R8.0.5