調用配置檔案連接配接oracle資料庫,報錯提示ORA-12505, TNS:listener does not currently know of SID調用配置檔案連接配接oracle資料庫,報錯提示ORA-12505, TNS:listener does not currently know of SID
調用配置檔案連接配接oracle資料庫,報錯提示ORA-12505, TNS:listener does not currently know of SID
場景複現:
監聽檔案:
調用配置檔案連接配接oracle資料庫,報錯提示ORA-12505, TNS:listener does not currently know of SID調用配置檔案連接配接oracle資料庫,報錯提示ORA-12505, TNS:listener does not currently know of SID
配置檔案:
由于我用的是springboot架構,是以配置檔案是application.properties。
其他架構視自身情況而定
調用配置檔案連接配接oracle資料庫,報錯提示ORA-12505, TNS:listener does not currently know of SID調用配置檔案連接配接oracle資料庫,報錯提示ORA-12505, TNS:listener does not currently know of SID
是以根據select INSTANCE_NAME from v$instance查詢出資料庫的SID_NAME,如圖:
調用配置檔案連接配接oracle資料庫,報錯提示ORA-12505, TNS:listener does not currently know of SID調用配置檔案連接配接oracle資料庫,報錯提示ORA-12505, TNS:listener does not currently know of SID
得到SID_NAME後将配置檔案的資料庫名改過來
調用配置檔案連接配接oracle資料庫,報錯提示ORA-12505, TNS:listener does not currently know of SID調用配置檔案連接配接oracle資料庫,報錯提示ORA-12505, TNS:listener does not currently know of SID