今天收到厂家反馈用户连接不上,问了下是通过主机名连还是ip,因为昨晚配合关闭数据库为了加了备份ip,开启时发现监听没成功提起,把listener.ora的内容里的HOST =主机名 都换成了ip,并把local_listener参数一同改了才正常,厂家确认是用ip连,就登上机器。
ORACLE Instance SZPQSYS - Archival Error
0RA-16Q14: log 1 sequence# 2551 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/data/SZPQSYS/redo0l.log'
Thu Feb 01 10:37:08 2018
Archiver process freed from errors. No longer stopped
Thu Feb 01 10:42:08 2018
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance SZPQSYS - Archival Error
0RA-16038: log 1 sequence# 2551 cannot be archived ORA-19504: failed co create file ""
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string location=/archive/SZPQSYS
原来是权限问题,把权限设置成 oradba:oinstall 就正常了
1)首先查看监听状态
$listener status
正常
2)尝试用同网段连入测试发现确实报错
想起昨晚还趁着重启顺便把归档开了,重新设置了三个库的归档目录,查看数据库日志,发现以下报错
Thu Feb 01 10:37:08 2018
ARCH: Archival stopped, error occurred. Will continue retryingORACLE Instance SZPQSYS - Archival Error
0RA-16Q14: log 1 sequence# 2551 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/data/SZPQSYS/redo0l.log'
Thu Feb 01 10:37:08 2018
Archiver process freed from errors. No longer stopped
Thu Feb 01 10:42:08 2018
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance SZPQSYS - Archival Error
0RA-16038: log 1 sequence# 2551 cannot be archived ORA-19504: failed co create file ""
ORA-00312: online log 1 thread 1: '/data/SZPQSYS/redo01.log'
3)查看参数设置,确认目录确实存在
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string location=/archive/SZPQSYS
但是发现三个库里的目录里面都没有归档日志
4)查看文件夹权限,没问题
drwxr-xr-x 5 oradba oinstall 4096 Jan 31 18:30 archive
5)再进去一层
$ cd /archive
$ ll
drwxr-xr-x 2 root root 6 Jan 31 18:30 orcl
drwxr-xr-x 2 root root 6 Jan 31 18:30 SZPQSYS
drwxr-xr-x 2 root root 6 Jan 31 18:30 VOLTAGE
原来是权限问题,把权限设置成 oradba:oinstall 就正常了