SQL> startup;
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ’LISTENER_ORCL’
----------------------------------------------------------------------------------
1、登录
sqlplus / as sysdba.
2、创建pfile文件(init<sid>.ora)
SQL>create pfile from spfile;
windows的系统在%oracle_home%的database目录下生成。(unix在dbs下)
3、修改pfile文件(init<sid>.ora)
local_listener='LISTENER_ORCL'
修改为:
local_listener='(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=hostname)(Port=1521)))'
保存,关闭。
4、创建spfile文件(spfile<sid>.ora)
SQL>create spfile from pfile;
-----------------------------------------------------------