FOXHIS西软系统sybase提示通知空间不足处理方法
<p>各位酒店的电脑房经理有没有经历过在如下图这样的错误？有时候酒店的维护费没有到位或者时间急迫的时候我们需要自己的操作，操作步骤如下文所述。</p>
<p>
<img title="FOXHIS西软系统sybase提示通知空间不足处理方法" alt="FOXHIS西软系统sybase提示通知空间不足处理方法" src="https://zhuji.jb51.net/uploads/img/202305/bc7f2b742e4b5026168b7175c711011f.jpg"></p>
<p>
1. 第一步我们需要用sybase权限登录只foxhis的sybase数据库。</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_918306">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash functions">bash</code><code class="bash plain">-3.2$ </code><code class="bash functions">su</code> <code class="bash plain">sybase </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">password: </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash functions">bash</code><code class="bash plain">-3.2$</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
2. 查看当前已有的数据文件,打开一个终端窗口，输入命令.(一会新建设备数据文件时切记不要建同名的)</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_629287">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash comments"># cd /home/sybase/data </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash comments"># ls -ahl</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
3. 查看已经使用的vdevno<br>
a. 登录数据库。（得点击回车）</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_503726">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">-</code><code class="bash functions">bash</code><code class="bash plain">-3.2$ isql -usa</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
b.查看最大的vdevno（因为系统有限制，当你新建设备时，是不能超过这个设备数的，所以要先查看一下）</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_536626">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">sp_configure </code><code class="bash string">"number of devices"</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
c.查看当前已经使用的vdevno</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_985854">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">sp_helpdevice </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">go</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
注：上面检查每条记录的device_number，已经出现过的device_number不能在下面的添加设备操作中使用。</p>
<p>
4. 添加新设备<br>
注：由于扩展需要同事扩展数据文件空间和log文件空间，所以要要扩容必须同时新建两个设备</p>
<p>
a. 新建一个data保存空间</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterplain" id="highlighter_582442">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="plain plain">disk init name='dev11'</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
,physname='/home/sybase/data/dev11.dat'（这里跟进自身情况设置）,vdevno=11（设备号码跟进自身情况定义）,size=10240002> go<br>
b. 新建一个log保存空间</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterplain" id="highlighter_157815">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="plain plain">disk init name='dev12'</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
,physname='/home/sybase/data/dev12.dat'</p>
<p>
,vdevno=12</p>
<p>
,size=10240002> go</p>
<p>
5. 把数据库扩展到新设备上，操作如下</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterplain" id="highlighter_121257">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="plain plain">alter database foxhis on dev11=2048000 log on dev12=2048000 </code>
</div>
<div class="line number2 index1 alt1">
<code class="plain plain">go</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
</div>
<p>
注：dev11和dev12是刚刚你自己建出来的，当您操作的时候请根据实际自己的名称写上去。</p>
<p>
6. 检查foxhis数据库是否online</p>
<p>
online database foxhis</p>
<p>
结语：这样整个操作就完成，不需要依赖support帮您操作，同时自己也掌握一门技能，有问题请留意给我，本人有空的时候尽量解答。</p>
頁:
[1]