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
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
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.
