当前位置:网站首页>Oracle告警日志alert.log和跟踪trace文件中文乱码显示
Oracle告警日志alert.log和跟踪trace文件中文乱码显示
2022-04-23 13:51:00 【数语数行】
当设置NLS_LANG环境变量为“AMERICAN_AMERICA.ZHS16GBK”后,Oracle在告警日志和跟踪文件中都会写入中文字符信息。通过终端软件比如securecrt连接到服务器,查看数据库告警日志和跟踪文件时,可能会无法正常显示中文,出现乱码,如下所示:
ORA-01034: ORACLE ²»¿ÉÓÃ
ORA-01034: ORACLE ²»¿ÉÓÃ
ORA-01034: ORACLE ²»¿ÉÓÃ
ORA-01034: ORACLE ²»¿ÉÓÃ
ORACLE Instance orcl1, archival error, archiver continuing
ORA-16055: ÒѾܾø FAL ÇëÇó
ORA-16055: ÒѾܾø FAL ÇëÇó
Shutting down ORACLE instance (immediate) (OS id: 11050)
Starting ORACLE instance (normal) (OS id: 15061)
ORACLE_HOME: /u01/app/oracle/product/19.0.0/dbhome
ORACLE_BASE from environment = /u01/app/oracle
ORA-15183: ASMLIB ??? [driver/agent not installed]
ORA-00270: ´´½¨¹éµµÈÕÖ¾ ʱ³ö´í
ORA-00270: ´´½¨¹éµµÈÕÖ¾ ʱ³ö´í
ORA-00270: ´´½¨¹éµµÈÕÖ¾ ʱ³ö´í
这时,可以更改终端软件到服务器的连接的编码设置(Terminal->Appearance->Character encoding)为中文。
然后,重新使用该连接登录服务器,再次查看ORACLE日志时就可以正常显示中文,如下所示:
ORA-01034: ORACLE 不可用
ORA-01034: ORACLE 不可用
ORA-01034: ORACLE 不可用
ORA-01034: ORACLE 不可用
ORACLE Instance orcl1, archival error, archiver continuing
ORA-16055: 已拒绝 FAL 请求
ORA-16055: 已拒绝 FAL 请求
Shutting down ORACLE instance (immediate) (OS id: 11050)
Starting ORACLE instance (normal) (OS id: 15061)
ORACLE_HOME: /u01/app/oracle/product/19.0.0/dbhome
ORACLE_BASE from environment = /u01/app/oracle
ORA-15183: ASMLIB ??? [driver/agent not installed]
ORA-00270: 创建归档日志 时出错
ORA-00270: 创建归档日志 时出错
ORA-00270: 创建归档日志 时出错
或者,麻烦一点,将告警日志或跟踪文件scp或ftp下载到windows机器,然后使用文本编辑器查看日志。
版权声明
本文为[数语数行]所创,转载请带上原文链接,感谢
https://blog.csdn.net/jetliu05/article/details/124322150
边栏推荐
- Reading notes: Secure federated matrix factorization
- Function executes only the once function for the first time
- JS time to get this Monday and Sunday, judge the time is today, before and after today
- try --finally
- Oracle database combines the query result sets of multiple columns into one row
- Resolution: argument 'radius' is required to be an integer
- GDB的使用
- Apache Atlas Compilation and installation records
- Zero copy technology
- 【报名】TF54:工程师成长地图与卓越研发组织打造
猜你喜欢
初探 Lambda Powertools TypeScript
Express middleware ③ (custom Middleware)
Technologie zéro copie
Usereducer basic usage
Dynamic subset division problem
redis如何解决缓存雪崩、缓存击穿和缓存穿透问题
3300万IOPS、39微秒延迟、碳足迹认证,谁在认真搞事情?
低频量化之明日涨停预测
Using Baidu Intelligent Cloud face detection interface to achieve photo quality detection
Handling of high usage of Oracle undo
随机推荐
Double pointer instrument panel reading (I)
Dolphin scheduler source package Src tar. GZ decompression problem
Opening: identification of double pointer instrument panel
Leetcode | 38 appearance array
[code analysis (1)] communication efficient learning of deep networks from decentralized data
JS compares different elements in two arrays
UNIX final exam summary -- for direct Department
JS time to get this Monday and Sunday, judge the time is today, before and after today
Using Jupiter notebook in virtual environment
Publish custom plug-ins to local server
Core concepts of microservice architecture
Error 403 in most cases, you or one of your dependencies are requesting
Modify the Jupiter notebook style
Zero copy technology
Analysis of unused index columns caused by implicit conversion of timestamp
AttributeError: ‘dict‘ object has no attribute ‘iteritems‘
MySQL [acid + isolation level + redo log + undo log]
PG SQL intercepts the string to the specified character position
淘宝发布宝贝提示“您的消保保证金额度不足,已启动到期保障”
剑南春把文字游戏玩明白了