Skip to content

Instantly share code, notes, and snippets.

@ccw

ccw/gist:2226467

Created March 28, 2012 14:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ccw/2226467 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ccw/2226467 to your computer and use it in GitHub Desktop.
Download ZIP
[Oracle] Change the Service Listening Ports of TNS Listener
Raw
gistfile1.txt
call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()', 9090));
commit;
exec dbms_xdb.cfg_refresh;
call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()', 9091));
commit;
exec dbms_xdb.cfg_refresh;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment