Current location - Quotes Website - Team slogan - How to set the oracle port
How to set the oracle port
Are you asking how to adjust the port of the server to a non-default port?

In listener.ora, adjust 152 1 to the port you want to specify, for example, 652 1.

Listener =

(Description _ List =

(Description =

(address = (protocol = TCP) (host = local host) (port = 652 1))

)

)

Or do you want to ask the client how to specify other ports?

In tnsnames.ora, 152 1 can be changed to a port provided by the server, for example, 652 1.

ORCL =

(Description =

(Address list =

(address = (protocol = TCP) (host = local host) (port = 652 1))

)

(Connection data =

(server = dedicated)

(service name = orcl)

)

)