手动创建数据库时将/opt/oracle/product/10.2.0/dbs/下文件initGE02.ora中语句local_listener=LISTENER_GE02释放出来
的后关闭数据库然后重新启动数据库时出现下面:
SQL> startup
ORA-00119: invalid specication 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 Global Area 285212672 s
Fixed Size 1218992 s
Variable Size 92276304 s
Database Buffers 188743680 s
Redo Buffers 2973696 s
Database mounted.
Database opened.
最新评论