Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
oracle directory permssions and listener

oracle directory permssions and listener

2004-10-12       - By Hollis, Les

Reply:     <<     11     12     13     14     15     16     17     18     19     20     >>  

Oh and Trey, the 192.168.253.11 IS the IP of the database HOST.  

-- --Original Message-- --
From: Trey Gruel [mailto:drathos-suseoracle@(protected)]
Sent: Tuesday, October 12, 2004 1:58 PM
To: suse-oracle@(protected)
Subject: RE: [suse-oracle] oracle directory permssions and listener


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


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting