Databases

Installing Oracle Database 10g Express Edition and Changing the Default HTTP Port

by

Oracle logoIn this article I will write about installing the Oracle Database 10g XE on Windows and changing the default port number for HTTP and optionally for FTP. The installer does not provide any customization option and you end up with the DB server instantly up and running reserving the port 1521 (a default for Oracle database servers), including an embedded HTTP listener set to a default port of 8080 which might conflict with some existing Java application servers or servlet containers such as Tomcat, JBoss Application Server and Glassfish which use the same port by default. Although it’s easy to start and stop the Oracle database with the shortcuts pre-installed in the Start menu, its http listener remains “on” at all times with no shortcut to be turned on and off easily.

In my case I already have Tomcat and Glassfish which are set to use the 8080 port as well, so I will show you how to modify the port number of Oracle 10g XE as I go along.

About APEX or what I would normally call Oracle 10g XE

Oracle Database 10g Express Edition (Oracle Database XE also goes by an abbreviated code name APEX) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that’s free to develop, deploy, and distribute; fast to download; and simple to administer. Oracle Database XE is a great starter database for:

  • Developers working on PHP, Java, .NET, XML, and Open Source applications
  • DBAs who need a free, starter database for training and deployment
  • Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge
  • Educational institutions and students who need a free database for their curriculum.

With Oracle Database XE, you can now develop and deploy applications with a powerful, proven, industry-leading infrastructure, and then upgrade when necessary without costly and complex migrations.

Read more

Quest Software – Database Development Best Practices Workflow

by

www.ToadWorld.com – In this episode of the Quest on the Board whiteboard series, Quest Manager of Systems Consulting Amit Parikh describes how development teams can meet the objectives of productivity and collaboration through a best practices workflow that builds quality, performance and maintainbility into their code.

Avoiding Common Pain Points When Migrating to Business Objects XI

by

Avoiding Common Pain Points When Migrating to XI — Vol 5 A 2007 user conference presentation by Tim Nightingale, Strategic Technology Architect Are you experiencing little tribulations with your migration project, or are you trying to discover all the “gotchas” before you dive in? Overwhelmed by the differences between versions and don’t know where to … Read more

High Concurrency MySQL

by

Domas Mituzas (Facebook) speaks at the 2010 O’Reilly MySQL User Conference & Expo. Slides – assets.en.oreilly.com From the official conference description at en.oreilly.com War and peace stories from Facebook how to detect, analyze and fix problems below, inside and above overloaded MySQL servers. This covers concurrecy problems that appear in real world environments, beyond labs … Read more

Jaspersoft At a Glance (Video webcast)

by

ワークブレイン・ジャパン株式会社 ジャスパーソフト設立準備室: Jaspersoft Business Intelligence Suite製品は、包括的なビジネスインテリジェンスファミリーとして、世界でもっとも使用されているオープンソースJavaレポーティング・ライブラリー（JasperReport）とレポートデザイナー(i-Report)、インメモリー分析・OLAP分析そしてデータ統合のETLが統合されたスイート製品。CognosやBusiness Objects（SAP)の代わりに定価で機能いっぱい。

How to set MySQL date from a result set to a PHP datetime object?

by

i am trying to set the date and time (DateTime stored in mysql database) to a php DateTime object, one way is to override the class some how to make that happen, but is there any easier way than that?e. g. $date = new DateTime();$date->setDate($mysql_resultset[‘date_time’]);and then format that date according and display it.

Starting Oracle ASM Instance & Database

by

This is basic step on how to start Oracle 11g ASM instance and then starting the Oracle 11g Database. You can see there was some errors so I updated the init file and fixed it because I had copied the init file from another box. Hope this helps. I will soon be uploading instructions step … Read more

Advanced Oracle PL/Sql: Programming With Packages

by

Product DescriptionSteven Feuerstein’s first book, Oracle PL/SQL Programming, has become the classic reference to PL/SQL, Oracle’s procedural extension to its SQL language. His new book looks thoroughly at one especially advanced and powerful part of the PL/SQL language — the package. The use of packages can dramatically improve your programming productivity and code quality, while … Read more

Crystal Reports Tutorial Using Running Totals Business Objects Training Lesson 13.1

by

Learn how to use a running total in Crystal Reports by Business Objects at www.teachUcomp.com. Get the complete tutorial at www.teachUcomp.com – the most comprehensive Crystal Reports tutorial available.

Modeling Business Objects with XML Schema

by

Product DescriptionXML Schema is the new language standard from the W3C and the new foundation for defining data in Web-based systems. There is a wealth of information available about Schemas but very little understanding of how to use this highly formal specification for creating documents. Grasping the power of Schemas means going back to the … Read more

Special Report: Can that guy in Ironman 2 whip IBM in real life?

by

Special Report: Can that guy in Ironman 2 whip IBM in real life? In the movie “Ironman 2,” Larry Ellison makes a cameo appearance as a billionaire, playboy software magnate. It is a role he knows well. He is playing himself — chief executive of Oracle Corp, one of Silicon Valley’s most enduring, successful and … Read more

Easy Oracle PL/SQL Programming: Get Started Fast with Working PL/SQL Code Examples

by

Product DescriptionDesigned for any Oracle professional who must quickly implement Oracle reporting, this indispensable guide offers new tips and tricks that make Oracle reporting simple. The basics of PL/SQL are introduced using multiple examples that include code snippets and sample code results. The example-driven methodology teaches PL/SQL language structures, anonymous blocks, and stored procedures so … Read more

Oracle Web Application Programming for PL/SQL Developers

by

Product DescriptionThis book covers everything you need to know to master Web application development in an Oracle environment – using PL/SQL. It is packed with practical tips that save the reader time, effort and frustration while developing and deploying Internet-ready, e-commerce applications using Oracle 9i. The book also provides important information on core topics such … Read more