[OCP 11 Complete Study Guide] [OCP 11 Programmer I Book] [OCP 11 Programmer II Book] [OCP 11 Practice Tests Book] [OCA 8 Book] [OCP 8 Book] [OCP 8 Practice Tests Book] [Blog]
Open a SQLPlus session and execute:
select value from v$parameter where name = 'db_name';
Replace "ORACLE" with the value returned.
-- change HTTP port from 8080 to 8083
call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()', 8083));
-- change FTP port from 2100 to 2111
call dbms_xdb.cfg_update(updateXML( dbms_xdb.cfg_get(), '/xdbconfig/sysconfig/protocolconfig/ftpconfig/ftp-port/text()' , 2111));
-- refresh settings
exec dbms_xdb.cfg_refresh;
Originally posted by Mike Thomson:
Do I need to run this query from SQL*plus?
Well don't expect me to do the dishes! This ad has been cleaned for your convenience:
Master Gardener Program
https://coderanch.com/t/771761/Master-Gardener-Program
|