当前位置:网站首页>Oracle alarm log alert Chinese trace and trace files

Oracle alarm log alert Chinese trace and trace files

2022-04-23 13:53:00 Number line language

When setting NLS_LANG The environment variable is “AMERICAN_AMERICA.ZHS16GBK” after ,Oracle Chinese character information will be written in the alarm log and trace file . Through terminal software, such as securecrt Connect to the server , When viewing the database alarm log and trace file , Chinese may not be displayed normally , Garbled , As shown below :
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: ´´½¨¹éµµÈÕÖ¾ ʱ³ö´í

At this time , You can change the coding setting of the connection between the terminal software and the server (Terminal->Appearance->Character encoding) In Chinese .
 Insert picture description here
then , Log in to the server again using this connection , Look again ORACLE When logging, you can normally display Chinese , As shown below :
ORA-01034: ORACLE Unavailable
ORA-01034: ORACLE Unavailable
ORA-01034: ORACLE Unavailable
ORA-01034: ORACLE Unavailable
ORACLE Instance orcl1, archival error, archiver continuing
ORA-16055: Rejected FAL request
ORA-16055: Rejected FAL request
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: Create archive log An error occurred when
ORA-00270: Create archive log An error occurred when
ORA-00270: Create archive log An error occurred when

perhaps , Please , Record the alarm log or trace file scp or ftp Download to windows machine , Then use a text editor to view the log .

版权声明
本文为[Number line language]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204231351026644.html