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