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
Magically, it's fixed. No one has 'fessed up' but it
is definietly not an Oracle problem.
--- Peter Barnett <[EMAIL PROTECTED]> wrote:
> Yesterday we had a cpu panic followed by a
> spontaneous
> reboot of a Sun E6000 server. When the server and
> databases came back on line we were getting 'n
As luck would have it, we just went through a similar problem.
Does the listener actually startup? Can you stop and restart it manually
using "lsnrctl"?
Ours wouldn't. We tracked it down to two problems, both security related.
The one that was hampering our listener was a change in /etc/nsswit
Wednesday, October 09, 2002 3:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Listener Problem
>
>
> Magically, it's fixed. No one has 'fessed up' but it
> is definietly not an Oracle problem.
>
--
Please see the official ORACLE-L FAQ: http://
Unfortunately, our company is large enough that no one
ever really has to admit to anything because it is
simply too difficult to run down the perpetrators.
The listener did start. Some users could connect to
the databases from one server but not another. We
think it was related to an intrusi
Do you have a service like Oracle_HOMETNSListener?
I assume that you must. You don't need a separate listener for each
instance. What does the TNSNames.ora entry for LMANAGER look like?
Harvinder,
Where is the application resolving the port from? Tnsnames / ONames? Check
the port defined with the connect string in these destinations as they will
be the ones who will identify which port the app goes to.
HTH
Shailesh
-Original Message-
Sent: Wednesday, July 25, 2001 4:
Do you have the second port defined in your tnsnames.ora?
> -Original Message-
> From: Harvinder Singh [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, July 25, 2001 4:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: listener problem..
>
>
> Hi,
>
> I have configured 2 lis
PORT SPECIFIED IN TNSNAMES.ORA IS 1526
-Original Message-
Sent: Wednesday, July 25, 2001 5:07 PM
To: Multiple recipients of list ORACLE-L
Harvinder,
Where is the application resolving the port from? Tnsnames / ONames? Check
the port defined with the connect string in these de
ONLY 1 PORT 1526 SPECIFIED IN TNSNAMES.ORA..
-Original Message-
Sent: Wednesday, July 25, 2001 5:02 PM
To: Multiple recipients of list ORACLE-L
Do you have the second port defined in your tnsnames.ora?
> -Original Message-
> From: Harvinder Singh [mailto:[EMAIL PROTECTED]]
1 5:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: listener problem..
>
>
> ONLY 1 PORT 1526 SPECIFIED IN TNSNAMES.ORA..
>
> -Original Message-
> Sent: Wednesday, July 25, 2001 5:02 PM
> To: Multiple recipients of list ORACLE-L
>
>
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 anythin
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 Dam
>
>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 di
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,
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.
>
> 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 o
> 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'
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.
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
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.
>
> Sinc
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??
>
>
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-
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 faile
> -Original Message-
> From: Damien [mailto:[EMAIL PROTECTED]
> Sent: September 2, 2003 4:09 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Listener problem on one client computer
>
>
> I have to do netstat -a on the webserver or on the Oracle serv
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
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
Amol - I think that you are on the right track, looking at LD_LIBRARY_PATH.
Possibly you don't have that variable set just quite right, or it isn't set
when you issue the lsnrctl. You can check the setting by entering "env" just
before you issue lsnrctl. Try to check for extra characters or non-pr
28 matches
Mail list logo