Ports

[carl airiel]

I just wantde to know what port does the remsh command used?And what port does BCV process used?

Regards

[Sivakumar TS · Accepted solution]

Dear Carl,

TCP 514 is the port used for remsh.

You can find it in the /etc/services ( shell is the service)

With Regards,

Siva.

[carl airiel]

When I'm doing a select statement or sql script on a remote database server,what port am I using. It is the oracle port or the shell port?

Regards,
Allan

[Arunvijai_4]

Hello, You will connnect to Oracle listener which accepts new connection and get authenticated then you can execute any SQL commands. There is no Shell port as you mentioned.

Hope this is clear.

-Arun

[Yogeeraj_1]

Hi,

as mentioned above, you will be connecting to the database through the Oracle Listener.

the default port is actually 1521

you can see the configuration details in the listener.ora file which is found in the $ORACLE_HOME/network/admin directory

hope this helps too!

kind regards
yogeeraj

[Rajesh SB]

Hi Carl,

select statement or sql script on a remote database server using tcp port.

Oracle Database works in Client/Server arch.
When You want to access database across the network, there are 2 ways.

1. SQLNET/Oracle Name Service
Listener on Database server side uses tcp port (typically default. 1521)
Client communicates using tnsnames config to Listener.

2. ODBC/JDBC


Thanks & Regards,
Rajesh

[Muthukumar_5]

Remsh is using two different ports,

1) When using with -n option to execute a command on remote shell then,

shell 514/tcp cmd # remote command, no passwd used

2) When using without -n option then,

login 513/tcp # remote login

You can use netstat -na or lsof tool to find with port is being used by BCV process.

-Muthu