Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Mike

Pages: 1 ... 144 145 [146] 147
PSOUG / Enterprise Pack for Eclipse Release 11g Now Available
« on: March 24, 2009, 10:08:22 AM »
Full article: Oracle® Enterprise Pack for Eclipse Release 11g Now Available

Continuing to deliver on its commitment to provide Java developers productivity with choice, Oracle today announced Oracle® Enterprise Pack for Eclipse Release 11g. This is a free component of Oracle Fusion Middleware designed to help developers leverage their expertise in Eclipse with the comprehensive capabilities of Oracle Fusion Middleware.

Key enhancements in this release include Object-Relational Mapping (ORM), Spring and Web Service tools to help reduce development complexity for Java and database developers targeting Oracle platforms.

The Oracle Enterprise Pack for Eclipse is designed to help organizations where Eclipse is the preferred Integrated Development Environment (IDE) by providing a set of Eclipse plug-ins to help develop, deploy and debug Java SE, Java EE, Spring, ORM and Web Service applications for Oracle WebLogic Server and Oracle Database.

Full article: Oracle® Enterprise Pack for Eclipse Release 11g Now Available

PSOUG / Re: Multiple Errors?
« on: March 23, 2009, 05:57:26 PM »
What am I doing wrong with this SQL statement?

These are the errors I am receiving...

-- ORA-00903: invalid table name
-- ORA-00900: invalid SQL statement
-- ORA-00928: missing SELECT keyword
-- ORA-00933: SQL command not properly ended

Any Suggestions?

Hmmm...well, some of the errors seem fairly self-explanatory. The "invalid table name" means you're referencing a table that doesn't appear to exist. That should be fairly easy to track down, and it may be responsible for the some or all of the other errors as well so that's where I'd start. Make sure that the tablenames you're using are all valid and that they all actually exist. I'd try to find and fix that error first.

PSOUG / Re: Migrating from SQL Server to Oracle
« on: March 23, 2009, 07:10:54 AM »
How to migrate from sqlserver to Oracle any information 

This might help:

"SwisSQL - SQL Server to Oracle Migration Tool helps you migrate MS SQL Server Transact-SQL Procedures, Functions and Triggers to Oracle PL/SQL language. When enterprises migrate from MS SQL Server to Oracle, application migration is one of the tedious tasks and there are no good tools which can ease the process of migrating MS SQL Server Stored Procedures to Oracle PL/SQL. Using SwisSQL - SQL Server to Oracle Migration Tool and through AdventNet's superior support, enterprises can realize significant time and cost savings during the migration and testing process."

This also looks like it might work:

"migrate Microsoft SQL Server database to Oracle in under five minutes"

# Full Unicode support
# Creates all data, indexes and foreign keys
# Data throughput of thousands of records/sec
# Easily handles tens of gigabytes of data
# Advanced command-line support
# Built-in scheduler for recurring conversions
# BLOB and MEMO fields are fully supported
# Runs on all Windows versions

PSOUG / Fuzzing tool helps Oracle DBAs defend against SQL injection
« on: March 23, 2009, 06:25:04 AM »
Full Article: Fuzzing tool helps Oracle DBAs defend against SQL injection

Database security software vendor Sentrigo Inc. released a new open source fuzzing tool, FuzzOr, designed to identify vulnerabilities found in Oracle database software applications.

With FuzzOr, Sentrigo aimed to create a tool that would allow database administrators and programmers to test PL/SQL applications for security vulnerabilities, said Slavik Markovich, co-founder and chief technology officer of Sentrigo.

While other tools for vulnerability assessment typically fix a list of errors, the FuzzOr is dynamic because it does not have a preconfigured checklist, Markovich said.

"[FuzzOr] is different because I don't think there is any other tool that does fuzzing on the PL/SQL program," Markovich said. "FuzzOr tries to scan a particular code and analyze [the code] for vulnerabilities."

Oracle security expert Pete Finnigan, director for, an Oracle security site, said FuzzOr is a useful tool because it is one of the only practical tools that is free and analyzes PL/SQL for vulnerabilities.

"FuzzOr has the advantage because with FuzzOr you're not looking at soft code and analyzing it, instead you're trying to break it and make it do something different," Finnigan said.

Full Article: Fuzzing tool helps Oracle DBAs defend against SQL injection

PSOUG / Data Pump Enhancements in Oracle Database 11g Release 1
« on: March 23, 2009, 06:22:08 AM »
Full Article: Data Pump Enhancements in Oracle Database 11g Release 1

Data Pump Enhancements in Oracle Database 11g Release 1

This article provides an overview of the main Data Pump enhancements in Oracle Database 11g Release 1, including:

    * Encryption Parameters
          o XML_CLOBS
    * Miscellaneous Enhancements

The COMPRESSION parameter allows you to decide what, if anything, you wish to compress in your export. The syntax is shown below.


The available options are:

    * ALL: Both metadata and data are compressed.
    * DATA_ONLY: Only data is compressed.
    * METADATA_ONLY: Only metadata is compressed. This is the default setting.
    * NONE: Nothing is compressed.

Here is an example of the COMPRESSION parameter being used.

    expdp test/test schemas=TEST directory=TEST_DIR dumpfile=TEST.dmp logfile=expdpTEST.log

The COMPATIBLE initialization parameter should be set to "11.0.0" or higher to use these options, except for the METADATA_ONLY option, which is available with a COMPATIBLE setting of "10.2".

Encryption Parameters
Data pump encryption is an Enterprise Edition feature, so the parameters described below are only relevant for Enterprise Edition installations. In addition, the COMPATIBLE initialisation parameter must be set to "11.0.0" or higher to use these features.

Full Article: Data Pump Enhancements in Oracle Database 11g Release 1

PSOUG / Oracle-Base: Basic Enterprise Manager Troubleshooting
« on: March 23, 2009, 06:20:27 AM »
Full Article: Basic Enterprise Manager Troubleshooting

The web-based Enterprise Manager tool was introduced in Oracle 10g and has significant functionality improvements over previous versions. Even so, it seems there is not a day goes by without someone asking how to solve an Enterprise Manager configuration issue, so this article explains the first things you should look at. It's not meant to be an all encompassing guide. Just a first shot.

First, check the listener is running correctly.

    lsnrctl status

If you get something like the following, your listener is not running and you need to start it using the "lsnrctl start" command.

    $ lsnrctl status

    LSNRCTL for Linux: Version - Production on 13-MAR-2009 13:32:49

    Copyright (c) 1991, 2008, Oracle.  All rights reserved.

    TNS-12541: TNS:no listener
     TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
       Linux Error: 2: No such file or directory
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oel5-11g.localdomain)(PORT=1521)))
    TNS-12541: TNS:no listener
     TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
       Linux Error: 111: Connection refused

Full Article: Basic Enterprise Manager Troubleshooting

PSOUG / Oracle close to acquiring Virtual Iron
« on: March 22, 2009, 09:28:15 AM »
With little to no success in pushing its own virtualization product, Oracle is in talks to acquire Virtual Iron, according to insiders at the startup.

Oracle Corp. has signed a letter of intent to acquire Virtual Iron Software Inc. and is said to be at the "checking-into-how-things-are-run stage," according to a source, who requested anonymity.

The terms of the deal were not available, but industry analysts believe it's likely to be a fire sale. In a fifth round of funding in January 2008, Lowell, Mass.-based Virtual Iron clinched $20 million bringing its total funding to date to $65 million.

Virtual Iron claims to have around 2,000 small and medium-sized business customers, but it's "very much an also-ran in this market," according to Gordon Haff, principal analyst at Illuminata Inc. "They might be the fifth largest virtualization player, but that's like being a fourth-string quarterback," he said. They'll pay "whatever Larry Ellison has lying around in his sock drawer," he added.

Full Story: Oracle close to acquiring Virtual Iron

PSOUG / Re: New Look 'n Feel
« on: March 21, 2009, 08:13:16 PM »
New nav menu is cool :)

Thank you, I'm glad you like the way the new design turned out. We re-wrote the snippet app more or less from scratch and also reformatted the rest of the site to make it faster and "cleaner". We have some great stuff coming that'll be added in the next month or two.  :)

PSOUG / Oracle Offering Scaled-Down Database Machine
« on: March 21, 2009, 05:02:18 PM »
Oracle Offering Scaled-Down Version of Database Machine

IDG News Service — Citing customer demand, Oracle has unveiled a half-size version of the HP Oracle Database Machine, its competitor to high-end data warehousing products such as that sold by Teradata.

The HP Oracle Database Machine was co-developed by Oracle and Hewlett-Packard and is part of Oracle's Exadata product line, launched to great fanfare at the OpenWorld conference last year.

It initially was available as a rack filled with eight HP DL360 database servers, four Infiniband switches, a storage server grid with 14 servers, and various software products, according to a post made Thursday to Oracle's Data Warehouse Insider blog.

But now, "due to popular demand, addressing smaller entry points with the same extreme performance on the same technology basis, Oracle is now introducing a smaller system," the blog states. The scaled-down version has four HP DL360 database servers, two switches and seven storage servers and "will provide similar scalability and performance characteristics as the full rack."

Full Story: Oracle Offering Scaled-Down Version of Database Machine

PSOUG / Is Oracle Forking Red Hat Linux?
« on: March 21, 2009, 06:28:38 AM »
via /.

Is Oracle Forking Red Hat Linux?

For nearly three years, Oracle has had its own version of Red Hat Enterprise Linux, claiming the two versions are essentially the same thing. But are they really?

As it turns out, there are a few things on which Oracle and Red Hat do not see eye-to-eye, including file systems and virtualization.

The article quotes Wim Coekaerts, Oracle's director of Linux engineering, saying, "A lot of people think Oracle is doing Enterprise Linux as just basically a rip off of Red Hat, but that's not what this is about," Wim Coekaerts, director of Linux engineering at Oracle, told "This is about a support program, and wanting to offer quality Linux OS support to customers that need it. The Linux distribution part is there just to make sure people can get a freely available Linux operating system that is fully supported."

"We don't want to create a new Linux distribution that is different from Red Hat, because the issue is about support and not the software itself," Coekaerts added.

Yet, as it turns out, Oracle Enterprise Linus's binary compatibility does not mean that its version is entirely identical to Red Hat's. In fact, there are some important differences, including support for a key file system technology.

Full article: Is Oracle Forking Red Hat Linux?

PSOUG / New Look 'n Feel
« on: March 20, 2009, 06:40:34 PM »
The final "look and feel" is here; there shouldn't be any more changes except possibly some fine-tuning. We hope you like it. :)

PSOUG / Re: Original Archive Pages Now Available
« on: March 19, 2009, 12:52:48 PM »
You're welcome!

We're glad you like the original pages, and we also hope you and other visitors give the new system a try. (The content is being transferred over to it bit by bit.)

Running with the old pages causes some pretty serious bandwidth usage/problems, so we're doing what we can to keep that in check (hence the Google ads and donation buttons).

Thanks for putting the original pages back!  I use them often, best examples on the web.

PSOUG / Upcoming Oracle Events List
« on: March 19, 2009, 08:59:47 AM »
March 2009

    * 8-12 March 2009 Hotsos Symposium, Dallas, Texas, USA
    * 10 March 2009 OUG Ireland Conference & Exhibition, Dublin.
    * 10-12 March 2009 Oracle’s OpenWorld Latin America 2009, São Paulo, Brazil.
    * 13 March 2009 Q3 2009 Oracle Earnings Release

April 2009

    * 1-2 April 2009 OAUG Connection Point, Dhow Palace Hotel, Dubai, UAE
    * 14 April 2009 Critical Patch Update
    * 22-24 April 2009 Oracle OpenWorld Japan: Tokyo, Japan.

May 2009

    * 3-7 May 20098 COLLABORATE '09 Conference (Orange County Convention Center, Orlando, Florida, USA)

June 2009

    * 16 June 2009 Q4 2009 Oracle Earnings Release
    * 21-25 June 2009 ODTUG Kaleidoscope 2009 conference, Monterey, California, USA.
    * 22-24 June 2009 SAOUG 2009 User Conference, Durban International Convention Centre, South Africa

July 2009

    * 14 July 2009 Critical Patch Update

August 2009

    * Extended Support for Oracle RDB version 7.0 ends.

October 2009

    * 11-15 October 2009 Oracle OpenWorld Conference (Moscone Center, San Fransisco, USA)
    * 13 October 2009 Critical Patch Update

PSOUG / InSync Oracle Conference April 20th-21st Sydney Australia
« on: March 17, 2009, 05:50:30 PM »

InSync09 is the leading applications event of 2009. The independent user groups in Australia and New Zealand will come together for the first time to co-host this inaugural conference.

The family of Oracle applications users in Australia and New Zealand are invited to join their peers to share ideas, innovations, solutions and experience the value of Oracle user groups (non-members are most welcome).

InSync09 offers the most comprehensive Oracle applications agenda outside the US. The programme will comprise 80+ sessions over 2 days and includes social activities such as the cocktail party and an InSync09 Exhibition.

Register here

PSOUG / Free Oracle Unbreakable Linux and Oracle VM 3-disc Kit
« on: March 17, 2009, 09:13:14 AM »
Free Oracle Unbreakable Linux and Oracle VM 3-disc Kit

"Manage your data more efficiently, economically, and ecologically with zero risk—start saving today.

Discover how to optimize resources while reducing hardware, energy, and facility costs with Oracle VM server virtualization. And realize highest quality service and cost savings with Oracle’s industry-leading, global, enterprise-class, Oracle Unbreakable Linux support program. Order your free kit today!

The kit includes Oracle Enterprise Linux 5.2 (x86-64bit), Oracle VM 2.1.2, and additional resources: Get It Here

Pages: 1 ... 144 145 [146] 147