ORACLE服务停了。

xianlongz 2017-03-18 10:28:38

小弟刚刚学Oracle，遇到这样问题。

今天回公司，发现网站无法连接资料库。
检查下，发现Oracle已停了。

小弟使用以下指令来重新开启

sqlplus /nolog

connect /as sysdba

SQL> startup

SQL> exit

LSNRCTL> start

开启了Oracle。
不过小弟想检查下日志，看看Oracle为何停了。是有人把它停了或受到什么影响。。。

请问各位前辈小弟该如何询查。（小弟是新手，很多还不懂）
谢谢。

...全文

350 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

qq_28538637 2017-06-22

打赏
举报

TNS-12502 错误一般是由客户端tnsnames.ora中没有包含CONNECT_DATA导致。检查你的tnsnames.ora 文件

xianlongz 2017-03-20

打赏
举报

<msg time='2017-03-17T16:28:39.352+07:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='DB01'
 host_addr='127.0.0.1'>
 <txt>17-MAR-2017 16:28:39 * 12502
 </txt>
</msg>
<msg time='2017-03-17T16:28:39.352+07:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='DB01'
 host_addr='127.0.0.1'>
 <txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
 </txt>
</msg>
<msg time='2017-03-17T16:31:39.351+07:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='DB01'
 host_addr='127.0.0.1'>
 <txt>17-MAR-2017 16:31:39 * 12502
 </txt>
</msg>
<msg time='2017-03-17T16:31:39.351+07:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='DB01'
 host_addr='127.0.0.1'>
 <txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
 </txt>
</msg>
<msg time='2017-03-17T16:34:39.372+07:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='DB01'
 host_addr='127.0.0.1'>
 <txt>17-MAR-2017 16:34:39 * 12502
 </txt>
</msg>
<msg time='2017-03-17T16:34:39.372+07:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='DB01'
 host_addr='127.0.0.1'>
 <txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
 </txt>
</msg>
<msg time='2017-03-17T16:37:39.372+07:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='DB01'
 host_addr='127.0.0.1'>
 <txt>17-MAR-2017 16:37:39 * 12502
 </txt>
</msg>
<msg time='2017-03-17T16:37:39.372+07:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='DB01'
 host_addr='127.0.0.1'>
 <txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
 </txt>
</msg>
<msg time='2017-03-17T16:40:39.378+07:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='DB01'
 host_addr='127.0.0.1'>
 <txt>17-MAR-2017 16:40:39 * 12502
 </txt>
</msg>
<msg time='2017-03-17T16:40:39.378+07:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='DB01'
 host_addr='127.0.0.1'>
 <txt>TNS-12502: TNS:listener received no CONNECT_DATA from client
 </txt>
</msg>

这是alert Log 请前辈帮帮忙