ORA-12505 TNS:listener does not currently know of SID given in connect

本文记录了一次在配置Oracle应用程序过程中遇到的SID连接错误问题。错误出现在执行adgendbc.sh脚本时，具体表现为监听器未能识别指定的服务名标识符(SID)，导致无法建立数据库连接。文章还提及了尝试连接到szxfa101db01.huawei.com上的erptest实例失败的情况。

1. 克隆报错信息如下：

[applerp@szxfa101ap01-ehr01 bin]$ vi /data01/applerp/inst/apps/erptest1_szxfa101ap01-ehr01/admin/log/ApplyAppsTier_08051732.log

AutoConfig Setup Phase
Running Setup Process 2 of 8 for AD_TOP
Executing script in InstantiateFile:
/data01/applerp/inst/apps/erptest1_szxfa101ap01-ehr01/admin/install/adgendbc.sh

script returned:
****************************************************

adgendbc.sh started at Tue Aug 5 17:35:25 CST 2014
SQL*Plus: Release 10.1.0.5.0 - Production on Tue Aug 5 17:35:25 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12505: TNS:listener does not currently know of SID given in connect
descriptor

Unique constraint error (00001) is OK if key already exists

Creating the DBC file...
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Database connection to jdbc:oracle:thin:@szxfa101db01.huawei.com:1521:erptest failed
ADD call failed with exit code 1

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-1249602/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-1249602/