"IO Error: Invalid number format for port number" when connecting to Oracle database
プラットフォームについて: サーバーと Data Center のみ。この記事は、サーバーおよび Data Center プラットフォームのアトラシアン製品にのみ適用されます。
問題
Bitbucket Server is setup manually with Oracle as backend, as opposed to migrating database after setup is complete.
After configuration is complete and bitbucket.properties is created with the required details, the following error(s) appear in the atlassian-bitbucket.log:
....
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: IO Error: Invalid number format for port number
....
....
Caused by: java.sql.SQLRecoverableException: IO Error: Invalid number format for port number
....
....
Caused by: oracle.net.ns.NetException: Invalid number format for port number
....
原因
JDBC Url format incorrect in bitbucket.properties.
bitbucket.properties
jdbc.url=jdbc:oracle:thin:@//dfw-vu-devodb1.uat.svbank.com:1526:DEVOPSPOCDB
ソリューション
Changed the Url as follows:
bitbucket.properties
jdbc.url=jdbc:oracle:thin:@//dfw-vu-devodb1.uat.svbank.com:1526/DEVOPSPOCDB
There should be a slash "/" rather than a colon ":" before the database name/SID.
最終更新日 2017 年 11 月 16 日
Powered by Confluence and Scroll Viewport.