記載著 Will 在網路世界的學習心得與技術分享 https://blog.miniasp.com/ http://www.rssboard.org/rss-specification BlogEngine.NET 3.3.7.0 zh-TW https://blog.miniasp.com/opml.axd https://blog.miniasp.com/syndication.axd Will Huang The Will Will Web 24.567110 120.970500 <p>我前幾天在企業內訓授課的時候，因為客戶主要採用 Oracle 資料庫，所以我原本想說要在 Docker 上安裝 Oracle Database 的免費版本來用，結果我在 2019 年<a href="/post/2019/10/07/How-to-use-Oracle-Database-Server-12c-R2-containers">寫過的 Oracle Database Server 12c R2 容器文章</a>已經不能用了。這幾天進一步發現 Oracle 官方提供了新版本的 Oracle Database 容器映象可用，但要從官網或網路上找到一篇立即可上手的文章並不容易，我花了好幾個小時才釐清來龍去脈，這篇文章我就打算來分享新版本 Oracle Database 容器映象的安裝與使用方式。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2024/02/29/Oracle-Database-23c-Free-for-Docker-Desktop-on-Windows#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2024/02/29/Oracle-Database-23c-Free-for-Docker-Desktop-on-Windows [email protected] https://blog.miniasp.com/post/2024/02/29/Oracle-Database-23c-Free-for-Docker-Desktop-on-Windows#comment https://blog.miniasp.com/post.aspx?id=7fe37f07-a492-47d1-b1ce-38f3e5232223 週四, 29 二月 2024 10:15:00 +0000 Container Oracle oracle will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=7fe37f07-a492-47d1-b1ce-38f3e5232223 https://blog.miniasp.com/trackback.axd?id=7fe37f07-a492-47d1-b1ce-38f3e5232223 https://blog.miniasp.com/post/2024/02/29/Oracle-Database-23c-Free-for-Docker-Desktop-on-Windows#comment https://blog.miniasp.com/syndication.axd?post=7fe37f07-a492-47d1-b1ce-38f3e5232223 <p>最近越來越多 ASP.NET Core 企業內訓需求，有客戶提到希望能在上課的時候展示 Entity Framework Core 與 Oracle 資料庫的整合能力，我第一時間就想到要在本機安裝 Oracle 資料庫容器起來，快速建立可開發測試的環境。不過，雖然建立 Oracle 資料庫容器相當簡單方便，但不太熟悉 Oracle 資料庫特性的我，卻連第一步「建立使用者」都沒辦法成功，錯誤訊息也相當難以理解，花了一些時間才找到解決之道。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2019/10/07/How-to-use-Oracle-Database-Server-12c-R2-containers#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2019/10/07/How-to-use-Oracle-Database-Server-12c-R2-containers [email protected] https://blog.miniasp.com/post/2019/10/07/How-to-use-Oracle-Database-Server-12c-R2-containers#comment https://blog.miniasp.com/post.aspx?id=61cf6e79-ef66-4b0c-b76a-c140a211545a 週一, 7 十月 2019 15:38:00 +0000 .NET Core Oracle oracle container .net core will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=61cf6e79-ef66-4b0c-b76a-c140a211545a https://blog.miniasp.com/trackback.axd?id=61cf6e79-ef66-4b0c-b76a-c140a211545a https://blog.miniasp.com/post/2019/10/07/How-to-use-Oracle-Database-Server-12c-R2-containers#comment https://blog.miniasp.com/syndication.axd?post=61cf6e79-ef66-4b0c-b76a-c140a211545a <p>今天又解決一個十分棘手的問題，我們有個專案原本在 x86 機器上開發 ( 資料庫採用 Oracle )，最近由於主機升級到 Windows 7 (x64) 後發現程式出問題，當在 Visual Studio 中按下 F5 進行測試除錯時完全無法連接到資料庫，而且一整個很沒道理，看看我如何解決這個棘手的問題吧。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2009/08/31/Solve-ASPNET-cannot-connect-Oracle-DB-using-Development-Server#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2009/08/31/Solve-ASPNET-cannot-connect-Oracle-DB-using-Development-Server [email protected] https://blog.miniasp.com/post/2009/08/31/Solve-ASPNET-cannot-connect-Oracle-DB-using-Development-Server#comment https://blog.miniasp.com/post.aspx?id=36434f64-58b7-46e7-9a91-1494a11829c2 週一, 31 八月 2009 08:48:53 +0000 ASP.NET Oracle Visual Studio oracle asp.net x64 windows 7 will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=36434f64-58b7-46e7-9a91-1494a11829c2 https://blog.miniasp.com/trackback.axd?id=36434f64-58b7-46e7-9a91-1494a11829c2 https://blog.miniasp.com/post/2009/08/31/Solve-ASPNET-cannot-connect-Oracle-DB-using-Development-Server#comment https://blog.miniasp.com/syndication.axd?post=36434f64-58b7-46e7-9a91-1494a11829c2 <p>我很愛用 Ramdisk (記憶體磁碟) 當成我的系統暫存目錄，因為這真的會讓系統的執行速度快很多，我最近為了讓我的桌上型電腦(Desktop)與筆記型電腦(Notebook)的 Ramdisk 磁碟代號一致而將 Ramdisk 磁碟更換了磁碟代碼，不過這卻導致我的 Outlook 開啟後就會出現 &quot;<strong>Outlook 無法建立工作檔。檢查暫存環境變數。</strong>&quot; 的錯誤訊息。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2009/04/16/Outlook-Could-Not-Create-the-Work-File#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2009/04/16/Outlook-Could-Not-Create-the-Work-File [email protected] https://blog.miniasp.com/post/2009/04/16/Outlook-Could-Not-Create-the-Work-File#comment https://blog.miniasp.com/post.aspx?id=cba98810-7d33-4709-8b78-8c57bc23da1f 週四, 16 四月 2009 14:46:36 +0000 系統管理 Oracle outlook will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=cba98810-7d33-4709-8b78-8c57bc23da1f https://blog.miniasp.com/trackback.axd?id=cba98810-7d33-4709-8b78-8c57bc23da1f https://blog.miniasp.com/post/2009/04/16/Outlook-Could-Not-Create-the-Work-File#comment https://blog.miniasp.com/syndication.axd?post=cba98810-7d33-4709-8b78-8c57bc23da1f <p>如果你有開發 Oracle 應用程式，那麼你應該要知道有這套工具，使用 <a href="http://www.aboves.com/products/statement_tracer_for_oracle/" rel="nofollow">Statement Tracer for Oracle</a> 最大的好處就在於他可以掃瞄(Sniffer)到你電腦內任何應用程式與 Oracle 資料庫之前的所有 SQL 查詢語法(Statement)，所以當你懷疑你的程式到底送了什麼 SQL Statement 到 Oracle 資料庫的話 ( 例如你用 LINQ to Oracle 進行查詢 )，就可以用這套軟體幫你掃出實際進 Oracle DB 查詢的語法。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2009/02/23/Useful-tool-Statement-Tracer-for-Oracle#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2009/02/23/Useful-tool-Statement-Tracer-for-Oracle [email protected] https://blog.miniasp.com/post/2009/02/23/Useful-tool-Statement-Tracer-for-Oracle#comment https://blog.miniasp.com/post.aspx?id=7e2bbd27-e876-471a-8115-d0d43823aa66 週一, 23 二月 2009 14:23:26 +0000 Oracle 介紹好用工具 statement tracer for oracle will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=7e2bbd27-e876-471a-8115-d0d43823aa66 https://blog.miniasp.com/trackback.axd?id=7e2bbd27-e876-471a-8115-d0d43823aa66 https://blog.miniasp.com/post/2009/02/23/Useful-tool-Statement-Tracer-for-Oracle#comment https://blog.miniasp.com/syndication.axd?post=7e2bbd27-e876-471a-8115-d0d43823aa66 <p>我們最近有個專案遇到一個 Oracle 資料庫查詢效能的問題，由於問題有點複雜，我必須先將「前情提要」說明清楚。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2009/01/22/Using-OracleParameter-will-cause-performance-problem#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2009/01/22/Using-OracleParameter-will-cause-performance-problem [email protected] https://blog.miniasp.com/post/2009/01/22/Using-OracleParameter-will-cause-performance-problem#comment https://blog.miniasp.com/post.aspx?id=ccd883ba-cd5b-4db2-8238-3bb8838898aa 週四, 22 一月 2009 03:07:14 +0000 .NET Framework Oracle oracle odp.net oraclecommand oracleparameter oracledataadapter will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=ccd883ba-cd5b-4db2-8238-3bb8838898aa https://blog.miniasp.com/trackback.axd?id=ccd883ba-cd5b-4db2-8238-3bb8838898aa https://blog.miniasp.com/post/2009/01/22/Using-OracleParameter-will-cause-performance-problem#comment https://blog.miniasp.com/syndication.axd?post=ccd883ba-cd5b-4db2-8238-3bb8838898aa <p>我們一直以來就很少使用 Oracle 資料庫，一年下來也頂多 1 ~ 2 個案子採用 Oracle 的資料庫，所以一直都對 Oracle 資料庫的操作不太熟悉，尤其是用 Oracle 內建的那些超難用工具，更是不想親近，太不人性了。不過今年 Oracle 終於推出了一套 <a href="http://www.oracle.com/technology/products/database/sql_developer/index.html" rel="nofollow" target="_blank">SQL Developer</a> 資料庫管理工具，雖然還是比 Management Studio 遜色很多，不過終究像是個<strong>人用的</strong>管理工具了。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2008/11/17/Useful-tool-Oracle-SQL-Developer#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2008/11/17/Useful-tool-Oracle-SQL-Developer [email protected] https://blog.miniasp.com/post/2008/11/17/Useful-tool-Oracle-SQL-Developer#comment https://blog.miniasp.com/post.aspx?id=8e03aebe-e524-45c4-ba3b-f6852587a6cd 週一, 17 十一月 2008 16:38:43 +0000 MySQL Oracle SQL Server 介紹好用工具 sql developer java will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=8e03aebe-e524-45c4-ba3b-f6852587a6cd https://blog.miniasp.com/trackback.axd?id=8e03aebe-e524-45c4-ba3b-f6852587a6cd https://blog.miniasp.com/post/2008/11/17/Useful-tool-Oracle-SQL-Developer#comment https://blog.miniasp.com/syndication.axd?post=8e03aebe-e524-45c4-ba3b-f6852587a6cd <p>我在工作上偶爾會需要整理各資料庫與資料庫各版本的比較表給客戶看，讓客戶瞭解而各種資料庫或資料庫各版本間的差異、價格、功能、...等。不過 SQL Server 2008 卻讓我花了好些時間才收集完相關的比較資訊，埋藏在 MSDN 裡面，且還分了好幾篇文章。我覺得納悶的是：為什麼這些比較資訊不整理放在 <a href="http://www.microsoft.com/taiwan/sql2008/default.aspx" rel="nofollow" target="_blank">SQL Server 2008 產品官網</a>中呢？！</p><p>... <a class="more" href="https://blog.miniasp.com/post/2008/09/27/SQL-Server-Oracle-Features-Comparison-Chart#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2008/09/27/SQL-Server-Oracle-Features-Comparison-Chart [email protected] https://blog.miniasp.com/post/2008/09/27/SQL-Server-Oracle-Features-Comparison-Chart#comment https://blog.miniasp.com/post.aspx?id=5a8c3e2d-591f-41f8-8089-357a7d4012c1 週六, 27 九月 2008 06:02:00 +0000 Oracle SQL Server oracle sql server 2008 sql server 2005 sql server will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=5a8c3e2d-591f-41f8-8089-357a7d4012c1 https://blog.miniasp.com/trackback.axd?id=5a8c3e2d-591f-41f8-8089-357a7d4012c1 https://blog.miniasp.com/post/2008/09/27/SQL-Server-Oracle-Features-Comparison-Chart#comment https://blog.miniasp.com/syndication.axd?post=5a8c3e2d-591f-41f8-8089-357a7d4012c1 <p> <span class="topstoryhead"><span class="topstoryhead">Oracle 最近推出了 <span class="parahead1">Oracle Developer Tools for Visual Studio with Oracle 11<em>g</em> <strong>ODAC 11.1.0.6.20</strong>，其中包括了支援 Visual Studio 2008 的開發工具（Server Explorer, ASP.NET providers, source control, 以及 user-defined types）與 .NET Framework 3.5 的支援。</span></span></span> </p><p>... <a class="more" href="https://blog.miniasp.com/post/2007/12/30/Oracle-Developer-Tools-for-Visual-Studio-with-Oracle-11g-ODAC-1110620#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2007/12/30/Oracle-Developer-Tools-for-Visual-Studio-with-Oracle-11g-ODAC-1110620 [email protected] https://blog.miniasp.com/post/2007/12/30/Oracle-Developer-Tools-for-Visual-Studio-with-Oracle-11g-ODAC-1110620#comment https://blog.miniasp.com/post.aspx?id=0006e95d-4125-4ae2-a822-eefacc2b68ad 週日, 30 十二月 2007 16:39:00 +0000 .NET Framework ASP.NET Oracle Visual Studio oracle visual studio will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=0006e95d-4125-4ae2-a822-eefacc2b68ad https://blog.miniasp.com/trackback.axd?id=0006e95d-4125-4ae2-a822-eefacc2b68ad https://blog.miniasp.com/post/2007/12/30/Oracle-Developer-Tools-for-Visual-Studio-with-Oracle-11g-ODAC-1110620#comment https://blog.miniasp.com/syndication.axd?post=0006e95d-4125-4ae2-a822-eefacc2b68ad <p> <strong>安裝、升級注意事項</strong> </p><p>... <a class="more" href="https://blog.miniasp.com/post/2007/10/27/Oracle-10g-Client-Installation-Note#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2007/10/27/Oracle-10g-Client-Installation-Note [email protected] https://blog.miniasp.com/post/2007/10/27/Oracle-10g-Client-Installation-Note#comment https://blog.miniasp.com/post.aspx?id=c44614f9-4ace-4367-ad22-47f2c740cb91 週六, 27 十月 2007 06:05:00 +0000 Oracle oracle will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=c44614f9-4ace-4367-ad22-47f2c740cb91 https://blog.miniasp.com/trackback.axd?id=c44614f9-4ace-4367-ad22-47f2c740cb91 https://blog.miniasp.com/post/2007/10/27/Oracle-10g-Client-Installation-Note#comment https://blog.miniasp.com/syndication.axd?post=c44614f9-4ace-4367-ad22-47f2c740cb91 <p><strong>Oracle 物件的命名限制</strong> </p><p>... <a class="more" href="https://blog.miniasp.com/post/2007/10/27/Oracle-Development-Note#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2007/10/27/Oracle-Development-Note [email protected] https://blog.miniasp.com/post/2007/10/27/Oracle-Development-Note#comment https://blog.miniasp.com/post.aspx?id=373bc259-ecd8-4b5a-b4ee-94c0c947d6e8 週六, 27 十月 2007 03:38:00 +0000 Oracle oracle sql will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=373bc259-ecd8-4b5a-b4ee-94c0c947d6e8 https://blog.miniasp.com/trackback.axd?id=373bc259-ecd8-4b5a-b4ee-94c0c947d6e8 https://blog.miniasp.com/post/2007/10/27/Oracle-Development-Note#comment https://blog.miniasp.com/syndication.axd?post=373bc259-ecd8-4b5a-b4ee-94c0c947d6e8