Home » SQL & PL/SQL » SQL & PL/SQL » Re: Changing the Port of The Oracle Server
Re: Changing the Port of The Oracle Server [message #37099] Thu, 17 January 2002 09:48
Joan Padilla i Salom
Messages: 5
Registered: January 2002
Junior Member
There's no problem.

To solve this question just use Net 80 assistant, at this point you can modify the diferent listener options, and obviusly the listining port No.

If you want to connect to DB you must modify the tnsnames.ora file, and change the listening port number.

The file should include something like this,

DB_global_name.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = Ip_direction)(Port = listener_port))
(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = Ip_direction)(Port = listener_port))
)
(CONNECT_DATA =
(SID = ORCL)
)
)
Previous Topic: Problem about create table
Next Topic: need to create a "read only" user
Goto Forum:
  


Current Time: Sun Jul 12 15:44:10 CDT 2020