oracle directory permssions and listener 2004-10-12 - By Trey Gruel
On Tue, 12 Oct 2004, Hollis, Les wrote:
<snip>
> Now, once the connection is MADE, through port 15xx (1521 if you prefer) a
> response is sent to your client that directs the actual connection to a port
> other than that of the listener. Your client then reconnects to the
> database with the port number supplied to it.
>
> Take a look at a listener.log and see what port numbers you are actually
> conversing on somewhere in the 30000 and up range typically.... but not
> always true it depends on the server.
<snip>
I don't think that is correct. The port numbers listed in your logs are,
I believe, the *source* port number. In this example:
12-AUG-2004 11:42:24 *
(CONNECT_DATA=(SID=TRATST)(SERVER=DEDICATED)(CID=(PROGRAM
=)(HOST=rydrsd01)(USER=trfprod))(SERVER=dedicated)) *
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.253.11)(PORT=47478)) * establish *
TRATST * 0
I believe that means that the connection is from 192.168.253.11:47478.
Take a look at netstat. I've got a daemon running with a connection to
Oracle that shows up like this with 'netstat -n' (don't resolve names):
tcp 0 0 127.0.0.1:53932 127.0.0.1:1521
ESTABLISHED
tcp 0 0 127.0.0.1:1521 127.0.0.1:53932
ESTABLISHED
Here's the lsof results as well:
tarlog 19546 logger 5u IPv4 108111853 TCP
127.0.0.1:53932->127.0.0.1:1521 (ESTABLISHED)
oracle 19558 oracle 12u IPv4 108111854 TCP
127.0.0.1:1521->127.0.0.1:53932 (ESTABLISHED)
--
trey
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
