In 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.
This video demonstrates how to install and configure the MySQL ODBC driver on a Windows-based PC and then use it to connect either Microsoft Access or Open Office Base to a MySQL database. Part 1 of 2.
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 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.
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.
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.
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.
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 >>
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.
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 >>
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.
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 >>
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 >>