Monday, 2 February 2009

Changing ports on Oracle 10g

I'm trying to get a VM setup for HP Quality Center (QC) and I've installed Oracle 10g XE as the database. Unfortunately QC uses port 8080 and so does 10g XE. Luckily, I found this snippet on how to change the port on 10g XE using sqlplus:-

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Aug 26 10:40:44 2008


Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> connect
Enter user-name: system
Enter password: <enter password if will not be visible>
Connected.
SQL> Exec DBMS_XDB.SETHTTPPORT(9090); [Assuming you want to have HTTP going to this port]

PL/SQL procedure successfully completed.

SQL>quit
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

Lovely! Didn't have to fiddle about in the internal of QC. Always something to be avoided if at all possible!

0 comments: