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 ... 122 123 [124] 125
1846
PSOUG / Are YOU the Smartest Database Professional in the World? :)
« on: March 26, 2009, 06:48:06 AM »
Are YOU the Smartest Database Professional in the World? Play this game and find out.

From the March 2009 edition of the Oracle ACE Newsletter:

Thanks to some of our ACEs who were the masterminds behind the questions, DB-Quest - the online game to test database knowledge - is now Live!
Become a database superhero and prove that you are the smartest database professional in the world. The top 10 scorers will be able to submit their own database question for inclusion in the game. Take the challenge.

1847
PSOUG / Re: Next PSOUG meeting, again ...
« on: March 25, 2009, 04:03:09 PM »
There is a question (not answered) about next PSOUG meeting.
Could you tell if/when it is going to happen?
I'm sorry, we don't have any information on meetings at this time.


Also, we used to have postings about new oracle-related jobs in "local" Puget Sound area. It is showing all kinds of destinations now. Kind of loosing that local tough, imho of course.
Ask and ye shall receive. :)

The listings have been configured specifically for Washington now (Seattle, Redmond, Renton, Bellevue, Everett, etc).

1848
PSOUG / Latest Northwest Oracle Users Group (NWOUG) News
« on: March 25, 2009, 07:54:06 AM »
Several exciting changes have happened at NWOUG since you have last heard from us! The NWOUG board has two new members, we have updated our website, and we have some new opportunities for vendors to be involved with our membership base.

* New Board Members *
Kamesh Naidoo has joined the NWOUG board in the capacity of content coordinator. Most recently she finished coordinating a full-house Lunch & Learn, and is ramping up for the next one. She will also be responsible for coordinating presentations for our conference this fall.

I am replacing Ann Miller in the capacity of vendor relations. You have worked with Ann for many years, and I hope to provide you with excellent service and opportunities as well.

* New Website *
We are excited about our newly revised website http://nwoug.org. If you haven’t checked on it in awhile, you will find that the new website is more intuitive, and offers some great features to our members. This is an excellent opportunity to provide additional information that you would find beneficial as a vendor. So any suggestions you have for content in our corner, please e-mail me at vendors@nwoug.org.

* Lunch & Learn *
As a board, we continually strive to find ways to educate members, and one of our best tools is the Lunch & Learn (L&L). Based in either Portland or Seattle, they provide our members with new skills and/or ideas.

We believe this is an excellent opportunity for our vendors and members to share time outside of the annual conference. By sponsoring an L&L you have the opportunity to provide our members with a value added functional or technical presentation and a meal. Attendance is limited only by the space you are able to provide.

Please contact me if you are interested in hosting an L&L in either Portland or Seattle.


* Fall 2009 Conference *
The planning phase of the Fall 2009 conference is well underway, and while I can’t give away any of the thunder here, you will soon be receiving detailed information. I will say that we are excited by our Keynote speaker, and believe that our members will be as well.

I want to express our sincere apology to those of you with us last year. The hotel’s decision to separate our vendors from the rest of the conference was disappointing, and diminished an important relationship.

Your inclusion was our highest concern when selecting a new location for this year’s conference. Thank you for being there with us, you are very important to us and we value your contribution to our community.

Nate Paul
Vendor Relations
vendors@nwoug.org

1849
PSOUG / Oracle Sues SAP - March 22nd
« on: March 24, 2009, 10:11:54 AM »
Full article: Oracle Sues SAP


On March 22, 2007, Oracle filed a lawsuit in U.S. Federal District Court in the Northern District of California against SAP. Among the claims made against SAP are violations of the Federal Computer Fraud and Abuse Act and California Computer Data Access and Fraud Act, Unfair Competition, Intentional and Negligent Interference with Prospective Economic Advantage and Civil Conspiracy.

On July 3, 2007, Oracle issued the following statement in response to SAP's legal filing:

"SAP CEO Henning Kagermann has now admitted to the repeated and illegal downloading of Oracle's intellectual property. Oracle filed suit to discover the magnitude of the illegal downloads and fully understands how SAP used Oracle's intellectual property in its business. To the extent requested, Oracle will cooperate with the Department of Justice investigation of SAP announced by the company in its press release," said Geoff Howard, Counsel for Oracle Corporation, Bingham McCutchen LLP.

Full article: Oracle Sues SAP

1850
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

1851
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.

1852
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:
http://www.swissql.com/products/sqlserver-to-oracle/sql-server-to-oracle.html

"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:

http://www.spectralcore.com/fullconvert/tutorials/convert-mssql-sql-server-to-oracle.php

"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

1853
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 PeteFinnigan.com, 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


1854
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:

    * COMPRESSION
    * Encryption Parameters
          o ENCRYPTION and ENCRYPTION_PASSWORD
          o ENCRYPTION_ALGORITHM
          o ENCRYPTION_MODE
    * TRANSPORTABLE
    * PARTITION_OPTIONS
    * REUSE_DUMPFILES
    * REMAP_TABLE
    * DATA_OPTIONS
          o SKIP_CONSTRAINT_ERRORS
          o XML_CLOBS
    * REMAP_DATA
    * Miscellaneous Enhancements

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

    COMPRESSION={ALL | DATA_ONLY | METADATA_ONLY | NONE}

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
      compression=all

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

1855
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 11.1.0.7.0 - Production on 13-MAR-2009 13:32:49

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

    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
    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

1856
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

1857
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.  :)

1858
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

1859
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 InternetNews.com. "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?

1860
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. :)

Pages: 1 ... 122 123 [124] 125