日常遇到的一些简单问题汇总

1.oracle登录进去显示乱码

SQL*Plus: Release 11.2.0.4.0 Production on Tue May 12 16:30:00 2020

Copyright (c) 1982, 2013, Oracle. All rights reserved.

???:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> archive log list
??????? ????
???? ??
???? USE_DB_RECOVERY_FILE_DEST
????????? 7
????????? 10
?????? 10

解决办法：

环境变量增加：

export NLS_LANG="american_america.zhs16gbk" 

然后显示正常：

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 7
Next log sequence to archive 10
Current log sequence 10

原文：https://www.cnblogs.com/liang-ning/p/12877052.html