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!
Monday, 2 February 2009
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment