Initializing Sybase ASE 11.0.3.3 on Linux

After installing Sybase Adaptive Server Enterprise, you can initialize the server by following these steps.

First, su to the sybase user using the -l option.

su -l sybase

Run install/sybinit, a text-based installation program. When prompted, follow these instructions.

select 3. Configure a Server product
select 1. SQL Server
select 1. Configure a new Adaptive Server
type ctrl-a to accept the default server name

select 1. CONFIGURE SERVER'S INTERFACES FILE ENTRY
select 3. Add a new listener service
don't modify the default hostname/address
select 2. Port:
enter 4100
type ctrl-a to Accept and Continue
type y when prompted with Is this information correct?
type ctrl-a to Accept and Continue
type y when prompted with Write the changes to the interfaces file now?

select 2. MASTER DEVICE CONFIGURATION
type ctrl-a to Accept and Continue
Press to continue, ignoring all WARNING's.
select 3. SYBSYSTEMPROCS DATABASE CONFIGURATION
type ctrl-a to Accept and Continue

select 4. SET ERRORLOG LOCATION
type ctrl-a to Accept and Continue

select 5. CONFIGURE DEFAULT BACKUP SERVER
type ctrl-a to Accept and Continue

select 6. CONFIGURE LANGUAGES
type ctrl-a to Accept and Continue

select 7. CONFIGURE CHARACTER SETS
type ctrl-a to Accept and Continue

select 8. CONFIGURE SORT ORDER
type ctrl-a to Accept and Continue

select 9. CONFIGURE AUDITING
type ctrl-a to Accept and Continue

on the SYBASE SERVER CONFIGURATION screen, type ctrl-a to Accept and Continue
type y when prompted with Execute the Sybase Server Configuration now?
Press <return> to continue, ignoring all WARNING's.

If all goes well, you should see several Running task: and Task succeeded: messages. When you get a Configuration completed successfully message, press <return> to continue.

type ctrl-x to Exit Screen
type ctrl-x to Exit Screen
type ctrl-x to Exit Screen

Starting the Database at Boot Time

Replace /usr/local/sybase with whatever directory Sybase ASE is installed in.

#!/bin/sh

export SYBASE=/usr/local/sybase

export PATH=$PATH:$SYBASE/bin:$SYBASE/install

case "$1" in
        start)
                for i in `ls $SYBASE/install/RUN_*`
                do
                        su -c "startserver -f $i" sybase > /dev/null 2>&1;
                done
                ;;
        stop)
                kill `ps -efa | grep sybase | grep -v grep | awk '{print $2}'`
                ;;
        *)
                echo $"Usage: $0 {start|stop}"
                exit 1
esac

exit 0

Install this script and run it with the "start" option to start up the database. Running it with the "stop" option shuts the database down. To access a database, it must be running.

No comments:

Post a Comment