OraFAQ Forum: Server Administration » port redirection solaris/linux

Home » RDBMS Server » Server Administration » port redirection solaris/linux

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

port redirection solaris/linux [message #64219]

Tue, 04 January 2005 17:34

Shiv
Messages: 20
Registered: May 2002

Junior Member

I have a default installation of oracle 8 on linux. i have a sqlplus client that connects to port 1521 but the connection does not get redirected to another dynamic port. Hence all queries go to the same port 1521. I changed the server config from shared to dedicated but still it doesnt work. How do i get this port redirection thing working? please help.

thanks
Shiv.

Report message to a moderator

Re: port redirection solaris/linux [message #64223 is a reply to message #64219]

Wed, 05 January 2005 00:09

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

I dont understand the requirement.
If you are looking to use another port for listener instead of the default 1521, edit the listener.ora and reconfigure your listener to listen to any port you want.
Port Redirection is something that comes into picture when you can make use of
1. a firewall
2. connection manager
3. If you have an MTS implementation.

In case of WINDOWS operating system, by setting the registry value USE_SHARED_SOCKET=True, you can fix this.
You are using Unix box. so option is ruled out.

Incase of MTS
You can set the ports in initsid.ora like this
mts_dispatchers="(address=(protocol=tcp)(host=hostname)(port=1111))(dispatchers=1)"

mts_dispatchers="(address=(protocol=tcp)(host=hostname)(port=1112))(dispatchers=1)"

Report message to a moderator

Re: port redirection solaris/linux [message #64251 is a reply to message #64223]

Wed, 05 January 2005 22:50

Shiv
Messages: 20
Registered: May 2002

Junior Member

so do u mean that on linux and solaris machines all TNS requests will go to port 1521 only. there is no way to configure a dedicated server kind of set up as we can do in windows where after the TNS connect request is sent to 1521, the server sends a redirect response back to client, thus redirecting him to a different port ???

Report message to a moderator

Re: port redirection solaris/linux [message #64257 is a reply to message #64251]

Thu, 06 January 2005 03:53

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Unix does not perform port redirection for dedicated connections,
unless MTS or SSL or some kind of externnal mechanism (firewall?) is configured.
Using a CMAN might help.

But windows does it.

Reasons is , Unix shares the port.
Windows will NOT share the port.

Report message to a moderator