RE: freebie. Summarize Oracle Listener logs
Hi Steve- Quite interested in having a go at it. Please send to me a copy asap. Cheers and regards, CSW Simon. -Original Message-From: Steve Perry [mailto:[EMAIL PROTECTED]Sent: Monday, January 05, 2004 6:29 AMTo: Multiple recipients of list ORACLE-LSubject: freebie. Summarize Oracle Listener logs I wanted to summarize our listener logs to see who's connecting with what tools. I checked google and didn't see anything, so I decided to write one. It may be useful to somebody else. It summarizes the linesof a listener log. the output is similar to Ora Listener Log Summary V0.5Oracle SID: ODP Log File: TSOORDDB.listener.logListener Started at: 06-DEC-2003 07:53:26User Host Program Total PA1DBO TSOORA49 DMSERVER_V4.EXE 6,594PW1DBO TSOORA50 DLLHOST.EXE 1,514IWAM_TSOORA50 TSOORA50 DLLHOST.EXE 600PW2DBO TSOORA56 DLLHOST.EXE 362ITMDBO TSOORA52 SQLPLUS.EXE 166SYSTEM TSOORA56 MAPS_BIZ 88PW3DBO TSOORA57 TD2000.EXE 72ASPNET TSOORA56 ASPNET_WP.EXE 57ORACLE __JDBC__ 41ARCDBO SATSAP09 SQLPLUS.EXE 122KNUPPS SKNUPP-1 TOAD.EXE 7PERRYSM SAIT02547 SQLPLUSW.EXE 62RILEYJ GLEFIO01210 TOAD.EXE 42MASHUA GLEFIO01262 TOAD.EXE 3PA1DBO TSOORA49 DMFILESCAN.EXE 3PA1DBO TSOORA49 DMCLEAN.EXE 3LDQDBO TSOORA24 JREW.EXE 22SHURTN GLEFIO01261 TOAD.EXE 1PW3DBO TSOORA57 DBDBOIN.EXE 1PA1DBO TSOORA49 SQLPLUSW.EXE 1ODDDBO TSOORD08 EXP.EXE 12KNUPPS SKNUPP-1 SQLPLUSW.EXE 1PW2DBO TSOORA56 SQLPLUSW.EXE 1 notes: It sorts in descending order by the connect attempts. all connect lines are counted. It doesn't take into account if the connection was made - only that it was attempted. seperating the failed connections may be a future enhancement. I just wrote it (and some cutting/pasting from the net), so it hasn't been burned in yet. It will process 100 megof logs in few minutes. It was written forwindows only. sorry, I workin a MicroSlop env... I have a cmd file that I use to run it so it can process our current logs or older stuff. Rather than pasting both of theminline, email me and I'll sendthem out. if you want it bad :), email me at work [EMAIL PROTECTED] otherwise use[EMAIL PROTECTED] and I'll get to it when I get home. if somebody optimizes it, cleans it up,finds a flaw..., let me know so I can update it. Steve
RE: freebie. Summarize Oracle Listener logs
Steve,
I have an awk script which does something similar - see code and example below
However I can put your file on my site where I have already stored your Perl script
for getting the DDL out of an export file ( www.hcresources.co.uk) if you wish.
Cheers
John
Service :Host :User :tcp:ip address
===
WMBT_DEV:CHALK :PARKR :tcp:10.33.33.215 13
WMBT_DEV:__jdbc__ :oracle :tcp:10.33.15.38 11
WMBT_DEV:__jdbc__ :oracle :tcp:10.33.15.43 1734
echo Service :Host :User :tcp:ip address
echo ===
grep CONNECT b2tperf.log |\
awk -F= '{print $3 :1: $6 :2: $7 :3: $9 :4: $10 :5: $11}' |\
sed 's/).*:1:/:/' | \
sed 's/).*:2:/:/' | \
sed 's/).*:3:/:/' | \
sed 's/).*:4:/:/' | \
sed 's/).*:5:/:/' | \
sed 's/).*$//' | \
awk -F: '{printf(%-8.8s:%-16.16s:%-16.16s:%-3.3s:%-10.15s\n, \
$1,$2,$3,$4,$5)}' | sort /tmp/j.lis
grep -v PROGRAM /tmp/j.lis /tmp/j1.lis
cat /tmp/j1.lis | awk '{if (data[$0]++ == 0)lines[++count] = $0}\
END{for (i = 1; i = count; i++)print lines[i],\tdata[lines[i]]}'\
|sort -n +4
rm /tmp/j.lis
rm /tmp/j1.lis
-Original Message-
Sent: 05 January 2004 03:29
To: Multiple recipients of list ORACLE-L
I wanted to summarize our listener logs to see who's connecting with what tools. I
checked google and didn't see anything, so I decided to write one. It may be useful to
somebody else.
It summarizes the lines of a listener log. the output is similar to
Ora Listener Log Summary V0.5
Oracle SID: ODP Log File: TSOORDDB.listener.log
Listener Started at: 06-DEC-2003 07:53:26
User Host Program Total
PA1DBO TSOORA49 DMSERVER_V4.EXE 6,594
PW1DBO TSOORA50 DLLHOST.EXE 1,514
IWAM_TSOORA50TSOORA50 DLLHOST.EXE 600
PW2DBO TSOORA56 DLLHOST.EXE 362
ITMDBO TSOORA52 SQLPLUS.EXE 166
SYSTEM TSOORA56 MAPS_BIZ 88
PW3DBO TSOORA57 TD2000.EXE 72
ASPNET TSOORA56 ASPNET_WP.EXE 57
ORACLE __JDBC__41
ARCDBO SATSAP09 SQLPLUS.EXE12
2KNUPPS SKNUPP-1 TOAD.EXE7
PERRYSM SAIT02547SQLPLUSW.EXE6
2RILEYJ GLEFIO01210 TOAD.EXE4
2MASHUA GLEFIO01262 TOAD.EXE3
PA1DBO TSOORA49 DMFILESCAN.EXE 3
PA1DBO TSOORA49 DMCLEAN.EXE 3
LDQDBO TSOORA24 JREW.EXE2
2SHURTN GLEFIO01261 TOAD.EXE1
PW3DBO TSOORA57 DBDBOIN.EXE 1
PA1DBO TSOORA49 SQLPLUSW.EXE1
ODDDBO TSOORD08 EXP.EXE 1
2KNUPPS SKNUPP-1 SQLPLUSW.EXE1
PW2DBO TSOORA56 SQLPLUSW.EXE1
notes:
It sorts in descending order by the connect attempts.
all connect lines are counted. It doesn't take into account if the connection was made
- only that it was attempted. seperating the failed connections may be a future
enhancement.
I just wrote it (and some cutting/pasting from the net), so it hasn't been burned in
yet.
It will process 100 meg of logs in few minutes.
It was written for windows only. sorry, I work in a MicroSlop env...
I have a cmd file that I use to run it so it can process our current logs or older
stuff.
Rather than pasting both of them inline, email me and I'll send them out.
if you want it bad :), email me at work mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
otherwise use [EMAIL PROTECTED] and I'll get to it when I get home.
if somebody optimizes it, cleans it up,finds a flaw..., let me know so I can update it.
Steve
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hallas, John, Tech Dev
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: freebie. Summarize Oracle Listener logs
Sorry - meant to send just to Steve
Please ignore
-Original Message-
Hallas, John, Tech Dev
Sent: 05 January 2004 11:19
To: Multiple recipients of list ORACLE-L
Steve,
I have an awk script which does something similar - see code and example below
However I can put your file on my site where I have already stored your Perl script
for getting the DDL out of an export file ( www.hcresources.co.uk) if you wish.
Cheers
John
Service :Host :User :tcp:ip address
===
WMBT_DEV:CHALK :PARKR :tcp:10.33.33.215 13
WMBT_DEV:__jdbc__ :oracle :tcp:10.33.15.38 11
WMBT_DEV:__jdbc__ :oracle :tcp:10.33.15.43 1734
echo Service :Host :User :tcp:ip address
echo ===
grep CONNECT b2tperf.log |\
awk -F= '{print $3 :1: $6 :2: $7 :3: $9 :4: $10 :5: $11}' |\
sed 's/).*:1:/:/' | \
sed 's/).*:2:/:/' | \
sed 's/).*:3:/:/' | \
sed 's/).*:4:/:/' | \
sed 's/).*:5:/:/' | \
sed 's/).*$//' | \
awk -F: '{printf(%-8.8s:%-16.16s:%-16.16s:%-3.3s:%-10.15s\n, \
$1,$2,$3,$4,$5)}' | sort /tmp/j.lis
grep -v PROGRAM /tmp/j.lis /tmp/j1.lis
cat /tmp/j1.lis | awk '{if (data[$0]++ == 0)lines[++count] = $0}\
END{for (i = 1; i = count; i++)print lines[i],\tdata[lines[i]]}'\
|sort -n +4
rm /tmp/j.lis
rm /tmp/j1.lis
-Original Message-
Sent: 05 January 2004 03:29
To: Multiple recipients of list ORACLE-L
I wanted to summarize our listener logs to see who's connecting with what tools. I
checked google and didn't see anything, so I decided to write one. It may be useful to
somebody else.
It summarizes the lines of a listener log. the output is similar to
Ora Listener Log Summary V0.5
Oracle SID: ODP Log File: TSOORDDB.listener.log
Listener Started at: 06-DEC-2003 07:53:26
User Host Program Total
PA1DBO TSOORA49 DMSERVER_V4.EXE 6,594
PW1DBO TSOORA50 DLLHOST.EXE 1,514
IWAM_TSOORA50TSOORA50 DLLHOST.EXE 600
PW2DBO TSOORA56 DLLHOST.EXE 362
ITMDBO TSOORA52 SQLPLUS.EXE 166
SYSTEM TSOORA56 MAPS_BIZ 88
PW3DBO TSOORA57 TD2000.EXE 72
ASPNET TSOORA56 ASPNET_WP.EXE 57
ORACLE __JDBC__41
ARCDBO SATSAP09 SQLPLUS.EXE12
2KNUPPS SKNUPP-1 TOAD.EXE7
PERRYSM SAIT02547SQLPLUSW.EXE6
2RILEYJ GLEFIO01210 TOAD.EXE4
2MASHUA GLEFIO01262 TOAD.EXE3
PA1DBO TSOORA49 DMFILESCAN.EXE 3
PA1DBO TSOORA49 DMCLEAN.EXE 3
LDQDBO TSOORA24 JREW.EXE2
2SHURTN GLEFIO01261 TOAD.EXE1
PW3DBO TSOORA57 DBDBOIN.EXE 1
PA1DBO TSOORA49 SQLPLUSW.EXE1
ODDDBO TSOORD08 EXP.EXE 1
2KNUPPS SKNUPP-1 SQLPLUSW.EXE1
PW2DBO TSOORA56 SQLPLUSW.EXE1
notes:
It sorts in descending order by the connect attempts.
all connect lines are counted. It doesn't take into account if the connection was made
- only that it was attempted. seperating the failed connections may be a future
enhancement.
I just wrote it (and some cutting/pasting from the net), so it hasn't been burned in
yet.
It will process 100 meg of logs in few minutes.
It was written for windows only. sorry, I work in a MicroSlop env...
I have a cmd file that I use to run it so it can process our current logs or older
stuff.
Rather than pasting both of them inline, email me and I'll send them out.
if you want it bad :), email me at work mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
otherwise use [EMAIL PROTECTED] and I'll get to it when I get home.
if somebody optimizes it, cleans it up,finds a flaw..., let me know so I can update it.
Steve
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hallas, John, Tech Dev
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include
freebie. Summarize Oracle Listener logs
I wanted to summarize our listener logs to see who's connecting with what tools. I checked google and didn't see anything, so I decided to write one. It may be useful to somebody else. It summarizes the linesof a listener log. the output is similar to Ora Listener Log Summary V0.5Oracle SID: ODP Log File: TSOORDDB.listener.logListener Started at: 06-DEC-2003 07:53:26User Host Program Total PA1DBO TSOORA49 DMSERVER_V4.EXE 6,594PW1DBO TSOORA50 DLLHOST.EXE 1,514IWAM_TSOORA50 TSOORA50 DLLHOST.EXE 600PW2DBO TSOORA56 DLLHOST.EXE 362ITMDBO TSOORA52 SQLPLUS.EXE 166SYSTEM TSOORA56 MAPS_BIZ 88PW3DBO TSOORA57 TD2000.EXE 72ASPNET TSOORA56 ASPNET_WP.EXE 57ORACLE __JDBC__ 41ARCDBO SATSAP09 SQLPLUS.EXE 122KNUPPS SKNUPP-1 TOAD.EXE 7PERRYSM SAIT02547 SQLPLUSW.EXE 62RILEYJ GLEFIO01210 TOAD.EXE 42MASHUA GLEFIO01262 TOAD.EXE 3PA1DBO TSOORA49 DMFILESCAN.EXE 3PA1DBO TSOORA49 DMCLEAN.EXE 3LDQDBO TSOORA24 JREW.EXE 22SHURTN GLEFIO01261 TOAD.EXE 1PW3DBO TSOORA57 DBDBOIN.EXE 1PA1DBO TSOORA49 SQLPLUSW.EXE 1ODDDBO TSOORD08 EXP.EXE 12KNUPPS SKNUPP-1 SQLPLUSW.EXE 1PW2DBO TSOORA56 SQLPLUSW.EXE 1 notes: It sorts in descending order by the connect attempts. all connect lines are counted. It doesn't take into account if the connection was made - only that it was attempted. seperating the failed connections may be a future enhancement. I just wrote it (and some cutting/pasting from the net), so it hasn't been burned in yet. It will process 100 megof logs in few minutes. It was written forwindows only. sorry, I workin a MicroSlop env... I have a cmd file that I use to run it so it can process our current logs or older stuff. Rather than pasting both of theminline, email me and I'll sendthem out. if you want it bad :), email me at work [EMAIL PROTECTED] otherwise use[EMAIL PROTECTED] and I'll get to it when I get home. if somebody optimizes it, cleans it up,finds a flaw..., let me know so I can update it. Steve
Re: Listener without IPC
Yes Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 7:24 AM What will happens if I remove all occurence of IPC protocol from communication level, i.e. Listener? Can U work only over TCP/IP? -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener without IPC
Yep. If you remove IPC, then you just can't connect to your database through sqlnet over IPC. direct IPC - bequeath will still work. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 7:24 AM What will happens if I remove all occurence of IPC protocol from communication level, i.e. Listener? Can U work only over TCP/IP? -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ [EMAIL PROTECTED] vices--858-538-5051httpwww.fatcity.zl6SanDiego,California--Mailinglistandweb hostingservices- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Listener without IPC
What will happens if I remove all occurence of IPC protocol from communication level, i.e. Listener? Can U work only over TCP/IP? -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
Thank you very mutch for your replys, Today I finally found the problem. The traceroute shows the good route, but a Ms Proxy Client installed on the server blocked the request apparently. Just disabling it resolve everything. Damien Damien wrote: I have to do netstat -a on the webserver or on the Oracle server? Listener.ora is on the oracle server or on the webserver? I don't have any access on the oracle server and nobody can help on this side. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:14 PM The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. To see if your Win2K server listens on port 1521 open MSDOS 'box' and type: C:\netstat -n Among (many) other things you should see something of this sort: Active Connections Proto Local Address Foreign AddressState TCP192.168.200.38:1031192.168.200.38:1521ESTABLISHED TCP192.168.200.38:1521192.168.200.38:1031ESTABLISHED You could also check contents of LISTENER.ORA file as it should list host name, protocol and listening port. You've mentioned that your problem is inability to acces database from the web server. Normally web server should be sitting in insulated DMZ environmemt, and there *should* be a firewall betweeen database and your web server. May be that's the part you are not aware of and/or not under your control, or it might happen that somebody changed firewall rules leaving your SQL*Net sessions on dry. If you do have DMZ, you should either have SQL*Net aware firewall or you could force Oracle to use static port (look for Metalink Note: 66382.1) as normally SQL*Net ports are dynamically negotiated, and only initial connection negotiation starts on port 1521. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien Babilon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
Damien Your gesture is appreciated. It is a must that such solutions are shared with the list members. GovindanK Thank you very mutch for your replys, Today I finally found the problem. The traceroute shows the good route, but a Ms Proxy Client installed on the server blocked the request apparently. Just disabling it resolve everything. Damien Damien wrote: I have to do netstat -a on the webserver or on the Oracle server? Listener.ora is on the oracle server or on the webserver? I don't have any access on the oracle server and nobody can help on this side. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:14 PM The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. To see if your Win2K server listens on port 1521 open MSDOS 'box' and type: C:\netstat -n Among (many) other things you should see something of this sort: Active Connections Proto Local Address Foreign AddressState TCP192.168.200.38:1031192.168.200.38:1521ESTABLISHED TCP192.168.200.38:1521192.168.200.38:1031ESTABLISHED You could also check contents of LISTENER.ORA file as it should list host name, protocol and listening port. You've mentioned that your problem is inability to acces database from the web server. Normally web server should be sitting in insulated DMZ environmemt, and there *should* be a firewall betweeen database and your web server. May be that's the part you are not aware of and/or not under your control, or it might happen that somebody changed firewall rules leaving your SQL*Net sessions on dry. If you do have DMZ, you should either have SQL*Net aware firewall or you could force Oracle to use static port (look for Metalink Note: 66382.1) as normally SQL*Net ports are dynamically negotiated, and only initial connection negotiation starts on port 1521. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien Babilon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
The database server. This has been run FROM de web server. Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 6:34 PM Damien, What does 200.XX.101.XX refer to, your WEB server or the database server?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, September 02, 2003 8:30 AM To: Multiple recipients of list ORACLE-L I have no access on the Oracle server, then I can't check the tnsnames.ora on it, but they are the sames on both tested clients. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 1:14 PM Hi Damien, have you checked tnsnames.ora on both boxes? Maybe there's a different port or something in the one on the working computer. That would give the exact error you posted. hth, Guido [EMAIL PROTECTED] 02.09.2003 12.59 Uhr Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Listener Lockout Feature
Any idea if a listener lockout feature is going to be added to the listener utility, i.e. lock after x failed login attempts (this is on the listener password). Are failed login attempts logged in the log file? Being lazy on that last question. Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
I have to do netstat -a on the webserver or on the Oracle server? Listener.ora is on the oracle server or on the webserver? I don't have any access on the oracle server and nobody can help on this side. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:14 PM The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. To see if your Win2K server listens on port 1521 open MSDOS 'box' and type: C:\netstat -n Among (many) other things you should see something of this sort: Active Connections Proto Local Address Foreign AddressState TCP192.168.200.38:1031192.168.200.38:1521ESTABLISHED TCP192.168.200.38:1521192.168.200.38:1031ESTABLISHED You could also check contents of LISTENER.ORA file as it should list host name, protocol and listening port. You've mentioned that your problem is inability to acces database from the web server. Normally web server should be sitting in insulated DMZ environmemt, and there *should* be a firewall betweeen database and your web server. May be that's the part you are not aware of and/or not under your control, or it might happen that somebody changed firewall rules leaving your SQL*Net sessions on dry. If you do have DMZ, you should either have SQL*Net aware firewall or you could force Oracle to use static port (look for Metalink Note: 66382.1) as normally SQL*Net ports are dynamically negotiated, and only initial connection negotiation starts on port 1521. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener Lockout Feature
Whoops, disregard my last post - do you mean logging on to lsnrctl? -Original Message- Post, Ethan Sent: 03 September 2003 17:39 To: Multiple recipients of list ORACLE-L Any idea if a listener lockout feature is going to be added to the listener utility, i.e. lock after x failed login attempts (this is on the listener password). Are failed login attempts logged in the log file? Being lazy on that last question. Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener Lockout Feature
Hi Ethan, I have not heard that Oracle will include a lock out or the listener but I did hear that they will change the listener to allow the text strings to be changed dynamically so that listeners can be made silent in terms of the banner info they give out. It would be nice if Oracle did put a lock out on the listener though to prevent brute force attacks and password management features - Are you listening Mary Ann?? The listener can be easily brute forced as there is as you know no lock out and no facilities to enforce strong passwords. Brute forcing is easy just send a lot of set password commands to the listener from a script. failed attempts will be sent to the log file as error TNS-01169 if logging is set with set log_status on. hth kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
Good idea, here is the output of my telnet: C:\telnet 200.XX.101.XX 1521 Connecting To 200.XX.101.37...Could not open a connection to host on port 1521 : Connect failed C:\telnet 200.55.101.XX 1526 Connecting To 200.XX.101.XX...Could not open a connection to host on port 1526 : Connect failed Ping did'n work... maybe because port 8 is closed on the oracle server. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 9:44 PM Wolfgang, if I were him, I would first try with ping and telnet to the port. That can be any number of things. For instance, SA might have changed the IP address of the box and the name server and his PC is not updated and so the tns descriptor is desperately trying to cajole network printer into providing a connection on port 1521. I've actually had such a case. It's a very good thing that the fire alarms are usually not accessible by using the TCP protocol. -- Mladen Gogala Oracle DBA -Original Message- Wolfgang Breitling Sent: Tuesday, September 02, 2003 3:15 PM To: Multiple recipients of list ORACLE-L Is there a sqlnet.ora file on the PC that can connect? If so copy that as well. Maybe that pc is not even using the tnsnames.ora. At 10:44 AM 9/2/2003 -0800, you wrote: TNSPING sends a message to some host on (in your case) port 1521 and finds no program listening on this port and answering. There are several possibilities : o You are addressing the wrong port. Check on which one you are 'talking' from the other machine, o Or you are prevented from opening a connection on port 1521 from your machine HTH, The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener Lockout Feature
Ethan, You can do this with profiles. Here's an example by Connor McDonald, on Jonathan Lewis' site: http://www.jlcomp.demon.co.uk/faq/password_expiry.html HTH Mark === Mark Leith | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original Message- Post, Ethan Sent: 03 September 2003 17:39 To: Multiple recipients of list ORACLE-L Any idea if a listener lockout feature is going to be added to the listener utility, i.e. lock after x failed login attempts (this is on the listener password). Are failed login attempts logged in the log file? Being lazy on that last question. Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener Lockout Feature
Listener password failures do not lock the password, unfortunately; but it is possible to identify the failed logins. The listener log shows entries similar to the lines below 05-JUL-2003 21:14:39 * services * 1169 TNS-01169: The listener has not recognized the password Note the lines TNS-01169: The listener has not recognized the password , which could mean as simple as a fat fingered DBA or repeated attempts to break in. As a rule of thumb, I scan TNS-01169 errors and review them periodically. HTH. Arup Nanda www.proligence.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 12:39 PM Any idea if a listener lockout feature is going to be added to the listener utility, i.e. lock after x failed login attempts (this is on the listener password). Are failed login attempts logged in the log file? Being lazy on that last question. Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener Lockout Feature
Yeah -Original Message- Sent: Wednesday, September 03, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Whoops, disregard my last post - do you mean logging on to lsnrctl? -Original Message- Post, Ethan Sent: 03 September 2003 17:39 To: Multiple recipients of list ORACLE-L Any idea if a listener lockout feature is going to be added to the listener utility, i.e. lock after x failed login attempts (this is on the listener password). Are failed login attempts logged in the log file? Being lazy on that last question. Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Listener problem on one client computer
Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem on one client computer
Hi Damien, have you checked tnsnames.ora on both boxes? Maybe there's a different port or something in the one on the working computer. That would give the exact error you posted. hth, Guido [EMAIL PROTECTED] 02.09.2003 12.59 Uhr Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
I have no access on the Oracle server, then I can't check the tnsnames.ora on it, but they are the sames on both tested clients. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 1:14 PM Hi Damien, have you checked tnsnames.ora on both boxes? Maybe there's a different port or something in the one on the working computer. That would give the exact error you posted. hth, Guido [EMAIL PROTECTED] 02.09.2003 12.59 Uhr Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem on one client computer
Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien TNSPING sends a message to some host on (in your case) port 1521 and finds no program listening on this port and answering. There are several possibilities : o You are addressing the wrong port. Check on which one you are 'talking' from the other machine, o Or you are prevented from opening a connection on port 1521 from your machine HTH, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem on one client computer
Damien, What does 200.XX.101.XX refer to, your WEB server or the database server?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, September 02, 2003 8:30 AM To: Multiple recipients of list ORACLE-L I have no access on the Oracle server, then I can't check the tnsnames.ora on it, but they are the sames on both tested clients. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 1:14 PM Hi Damien, have you checked tnsnames.ora on both boxes? Maybe there's a different port or something in the one on the working computer. That would give the exact error you posted. hth, Guido [EMAIL PROTECTED] 02.09.2003 12.59 Uhr Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem on one client computer
he should try something like telnet server 1521 If the server is found but connection is immediately refused, then listener is not started on the server or is started at another port. If the connection appears to be hanging, then there is a server on port 1521, but there is a problem with it. -- Mladen Gogala Oracle DBA -Original Message- Goulet, Dick Sent: Tuesday, September 02, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Damien, What does 200.XX.101.XX refer to, your WEB server or the database server?? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, September 02, 2003 8:30 AM To: Multiple recipients of list ORACLE-L I have no access on the Oracle server, then I can't check the tnsnames.ora on it, but they are the sames on both tested clients. Best regards, Damien - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 1:14 PM Hi Damien, have you checked tnsnames.ora on both boxes? Maybe there's a different port or something in the one on the working computer. That would give the exact error you posted. hth, Guido [EMAIL PROTECTED] 02.09.2003 12.59 Uhr Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual
Re: Listener problem on one client computer
TNSPING sends a message to some host on (in your case) port 1521 and finds no program listening on this port and answering. There are several possibilities : o You are addressing the wrong port. Check on which one you are 'talking' from the other machine, o Or you are prevented from opening a connection on port 1521 from your machine HTH, The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. Best regards, Damien Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem on one client computer
The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. To see if your Win2K server listens on port 1521 open MSDOS 'box' and type: C:\netstat -n Among (many) other things you should see something of this sort: Active Connections Proto Local Address Foreign AddressState TCP192.168.200.38:1031192.168.200.38:1521ESTABLISHED TCP192.168.200.38:1521192.168.200.38:1031ESTABLISHED You could also check contents of LISTENER.ORA file as it should list host name, protocol and listening port. You've mentioned that your problem is inability to acces database from the web server. Normally web server should be sitting in insulated DMZ environmemt, and there *should* be a firewall betweeen database and your web server. May be that's the part you are not aware of and/or not under your control, or it might happen that somebody changed firewall rules leaving your SQL*Net sessions on dry. If you do have DMZ, you should either have SQL*Net aware firewall or you could force Oracle to use static port (look for Metalink Note: 66382.1) as normally SQL*Net ports are dynamically negotiated, and only initial connection negotiation starts on port 1521. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
Is there a sqlnet.ora file on the PC that can connect? If so copy that as well. Maybe that pc is not even using the tnsnames.ora. At 10:44 AM 9/2/2003 -0800, you wrote: TNSPING sends a message to some host on (in your case) port 1521 and finds no program listening on this port and answering. There are several possibilities : o You are addressing the wrong port. Check on which one you are 'talking' from the other machine, o Or you are prevented from opening a connection on port 1521 from your machine HTH, The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener problem on one client computer
Wolfgang, if I were him, I would first try with ping and telnet to the port. That can be any number of things. For instance, SA might have changed the IP address of the box and the name server and his PC is not updated and so the tns descriptor is desperately trying to cajole network printer into providing a connection on port 1521. I've actually had such a case. It's a very good thing that the fire alarms are usually not accessible by using the TCP protocol. -- Mladen Gogala Oracle DBA -Original Message- Wolfgang Breitling Sent: Tuesday, September 02, 2003 3:15 PM To: Multiple recipients of list ORACLE-L Is there a sqlnet.ora file on the PC that can connect? If so copy that as well. Maybe that pc is not even using the tnsnames.ora. At 10:44 AM 9/2/2003 -0800, you wrote: TNSPING sends a message to some host on (in your case) port 1521 and finds no program listening on this port and answering. There are several possibilities : o You are addressing the wrong port. Check on which one you are 'talking' from the other machine, o Or you are prevented from opening a connection on port 1521 from your machine HTH, The ports are the same, I've checked the tnsnames.ora files and copied pasted the content of the box who work on the web server. Still same prob. How can I check if i can open the port? It's a Win2000 server. Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem on one client computer
May be Metalink note 111910.1 will help you. HTH GovindanK Hi everybody, I'm new to the list, I don't know anything about oracle. I have make a script to get some informations by stored procedures on a remote server. I can't access this server, and can't get logs from it. Since 5 days, I have a tns-listener problem with this server. He did'n reply anymore. This problems occurs only from one machine (my web server from where the strored procedure are executed) I've tryed from another computer into the lan and I get responses from the server. Here is the output from tnsping: TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 02-SEP-2003 11:11:41 (c) Copyright 1997 Oracle Corporation. All rights reserved. Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=200.XX.101.XX)(PORT=1521)) TNS-12541: TNS:no listener The tracert output are the sames on the working box the web server. Please, help me... I don't know what to do ! On my side (web server) nothing has been changed since 5 days. Best regards and thank's in advance, Damien -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Damien INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file or
Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER=service_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file or
Madhu, Can you ping the host? BTW, please use '!'s sparingly - I couldn't help but noticed that most of your message carry a few. They should be used for emergencies not just attention grabbers. Dennis -Original Message- Sent: Friday, August 15, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER=service_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file
check listener.ora and the hostname of the box for resoltution problems. -Original Message- Sent: Friday, August 15, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER=ser vice_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file or
Madhu, If you are sure you are starting all the listeners, not just the default listener but named listeners as well (if any). I would look into the HPUX error next. What is file or directory is it looking for? I would examine the listener.ora closely and verify that the logging/tracing directories exist and the appropriate permissions are in place. Cross-check the listener.ora entries with the tnsnames.ora entries to make sure someone hasn't accidentally updated either file with invalid information. Carol -Original Message- Sent: Friday, August 15, 2003 1:34 PM To: Multiple recipients of list ORACLE-L file or Madhu, Can you ping the host? BTW, please use '!'s sparingly - I couldn't help but noticed that most of your message carry a few. They should be used for emergencies not just attention grabbers. Dennis -Original Message- Sent: Friday, August 15, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER =service_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pena, Carol A INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file or
Several possibilities: The host you specified in listener.ora does not exist or your machine is unable to recognize it. That usually happens when hosts are known under many nicknames and, of course, the host recognizes only some of them. You are trying to resolve the hostname by using a name server (/etc/nsswitch.conf) and you don't have /etc/resolv.conf properly configured (at least nameserver entry must be configured). So, figure out what's wrong with your network setup and put 127.0.0.1 in listener.ora in the meantime. If that address is unreachable, then there is something seriously wrong with your box. -- Mladen Gogala Oracle DBA -Original Message- Reddy, Madhusudana Sent: Friday, August 15, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER=ser vice_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file
i always did like that about the internet, i can telnet to 127.0.0.1 on ANY server and it knows my userid/passwd, total awesome. joe Mladen Gogala wrote: Several possibilities: The host you specified in listener.ora does not exist or your machine is unable to recognize it. That usually happens when hosts are known under many nicknames and, of course, the host recognizes only some of them. You are trying to resolve the hostname by using a name server (/etc/nsswitch.conf) and you don't have /etc/resolv.conf properly configured (at least nameserver entry must be configured). So, figure out what's wrong with your network setup and put 127.0.0.1 in listener.ora in the meantime. If that address is unreachable, then there is something seriously wrong with your box. -- Mladen Gogala Oracle DBA -Original Message- Reddy, Madhusudana Sent: Friday, August 15, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER=ser vice_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file
Yeah, that host is always reachable. As for the telnet, I don't run that thingy any more. It's ssh localhost, not telnet localhost. Telnet is politically incorect. -- Mladen Gogala Oracle DBA -Original Message- Testa Sent: Friday, August 15, 2003 3:59 PM To: Multiple recipients of list ORACLE-L i always did like that about the internet, i can telnet to 127.0.0.1 on ANY server and it knows my userid/passwd, total awesome. joe Mladen Gogala wrote: Several possibilities: The host you specified in listener.ora does not exist or your machine is unable to recognize it. That usually happens when hosts are known under many nicknames and, of course, the host recognizes only some of them. You are trying to resolve the hostname by using a name server (/etc/nsswitch.conf) and you don't have /etc/resolv.conf properly configured (at least nameserver entry must be configured). So, figure out what's wrong with your network setup and put 127.0.0.1 in listener.ora in the meantime. If that address is unreachable, then there is something seriously wrong with your box. -- Mladen Gogala Oracle DBA -Original Message- Reddy, Madhusudana Sent: Friday, August 15, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USE R=ser vice_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file
very true and telnet service is usually disabled but localhost it just doesn't have the confusion for the newbies as 127.0.0.1 does joe Mladen Gogala wrote: Yeah, that host is always reachable. As for the telnet, I don't run that thingy any more. It's ssh localhost, not telnet localhost. Telnet is politically incorect. -- Mladen Gogala Oracle DBA -Original Message- Testa Sent: Friday, August 15, 2003 3:59 PM To: Multiple recipients of list ORACLE-L i always did like that about the internet, i can telnet to 127.0.0.1 on ANY server and it knows my userid/passwd, total awesome. joe Mladen Gogala wrote: Several possibilities: The host you specified in listener.ora does not exist or your machine is unable to recognize it. That usually happens when hosts are known under many nicknames and, of course, the host recognizes only some of them. You are trying to resolve the hostname by using a name server (/etc/nsswitch.conf) and you don't have /etc/resolv.conf properly configured (at least nameserver entry must be configured). So, figure out what's wrong with your network setup and put 127.0.0.1 in listener.ora in the meantime. If that address is unreachable, then there is something seriously wrong with your box. -- Mladen Gogala Oracle DBA -Original Message- Reddy, Madhusudana Sent: Friday, August 15, 2003 2:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USE R=ser vice_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file
Not on ANY server. MANY, perhaps, but not ANY. Doesn't work for our HP/UX 11.0 servers here, nor my RH7.2/RH8.0 boxes at home. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Joe Testa [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file i always did like that about the internet, i can telnet to 127.0.0.1 on ANY server and it knows my userid/passwd, total awesome. joe Mladen Gogala wrote: Several possibilities: The host you specified in listener.ora does not exist or your machine is unable to recognize it. That usually happens when hosts are known under many nicknames and, of course, the host recognizes only some of them. You are trying to resolve the hostname by using a name server (/etc/nsswitch.conf) and you don't have /etc/resolv.conf properly configured (at least nameserver entry must be configured). So, figure out what's wrong with your network setup and put 127.0.0.1 in listener.ora in the meantime. If that address is unreachable, then there is something seriously wrong with your box. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file
Let me rephrase it: it works on any machine which has telnet service up and running in shape or form, even on Windoze. -- Mladen Gogala Oracle DBA -Original Message- Jesse, Rich Sent: Friday, August 15, 2003 4:44 PM To: Multiple recipients of list ORACLE-L Not on ANY server. MANY, perhaps, but not ANY. Doesn't work for our HP/UX 11.0 servers here, nor my RH7.2/RH8.0 boxes at home. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Joe Testa [mailto:[EMAIL PROTECTED] Sent: Friday, August 15, 2003 2:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such file i always did like that about the internet, i can telnet to 127.0.0.1 on ANY server and it knows my userid/passwd, total awesome. joe Mladen Gogala wrote: Several possibilities: The host you specified in listener.ora does not exist or your machine is unable to recognize it. That usually happens when hosts are known under many nicknames and, of course, the host recognizes only some of them. You are trying to resolve the hostname by using a name server (/etc/nsswitch.conf) and you don't have /etc/resolv.conf properly configured (at least nameserver entry must be configured). So, figure out what's wrong with your network setup and put 127.0.0.1 in listener.ora in the meantime. If that address is unreachable, then there is something seriously wrong with your box. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT !!! Listener Errors !!! ( HPUX Error: 2: No such
The only time I have seen this is when the server process could not be started because the database shared segment did not exist or an executable that was pointed to in the TNS entry actually did not exist. HP-UX error 2 is file not found so I think you are looking at the later case. It looks very much like you are trying to establish a dedicated connection through an mts dispatcher. Allan -Original Message- Sent: Friday, August 15, 2003 1:14 PM To: Multiple recipients of list ORACLE-L Have you seen this before 15-AUG-2003 12:10:34 * (CONNECT_DATA=(SID=rtprod)(CID=(PROGRAM=dllhost.exe)(HOST=DS01IWEB)(USER =service_mts))) * (ADDRESS=(PROTOCOL=tcp)(HOST=172.16.12.10)(PORT=1672)) * establish * rtprod * 12500 TNS-12500: TNS:listener failed to start a dedicated server process TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error TNS-00515: Connect failed because target host or object does not exist HPUX Error: 2: No such file or directory I have already bounced the listener 3 times . Almost no help from ORACLE so far . Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How can I turn Oracle listener on for Oracle 9i on solaris - FYI
Hi, My servers are power off. Now I get the power and start them up. I would like to know how to start Oracle 9.2 listener on Solaris platform so that my program can talk to it. Any suggestions are appreciated! Thanks in advance! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How can I turn Oracle listener on for Oracle 9i on solaris - FYI
lsnrctl start -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 18, 2003 11:09 AM Hi, My servers are power off. Now I get the power and start them up. I would like to know how to start Oracle 9.2 listener on Solaris platform so that my program can talk to it. Any suggestions are appreciated! Thanks in advance! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How can I turn Oracle listener on for Oracle 9i on solaris - FYI
lsnrctl start Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, July 18, 2003 2:09 PM To: Multiple recipients of list ORACLE-L FYI Hi, My servers are power off. Now I get the power and start them up. I would like to know how to start Oracle 9.2 listener on Solaris platform so that my program can talk to it. Any suggestions are appreciated! Thanks in advance! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
listener
Is it possible to have listner running on box a while databases running on X,Y,Z . If yes , then how does oracle instance find the address of the box running the listner , if I configure ini.ora with service_name . Does it mean that local tnsnames.ora file ( on server X,Y,Z) should haave an entry for this service_name . -ak
Re: listener
Hi! Your databases actually have to register with your listener on remote machine. Your databases have to have tnsnames.ora configured with entry for listener location as well and your instances' REMOTE_LISTENER parameter has to specify the tns alias for listener location. That way databases can register themselves with listener and give it all necessary connect information. I believe that you actually can specify the whole tns address string for remote_listener parameter, like you can do with local_listener... Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 16, 2003 10:44 PM Subject: listener Is it possible to have listner running on box a while databases running on X,Y,Z . If yes , then how does oracle instance find the address of the box running the listner , if I configure ini.ora with service_name . Does it mean that local tnsnames.ora file ( on server X,Y,Z) should haave an entry for this service_name . -ak
RE: oracle listener (auto increment value for PK)
Hi Markus! Here's a recipe that might help you (assuming your table is called MYTABLE: 1. create a sequence: CREATE SEQUENCE MYTABLE_Sequence start with 1 increment by 1 nocycle nocache; 2. create an insert trigger CREATE OR REPLACE TRIGGER MYTABLE_Insert_Trigger BEFORE INSERT ON MYTABLE FOR EACH ROW DECLARE n PLS_INTEGER; BEGIN -- get the next auto increment value SELECT MYTABLE_Sequence.NEXTVAL INTO n FROM DUAL; -- assign the value to the ID of the row that is being inserted :NEW.ID:=n; END; / HTH Servus! Andreas -Original Message- Sent: Monday, July 14, 2003 10:39 PM To: Multiple recipients of list ORACLE-L hi i run oracle8 on w2000 advanced server. my question is how to create a auto increment primary key for this table: id number(5) name varchar(12) id should auto increment after inserting a new datarow must i create a trigger ? excuse my bad english thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle listener (auto increment value for PK)
Sorry I meant Hi Martin -Original Message- Sent: Tuesday, July 15, 2003 8:59 PM To: Multiple recipients of list ORACLE-L Hi Markus! Here's a recipe that might help you (assuming your table is called MYTABLE: 1. create a sequence: CREATE SEQUENCE MYTABLE_Sequence start with 1 increment by 1 nocycle nocache; 2. create an insert trigger CREATE OR REPLACE TRIGGER MYTABLE_Insert_Trigger BEFORE INSERT ON MYTABLE FOR EACH ROW DECLARE n PLS_INTEGER; BEGIN -- get the next auto increment value SELECT MYTABLE_Sequence.NEXTVAL INTO n FROM DUAL; -- assign the value to the ID of the row that is being inserted :NEW.ID:=n; END; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LISTENER ON LINUX
A simple ps -ef|grep lsnr will work. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Friday, July 11, 2003 11:20 AM To: Multiple recipients of list ORACLE-L Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't show but when I tried to see the status thru lsnrctl status listener_name .its shows service handler. How to check whether listener is running or not and how to start that? thx -seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oracle listener
hi i run oracle8 on w2000 advanced server. my question is how to create a auto increment primary key for this table: id number(5) name varchar(12) id should auto increment after inserting a new datarow must i create a trigger ? excuse my bad english thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle listener
Hello Martin, You can create a sequence in Oracle and assign it to the table. You don';t have to create trigger on it. Hope this helps Raju. sorry for my english too :) --- pfeffer [EMAIL PROTECTED] wrote: hi i run oracle8 on w2000 advanced server. my question is how to create a auto increment primary key for this table: id number(5) name varchar(12) id should auto increment after inserting a new datarow must i create a trigger ? excuse my bad english thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: raju angani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
listener newbie
hi i has configured my listener but if i try to ping i get the error: target host or object does not exist. means the server in the config the database name or the computername i run ora8 on w2000 server thx martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: pfeffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LISTENER ON LINUX
Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't show but when I tried to see the status thru lsnrctl status listener_name .its shows service handler. How to check whether listener is running or not and how to start that? thx -seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LISTENER ON LINUX
use ps -lax instead Ciao Fuzzy :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Seema Singh Sent: Friday, July 11, 2003 17:20 To: Multiple recipients of list ORACLE-L Subject: LISTENER ON LINUX Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't show but when I tried to see the status thru lsnrctl status listener_name .its shows service handler. How to check whether listener is running or not and how to start that? thx -seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LISTENER ON LINUX
That's because it's truncating the line. Try ps -eflll instead. --Walt Weaver Bozeman, Montana -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Seema Singh Sent: Friday, July 11, 2003 17:20 To: Multiple recipients of list ORACLE-L Subject: LISTENER ON LINUX Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't show but when I tried to see the status thru lsnrctl status listener_name .its shows service handler. How to check whether listener is running or not and how to start that? thx -seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LISTENER ON LINUX
ps -efw|grep tns -Candi On Fri, 2003-07-11 at 12:19, Seema Singh wrote: Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't show but when I tried to see the status thru lsnrctl status listener_name .its shows service handler. How to check whether listener is running or not and how to start that? thx -seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boyle Candi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LISTENER ON LINUX
Try 'lsof -i |egrep (TCP|UDP) to see what's got the address bound. Lsof is a freely available tool that should be installed on all unix boxes, IMHO. :-) -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Seema Singh Sent: Wednesday, July 02, 2003 2:36 PM To: Multiple recipients of list ORACLE-L Subject: LISTENER ON LINUX Hi, When I am trying to start listener on Linux box ,getting error TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use I checked no process fro listener and no port used by another process. Let me know how to fix that pl thx -Seema _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rich Holland INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
listener
one can configure init.ora file so that instance registers itself with listener ( oracle 8i ) . what happens if the listener is stopped after that ( registering )? Does it require boucing those instances which register themselves to listener ? -ak
Re: listener
try it and see, the best way to learn. joe AK wrote: one can configure init.ora file so that instance registers itself with listener ( oracle 8i ) . what happens if the listener is stopped after that ( registering ) ? Does it require boucing those instances which register themselves to listener ? -ak -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: listener
In 9i, there is command alter system register which does the trick. In 8i, it takes approximately 15 minutes for the instance to re-register with the listener. On 2003.07.08 20:44, Joe Testa wrote: try it and see, the best way to learn. joe AK wrote: one can configure init.ora file so that instance registers itself with listener ( oracle 8i ) . what happens if the listener is stopped after that ( registering ) ? Does it require boucing those instances which register themselves to listener ? -ak -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: listener
If the listener is stopped, then within 60 seconds of restarting, the running services will be registered with the newly started listener again. At least this is the case on AIX and Solaris servers. HTH, -Ron- -Original Message- Testa Sent: Tuesday, July 08, 2003 7:44 PM To: Multiple recipients of list ORACLE-L try it and see, the best way to learn. joe AK wrote: one can configure init.ora file so that instance registers itself with listener ( oracle 8i ) . what happens if the listener is stopped after that ( registering ) ? Does it require boucing those instances which register themselves to listener ? -ak -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the CACHE -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Yount INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LISTENER ON LINUX
1521 and 1522 netstat 9i From: Gogala, Mladen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: LISTENER ON LINUX Date: Wed, 02 Jul 2003 11:15:56 -0800 What is the port? How did you check that it wasn't used? Which distro, which version of the database? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 02, 2003 2:36 PM To: Multiple recipients of list ORACLE-L Hi, When I am trying to start listener on Linux box ,getting error TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use I checked no process fro listener and no port used by another process. Let me know how to fix that pl thx -Seema _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
LISTENER ON LINUX
Hi, When I am trying to start listener on Linux box ,getting error TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use I checked no process fro listener and no port used by another process. Let me know how to fix that pl thx -Seema _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LISTENER ON LINUX
Sounds like a duplicated IP or duplicated Service name. Luis -Original Message- Sent: Wednesday, July 02, 2003 12:36 PM To: Multiple recipients of list ORACLE-L Hi, When I am trying to start listener on Linux box ,getting error TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use I checked no process fro listener and no port used by another process. Let me know how to fix that pl thx -Seema _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Luis deUrioste INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LISTENER ON LINUX
What is the port? How did you check that it wasn't used? Which distro, which version of the database? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 02, 2003 2:36 PM To: Multiple recipients of list ORACLE-L Hi, When I am trying to start listener on Linux box ,getting error TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use I checked no process fro listener and no port used by another process. Let me know how to fix that pl thx -Seema _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Application Server Listener Anomalies
OAS 4.0.8.2.4 running on Windows 2000 SP2, connecting to Oracle 7.3.4.5 database. Server housing OAS regularly rebooted at 4:00 a.m. every morning. Hi Everyone, We have recently had some anomalies with our OAS server. On the weekend, we had an internal user try to connect to our web application they were not successful, the browser returned the standard error message (with a lot of text) indicating that it was not able to retrieve the page. Other users had experienced the same problem. The problem was resolved by rebooting the server, then running the batch file to start the OAS listener(s). On Monday morning we looked in the log files associated with OAS. It showed the reboot occurred at 10:05 p.m. It also showed connections to OAS as late as ten minutes before the reboot. In fact, it showed a light stream of connections right up to the time OAS was restarted. One of our other tech people had a utility running over the weekend that was connecting to the web application every 30 minutes. This showed successful connections all day Sunday, except at the planned and scheduled reboot time at 4:00 a.m. Sunday morning and the unplanned reboot at 10:00 p.m. So, we have a situation where some are able to access our web application, and others are not able to. Anybody ever experienced a problem like this? Can anybody hazard a guess why we have this erratic behavior? Thanks for your input, Sam
Re: Listener showing 2 service handlers for the same service
Naveen, Do you have local_listener set in your init.ora file? -Ravi. --- Naveen Nahata [EMAIL PROTECTED] wrote: Hi All, When I start the listener, after sometimes the instance registers itself with the listener. After this the status of the listener shows 2 service handlers for the same service. For the sake of clarity I'm pasting the output and listener.ora file. Initial Status: --- Services Summary... PLSExtProchas 1 service handler(s) The command completed successfully After instance registers itself: Services Summary... PLSExtProchas 1 service handler(s) salesnet has 2 service handler(s) The command completed successfully listener.ora - SID_LIST_817_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = F:\Oracle\Ora817) (PROGRAM = extproc) ) ) 817_LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = DT309-NaveenN)(PORT = 1521)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) ) ) Any help or pointers on what can be the issue? Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ravi Kulkarni INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Listener showing 2 service handlers for the same service
Hi All, When I start the listener, after sometimes the instance registers itself with the listener. After this the status of the listener shows 2 service handlers for the same service. For the sake of clarity I'm pasting the output and listener.ora file. Initial Status: --- Services Summary... PLSExtProchas 1 service handler(s) The command completed successfully After instance registers itself: Services Summary... PLSExtProchas 1 service handler(s) salesnet has 2 service handler(s) The command completed successfully listener.ora - SID_LIST_817_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = F:\Oracle\Ora817) (PROGRAM = extproc) ) ) 817_LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = DT309-NaveenN)(PORT = 1521)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) ) ) Any help or pointers on what can be the issue? Regards Naveen DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Can't start listener after installing 9.2.0.3 Patch ?
Guys, I have installed 9.2.0.3 Patch over 9.2.0.1 on a win2k server machine ( DELL PE2650 Xeon ). i followed the README file along with patch. while installing the patch,the universal installer requested to stop DISTRIBUTED TRANSACTION COORDINATOR service on the OS. after stopping that,the installation of the patch was successful. but while starting the listener,i get the error: PROCEDURE ENTRY POINT OF LXHLCMOD NOT FOUND IN ORANLS9.DLL. and i am not able to start the listener. am i missing out something ? have anyone faced the same before ? TIA. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
8i databases under 9i listener?
Title: 8i databases under 9i listener? RS6000 running AIX 4.3.3. We are experiencing the following issues with our 8.1.7.4 databases under a 9.2.0.1 listener. 1) PL/SQL procedures utilizing UTL_FILE fail with INVALID_PATH errors when attempting to open a file. 2) Database links from WE8ISO8859P1 databases to UTF8 databases fail with ORA-3113. Database links work fine as long as the character set is the same on both databases. We've checked, and double-check, all environment variables, O/S permissions, and so forth. Oracle Support has been basically useless. Eventually, they stated that these problems are unique to the AIX platform, and not something that they've seen on HP or Solaris, and recommended running both the 8i and 9i listeners, in other words, they had no clue. The sequence of events went like this: Feb 7th -- 9.2.0.1 was installed on our test/development box, on which there are eight 8.1.7.4 instances running. Feb 14th -- We startup the 9i listener and shutdown the 8i listener. Feb 21st -- First upgrade of an 8.1.7.4 database to 9.2.0.1. The upgrade was successful. The funny thing is that none of the 8.1.7.4 databases had any problems with the 9i listener from Feb 14th to Feb 21st, either with UTL_FIL or with database links. But on Feb 21st, after the first 9.2.0.1 database upgrade, the 9i listener was bounced for the first time since it's inception, and then all the problems started. We are back to running both an 8i and 9i listener for the time being, but I have a lurking suspicion that something is not right somewhere, and could come back and bite us in the future. Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba Select 'Indy DBA' then 'DBA Web Pages' --- As of February 12, 2003 Thomson unified its email addresses on a worldwide basis. Please note my new email address: [EMAIL PROTECTED] Thomson is the leader in solutions and technologies for the entertainment and media industries and serves its customers under its four strategic brands: Technicolor, Grass Valley, RCA and THOMSON. More about Thomson: http://www.thomson.net/videochain
RE: 8i databases under 9i listener?
Title: Message We are also finding difficulties with a mixed Oracle environment. We are running AIX 4.3.3-ML10, Oracle 8.1.7.3-EE-64 bit, PeopleSoft 8.18 and moving to Oracle 9.2.0.2. In the past, when moving to a new Oracle release, we would install the software, upgrade our listener, and then start to upgrade our instances, one by one. This go around, after upgrading our listener to 9.2.0.2, when PeopleSoft tries to connect to a 8.1.7.3 database using the 9.2.0.2 listener, the process fails with the message "ORA-01890 NLS error detected". This is happening both when a PS App Server is connecting to Oracle and when the PS client program connects in 2-tier mode. We didn't see this type of behavior with other tools (SQL+, Toad, etc.) connecting to Oracle, so we thought it was a PS problem and reported it to their support center without much progress. In the mean time, we have reconfigured so that we are now running 2 listeners on the box, one for Oracle 8i and one for Oracle 9iR2. So far, we have not found a problem with Oracle 9iR2 databases interacting with like listeners, but our testing continues. If anyone else on this list can shine some light on this problem, please do. -- *---* Stephen T. Murphy Manager, Database and Technical Support ITS - University Applications Development MSC-100 The University at Albany, S.U.N.Y Albany, New York 1 Phone: (518) 437-4523 Fax: (518) 437-4540 MailTo: [EMAIL PROTECTED] AIM: SMurphy199 -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 8:05 AMTo: Multiple recipients of list ORACLE-LSubject: 8i databases under 9i listener? RS6000 running AIX 4.3.3. We are experiencing the following issues with our 8.1.7.4 databases under a 9.2.0.1 listener. 1) PL/SQL procedures utilizing UTL_FILE fail with INVALID_PATH errors when attempting to open a file. 2) Database links from WE8ISO8859P1 databases to UTF8 databases fail with ORA-3113. Database links work fine as long as the character set is the same on both databases. We've checked, and double-check, all environment variables, O/S permissions, and so forth. Oracle Support has been basically useless. Eventually, they stated that these problems are unique to the AIX platform, and not something that they've seen on HP or Solaris, and recommended running both the 8i and 9i listeners, in other words, they had no clue. The sequence of events went like this: Feb 7th -- 9.2.0.1 was installed on our test/development box, on which there are eight 8.1.7.4 instances running. Feb 14th -- We startup the 9i listener and shutdown the 8i listener. Feb 21st -- First upgrade of an 8.1.7.4 database to 9.2.0.1. The upgrade was successful. The funny thing is that none of the 8.1.7.4 databases had any problems with the 9i listener from Feb 14th to Feb 21st, either with UTL_FIL or with database links. But on Feb 21st, after the first 9.2.0.1 database upgrade, the 9i listener was bounced for the first time since it's inception, and then all the problems started. We are back to running both an 8i and 9i listener for the time being, but I have a lurking suspicion that something is not right somewhere, and could come back and bite us in the future. Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba Select 'Indy DBA' then 'DBA Web Pages' --- As of February 12, 2003 Thomson unified its email addresses on a worldwide basis. Please note my new email address: [EMAIL PROTECTED] Thomson is the leader in solutions and technologies for the entertainment and media industries and serves its customers under its four strategic brands: Technicolor, Grass Valley, RCA and THOMSON. More about Thomson: http://www.thomson.net/videochain
RE: 8i databases under 9i listener?
Title: Message We had something similar, but only when attempting a serverSQL+ connection, which I found was due to someone messing up the ORA_NLS33 setting. --- As of February 12, 2003 Thomson unified its email addresses on a worldwide basis. Please note my new email address: [EMAIL PROTECTED] Thomson is the leader in solutions and technologies for the entertainment and media industries and serves its customers under its four strategic brands: Technicolor, Grass Valley, RCA and THOMSON. More about Thomson: http://www.thomson.net/videochain -Original Message-From: Stephen Murphy [mailto:[EMAIL PROTECTED]Sent: Wednesday, March 05, 2003 10:06 AMTo: Multiple recipients of list ORACLE-LSubject: RE: 8i databases under 9i listener? We are also finding difficulties with a mixed Oracle environment. We are running AIX 4.3.3-ML10, Oracle 8.1.7.3-EE-64 bit, PeopleSoft 8.18 and moving to Oracle 9.2.0.2. In the past, when moving to a new Oracle release, we would install the software, upgrade our listener, and then start to upgrade our instances, one by one. This go around, after upgrading our listener to 9.2.0.2, when PeopleSoft tries to connect to a 8.1.7.3 database using the 9.2.0.2 listener, the process fails with the message "ORA-01890 NLS error detected". This is happening both when a PS App Server is connecting to Oracle and when the PS client program connects in 2-tier mode. We didn't see this type of behavior with other tools (SQL+, Toad, etc.) connecting to Oracle, so we thought it was a PS problem and reported it to their support center without much progress. In the mean time, we have reconfigured so that we are now running 2 listeners on the box, one for Oracle 8i and one for Oracle 9iR2. So far, we have not found a problem with Oracle 9iR2 databases interacting with like listeners, but our testing continues. If anyone else on this list can shine some light on this problem, please do. -- *---* Stephen T. Murphy Manager, Database and Technical Support ITS - University Applications Development MSC-100 The University at Albany, S.U.N.Y Albany, New York 1 Phone: (518) 437-4523 Fax: (518) 437-4540 MailTo: [EMAIL PROTECTED] AIM: SMurphy199 -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 8:05 AMTo: Multiple recipients of list ORACLE-LSubject: 8i databases under 9i listener? RS6000 running AIX 4.3.3. We are experiencing the following issues with our 8.1.7.4 databases under a 9.2.0.1 listener. 1) PL/SQL procedures utilizing UTL_FILE fail with INVALID_PATH errors when attempting to open a file. 2) Database links from WE8ISO8859P1 databases to UTF8 databases fail with ORA-3113. Database links work fine as long as the character set is the same on both databases. We've checked, and double-check, all environment variables, O/S permissions, and so forth. Oracle Support has been basically useless. Eventually, they stated that these problems are unique to the AIX platform, and not something that they've seen on HP or Solaris, and recommended running both the 8i and 9i listeners, in other words, they had no clue. The sequence of events went like this: Feb 7th -- 9.2.0.1 was installed on our test/development box, on which there are eight 8.1.7.4 instances running. Feb 14th -- We startup the 9i listener and shutdown the 8i listener. Feb 21st -- First upgrade of an 8.1.7.4 database to 9.2.0.1. The upgrade was successful. The funny thing is that none of the 8.1.7.4 databases had any problems with the 9i listener from Feb 14th to Feb 21st, either with UTL_FIL or with database links. But on Feb 21st, after the first 9.2.0.1 database upgrade, the 9i listener was bounced for the first time since it's inception, and then all the problems started. We are back to running both an 8i and 9i listener for the time being, but I have a lurking suspicion that something is not right somewhere, and could come back and bite us in the future. Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba Select 'Indy DBA' then 'DBA Web Pages' --- As of February 12, 2003 Thomson unified its email addresses on a worldwide basis. Please note my new email address: [EMAIL PROTECTED] Thomson is the leader in solutions and technologies for the entertainment and media industries and serves its customers under its four strategic brands: Technicolor, Grass Valley, RCA and THOMSON.
Listener Hangs
We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. Yesterday morning our LISTENER process hung. ERROR: ORA-12203: TNS:unable to connect to destination. We resolved the problem using the following steps: a) Stop Listener using LSNRCTL utility (this hung did not succeed in stopping the listener) b) Issue UNIX command kill -9 process id to kill the corresponding Listener process. c) Start the listener using the LSNRCTL utility I checked the alert log and listener log. I found nothing in either file pointing to what the problem might have been. However, I did note that the listener.log file was 200 MB in size. Would the large size of the listener.log file contribute to the Listener hanging? This problem has occurred 6 to 8 times in the past couple of weeks. I do plan on starting a new listener.log file. Thanks, Sam Bootsma [EMAIL PROTECTED]
RE: Listener Hangs
This is how you can cleanup listener.log w/o taking the listener down. You can copy the listener.log to an archive location, then do the following: cat "/dev/null" and redirect to listener.log file. This will zero the current file and allow other updates to the log from the listener to continue. eg: cp listener.log wherever.logcat /dev/null listener.log ls -l listener.log-rw-r--r-- 1 oracle 0 Apr 5 13:22 listener.loglsnrctl statusls -l listener.log-rw-r--r-- 1 oracle 160 Apr 5 13:22 listener.log Here you can see the listener.log files gets emptied. Doing a 'status' command on the listeneryou can see the current tnslsnr process continues to write to the file. By redirecting the output of an empty file '/dev/null' or using a file that may contain thelast 100 lines of the Listener and redirecting to the "listener.log", you keep the same inodevalue that tnslsnr process uses to write to the "listener.log". The key is not to remove or move the current "listener.log" while the tnslsnr process is running.It is ok to copy the file for historical records. -Original Message-From: Sam Bootsma [mailto:[EMAIL PROTECTED]Sent: Tuesday, March 04, 2003 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: Listener Hangs We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. Yesterday morning our LISTENER process hung. ERROR: ORA-12203: TNS:unable to connect to destination. We resolved the problem using the following steps: a) Stop Listener using LSNRCTL utility (this hung did not succeed in stopping the listener) b) Issue UNIX command kill -9 process id to kill the corresponding Listener process. c) Start the listener using the LSNRCTL utility I checked the alert log and listener log. I found nothing in either file pointing to what the problem might have been. However, I did note that the listener.log file was 200 MB in size. Would the large size of the listener.log file contribute to the Listener hanging? This problem has occurred 6 to 8 times in the past couple of weeks. I do plan on starting a new listener.log file. Thanks, Sam Bootsma [EMAIL PROTECTED]
Re: Listener Hangs
It's possible. I've heard of this happening before and the recommendation was to clear out the listener.log file. There are a couple of ways to clear out that file. One is to stop the listener and delete it. The other is to cat /dev/null to it (i.e. cat /dev/null listener.log). The latter doesn't require the listener to be stopped. This works in Unix. On windows I think the only option is to stop the listener and delete the file. - Original Message - From: Sam Bootsma To: Multiple recipients of list ORACLE-L Sent: Tuesday, March 04, 2003 12:04 PM Subject: Listener Hangs We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. Yesterday morning our LISTENER process hung. ERROR: ORA-12203: TNS:unable to connect to destination. We resolved the problem using the following steps: a) Stop Listener using LSNRCTL utility (this hung did not succeed in stopping the listener) b) Issue UNIX command kill -9 process id to kill the corresponding Listener process. c) Start the listener using the LSNRCTL utility I checked the alert log and listener log. I found nothing in either file pointing to what the problem might have been. However, I did note that the listener.log file was 200 MB in size. Would the large size of the listener.log file contribute to the Listener hanging? This problem has occurred 6 to 8 times in the past couple of weeks. I do plan on starting a new listener.log file. Thanks, Sam Bootsma [EMAIL PROTECTED]
RE: Listener Hangs
Thank-you! This should prove to be helpful. Sam Bootsma George Brown College [EMAIL PROTECTED] 416-415-5000 x4933 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: March 4, 2003 2:22 PM To: Multiple recipients of list ORACLE-L Subject: RE: Listener Hangs This is how you can cleanup listener.log w/o taking the listener down. You can copy the listener.log to an archive location, then do the following: cat /dev/null and redirect to listener.log file. This will zero the current file and allow other updates to the log from the listener to continue. eg: cp listener.log wherever.log cat /dev/null listener.log ls -l listener.log -rw-r--r-- 1 oracle 0 Apr 5 13:22 listener.log lsnrctl status ls -l listener.log -rw-r--r-- 1 oracle 160 Apr 5 13:22 listener.log Here you can see the listener.log files gets emptied. Doing a 'status' command on the listener you can see the current tnslsnr process continues to write to the file. By redirecting the output of an empty file '/dev/null' or using a file that may contain the last 100 lines of the Listener and redirecting to the listener.log, you keep the same inode value that tnslsnr process uses to write to the listener.log. The key is not to remove or move the current listener.log while the tnslsnr process is running. It is ok to copy the file for historical records. -Original Message- From: Sam Bootsma [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2003 12:05 PM To: Multiple recipients of list ORACLE-L Subject: Listener Hangs We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. Yesterday morning our LISTENER process hung. ERROR: ORA-12203: TNS:unable to connect to destination. We resolved the problem using the following steps: a) Stop Listener using LSNRCTL utility (this hung did not succeed in stopping the listener) b) Issue UNIX command kill -9 process id to kill the corresponding Listener process. c) Start the listener using the LSNRCTL utility I checked the alert log and listener log. I found nothing in either file pointing to what the problem might have been. However, I did note that the listener.log file was 200 MB in size. Would the large size of the listener.log file contribute to the Listener hanging? This problem has occurred 6 to 8 times in the past couple of weeks. I do plan on starting a new listener.log file. Thanks, Sam Bootsma [EMAIL PROTECTED]
Listener/Database shutdown sequence
Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases Any comments and/or issues David _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener/Database shutdown sequence
Why do you/they think it matters, regardless of the documentation? You can shut them down in any order you want. Users just get a different error if the listener is up vs. when it is down. Starting up, if services are registered via local_listener or mts_dispatchers, the listener should be up before the database opens. Otherwise, you will have to wait for instance registration with the listener, or force it with 'alter system register'. For dedicated connections, this problem can be avoided with a sid_desc in the listener.ora -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 3 Mar 2003, david davis wrote: Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener/Database shutdown sequence
There might be some docs somewhere but the issues are not as much technical as procedural. If you shut the database down, leave the listener up, and bring the database backup there are no connection problems except when the db is down. This implies that the instance and the listener are independent to a large extent. Having your users and developers being able to tnsping prod while the database is down may not be what you want. In any event, doing it either way won't do you any technical harm. Allan -Original Message- Sent: Monday, March 03, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases Any comments and/or issues David _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener/Database shutdown sequence
David, it just doesn't matter. why do you even feel the need to shut the listener down? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, March 03, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases Any comments and/or issues David _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener/Database shutdown sequence
Sometimes it does matter what is stopped rather than the order, but we can't tell why the original poster was asking. It depends on your environment. For example, one site I worked at had a separate listener for every database in their environment. Their reasoning was they made life easier for themselves when doing maintenance because they could just stop the listener and not worry about whether the database was accessible to normal users or not i.e. they didn't need to start the database in restricted mode, give extra privileges to application owner accounts temporarily while doing the maintenance and so on. This was for maintenance that required the app owner to log in to verify changes). On the other hand, if you have a single listener for all your databases and you want to do maintenance on just one, you would not want to stop the listener at all. Coming back to the original question, though, there is no dependency on the order, as you stated. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long-term Oracle DBA -Original Message- Mercadante, Thomas F Sent: Monday, March 03, 2003 9:04 AM To: Multiple recipients of list ORACLE-L David, it just doesn't matter. why do you even feel the need to shut the listener down? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, March 03, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases Any comments and/or issues David _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Sharman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener/Database shutdown sequence
Tom, It is for the server auto-start/auto-shutdown procedures run by root. From: Mercadante, Thomas F [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Listener/Database shutdown sequence Date: Mon, 03 Mar 2003 09:04:11 -0800 David, it just doesn't matter. why do you even feel the need to shut the listener down? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, March 03, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases Any comments and/or issues David _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fwd: Re: Listener/Database shutdown sequence
From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Listener/Database shutdown sequence Date: Mon, 03 Mar 2003 08:19:06 -0800 Why do you/they think it matters, regardless of the documentation? You can shut them down in any order you want. Users just get a different error if the listener is up vs. when it is down. Starting up, if services are registered via local_listener or mts_dispatchers, the listener should be up before the database opens. Otherwise, you will have to wait for instance registration with the listener, or force it with 'alter system register'. For dedicated connections, this problem can be avoided with a sid_desc in the listener.ora -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 3 Mar 2003, david davis wrote: Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener/Database shutdown sequence
Jeremiah I didn't really think it mattered for the shutdown. Though I know in Oracle 7 it did matter for the startup (we use MTS). Another DBA seemed to imply that the sequence was important on shutdown of 8i. So if in doubt I RTFM, suffer the metalink search and post to the list. As usual, the most successful path is the list. Thx David From: Jeremiah Wilton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Listener/Database shutdown sequence Date: Mon, 03 Mar 2003 08:19:06 -0800 Why do you/they think it matters, regardless of the documentation? You can shut them down in any order you want. Users just get a different error if the listener is up vs. when it is down. Starting up, if services are registered via local_listener or mts_dispatchers, the listener should be up before the database opens. Otherwise, you will have to wait for instance registration with the listener, or force it with 'alter system register'. For dedicated connections, this problem can be avoided with a sid_desc in the listener.ora -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 3 Mar 2003, david davis wrote: Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener/Database shutdown sequence
Dave, that's kind of a different question. in this case, as others have stated, the order of shutting things down does not matter too much. For practical purposes, I would shut the listener down first and then the database - only because the database takes longer to shut down. For startup, I would start the listener first - the database being up without the listener is pretty useless anyway. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, March 03, 2003 1:22 PM To: Multiple recipients of list ORACLE-L Tom, It is for the server auto-start/auto-shutdown procedures run by root. From: Mercadante, Thomas F [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Listener/Database shutdown sequence Date: Mon, 03 Mar 2003 09:04:11 -0800 David, it just doesn't matter. why do you even feel the need to shut the listener down? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, March 03, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases Any comments and/or issues David _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Listener/Database shutdown sequence
OK, after emphatically stating it doesn't matter, I thought of a situation in which the order of shutting down could make a difference. In this scenario, you first must be the kind of person who needlessly insists on shutdown immediate (instead of abort). Second, you must have a very heavy rate of incoming connections, such as from a huge user base or many many webservers. Finally, you must be CPU bound. If you try to shutdown immediate, any activity, such as rolling back transactions and deallocating temp segments, that must complete before the shutdown completes, will have cycles stolen away by a needlessly spinning listener(s) that is just rejecting connections, one after another. So, in such a case, listener first, then database. But shutdown immediate is for wimps. Just shoot DBW0 in the head with a SIGKILL. ;-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 3 Mar 2003, Mercadante, Thomas F wrote: that's kind of a different question. in this case, as others have stated, the order of shutting things down does not matter too much. For practical purposes, I would shut the listener down first and then the database - only because the database takes longer to shut down. For startup, I would start the listener first - the database being up without the listener is pretty useless anyway. -Original Message- It is for the server auto-start/auto-shutdown procedures run by root. From: Mercadante, Thomas F [EMAIL PROTECTED] it just doesn't matter. why do you even feel the need to shut the listener down? -Original Message- Should the databases be shutdown before the listener or the other way around. A DBA here (actually at Service Provider) believes that the listener has to be shutdown before the databases in 8i according to some documentation (they can't recall). I am proposing: Set Oracle 817 environment shutdown database stop 817 listener set Oracle 806 environment stop 806 listener They feel it should be the other order: Shutdown Listeners Shutdown databases Any comments and/or issues -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Listener
Title: Message Hi list, I have my DB server with 2 network card and I want to split theconnections between the users to balance the load. I addedLOAD_BALANCE=ON in the listener.ora and another line with the new ip address with the port 1526. Now all the connections are managed with the new address and the port 1526. (ADDRESS_LIST= (LOAD_BALANCE=ON) (ADDRESS = (PROTOCOL = TCP) (HOST=125.115.100.10)(PORT=1521) (ADDRESS = (PROTOCOL = TCP) (HOST=125.115.100.11)(PORT=1526) ) ORCL = (DESCRIPTION = (ADDRESS_LIST = (LOAD_BALANCE=ON) (ADDRESS = (PROTOCOL = TCP)(HOST = 125.115.100.10)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 125.115.100.11)(PORT = 1526)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL) ) ) Any suggestions, comments will be appreciated. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-565-3121
RE: Listener Hanging 64 Bit Solaris 8 Oracle 9.2
We had this problem recently- running 8.1.7 (64-bit) and 9.0.1.3 (32-bit) on Sun Solaris 2.8. Both databases were registered in the same version 9.0.1.3.0 Listener. Oracle Support eventually told me that Listener versions below 9iR2 do not support mixed bit versions (64- and 32-bit). You would have to run a separate listener for each bit version. I upgraded the 9.0.1.3.0 to 9.2.0.2.0 and registered both on the new 9iR2 Listener (this week) and haven't seen a listener crash...yet (fingers crossed). See text below, copied from my TAR. David B. Wagoner Database Administrator Arsenal Digital Solutions Phone: 919-466-6723 Cell: 919-412-8462 Fax: 919-466-6783 E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web: http://www.arsenaldigital.com http://www.arsenaldigital.com/ === ANALYSIS === This is most likely the known issues with registration taking place accross bit versons and from a higher version of a database to a lower version of the listener. Cross Registration for 2 oracle instances with different BIT versions will not work until listener 9.2.0.2.0. The other possibility is that the 9.2.0 regular instance is registering using the default settings to the listener 8.1.7. This is not a supported functions. The supported method would be using the listener version that matches the highest version of the database you plan on using. Ill tell you the methods that you can use to determine if this is in fact your issue and how to resolve it. Some facts about the known issue. 1. Your running 32 and 64 bit software 2. The listener that is crashing is using port 1521. 3. Your listener shows a service handler twice for the instances. 4. Your not completely familiar with Automatic instance registration functionality. === ACTION PLAN === 1. Go to Oracle_home/bin and perform file oracle that should return Elf and some other text. if the return Text Says 64 then its running 64 bit oracle. 2. Perform the same in the other oracle home. 3. perform lsnrctl status and you will see that there is the two instances in the service list. 4. Go to metalink and read Article-ID: Note:76636.1 Circulation: PUBLISHED (EXTERNAL) Folder: network.TNSListener Topic: Service Registration Title: Service Registration in Net 8i So you understand the instance registration process. === SOLUTION/ANSWER === You have a few options. 1. Change the listener port to something other than 1521. That way registration to the default port wont take place which is why the issue is taking place. 2. Use a 9.2.0.2.0 listener...see bug 2187760 for full details. Cross Registration between BIT versions doesnt work until listener 9.2.0.2.0 3. Force Registration to fail by setting the LOCAL_LISTENER parameter to a value other than the current listener address. Again avoiding Registration by forcing it not to work properly. -Original Message- From: Post, Ethan [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 13, 2003 5:00 PM To: Multiple recipients of list ORACLE-L Subject: Listener Hanging 64 Bit Solaris 8 Oracle 9.2 Anyone had this issue? Oracle support has been helpless so far, even with mega trace files. - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Listener Hanging 64 Bit Solaris 8 Oracle 9.2
Anyone had this issue? Oracle support has been helpless so far, even with mega trace files. - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener Hanging 64 Bit Solaris 8 Oracle 9.2
Ethan, We're currently having is on one of out HP/Compaq Tru64 5.1a clusters running mostly 8.1.7.3. Since we started tracing earlier this week, we haven't had a problem. I'll let you know if we find anything. Stephen [EMAIL PROTECTED] 02/13/03 02:59PM Anyone had this issue? Oracle support has been helpless so far, even with mega trace files. - Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
common listener
Hi DBA's I have a common listener setup for 4 database on a server. i.e. listener.ora is listening to 4 different databases on the server (port numbers are different for each DB). is there a way to stop services for only 1 database (I mean if I stop listener, it stops connections for all databases) Thnaks in advance, Srinivas __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: common listener
short answer: no Longer answer: you would have to have a separate listener for each database to stop the services only for one database. Or you could edit the listener.ora file, remove the one database you wanted to stop listening for, stop the listener (this won't disconnect anyone already logged in, but will stop anyone else logging in to ANY database) and restart the listener with all the databases you want to continue listening for. I *think* you might be able to just reload the listener but I'm not sure it would stop listening for that one database and I don't have a test machine available to try it on --- kommareddy sreenivasa [EMAIL PROTECTED] wrote: Hi DBA's I have a common listener setup for 4 database on a server. i.e. listener.ora is listening to 4 different databases on the server (port numbers are different for each DB). is there a way to stop services for only 1 database (I mean if I stop listener, it stops connections for all databases) Thnaks in advance, Srinivas __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: common listener
Srinivas Stopping the listener does not affect existing connections, but only users that are trying to connect. Therefore you can modify the listener.ora file, then stop and start the listener without affecting your users. I would recommend that you avoid doing this when a lot of your users are logging in, like the first thing in the morning. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, February 10, 2003 6:04 AM To: Multiple recipients of list ORACLE-L Hi DBA's I have a common listener setup for 4 database on a server. i.e. listener.ora is listening to 4 different databases on the server (port numbers are different for each DB). is there a way to stop services for only 1 database (I mean if I stop listener, it stops connections for all databases) Thnaks in advance, Srinivas __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: common listener
How about just a 'Reload' insead of stop and start? Much faster. Ron Smith -Original Message- Sent: Monday, February 10, 2003 8:04 AM To: Multiple recipients of list ORACLE-L Srinivas Stopping the listener does not affect existing connections, but only users that are trying to connect. Therefore you can modify the listener.ora file, then stop and start the listener without affecting your users. I would recommend that you avoid doing this when a lot of your users are logging in, like the first thing in the morning. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, February 10, 2003 6:04 AM To: Multiple recipients of list ORACLE-L Hi DBA's I have a common listener setup for 4 database on a server. i.e. listener.ora is listening to 4 different databases on the server (port numbers are different for each DB). is there a way to stop services for only 1 database (I mean if I stop listener, it stops connections for all databases) Thnaks in advance, Srinivas __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: common listener
kommareddy sreenivasa, hei, you can just create 4 listener and each listener listeners on one port for one database, isn't it pretty easy? Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) === 2003-02-10 04:03:00 ,you wrote£º=== Hi DBA's I have a common listener setup for 4 database on a server. i.e. listener.ora is listening to 4 different databases on the server (port numbers are different for each DB). is there a way to stop services for only 1 database (I mean if I stop listener, it stops connections for all databases) Thnaks in advance, Srinivas __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: common listener
Kommareddy, Srinivas (MED, Wissen Infotech), What about change it from the database? like alter system enable resticted session?So, general user without special privs will not be able to logon to the database even the listener is still up and conection to other database is still ok? Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) === 2003-02-10 23:25:00 ,you wrote£º=== hi, Thanks for the input. yes, we have that setup for some servers. but for some servers a common listener is being maintained and searching for a method to stop services for a single DB. Srinivas -Original Message- From: chao_ping [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 11, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Subject: Re: common listener kommareddy sreenivasa, hei, you can just create 4 listener and each listener listeners on one port for one database, isn't it pretty easy? Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) === 2003-02-10 04:03:00 ,you wrote£º=== Hi DBA's I have a common listener setup for 4 database on a server. i.e. listener.ora is listening to 4 different databases on the server (port numbers are different for each DB). is there a way to stop services for only 1 database (I mean if I stop listener, it stops connections for all databases) Thnaks in advance, Srinivas __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Listener problem ....
Joshua, This is not a problem. From Oracle 8i onwards, the instance running can register itself with the listener running on the local host without any listener.ora file. Or, if the listener.ora is defined and the listener runs on the default port, 1521. In this case you have one handler for the onedefined in listener.ora file (under SID_LIST parameter) an anotherfor the onethat hasbeen registered automatically. HTH. Arup Nanda - Original Message - From: Joshua Becker To: Multiple recipients of list ORACLE-L Sent: Monday, January 20, 2003 11:59 PM Subject: Listener problem Hi all, I am wondering is there something wrong with my listener settings. I mean when I type LSNRCTL servicesConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test01u)(PORT=1521)))Services Summary...Service "TEST2" has 2 instance(s). Instance "TEST2", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST2", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:1 refused:0 state:ready LOCAL SERVERService "TEST1" has 2 instance(s). Instance "TEST1", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST1",! status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVERService "TEST3" has 2 instance(s). Instance "TEST3", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST3", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVER Why it shows service has 2 instances? I am using Sun Solaris with Oracle 8.1.7 and 9.2. rgds, Joshua Gratis e-mail resten av livet på: www.yahoo.se/mailBusenkelt!
Listener problem ....
Hi all, I am wondering is there something wrong with my listener settings. I mean when I type LSNRCTL servicesConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test01u)(PORT=1521)))Services Summary...Service "TEST2" has 2 instance(s). Instance "TEST2", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST2", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:1 refused:0 state:ready LOCAL SERVERService "TEST1" has 2 instance(s). Instance "TEST1", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST1", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVERService "TEST3" has 2 instance(s). Instance "TEST3", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TEST3", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVER Why it shows service has 2 instances? I am using Sun Solaris with Oracle 8.1.7 and 9.2. rgds, JoshuaGratis e-mail resten av livet på: www.yahoo.se/mail Busenkelt!
Oracle connection/listener/dispatcher stops allowing connections
Hello, Just in time for the Holidays. Oracle stops accepting connections. I am wondering if people here can give me their horror stories when Oracle stops accepting new connections or stops accepting connections altogether? Scalability problems when you've got around 5,000 concurrent connections? MTS/Shared server configurations enabled or disabled? It could be an Oracle problem or the application that's trying to connect's fault. Any tips and insights into what caused your horror story and how it was fixed. Thanks. Have a Happy Holidays everybody. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle connection/listener/dispatcher stops allowing connecti
Lyndon I would look at the wait statistics to see what is happening inside Oracle. I would also look at the O.S. performance statistics to see what is happening underneath Oracle. Don't make any rash assumptions. Also, are any error messages or trace files generated? For me the funny story was a misunderstanding of the Unix nice value for an unfamiliar platform. Long story short, we wound up with batch running at a higher priority than interactive users. New users were shut out. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 9:45 AM To: Multiple recipients of list ORACLE-L connections Hello, Just in time for the Holidays. Oracle stops accepting connections. I am wondering if people here can give me their horror stories when Oracle stops accepting new connections or stops accepting connections altogether? Scalability problems when you've got around 5,000 concurrent connections? MTS/Shared server configurations enabled or disabled? It could be an Oracle problem or the application that's trying to connect's fault. Any tips and insights into what caused your horror story and how it was fixed. Thanks. Have a Happy Holidays everybody. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle connection/listener/dispatcher stops allowing connecti
The reason I ask is because people around me always blame Oracle when things stop working. Anyways, the problem was traced to a corrupted Oracle database (as to whether the tables or the data file got corrupted. how and why - a $$$ consultant is trying to find out). How could an Oracle database get corruppted in the first place? Anyone here with an experience of their Oracle database getting corrupted and what caused it and what was done to fix it? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: Lyndon I would look at the wait statistics to see what is happening inside Oracle. I would also look at the O.S. performance statistics to see what is happening underneath Oracle. Don't make any rash assumptions. Also, are any error messages or trace files generated? For me the funny story was a misunderstanding of the Unix nice value for an unfamiliar platform. Long story short, we wound up with batch running at a higher priority than interactive users. New users were shut out. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 9:45 AM To: Multiple recipients of list ORACLE-L connections Hello, Just in time for the Holidays. Oracle stops accepting connections. I am wondering if people here can give me their horror stories when Oracle stops accepting new connections or stops accepting connections altogether? Scalability problems when you've got around 5,000 concurrent connections? MTS/Shared server configurations enabled or disabled? It could be an Oracle problem or the application that's trying to connect's fault. Any tips and insights into what caused your horror story and how it was fixed. Thanks. Have a Happy Holidays everybody. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
