oracle用户dbca命令截图如下:
日志如下:
WARNING: Error during db connection : ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
大意是监听不能被解释:
解决问题:
oracle 用户:
[oracle@11grac2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sun Feb 3 17:54:59 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL>
SQL> show parameter listener
NAME TYPE
VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string(DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=192.
168.2.53)(PORT=1521))))
remote_listener stringscan.rac.com:1521
SQL>
grid 用户:
[grid@11grac1 alert]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sun Feb 3 17:25:48 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> show parameter listener
NAME TYPE
VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string(DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=192.
168.2.52)(PORT=1521))))
remote_listener string
//发现remote_listener是空值
SQL> alter system set remote_listener='scan.rac.com:1521';
System altered.
SQL> show parameter listener
NAME TYPE
VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string(DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=192.
168.2.52)(PORT=1521))))
remote_listener stringscan.rac.com:1521