untitled

Transcription

1 Oracle on Windows etc Windows Server System Center / OTN Japan + Oracle Database.NET Developer Center / OTN Japan Oracle / OTN Japan 1

2 / Oracle on Windows 2 2

3 Oracle Direct Seminar <Insert Picture Here> Oracle Database.NET.NET

4 Oracle PeopleSoft JD Edwards Siebel 4

5 Agenda.NET Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000 Web Oracle Database Oracle Database 5

6 Oracle Oracle Oracle Enterprise Manager Microsoft Visual Studio PL/SQL SQL*PLUS, GUI TOOL, Oracle SQL Developer 6

7 7

8 Visual Studio + ODT Visual Studio + ODT Visual Studio Oracle 8

9 Visual Studio Oracle DB Oracle Developer Tools for Visual Studio.NET (ODT) Microsoft Visual Studio C++ / C# VB.NET (ASP/ASP.NET) MTS/COM IIS Oracle Database Extensions for.net (ODE.NET) Oracle Data Provider for.net (ODP.NET) Oracle Services for MTS 9

10 10

11 Agenda.NET Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000 Web Oracle Database Oracle Database 11

12 Microsoft OracleClient ODP.NET 2002 VS.NET , 2008.NET Framework 1.0 ADO.NET Oracle 12

13 ODP.NET Oracle.DataAccess 13

14 ODP.NET : Oracle Data Provider for.net 14

15 Microsoft MVP ODP.NET 15

16 ODP.NET 16

17 ODP.NET vs Microsoft OracleClient Performance 17

18 ODP.NET vs Microsoft OracleClient Security 18

19 ODP.NET vs Microsoft OracleClient High Availability and Scalability 19

20 ODP.NET vs Microsoft OracleClient Oracle Database Technology 20

21 ODP.NET vs Microsoft OracleClient Ease of Use and Developer Productivity 21

22 ODP.NET 22

23 ODP.NET 1 FetchSize 65,536 23

24 ODP.NET 2 1 Select * from emp DB 1 WEB DB 2 Select * from emp 2 WEB DB 24

25 ODP.NET 3 Client = Connection WEB DB Client > Connection WEB DB 25

26 ODP.NET 26

27 ODP.NET FetchSize 64KB FetchSize OracleCommand (DataSet 27

28 ODP.NET / BLOB BLOB Oracle Data Provider for.net 11.1 LOB Oracle 11g

29 ODP.NET OracleBulkCopy Oracle Oracle Oracle Data Provider for.net

30 ODP.NET 30

31 Oracle Database Result Cache Oracle Datatbase 11g 1.0 Inventory Orders Line Items Inventory Orders Line Items Back Orders Pick Lists Back Orders Pick Lists SQL 31

32 Oracle Database Result Cache SQL SGA A Select SGA SQL Select B 32

33 Oracle Database Result Cache alter system set RESULT_CACHE_MODE = 'FORCE'; MANUAL FORCE select /*+ result_cache */ first_name, last_name from employees RESULT_CACHE_MODE MANUAL SQL 33

34 ODP.NET SQL Where 34

35 ODAC ODP.NET ODP.NET SQL or PL/SQL Application (A) ODP.NET Cache ODP.NET Cache ) ODP.NET Cache 35

36 Oracle Database SecureFiles SecureFiles LOB Oracle 11g

37 Oracle Database SecureFiles STORE AS SECUREFILE SQL> SQL> CREATE TABLE TABLE t1 t1 (c1 (c1 CLOB) CLOB) 2 LOB LOB (c1) (c1) STORE STORE AS AS SECUREFILE ; BASICFILE (STORE AS ) BASICFILE SQL> SQL> CREATE TABLE TABLE t1 t1 (c1 (c1 CLOB) CLOB) 2 LOB LOB (c1) (c1) STORE STORE AS AS BASICFILE ; 37

38 LOB Oracle Database SecureFiles LOB 38

39 ODP.NET 39

40 Oracle Database ODP.NET Pooling=FALSE string no_pool = "User Id=hr; Password=hr; Data Source=oramag; Enlist=false; Pooling=false" Pooling=TRUE string with_pool = "User Id=hr; Password=hr; Data Source=oramag; Enlist=false; Pooling=true" Pooling TRUE 40

41 ODP.NET ONLY Oracle Database OS ConnectionString User Id / Windows DBA Privilege SYSDBA SYSOPER Oracle ODP.NET OS 41

42 Oracle Database Perfmon Windows Perfmon ODP.NET ODP.NET Oracle Data Provider for.net 42

43 ODP.NET 43

44 Active Directory + Oracle Database Active Directory tnsnames.ora Active Directory (11g) Single Sign On Windows Kerberos 44

45 Active Directory 45

46 Active Directory Overview Oracle tnsnames.ora Active Directory (11g) Windows AD User Oracle DB Configuration Assistant, Net Configuration Assistant and Net Manager 46

47 Active Directory Client OS Server OS AD OID Comments Windows Windows Yes Yes Windows Any Yes Yes Linux/Unix Any No Yes Tools for registering Net Service in AD must be run on Windows AD Integration solutions can help 47

48 Active Directory Configuration/Administration 1 Administrator Active Directory 変更 2 NetCA 録 Windows Environment 5 NetCA Directory Naming Directory Usage (AD) 3 NetCA Naming Context 4 - DBCA or Net Manager 録 Active Directory Repository of Database Names and Connect Descriptors Client Systems 48

49 Active Directory Run-time Repository of Database Names and Connect Descriptors 1 User Desktop 3 続 ActiveDirectory Active Directory Oracle Database 2 User 続 行 4 続 Oracle Database 続 (Any Platform) 49

50 Active Directory Summary 1. NetCA - Active Directory 変更 2. NetCA - Naming Context 3. DBCA (Net Manager) - Acitive Directory 録 4. NetCA - Directory Naming Directory Usage (AD) 5. SQLNET.ORA 11g client NAMES.LDAP_AUTHENTICATE_BIND=Yes To support pre-11g clients 1. anonymous bind in AD 2. ACLs for Oracle Naming Context Database/Net Services objects anonymous 変更 Oracle Database 11g for Microsoft Windows - 13 Microsoft Active Directory Oracle Database 50

51 Single Sign-On 51

52 Single Sign-On Authentication Client OS Server OS Comments Edition Windows Windows Windows MS KDC Enterprise User Security Kerberos Any Any EE and ASO option MS KDC Enterprise User Security 52

53 Windows Basics ORA_DBA: SYSDBA ORA_OPER: SYSOPER External user Oracle DB create user Sales frank identified externally; Windows groups can be used to assign roles (os_roles true ) create role sales identified externally; 53

54 Windows SCOTT Active Directory (Windows Windows Oracle AD Window EXAMPLE AD DB sqlplus EXAMPLE SCOTT Oracle RDBMS Windows Oracle ID/ 54

55 Windows 1 - User Desktop Active Directory/KDC 2 User Oracle 3 行 security tokens 5 Windows Group memberships 検索 (os_roles true ) 4 6 (based on os_roles) 55

56 Windows Configuration init.ora os_authent_prefix to sqlnet.authentication_services NTS sqlnet.ora (default ) os_roles to true init.ora Windows Group Membership for role authorization 56

57 .NET ODP.NET ONLY *1 *1: ConnectionString User Id / Windows DBA Privilege SYSDBA SYSOPER Oracle ODP.NET OS 57

58 Active Directory + Oracle Database Active Directory tnsnames.ora Active Directory Single Sign On Windows Kerberos Active Directory 58

59 Active Directory DB Run-Time Repository of Database Names and Connect Descriptors 3- ActiveDirectory Active Directory 1 - User Desktop Oracle Database 2 - User 4- Oracle Database (Any Platform) 59

60 Windows Native Run-Time 1 User Desktop Active Directory/KDC 2 User Oracle 3 security tokens 5 Windows Group memberships (os_roles true ) 4 6 (based on os_roles) 60

61 .NET tnsname.ora ODP.NET ONLY tnsnams.ora 61

62 .NET Proxy ODP.NET ONLY 62

63 .NET ODAC Oracle Providers for ASP.NET ASP.NET 2.0 Provider Web Web 63

64 .NET ODAC Oracle Providers for ASP.NET OracleMembershipProvider OracleRoleProvider 64

65 Agenda.NET Oracle Direct Concierge SQL Server MySQL PostgreSQL Access Oracle Database Oracle Developer/2000 Web Oracle Database Oracle Database 65

66 Visual Studio Automatic Database Diagnostic Monitor(ADDM) SQL Tuning Adviser ADDM / AWR ( ) SQL SQL 66

67 SQL Tuning Adviser 67

68 Oracle Performance Analyzer 68

69 .NET Oracle Database 69

70 70

71 Oracle Direct Seminar 100 Wendy !! a. b. c. d. a,b,c,d Oracle Direct 71

72 IT Oracle Direct Concierge BI IT BI Access / SQL Server MySQL / PostgreSQL Oracle Database Oracle Developer Web RFP BI Oracle Database Oracle Database 72

73 Oracle Direct Oracle Direct IT / Web ~ 9:00~12:00 13:00~18:00 73

74 74