错误信息:
SQL> startup;
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name ’LISTENER_ORCL’
解决错误:
修改安装目录下的SPFILEORCL.ORA文件,如D:\app\Administrator\product\11.2.0\dbhome_2\database\dbs目录下,修改内容:
*.local_listener='LISTENER_ORCL' 修改成:*.local_listener='(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=WIN-COSDJDSFC4C)(Port=1521)))'
其中WIN-COSDJDSFC4C是机器名
(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=WIN-COSDJDSFC4C)(Port=1521)))为TNS中配置的地址