oraora Yes, in the listener.ora file, in the section: LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 999.999.999.999) (Port = 2521)
You don't want to accidentally select a port that something else on your network is using. The usual alternate port to use for Oracle is 1526. On Unix, there is a file that designates what application or function uses what port. I understand from my networking buddy that this is more of a honor system, so theoretically you should add an entry there. I haven't the faintest idea how this applies to W2K, but somebody on this list probably does. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, October 09, 2002 7:19 AM To: Multiple recipients of list ORACLE-L guys, i have a db CLONEDB , cloned from another DB. i have did it successfully and things work fine. the listener listens on default port 1521. now i would like to change this to some other port number , say 2521. the environment is oracle 8.1.6/win2k. how do i do it ? can someone explain me the steps involved ? TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).