Use Sybase 11.0.3.3 in FreeBSD environments

Source: Internet
Author: User
Tags sybase
First, preparatory work

First step: Adjust kernel parameters

If your FreeBSD is missing, in order to run Sybase11.0.3.3 under FreeBSD, chances are you
Recompile your own kernel. This is because by default, the maximum memory space that the core provides to Linux does not
Meet the needs of running Sybase. The first time I install the process found that the configuration finished SQL
Server failed to start and viewed the installation log:

00:2001/01/08 09:41:28.02 kernel Max fd 1064 exceeds internal limit of 1024

00:2001/01/08 09:41:28.18 Kernel Using config area from primary master device.

00:2001/01/08 09:41:28.18 kernel Configuration error:configuration file,
'/usr/opt/sybase/sybase/sybase.cfg ', does not exist.

00:2001/01/08 09:41:28.19 Kernel warning:a configuration file is not specified and
The default file '/usr/opt/sybase/sybase/sybase.cfg ' does not exist.
SQL Server creates the default file with the default configuration.

00:2001/01/08 09:41:28.19 kernel Os_create_region:can ' t allocate 11665408

00:2001/01/08 09:41:28.19 kernel kbcreate:couldn ' t create kernel region.

00:2001/01/08 09:41:28.19 kernel kistartup:could not create shared memory

Obviously: the current kernel cannot allocate enough memory to start the SQL Server, so adjust the core parameters.

The following starts with adjusting the FreeBSD core parameters:

# Cd/usr/src/sys/i386/config

# VI Mykernel (my core name is Mykernel, you should edit generic this file)

Where to join:

Options shmmaxpgs=200000

Options shmmni=100

Options shmseg=10

Options semmns=200

Options semmni=70

Options semmsl=61

Disk exit

#/usr/sbin/config Mykernel

#cd. /.. /compile/mykernel

# make Depend

#make

#make Install

OK completes the core compilation and installation.

Reboot the machine, if you compile the core cannot, when prompted, type:

Kernel.old

You can also start your FreeBSD system again with the old core.

  

Step two: Install Linux support

Sybase's operation under FreeBSD is actually dependent on FreeBSD's emulation of Linux. As before
Like Oracle in Linux running SCO environments. So first you have to install a Linux emulation environment for FreeBSD.

Install the Linux_base package below:

The installation package can be found on the FreeBSD installation CD:

#mount –t Iso9660/dev/acd0c/cdrom

# cd/cdrom/packages

# CD Linux_base

#pkg_add linux_base6.1.tgz

It takes about 10 minutes to install a lot of packages.

If you do not have a CD, you can also install Linux support directly via port

The method is as follows:

Log in as root:

# cd/usr/port/emulators

# CD Linux_base

#make Install

The installer will automatically download the required software from the network, verify the package, and finalize the installation

This installation requires your computer to be able to access a router or gateway via dial-up Internet or FreeBSD host on the LAN that can
Connected to the Internet.

  

Log in as root, load Linux core module, start Linux support

# Linux or

# Kldload Linux

View the core modules to ensure that the Linux core modules have been successfully loaded:

#kldstat

Show:

Id Refs Address Size Name

1 2 0xc0100000 1B1C60 kernel

2 1 0xc0a9c000 10000 Linux.ko

Line 2nd indicates that the load was successful.

Now that the preparation is complete, the following is officially installed.

  

Third, download software and decompression

To the Sybase site to download the latest sybase-ase-11.0.3.3 update package, Sybase has made several improvements to this version,
A package designed for FreeBSD is currently available, including the following three files:

Sybase-ase-11_0_3_3-freebsd-6_i386.tgz

Sybase-doc-11_0_3_3-freebsd-6_i386.tgz

Sybase-ocsd-10_0_4-freebsd-6_i386.tgz

You can see that this is the 6th time this version has been updated.

  

Log on to FreeBSD host with Root to increase user Sybase

#adduser

Add a Sybase user as prompted and add one Sybase group user.

  

1. Copy the downloaded packages to the/opt/sybase directory

# CD Sybase

Log in with Sybase user to extract the above three compressed files:

$ gunzip–c sybase-ase-11_0_3_3-freebsd-6_i386.tgz | Tar vxpf–

$ gunzip–c sybase-doc-11_0_3_3-freebsd-6_i386.tgz | Tar vxpf–

$ gunzip–c sybase-oscd-10_0_4-freebsd-6_i386.tgz | Tar vxpf–

After the decompression is complete, the following starts configuring the SQL Server.

  

2. Configure the database server

 

Log on to FreeBSD host with Sybase user

$ CD Sybase

$ cd Install

$./sysinit

The following screen appears:

  

Sybinit

  

1. Release directory:/opt/sybase

2. Edit/view Interfaces File

3. Configure a Server product

4. Configure an Open client/server product

  

Ctrl-a Accept and Continue, ctrl-x Exit screen,? Help.

Enter the number of your choice and press RETURN:

After you select 3: The following prompts appear:

  

CONFIGURE SERVER Products

Products:

  

Product Date Installed date configured

1. SQL Server Mar 22 2000 21:22

2. Backup Server Mar 22 2000 21:22

   

  

Ctrl-a Accept and Continue, ctrl-x Exit screen,? Help.

Enter the number of your choice and press Return:1

When you select 1, you receive a prompt:

  

EXISTING SYBASE SERVER

1. Configure A new adaptive Server

2. Configure an existing Sybase Server

3. Upgrade an existing Sybase Server

  

  

Ctrl-a Accept and Continue, ctrl-x Exit screen,? Help.

Enter the number of your choice and press Return:1

Select 1

ADD NEW Adaptive SERVER

1. Adaptive Server name:sybase

   

Ctrl-a Accept and Continue, ctrl-x Exit screen,? Help.

Enter the number of your choice and press Return:1

If you want to change the adaptive Server
The name, choose 1, type the name you want to use, after completing using Ctrl-a to accept the current configuration, the following prompts,
To start a specific configuration of the server:

SYBASE SERVER CONFIGURATION

  

1. CONFIGURE SERVER ' S interfaces FILE ENTRY incomplete

2. MASTER DEVICE CONFIGURATION Incomplete

3. Sybsystemprocs DATABASE CONFIGURATION Incomplete

4. SET ERRORLOG LOCATION Incomplete

5. CONFIGURE DEFAULT BACKUP SERVER Incomplete

6. CONFIGURE LANGUAGES Incomplete

7. CONFIGURE CHARACTER SETS Incomplete

8. CONFIGURE SORT Order Incomplete

9. CONFIGURE Auditing Incomplete

  

  

  

Ctrl-a Accept and Continue, ctrl-x Exit screen,? Help.

Enter the number of your choice and press RETURN:

Select 1~9 items to configure the above 9 items.

For example, the 1th item, after the configuration is complete, appears as follows:

SERVER Interfaces FILE ENTRY screen

  

Server Name:sybase

  

1. Retry count:0

2. Retry delay:0

3. ADD A new listener service

Modify or delete a service

Listener Services available:

  

Protocol address Port Name Alias

4. TCP FreeBSD 7100 syb1103

   

Ctrl-a Accept and Continue, ctrl-x Exit screen,? Help.

Enter the number of your choice and press RETURN:

After configuring the full part 1~9 entry, the results are as follows:

  

SYBASE SERVER CONFIGURATION

1. CONFIGURE SERVER ' S interfaces FILE ENTRY Complete

2. MASTER DEVICE CONFIGURATION Complete

3. Sybsystemprocs DATABASE CONFIGURATION Complete

4. SET ERRORLOG LOCATION Complete

5. CONFIGURE DEFAULT BACKUP SERVER Complete

6. CONFIGURE LANGUAGES Complete

7. CONFIGURE CHARACTER SETS Complete

8. CONFIGURE SORT Order Complete

9. CONFIGURE Auditing Complete

  

Ctrl-a Accept and Continue, ctrl-x Exit screen,? Help.

Enter the number of your choice and press RETURN:

After selecting Ctrl-a, the following warning appears:

WARNING: '/home/sybase/master.dat ' is a regular file which are not recommended
For a Server device.

Press to continue.

This is because the database we are using is not placed directly on the raw device, but it uses the operating system mask
Under the file system, no relationship, direct return can. It is said that installation in sybase-11.0.3.3 added to the raw
The support of the equipment, interested friends can try it on their own. The above server configuration is complete.

The following is a detailed procedure for configuring a backup server (abbreviated) see the author another sybase11.0.3.3 installation under Linux.

Iv. Use of data

Log in to the database first:

$ isql–usa–p

>

Indicates that the connection database is successful and the database can be used normally in the future.

If you cannot connect, confirm that the Sybase environment variable is set or set to an error

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.