[본문스크랩] Oracle 10g xdb port 변경

나의 마음에 봄은 언제?? | 윤재진
http://blog.naver.com/spyrogira256/120030856865

D.8 Changing the Oracle XML DB Ports

To change the Oracle XML DB FTP and HTTP ports, you need to run the catxdbdbca.sql script, which in a default installation is located in $ORACLE_HOME/rdbms/admin.

To change the Oracle XML DB ports:

1. Check that the Oracle listener is running. To do so, in the Services control panel, make sure that the Oracle TNS Listener service (for example, OracleOraDb10g_home1TNSListener) is set to Started.

   If you cannot start the listener, refer to Oracle Net Services Administrator's Guide.

2. Log into SQL*Plus or iSQL*Plus as SYS or XDB using the SYSDBA role.

   For example, to log in to SQL*Plus as SYS using the password welcome:

   # sqlplus "sys/welcome as SYSDBA"
   
   

3. Run the catxdbdbca.sql script.

   For example, to use 2200 for the FTP port and 8200 for the HTTP port, and assuming your Oracle home is in the following location, enter the following command:

   SQL> $ORACLE_HOME\rdbms\admin\catxdbdbca.sql 2200 8200
   
   

4. Exit SQL*Plus or iSQL*Plus.