1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
|
<html>
<head>
<title>SQL Relay - Getting Started With Sybase - Initializing an 11.0.3.3 Server</title>
<link rel="stylesheet" href="../../css/styles.css">
</head>
<body>
<span class="heading1">Initializing an 11.0.3.3 Server</span><br>
<p>After installing Sybase Adaptive Server Enterprise, you can initialize the
server by following these steps.</p>
<p>First, <i>su</i> to the sybase user using the -l option.</p>
<blockquote>
<b>su -l sybase</b>
</blockquote>
<p>Run <b>install/sybinit</b>, a text-based installation program. When
prompted, follow these instructions.</p>
<blockquote>
select <b>3. Configure a Server product</b><br>
select <b>1. SQL Server</b><br>
select <b>1. Configure a new Adaptive Server</b><br>
type ctrl-a to accept the default server name<br>
<br>
select <b>1. CONFIGURE SERVER'S INTERFACES FILE ENTRY</b><br>
select <b>3. Add a new listener service</b><br>
don't modify the default hostname/address<br>
select <b>2. Port:</b><br>
enter 4100<br>
type ctrl-a to <b>Accept and Continue</b><br>
type y when prompted with <b>Is this information correct?</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
type y when prompted with <b>Write the changes to the interfaces file now?</b><br>
<br>
select <b>2. MASTER DEVICE CONFIGURATION</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
Press <return> to continue, ignoring all WARNING's.
<br>
select <b>3. SYBSYSTEMPROCS DATABASE CONFIGURATION</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
select <b>4. SET ERRORLOG LOCATION</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
select <b>5. CONFIGURE DEFAULT BACKUP SERVER</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
select <b>6. CONFIGURE LANGUAGES</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
select <b>7. CONFIGURE CHARACTER SETS</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
select <b>8. CONFIGURE SORT ORDER</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
select <b>9. CONFIGURE AUDITING</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
on the <b>SYBASE SERVER CONFIGURATION</b> screen, type ctrl-a to <b>Accept and Continue</b><br>
type y when prompted with <b>Execute the Sybase Server Configuration now?</b><br>
Press <return> to continue, ignoring all WARNING's.
<br>
</blockquote>
<p>If all goes well, you should see several <b>Running task:</b> and
<b>Task succeeded:</b> messages. When you get a <b>Configuration completed
successfully</b> message, press <return> to continue.</p>
<blockquote>
type ctrl-x to <b>Exit Screen</b><br>
type ctrl-x to <b>Exit Screen</b><br>
type ctrl-x to <b>Exit Screen</b><br>
</blockquote>
<span class="heading2">Starting the Database at Boot Time</span><br>
<p>Replace <i>/usr/local/sybase</i> with whatever directory Sybase ASE is
installed in.</p>
<blockquote>
<PRE>
<FONT color=#0000ff>#!/bin/sh</FONT>
<B><FONT color=#a62828>export </FONT></B><FONT color=#008a8e>SYBASE</FONT><B><FONT color=#a62828>=</FONT></B>/usr/local/sybase</FONT>
<B><FONT color=#a62828>export </FONT></B><FONT color=#008a8e>PATH</FONT><B><FONT color=#a62828>=</FONT></B><FONT color=#a620f7>$PATH</FONT>:<FONT color=#a620f7>$SYBASE</FONT>/bin:<FONT color=#a620f7>$SYBASE</FONT>/install
<B><FONT color=#a62828>case</FONT></B> "$1" <B><FONT color=#a62828>in</FONT></B>
start<B><FONT color=#a62828>)</FONT></B>
<B><FONT color=#a62828>for</FONT></B> i <B><FONT color=#a62828>in</FONT></B> <FONT color=#6959cf>`ls </FONT><FONT color=#a620f7>$SYBASE</FONT><FONT color=#6959cf>/install/RUN_*`</FONT>
<B><FONT color=#a62828>do</FONT></B>
su <B><FONT color=#a62828>-c</FONT></B> <B><FONT color=#a62828>"</FONT></B><FONT color=#ff00ff>startserver -f </FONT><FONT color=#a620f7>$i</FONT><B><FONT color=#a62828>"</FONT></B> sybase <B><FONT color=#a62828>></FONT></B> /dev/null <B><FONT color=#a62828>2>&1</FONT></B><B><FONT color=#a62828>;</FONT></B>
<B><FONT color=#a62828>done</FONT></B>
<B><FONT color=#a62828>;;</FONT></B>
stop<B><FONT color=#a62828>)</FONT></B>
<B><FONT color=#a62828>kill</FONT></B> <FONT color=#6959cf>`ps </FONT><FONT color=#6959cf>-efa</FONT><FONT color=#6959cf> </FONT><B><FONT color=#a62828>|</FONT></B><FONT color=#6959cf> grep sybase </FONT><B><FONT color=#a62828>|</FONT></B><FONT color=#6959cf> grep </FONT><FONT color=#6959cf>-v</FONT><FONT color=#6959cf> grep </FONT><B><FONT color=#a62828>|</FONT></B><FONT color=#6959cf> awk </FONT><B><FONT color=#a62828>'</FONT></B><FONT color=#ff00ff>{print $2}</FONT><B><FONT color=#a62828>'</FONT></B><FONT color=#6959cf>`</FONT>
<B><FONT color=#a62828>;;</FONT></B>
*<B><FONT color=#a62828>)</FONT></B>
<B><FONT color=#a62828>echo</FONT></B><FONT color=#ff00ff> $</FONT><B><FONT color=#a62828>"</FONT></B><FONT color=#ff00ff>Usage: </FONT><FONT color=#a620f7>$0</FONT><FONT color=#ff00ff> {start|stop}</FONT><B><FONT color=#a62828>"</FONT></B>
<B><FONT color=#a62828>exit</FONT></B> <FONT color=#ff00ff>1</FONT>
<B><FONT color=#a62828>esac</FONT></B>
<B><FONT color=#a62828>exit</FONT></B> <FONT color=#ff00ff>0</FONT>
</PRE>
</blockquote>
<p>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.</p>
</body>
</html>
|
