TAILIEUCHUNG - Oracle Database Administration for Microsoft SQL Server DBAs part 15

Oracle Database Administration for Microsoft SQL Server DBAs part 15 takes the administration topics with which the SQL Server DBA is familiar, translates them into Oracle terms, and then expands on Oracle functionality. Definitions and comparative terms run throughout the book so the SQL Server DBA can easily leverage existing knowledge. This Oracle Press guide also expands on some of the features in Oracle that do not match up directly with SQL Server, and looks at other processes often performed on an Oracle database that would not typically be a standard practice in SQL Server environments | 122 Oracle Database Administration for Microsoft SQL Server DBAs locations that can be centrally managed. All that is required on the client side is the information for the Oracle Internet Directory. For the connection to the Oracle Internet Directory to look up the location of the database an file is needed in the ORACLE_HOME network admin directory. Here is an example of an file DEFAULT_ADMIN_CONTEXT ou databases dc company1 dc com DIRECTORY_SERVICES 389 636 DIRECTORYSERVERTYPE OID The file has parameters for using the Oracle Internet Directory EZCONNECT easy connection naming method without and the default domain. There is also expiration time of the client connection and this can be used to trace client sessions. Here is a list of some of these parameters in a sample It will try these LDAP etc. connections in this order path first LDAP TNSNAMES EZCONNECT NTS allows oracle to use current Windows domain credentials to authenticate. If Oracle server is not configured for this errors will occur in setting NONE first will only disable the local support using Windows credentials NONE NTS These parameters can be uncommented to start the tracing TRACE_LEVEL_CLIENT 4 TRACE_FILE_CLIENT TRACE_DIRECTORY_CLEINT D oracle trace Time is specified in minutes for the expire time but this would be set on the database server 30 As seen with the NTS setting in this file the Windows domain credentials would be useful for defining externally authenticated users in the database and then setting AUTHENTICATION_SERVICES NTS will allow for passing the Windows credentials through to the database. Since the file is on both the client and server side there might be some parameters that are set for the server but these may still have an effect on the client. For

• Chứng chỉ quốc tế
• Học Oracle
• quản lý cơ sở dữ liệu
• luyện thi chứng chỉ quốc tế
• môi trường SQL Server
• cơ sở dữ liệu oracle
• Đề cương môn Chuyên đề Oracle
• Chuyên đề Oracle
• Quản trị cơ sở dữ liệu
• Biện pháp bảo vệ cơ sở dữ liệu
• Cấu trúc lưu trữ
• Tin học thực dụng
• Thực hành ORACLE 11g
• Lý thuyết ORACLE 11g
• Ngôn ngữ lập trình PL SQL
• Lập trình nâng cao với PL SQL
• Thư viện Java
• Topic Focused
• Multi document Summarization
• Approximate Oracle Score
• báo cáo khoa học
• mô hình ngôn ngữ
• xử lý ngôn ngữ tự nhiên