ORA-12514: TNS:listener does not currently know of service requested in connect

chinadm123

不多说了，在大家看来是个超级初级的问题，请大家帮忙瞅一眼，下面晒症状：
环境：
[oracle@vmodg1 admin]$ uname -a
Linux vmodg1 2.6.32-200.13.1.el5uek #1 SMP Wed Jul 27 21:02:33 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
[oracle@vmodg1 admin]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 3 17:23:19 2013

[oracle@vmodg1 admin]$ sqlplus system/oracler@vmo_stby

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 3 17:19:52 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Enter user-name: ^C
[oracle@vmodg1 admin]$
[oracle@vmodg1 admin]$
[oracle@vmodg1 admin]$ more listener.ora
# listener.ora Network Configuration File: /g01/app/grid/product/11.2.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = vmodg1)(PORT = 1521))
    )
  )

#ADR_BASE_LISTENER = /g01/app/grid
ADR_BASE_LISTENER =/u01/app/oracle

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent
[oracle@vmodg1 admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

VMO =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = vmo-cluster-scan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = vmo)
    )
  )



VMOPM1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.30.112)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = vmo)
      (INSTANCE_NAME = vmo1)
    )
  )

VMO =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.30.222)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = vmo)
      (INSTANCE_NAME = vmo2)
    )
  )

VMO_STBY =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.30.123)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = vmo)
      (INSTANCE_NAME = vmo)
    )
  )
[oracle@vmodg1 admin]$

[oracle@vmodg1 admin]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 03-JUL-2013 17:17:31

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                03-JUL-2013 17:15:26
Uptime                    0 days 0 hr. 2 min. 5 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/vmodg1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vmodg1)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "vmo_stby" has 1 instance(s).
  Instance "vmo", status READY, has 1 handler(s) for this service...
The command completed successfully


[oracle@vmodg1 admin]$ tnsping vmo_stby

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 03-JUL-2013 17:24:05

Copyright (c) 1997, 2009, Oracle.  All rights reserved.

Used parameter files:
/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.30.123)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = vmo) (INSTANCE_NAME = vmo)))
OK (0 msec)
[oracle@vmodg1 admin]$

Maclean Liu(刘相兵

这个报错没问题
你 request 的service_name 是 vmo ， 但在listener 里只注册了vmo_stby的service_name

chinadm123

Maclean Liu(刘相兵 发表于 2013-7-3 21:44
这个报错没问题
你 request 的service_name 是 vmo ， 但在listener 里只注册了vmo_stby的service_name ...

刘大，弱弱的问下，您能不能具体点，需要改哪里？

chinadm123

SQL> show parameter name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
db_name                              string      vmo
db_unique_name                       string      vmo_stby
global_names                         boolean     FALSE
instance_name                        string      vmo
lock_name_space                      string
log_file_name_convert                string
service_names                        string      vmo_stby

Maclean Liu(刘相兵

request 的service_name 是 vmo ， 但在listener 里只注册了vmo_stby的service_name

还不够明确？

data guard安装请按照我的视频 不会遇到任何问题

  【Maclean 视频教学Oracle DataGuard】
  【Maclean Liu视频技术分享】11g ocm考纲复习Active Data Guard http://t.askmaclean.com/thread-2530-1-1.html