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?
0 Responses to “Expressly Oracle”