oracle关闭强制日志,oracle 服务自动关闭，日志信息如下，大神求解！

最新推荐文章于 2023-03-28 15:51:57 发布
最新推荐文章于 2023-03-28 15:51:57 发布
阅读量205 收藏
点赞数
文章标签： oracle关闭强制日志

以下是 oracle 的报错日志，日志是连续的

TNS-12518: Message 12518 not found; Error in reading message file for product=NETWORK, facility=TNS

TNS-12560: Message 12560 not found; Error in reading message file for product=NETWORK, facility=TNS

TNS-00530: Message 530 not found; Error in reading message file for product=NETWORK, facility=TNS

64-bit Windows Error: 1455: Unknown error

。。。。

TNS-12547: TNS: 丢失连接

。。。。

TNS-12518: TNS: 监听程序无法分发客户机连接

TNS-12560: TNS: 协议适配器错误

TNS-00530: 协议适配器错误

64-bit Windows Error: 203: Unknown error

人体疾病研究室
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Linux下Oracle归档日志自动清理脚本代码(sh)
09-10
本文将详细介绍如何利用提供的.sh脚本实现Linux下Oracle归档日志的自动清理，并解释脚本中的关键部分。 首先，我们需要创建一个.sh文件来存放脚本代码。这个脚本的目的是自动删除已过期或不再需要的归档日志，以...
oracle会自动关闭服务,ORACLE Listener服务自动关闭错误处理
weixin_29775447的博客
04-08 771
ORACLE Listener服务自动关闭错误处理。打开ORACLE中的NET MANAGER工具在监听程序中选中LISTENER查看一个配置是否正常，或删除这个LISTENER，重新配置一下故障排除直接 修改%ORACLE_HOME%\network\admin\listener.ora文件也可listener.ora配置# listener.ora Network Configuration ...
oracle总是自动关闭,数据库每天都自动关闭，请高手指点！
weixin_35192920的博客
04-07 758
还有：Fri Sep 28 03:59:16 2007SMON: about to recover undo segment 1SMON: mark undo segment 1 as needs recoverySMON: about to recover undo segment 2SMON: mark undo segment 2 as needs recoverySMON: about t...
oracle日志模式
最新发布
末点
03-28 1331
并不代表在dml操作中oracle不产生redo，只是对于指定表的更新数据不产生redo，但是 oracle还是要记录这些操作，所以无论怎么优化，dml操作肯定要产生redo，但是使用这些参数对redo size的影响还是非常可观的。c、单独使用append提示，对redo的产生影响很大，这是我到现在都不明白的道理，按说append是绕过freelists，直接去寻找新块，能减少对freelists的争用，为什么会少这么多redo呢？（1）、单一的使用nologging参数，对redo的产生没有什么影响。
oracle 如何关闭打开归档日志
12-16
在Oracle数据库管理中，归档日志是一种重要的数据保护机制，它记录了数据库事务日志在发生切换时的旧日志文件，以便在需要时用于恢复。归档日志模式和非归档日志模式是Oracle数据库两种不同的运行状态，它们在数据...
自动删除ORACLE归档日志文件
03-09
#功能：自动删除ORACLE归档日志文件 #删除方式：rman ，deletearchivelog #调用方式：可单独调用，或在job_clean_archivlog.sh脚本中根据需要调用见另外的附件） ##############################################
oracle的归档模式 ORACLE数据库归档日志常用命令
12-16
–连接恢复管理器 C:\Documents and Settings\mengzhaoliang>rman target/ –归档日志列表 RMAN> list archivelog all; –删除物理文件不存在的归档日志 RMAN> delete expired archivelog all; –删除7天前的归档...
当空间占用率高于60%时自动删除ORACLE归档日志文件
03-09
#功能：当空间占用率高于60%时自动删除ORACLE归档日志文件 # #删除方式：高于60%时使用rman+deletearchivelog，高于79%时使用武力删除 #调用方式：可单独调用，或配置定时任务自动执行脚本（会调用clean_archivelog....
ora10g客户端
03-21
ora10g客户端 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 17-SEP-2011 12:24:11 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 17-SEP-2011 12:24:12 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 18-SEP-2011 10:22:30 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 19-SEP-2011 10:20:57 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 20-SEP-2011 10:27:04 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 20-SEP-2011 11:50:33 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12505, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.200)(PORT=1521))(CONNECT_DATA=(SID=dba)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 27-OCT-2011 22:03:49 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: Message 12564 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12505, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.200)(PORT=1521))(CONNECT_DATA=(SID=dba)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 27-OCT-2011 22:04:07 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: Message 12564 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12505, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.200)(PORT=1521))(CONNECT_DATA=(SID=dba)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 29-OCT-2011 11:57:00 Tracing not turned on. Tns error struct: ns main err code: 12564 TNS-12564: Message 12564 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 0 nt secondary err code: 0 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 29-OCT-2011 11:57:30 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 29-OCT-2011 11:59:39 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0 *********************************************************************** Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oracleORCL)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=ORCL)(CID=(PROGRAM=D:\oracle\ora10g\sqlplus.exe)(HOST=X200)(USER=Andy)))) VERSION INFORMATION: TNS for 32-bit Windows: Version 10.2.0.5.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 10.2.0.5.0 - Production Time: 29-OCT-2011 11:59:43 Tracing not turned on. Tns error struct: ns main err code: 12560 TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS ns secondary err code: 0 nt main err code: 530 TNS-00530: Message 530 not found; No message file for product=NETWORK, facility=TNS nt secondary err code: 126 nt OS err code: 0
Oracle启动和停止的方式步骤
12-14
概述 　　只有具备sysdba和sysoper系统特权的用户才能启动和关闭数据库。 　　在启动数据库之前应该启动监听程序，否则不能利用命令方式来管理数据库，包括启动和关闭数据库。 　　虽然数据库正常运行，但如果没有启动监听程序，客户端不能连接到数据库。 　　在oracle用户下： 启动监听程序 lsnrctl start 关闭监听程序lsnrctl stop 　　查询监听程序状态lsnrctl status 　　startup 支持参数 　　STARTUP options | upgrade_options 　　options为：[FORCE] [RESTRICT] [PFIL
oracle关闭强制日志,关闭ORACLE客户端trace日志
weixin_32238157的博客
04-04 708
TRACE时的注意事项1、确保所需trace组建的配置文件存在缺省情况下，Oracle会从下列位置搜索网络配置文件a.TNS_ADMINenvironmentvariable(incl.WindowsRegistryKey)b./etcor/var/opt/oracle(Unix)c.$ORACLE_HOME/network/admin(Unix)d.%ORACLE_HOME%...
TNS-01106: Message 1106 not found; No message file for product=network, facility=TNS
热门推荐
Mr. David 专栏
04-26 3万+
lsnrctl start报错：TNS-01106: Message 1106 not found; No message file for product=network, facility=TNS  原因：ORACLE_HOME没有设置 方法： export ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1
oracle关闭强制日志,Oracle 如何关闭监听日志 | 信春哥，系统稳，闭眼上线不回滚！...
weixin_39778582的博客
04-04 330
前段时间，一套小型生产数据库，由于使用很多短连接，并且连接相当频繁，监听日志文件占用了大量的磁盘空间。检查日志内容，发现都是正常的连接，那么在不需要分析监听日志的情况下，可以直接关闭监听的日志输出，如果在需要通过监听日志来分析故障或解决问题时，再打开监听日志的输出。以下是默认情况下，监听的状态信息，以下信息来自测试数据库。Connecting to (DESCRIPTION=(ADDRESS=(P...
异常：Message 850 not found； No message file for product=network, facility=NL解决方案
mhx123456789的博客
05-30 511
异常：Message 850 not found; No message file for product=network, facility=NL解决方案
Message 850 not found; No message file for product=network, facility=NL
Sailiann的专栏
04-29 684
  用户juice登陆ssh 后切换用户 su oralce 使用命令启动 lsnrctl start  出现bash 不识别 查看环境变量 echo $PATH /usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/juice/bin     之后使用fin...
Message 1053 not found； No message file for product=network, facility=TNSTNS-12541:
qq_42952754的博客
11-26 3952
今天在公司安装Oracle，启动监听lsnrctl start的时候，发现报错如下 Copyright © 1991, 2009, Oracle. All rights reserved. Message 1070 not found; No message file for product=network,facility=TNSTNSLSNR for Linux: Version 11.2.0.1.0 - Production Message 459 not found; No message fi

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值