Shulou(Shulou.com)06/01 Report--

Today, when restoring a test database, use pfile to start the database instance after deleting the original library file, and keep reporting an error:

SQL > startup nomount pfile='?/dbs/test.txt'

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00130: invalid listener address'(ADDRESS= (PROTOCOL=TCP) (HOST=orcltest) (PORT=1521))'

A close examination of pfile reveals nothing related to LOCAL_LISTENER.

At the same time, although the host does not have a pmon process, the message is not normal when logging in through sq1plus

[oracle@orcltest dbs] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 31 12:19:54 2019

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

Connected.

SQL > shutdown abort

ORACLE instance shut down.

On closer inspection, it is found that lsnrctl status returns very slowly. So check the listening configuration file, and the hostname in the configuration file does not match the current hostname. Also, the hostname in / etc/hosts does not match the current hostname.

After modifying hosts and listener.ora, restart listening. Log in to the database through local authentication and then start to return to normal

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.