IT Certification 考試資訊

分类： Sybase

  • Sybex OCP: Oracle 10g New Features for Administrators Exam Guide 電子書分享

    OCP  Oracle 10g New Features for Administrators Study Guide

    111.jpg

    Here’s the book you need to prepare for Oracle’s 10g upgrade exam, Oracle Database 10g: New Features for Administrators (1Z0-043). This Study Guide was developed to meet the exacting requirements of today’s Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the “Best Study Guide” selection in CertCities Readers Choice Awards for two consecutive years, this book provides:

    * Clear and concise information on the enhancements included in Oracle 10g
    * Practical examples and insights drawn from the authors’ real-world experiences
    * Leading-edge exam preparation software, including a test engine and electronic flashcards

    You’ll also find authoritative coverage of key exam topics, including:
    * Installing and Configuring the Server
    * Loading and Unloading Data
    * Tuning Applications
    * Supporting Analytical Applications
    * Backing Up and Recovering Data
    * Automating Data Storage Management
    * Applying Security Policies
    * Supporting Upgrade Paths to Oracle 10g

    Look to Sybex for the knowledge and skills needed to succeed in today’s competitive IT marketplace.

    Contents at a Glance
    Chapter 1 Installing and Upgrading to Oracle 10g
    Chapter 2 Moving Data and Managing the Scheduler
    Chapter 3 Automating Management
    Chapter 4 General Storage Management
    Chapter 5 Automated Storage Management
    Chapter 6 Performance and Application Tuning
    Chapter 7 Backup, Recovery, and High Availability
    Chapter 8 Security and SQL Enhancements
    Appendix A SQL*Plus Enhancements
    Appendix B  New and Obsolete Initialization Parameters
    Appendix C  PL/SQL Enhancements and New Packages
    Index

    Download Now! Oracle 10g New Features for Administrators Exam Guide

  • 八步精通Oracle訪問Sybase數據庫

    配置TRANSPARENT GATEWAY FOR Sybase步驟：
    　　1． Oracle所在服務器上安裝Sybase client（或者在同一台server上安裝Oracle、Sybase服務器），確保能夠訪問Sybase數據庫；
    　　2．安裝TRANSPARENT GATEWAY FOR Sybase選件，要用自定義安裝。正確選擇Sybase的安裝目錄；
    　　3．選擇一個sid字符串準備賦給Sybase數據庫。如：tg4sybs設置Sybase的dll路徑到環境變量PATH（這一步很重要）；
    　　4．修改初始化文件，默認的是：
    　　Oracle_HOME\tg4sybs\admin\inittg4sybs.ora
    　　設置參數
    　　HS_FDS_CONNECT_INFO
    　　格式：
    HS_FDS_CONNECT_INFO= server_name. database_name[，INTER interface_file]
    server_name. database_name是大小寫敏感的。
    　　INTERFACE可選
    　　例子：如下
    # This is a sample agent init file that contains the HS parameters that are# needed
    for the Transparent Gateway for Sybase## HS init parameters#HS_FDS_CONNECT_INFO=migration_serv.taxHS_FDS_TRACE_LEVEL=
                OFFHS_FDS_RECOVERY_ACCOUNT=RECOVERHS_FDS_RECOVERY_PWD=RECOVER
    ## Environment variables required for Sybase#set SYBASE=d:\sybase

    　　上例中
    　　server_name是migration_serv
    　　database_name是tax
    　　5．配置oracle網絡服務的listener，配置文件是：listener.ora
    　　默認路徑：ORACLE_HOME\network\admin
    　　加入如下：
    SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME= gateway_sid)
    (ORACLE_HOME= oracle_home_directory)(PROGRAM=tg4sybs)))

    gateway_sid就是3選擇的sid字符串
    　　oracle_home_directory是ORACLE_HOME
    　　tg4sybs若是SYBASE是特定的。如果是其他數據庫，會不同。
    　　例子如下：
    (SID_DESC=(SID_NAME=tg4sybs)
    (ORACLE_HOME = D:\oracle\ora92)(PROGRAM=tg4sybs))

    　　6．停止監聽
    　　lsnrctl stop
    　　重新啟動監聽程序
    　　lsnrctl start
    　　7．配置oracle server的tnsnames.ora使其能夠訪問sybase
    connect_descriptor=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
    (HOST= host_name)(PORT= port_number))
    (CONNECT_DATA=(SID= gateway_sid))(HS=OK))

    connect_descriptor是連接串，任取，一般為sybs
    　　host_name：oracle server的name
    　　port_number：oracle監聽端口
    　　gateway_sid就是3選擇的sid字符串
    　　例子如下：
    sybs=(DESCRIPTION=(ADDRESS_LIST =(ADDRESS=(PROTOCOL=TCP)
    (HOST= dw-server1)(PORT= 1521)))
    (CONNECT_DATA=(SID= tg4sybs))(HS=OK))

    　　8．建立database link
    　　如：
    CREATE DATABASE LINK sybs CONNECT TO sa IDENTIFIED BY prient USING ‘SBYS’ ；
    　　即可訪問sybase 數據庫。
    需要注意的是，sybase數據庫的表名，字段名，如果是小寫的，那麼在oracle裡訪問的時候要加上雙引號””
    　　如：
    SQL〉select “a” from “b”@sybs;