Category: Databases

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

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.

Continue reading “Installing Oracle Database 10g Express Edition and Changing the Default HTTP Port”

Quest Software – Database Development Best Practices Workflow


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


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 start? Then, this session is for you! Examine the common areas that cause issues and delays during a migration project. Identify the pain points, understand why they come up, and how they can be avoided in advance. Hear best-practice recommendations on how to plan, test, and implement the move to BusinessObjects XI R2. Both IT managers and technical staff can gain a better understanding of the tasks involved, and how to make the migration as seamless as possible. Download the slide deck at: www.bobjects.com (1MB) Need more information? Visit: www.businessobjects.com Need to speak with some one today contact Jeffrey Michaels directly through this channel.

High Concurrency MySQL


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 and benchmarks and what tools have to be built to understand and contain the load.

Jaspersoft At a Glance (Video webcast)


ワークブレイン・ジャパン株式会社 ジャスパーソフト設立準備室: 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?

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


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 by step with voice. Please stay tuned.

Advanced Oracle PL/Sql: Programming With Packages

Product Description
Steven 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 preparing you for object-oriented development in Oracle technology. In this book, Feuerstein explains how to construct packages — and how to build them the right way. His “best practices” for building packages will transform the way you write packages and help you get the most out of the powerful, but often poorly understood, PL/SQL language. Much more than a book, Advanced Oracle PL/SQL Programming with Packages comes with a PC diskette containing a full-use software companion. Developed by Feuerstein, RevealNet’s PL/Vision Lite is the first of its kind for PL/SQL developers: . . . More >>

Advanced Oracle Pl/Sql: Programming With Packages

Crystal Reports Tutorial Using Running Totals Business Objects Training Lesson 13.1


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

Product Description
XML 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 basics of documents themselves, and the semantic rules, or grammars, that define them. Written for schema designers, system architects, programmers, and document authors, Modeling Business Objects with XML Schema guides you through understanding Schemas from the basic concepts, type systems, type derivation, inheritance, namespace handling, through advanced concepts in schema design.

*Reviews basic XML syntax and the Schema recommendation in detail.
*Builds a knowledge base model step by step (about jazz music) that is used throughout the book.
*Discusses Schema design in larg. . . More >>

Modeling Business Objects with XML Schema

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

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 flamboyant figures.

Read more on Reuters via Yahoo! News

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

Product Description
Designed 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 well that by the end of the first chapter users will be coding blocks confidently. Exercises are also provided intermittently to test knowledge comprehension.  While gradually building on previous concepts and increasing in complexity, this handbook always focuses on manageability. . . . More >>

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

Oracle Web Application Programming for PL/SQL Developers

Product Description
This 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 as HTML, Java, XML, WML, Perl and PHP, as well as covering various maintenance duties, such as troubleshooting, debugging, indexing, testing and site analysis. As Oracle’s premier tool for building store procedures, PL/SQL uniquely supplements the standard relational database language, SQL, with the features needed to build real-world applications. . . . More >>

Oracle Web Application Programming for PL/SQL Developers