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.

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

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

Oracle 10g Database Administrator II: Backup/Recovery and Network Administration

Product Description
Oracle 10g Database Administrator II: Backup/Recovery uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator. This text drills down key tools and techniques for Oracle database backup, recovery and network administration and provides good preparation for the update Oracle certification exam, Database Fundamentals I (#1Z0-043). In addition to extensive review material, the end of chapter content also includes comprehensive coverage of the exam objectives and exam-like practice questions. This text is the perfect compliment to the Oracle 10g: Database Administrator: Implementation and Administration (DBA1) text and the 1Z0-042. . . . More >>

Oracle 10g Database Administrator II: Backup/Recovery and Network Administration

Mastering Oracle PL/SQL: Practical Solutions

  • ISBN13: 9781590592175
  • Condition: USED – VERY GOOD
  • Notes:

Product Description
This isn’t a tutorial on how to code PL/SQL. It’s designed to show you how to code PL/SQL well. It shows you how to write code that will run quickly and won’t break in high-load, multiuser environments. It covers the vast array of the functionality that PL/SQL provides, including effective handling of relational and abstract data, security, triggers, dynamic web content presentation from within the database, creation of a DBA toolkit, and effective debugging techniques. This book sets out to redress the unjust criticism leveled at PL/SQL in years gone by. It gives you the tools and techniques to ensure that, whatever your needs are, the PL/SQL you build will run as efficiently as possible. The practical solutions provided in this book will help you to realize the true power and functionality PL/SQL can offer your projects. Mastering Oracle PL/SQL: Practical Solutions is targeted primarily toward the DBA or developer charged with the implementatio. . . More >>

Mastering Oracle PL/SQL: Practical Solutions

Oracle PL/SQL Language Pocket Reference

  • ISBN13: 9780596514044
  • Condition: NEW
  • Notes: Brand New from Publisher. No Remainder Mark.

Product Description
The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle’s PL/SQL language, including the newest Oracle Database 11g features. It’s a companion to Steven Feuerstein and Bill Pribyl’s bestselling Oracle PL/SQL Programming.

This concise guide boils down the most vital PL/SQL information into an accessible summary of: Fundamental language elements (e. g. , block structure, datatypes, declarations)Statements for program control, cursor management, and exception handlingRecords, procedures, functions, triggers, and packagesCalling PL/SQL functions in SQLCompilation options, object-oriented features, collections, and Java integration The new edition describes such Oracle Database 11g elements as PL/SQL’s function result cache, compound triggers, the CONTINUE statement, the SIMPLE_INTEGER datatype, and improvements to native compilation, regular expressions, and compiler optimization (including intr. . . More >>

Oracle PL/SQL Language Pocket Reference

PL/SQL Injection From Web


This video demonstrates how ‘vulnerable’ Oracle Application Servers can be compromised using OAP_Hacker.pl script. This vulnerability was patched by Oracle in 2006. The idea here is to demonstrate exploitation of PL/SQL injection from web applications. In most instances a PL/SQL Injection in Oracle web app, will result in OS code execution.

The Importance of Oracle Certifications and Oracle Certification Preparation & Training

The network of Microsoft is growing very fast. It has made space for so many fields, and they are progressing very fast too. The oracle is the one of all the Fields of IT (information technology) which is progressing with each and every day. The one of the popular certifications of IT has a great importance in the industries. The Oracle Corporation has worked very hard to achieve this standard, therefore they introduced the certification program to the candidates who wants to be the professional in the future in Oracle database program. The Oracle certifications can give the certified holder a distinct advantage. The certified professional has testified to the value of these certifications. These certifications are valuable industry recognized credentials that a proven level of knowledge and ability of the certified holder. Each high level of these certifications brings the new standard of benchmark skills and ability of the certified holder. This helps the candidate to get the good opportunities and good pay from the IT organization.

Continue reading “The Importance of Oracle Certifications and Oracle Certification Preparation & Training”

Book Giveaway & Chapter Download: Mastering Oracle Scheduler in Oracle 11g Databases

Oracle Scheduler does a lot of out of the box things, and if the demands are not too high, Oracle Scheduler can cover most of the situations. When your application has to run many thousands of jobs in an hour and log them over a long period, a little more attention is needed. In cases where the demands are high, we need to take care of a few more things to keep the system happy. What we need to do depends on how the Scheduler is used and what kind of load it is supposed to handle.

In this chapter, we will take a closer look at how we can control this beast. We will take a look at the privileges for job creation, job execution, and Scheduler management. We will also examine how to control logging retention and find a way to prevent jobs from running when the database starts.

Job Creation

Like most object types in the database, as seen at the beginning of Chapter 1, Oracle enables us to create Scheduler objects. The privileges create job and create external job are very important. They should normally be used when building an application system . Also, there is a create any job privilege, which can be useful when you need to create a job in a different schema. Normally, this privilege should not be granted to anyone. It will allow the grantee to run an arbitrary code on any schema, which is not particularly desirable. Instead, just log on to the correct schema and perform the tasks using the correct privileges.

Continue reading “Book Giveaway & Chapter Download: Mastering Oracle Scheduler in Oracle 11g Databases”

Introduction to PL/SQL: PL/SQL guide in oracle 11g for naives to experts

Product Description
This book has been written by giving enormous simple examples of each feature so it is easily understandable for new developers, and there are many advance features that most of the conventional books ignore so it is equally beneficial to the experts. There are more than 400 practical examples, which are being given by the author by keeping in mind the practical problems he himself faced. This book is very useful for the person, who wants to work as an oracle developer, working developer who wants to extend his knowledge and professional or student who intend to give OCP exam. . . . More >>

Introduction to PL/SQL: PL/SQL guide in oracle 11g for naives to experts