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

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

2.

EXECUTE dbms_logmnr_d.build('dictionary.ora','/u01/app/oracle/data'); --------------注意最后没有/

3.

ORA-01858: a non-numeric character was found where a numeric was expected

说明时间格式不对。

 select name from v$archived_log where dest_id=1 and first_time >=to_date('12-MAY-2020 16:39:55','yyyy-mm-dd hh24:mi:ss') and first_time <= to_date('12-MAY-2020 16:41:43','yyyy-mm-dd hh24:mi:ss');  ---------错误

select name from v$archived_log where dest_id=1 and first_time >=to_date('2020-MAY-12 16:39:55','yyyy-mm-dd hh24:mi:ss') and first_time <= to_date('2020-MAY-12 16:41:43','yyyy-mm-dd hh24:mi:ss');  -------正确

4.

[root@rac2 ~]# su - mysql
Last login: Fri Jun 12 13:45:51 CST 2020 on pts/4
su: warning: cannot change directory to /home/mysql: No such file or directory
-bash-4.2$

solution：

cp /etc/skel/.bashrc /home/mysql/

cp /etc/skel/.bash_profile /home/mysql

 5.修改linux主机名

vi /etc/hosts

vi /etc/syconfig/network

6.contos7修改网卡名

vi /etc/sysconfig/grub 

quit后面增加  net.ifnames=0 biosdevname=0

然后执行

grub2-mkconfig -o /boot/grub2/grub.cfg

然后修改网卡配置文件

vi /etc/sysconfig/network-scripts/ifcfg-***

mv /etc/sysconfig/network-scripts/ifcfg**

7.dbca出现小方框等乱码

export LANG=en_US.UTF-8

 8.清理目录

du -sh *

du -sm * | sort -n

9.怎么查看自己的oracle数据库是标准版还是企业版 ？

a.查看v$version视图

select * from v$version;

企业版有个enterprise。

b.查看v$option视图是否支持位图索引，不支持就是标准版

select * from v$option where parameter like '%Bit%'
Bit-mapped indexes      FALSE