ORA-12154 不能连接服务 很是着急 - Oracle数据库管理 - ITPUB...

来自 : ITPUB 发布时间：2021-03-25

LSNRCTL status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbserver1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 11-JAN-2013 02:21:37
Uptime 0 days 0 hr. 10 min. 5 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dbserver1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service procdb has 1 instance(s).
Instance procdb , status READY, has 1 handler(s) for this service...
Service procdbXDB has 1 instance(s).
Instance procdb , status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL service
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbserver1)(PORT=1521)))
Services Summary...
Service procdb has 1 instance(s).
Instance procdb , status READY, has 1 handler(s) for this service...
Handler(s):
DEDICATED established:0 refused:0 state:ready
LOCAL SERVER
Service procdbXDB has 1 instance(s).
Instance procdb , status READY, has 1 handler(s) for this service...
Handler(s):
D000 established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER machine: dbserver1, pid: 3939
(ADDRESS=(PROTOCOL=tcp)(HOST=dbserver1)(PORT=56512))
The command completed successfully
SERVER B
[oracle@dbserver1 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
PROCDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.127)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = procdb)
)
)
之后再SERVER B 上操作
[oracle@dbserver1 admin]$ rmantarget user_name/password@procdb
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jan 11 10:25:39 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-12154: TNS:could not resolve the connect identifier specified
[oracle@dbserver1 bin]$ tnsping 192.168.100.127
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 11-JAN-2013 10:34:36
Copyright (c) 1997, 2011, Oracle.All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.127)(PORT=1521)))
OK (10 msec)
请大家看看问题出在哪里呢？ 很是着急