Sybase: Download Adaptive Server Enterprise 15.0.3 Developer’s Edition

Adaptive Server Enterprise 15.0.3 Developer’s Edition on Windows

    * ASE 15.0.3 Windows Server

 Adaptive Server Enterprise 15.0.3 Developer’s Edition on Linux

    * ASE 15.0.3 x86 Linux Server
    * ASE 15.0.3 x86 64 bit Linux Server
    * ASE 15.0.3 x86 64 bit Linux on POWER

For ASE 15.0.3 Quick Installation Guides click on the appropriate operation system.

    * ASE Quick Install Guide – Windows
    * ASE Quick Install Guide – Solaris
    * ASE Quick Install Guide – Linux

Create Oracle Database Link access SQL Server

Just finished a project: customer A use Oracle Database 10G, customer B user SQL Server 2005.
Need read SQL Server from Oracle Database.

Here is how:

Request: Microsoft Windows 32 bit OS
Memory Great than 2 Giga-Byte

1. First Download oracle for windows from
Oracle Database 10g Release 1 ( for Microsoft Windows

2. Download Oracle Database 10g Release 1 patch for Microsoft Windows
3. Uncompress files
4. Start Installation
5. “Oracle Transparent Gateway for Microsoft SQL Server” has to bee install

(Manual attached: b14270.pdf)

6. Create a Database for convert (SID name = ora)
7. Notice the “Database Character Set” to
8. Create a Listener for connection
9. Setup MS SQL Server (Host Name and Database Name)
10. create a user in SQL Server for Oracle connection (User Name: cyx Password:testora)
11. Create a user in Oracle Server for operation (User Name: cyx Password: cyx)
12. Setup 4 configure files:

tnsnames.ora /listener.ora /inittg4msql.ora /tg4msql_tx.sql
(Files attached)

13. Create Database Link in Oracle:

create database link msql connect to “cyx” identified by “testora” using ‘tg4msql’;

14. Create Mirror Table in Oracle:

create table t2008_test
select *
from t2008_geo@msql;

15. Export Mirror Talbe by using command “exp”:

set ORACLE_SID=ora
exp cyx/cyx file=test.dmp table=t2008_test

PS:For save some memory and 3 services has been set to Manual:
OracleCSService /OracleORACLE_HOMETNSListener /OracleServiceORA
Please start these 3 services before your operation.

For More info and screen shoot please left commit and let me know.

Debian: Add a new hard driver

With fast storage coast (movie,photo and music) I have to add an new 1.5TB hard driver on my Debian Home Server.

The server had a hard driver on /dev/sda already.

First shutdown the server:

# halt

Then add the hard driver with power and data cable.

Power on wait for the boot up then login as ROOT and input:

# fdisk /dev/sdb
n –create a new partition

Format a partition:
# mkfs -t ext3 -V /dev/sdb1

Create a mount directory:
# mkdir /home2

Mount it:
#mount -t ext3 /dev/sdb1 /home2

Automatic mount at start up:
# vi /etc/fstab
/dev/sdb1 /home2 ext3 defaults 0 2

CentOS: Config FTP server – vsftp service

On CentOS vsftp is the most pop FTP service, to install login as ROOT and input:

# yum -y install vsftpd db4-utils

To config vsftp service, update config file:/etc/vsftpd/vsftpd.conf

For virtual user use:

Set allow user list:
# vi /etc/vsftpd/user_list

# vi /etc/vsftpd/denied_users

# touch /etc/vsftpd/accounts.tmp
# mkdir /etc/vsftpd/users

Set up virtual user ftp owner account:
# useradd vftpuser -d /home/ftp -s /sbin/nologin

Set pam:
# vi /etc/pam.d/ftp
auth required /lib64/security/ db=/etc/vsftpd/accounts
account required /lib64/security/ db=/etc/vsftpd/accounts

Create user & password List file:
# vi /etc/vsftpd/accounts.tmp
testftp #username
test1234 #password

To create a new virtual user account’s access right:
# vi /etc/vsftpd/users/testftp

Create db file:
# /usr/bin/db_load -T -t hash -f /etc/vsftpd/accounts.tmp /etc/vsftpd/accounts.db
# chmod 600 /etc/vsftpd/accounts.db

Restart the service:
# service vsftpd restart

Set up iptable / firewall for PASV mode:
#vi /etc/sysconfig/iptables
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dport 64000:65535 -j ACCEPT

# service vsftpd restart
# service iptables restart

Set up SELinux:
# setsebool -P ftpd_disable_trans 1
# chcon -R -h -t public_content_t /home/ftp

CentOS: Install Samba and settings for file sharing

For sharing file in the home or company, I always recommended Samba.

To install Samba under CentOS:

# yum install samba

To start Samba service:

# /sbin/service smb restart

# chkconfig –levels 35 smb  on

To config Samba share folder:

# vi /etc/samba/smb.conf


load printers = No
hosts allow = 127., 192.168.0. #allow intranet IP
workgroup = WORKGROUP

comment = Private Home Directories
read only = No
browseable = No

comment = Public Stuff
path = /home/public
read only = No

path = /home/www
valid users = leo
read only = No
create mask = 0755
browseable = No

To test this conf file:

# testparm

# mkdir /home/public
# chmod -R 777 /home/public

Set up SELinux:

# setsebool -P samba_enable_home_dirs=1
# chcon -R -t samba_share_t /home/public

Setup a new Samba only account’s password:

# useradd “username” -d /home/”username” -s /sbin/nologin
# smbpasswd -a “username”

CentOS: Install MySQL Server

To install MySQL under CentOS, login as ROOT and input:

# yum install mysql-server

To start the service:

# service mysqld restart

Which will give some message:

To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password ‘new-password’
/usr/bin/mysqladmin -u root -h testserver1 password ‘new-password’

Use mysqladmin setup the password.

Alternatively you can run:

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

Set mysql service automatic start after reboot:

# chkconfig –levels 35 mysqld on

Set up mysql service port:

# /sbin/service mysqld stop
# vi /etc/my.cnf
modify: port=3306
/sbin/service mysqld start

To change mysql data directory:

# mkdir /home/mysql
# chown -R mysql:mysql /home/mysql
# chcon -R -h -t mysqld_db_t /home/mysql

# service mysqld stop
# mv /var/lib/mysql/* /home/mysql
# vi /etc/my.cnf


# vi /etc/init.d/mysqld

#get_mysql_option mysqld datadir “/var/lib/mysql”
get_mysql_option mysqld datadir “/home/mysql”

# service mysqld start

Check MySQL log file:

# cat /var/log/mysqld.log

Add a new remote user: