oracle19c常见异常问题处理

1、The listener supports no service

原因分析：数据库监听未启动，而先启动了数据库实例

已排查：listener.ora中已添加监听信息

解决方法：

方法1）重新注册监听

--sqlplus / as sysdba进入数据库，依次执行以下命令

alter system register;

alter system register;

alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=具体ip)(PORT=3030))))' scope=both;

alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.100.222.113)(PORT=3030))))' scope=both;

检查监听是否恢复

ho lsnrctl status;

方法2）重启按顺序启动数据库

--sqlplus / as sysdba 进入数据库，依次执行以下命令

shutdown immediate;

startup;

ho lsnrctl start;

shutdown immediate;

startup;

ho lsnrctl start;

检查监听是否恢复

ho lsnrctl status;

2、ORA-65054: Cannot open a pluggable database in the desired mode

或者ORA-01219：database or pluggable not open:queries allowed in fixed tables or views only

原因分析：种子数据库数据库的实例未打开，执行打开插拔的数据库实例时不能启动

已排查：show pdbs查看数据库状态是mount

sqlplus / as sysdba   -进入数据库
--先启动容器，种子数据库
shutdown immediate
startup
--再启动具体数据库
show pdbs--查看数据库名
alter session set container=nftdb;
alter plugggable database nftdb open;

shutdown immediate;
startup;
alter session set container=nftdb;
alter plugggable database nftdb open;