报错
如果配置监听没有问题了,但是连接时又出现ORA-00119问题:
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'
![](https://img2018.cnblogs.com/i-beta/1833466/202003/1833466-20200301222607335-642986809.png)
打开cmd,执行sqlplus进入sqlplus模式,输入用户名sys as sysdba,和sys的密码
先执行命令:
create pfile from spfile='D:appArcherproduct11.2.0dbhome_1databasespfileorcl.ora';
此时进入D:appArcherproduct11.2.0dbhome_1database目录下可以看到initorcl.ora文件,orcl为数据库名,如果没有看到这个文件,则再执行以下命令:
create spfile from pfile='D:appArcherproduct11.2.0dbhome_1databaseinitorcl.ora';
这是会生成这个文件,在进入文件将 *.local_listener='LISTENER_ORCL'修改为:
*.local_listener='(ADDRESS_LIST=(Address=(Protocol=tcp) (Host=your_hostname)(Port=1521)))'
再次执行命令:
create spfile from pfile='D:appArcherproduct11.2.0dbhome_1databaseinitorcl.ora';
此时打开spfileorcl.ora文件,会看到文件中添加了initorcl.ora中的一部分内容
![](https://img2018.cnblogs.com/i-beta/1833466/202003/1833466-20200301223151508-196613088.png)
![](https://img2018.cnblogs.com/i-beta/1833466/202003/1833466-20200301223238413-567524413.png)
![](https://img2018.cnblogs.com/i-beta/1833466/202003/1833466-20200301223410912-55608826.png)
![](https://img2018.cnblogs.com/i-beta/1833466/202003/1833466-20200301223522258-473088463.png)
执行starup命令成功
![](https://img2018.cnblogs.com/i-beta/1833466/202003/1833466-20200301223626888-1164801400.png)
然后进入数据库连接成功
![](https://img2018.cnblogs.com/i-beta/1833466/202003/1833466-20200301223651068-104795482.png)