Deprecated: Assigning the return value of new by reference is deprecated in /home/digitalm/www/www/wp-includes/cache.php on line 36

Deprecated: Assigning the return value of new by reference is deprecated in /home/digitalm/www/www/wp-includes/query.php on line 21

Deprecated: Assigning the return value of new by reference is deprecated in /home/digitalm/www/www/wp-includes/theme.php on line 508
Expressly Oracle at digitalmeandering.com
« More fun with WoW (and Macros)
Gmail & Google Apps »

Expressly Oracle

13Jun07

At my last job, I spent a considerable amount of time using SQL. I pretty much lived, ate, and breathed it. For good or for ill the engine that I learned on was Microsoft SQL Server, which wasn’t too bad to learn. At my current position I’m getting exposure to three flavors of SQL: MS SQL, Oracle, and MySQL. So far the most interesting one has been Oracle, which is just different enough from MS SQL or MySQL to really give it a bit of a learning curve.

My first exposure to Oracle was with an older version (9i to be exact), and I have to say it, the management utility left quite a bit to be desired. The interface was awkward and slow, and for simple administration tasks it seemed overly complex. Apparently I chose the wrong version to learn on, as Oracle released a version of 10g that is tailored to those of us just being introduced to the wonders of Oracle.

Meet Oracle 10g Express Edition. He’s lean, he’s mean, and his web interface doesn’t suck! There are some limitations to the interface, but overall what you can do quick and easy. The only issue I had with it was that the web management utility wants to listen to port 8080 by default, which is great until you realize that you already have something listening there that doesn’t want to give it up.

Changing the listening port isn’t too hard, but wasn’t documented well (as far as I could find).  Luckily I found the solution on an Oracle employee’s blog. Here’s the solution, in condensed format.

Execute the following commands in SQL*Plus, as the system user:

  • To find what port it’s listening on: select dbms_xdb.gethttpport() from dual;
  • To set what port to listen on: exec dbms_xdb.sethttpport(8081);
    • Where ‘8081′ is the port

The other alternative is to completely uninstall and reinstall the application, but that seems a little overkill eh?

Filed under Oracle and Work.  |

0 Responses to “Expressly Oracle”

Feed for this Entry Trackback Address
  1. No Comments

Leave a Reply


Comment guidelines: No spamming, no profanity, and no flaming. Inappropriate comments will be deleted outright.

*
To prove you're a person (not a spam script), type the security word shown in the picture.
Anti-Spam Image

« More fun with WoW (and Macros)
Gmail & Google Apps »

 

June 2007
M T W T F S S
« Apr   Aug »
 123
45678910
11121314151617
18192021222324
252627282930  

Links

Take it, it's good for you

wowhead

APOD


Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 59

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 62

Deprecated: Function eregi() is deprecated in /home/digitalm/www/www/wp-content/plugins/widgets/apod_widget.php on line 86

Wunderground Weather Photo

Velvet Sunset


Google Ads!