手动创建数据库时,将/opt/oracle/product/10.2.0/dbs/下的初始文件initGE02.ora中的语句local_listener=LISTENER_GE02释放出来
之后,关闭数据库然后重新启动数据库时,出现下面的错误:
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_GE02'
解决方法如下:
1、关闭数据库;
SQL> shutdown abort
ORACLE instance shut down.
2、然后在修改/opt/oracle/product/10.2.0/network/admin/tnsnames.ora文件,添加下面的语句:
LISTENER_GE02 =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
3、然后重新启动数据库
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 92276304 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.