regarding listener

From: Suganya <ukumsu02_at_shafika.vetri.com>
Date: Mon, 04 Dec 2000 19:38:40 +0530
Message-Id: <10700.123521@fatcity.com>

This is a multi-part message in MIME format.
--------------3F9D7BE2513C10702DD9F1E3

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

--------------3F9D7BE2513C10702DD9F1E3

Content-Type: message/rfc822
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Received: from vetri.com (webster [198.153.135.140])
	by shafika.vetri.com (8.9.3+Sun/8.9.3) with ESMTP id TAA19926;
	Mon, 4 Dec 2000 19:43:30 +0530 (GMT)
Received: from obelix.thiru.vetri.com (obelix [196.3.65.9])
	by vetri.com (8.9.3/8.9.3) with ESMTP id JAA23536;
	Mon, 4 Dec 2000 09:13:22 -0500
Received: from mathu by obelix.thiru.vetri.com (8.8.8+Sun/SMI-SVR4)
	id TAA20092; Mon, 4 Dec 2000 19:58:00 +0530 (GMT)

Message-ID: <001e01c05dfc$d40e90c0$4465100a_at_thiru.vetri.com> From: "Rajasekaran" <usivra01_at_thiru.vetri.com> To: "Suganya" <ukumsu02_at_shafika.vetri.com>,

"Rajesh Kanna" <uranra01_at_shafika.vetri.com> Subject: Fw: Help us
Date: Mon, 4 Dec 2000 19:45:27 +0530
Organization: Vetri Software
MIME-Version: 1.0

X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_001B_01C05E2A.C0943670"

X-Mozilla-Status2: 00000000

This is a multi-part message in MIME format.

------=_NextPart_000_001B_01C05E2A.C0943670 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Original Message -----=20 From: Rajasekaran=20 To: repsig_us_at_oracle.com=20 Sent: Monday, December 04, 2000 6:48 PM Subject: Help us

We are in the test process of Replication. The environment is Windows 2000 Professional and Oracle 8i. (8.1.5)=20 After Installation we can not access the database. I have here provided the details. Please help us.

AT SERVER MANAGER
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Connect internal/internal_at_gxtest
ORA-12541: TNS:no listener

=20
AT SQL+
=3D=3D=3D=3D=3D=3D=3D=3D
ERROR:
ORA-12541: TNS:no listener

Got the following details from the document

TNS-12541 TNS:no listener

Cause: The connection request could not be completed because the = listener is not running.

Action: Ensure that the supplied destination address matches one of the =
addresses used by the listener. Compare the TNSNAMES.ORA entry with the =
appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go =

by way of an Interchange). Start the listener on the remote machine.

But Our TNSNAME.ORA address match with LISTENER.ORA.

At Listener Control
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

LSNRCTL> test
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
32-bit Windows Error: 61: Unknown error TNS-12541: TNS:no listener

     TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
       32-bit Windows Error: 2: No such file or directory


------------------

LSNRCTL> show current_listener=20
Current Listener is LISTENER

tnsping krishna
TNS-12541 TNS:no listener

We think Listener auto is also not woking in this case.

The error that has been in Listener log file is=20 TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 38: Filename too long

Is it windows OS error.
Our db file name is 8chr long. That is GXTESTDB. Is there any rules to have a db file name with in 4chr.

Thanks in advance.

with regards
sekar

=20

------=_NextPart_000_001B_01C05E2A.C0943670 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =

http-equiv=3DContent-Type>

<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>&nbsp;</DIV>
<DIV style=3D"FONT: 10pt arial">----- Original Message -----=20
<DIV style=3D"BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A=20

href=3D"mailto:usivra01_at_thiru.vetri.com"=20 title=3Dusivra01_at_thiru.vetri.com>Rajasekaran</A> </DIV> <DIV><B>To:</B> <A href=3D"mailto:repsig_us_at_oracle.com"=20 title=3Drepsig_us_at_oracle.com>repsig_us_at_oracle.com</A> </DIV>

<DIV><B>Sent:</B> Monday, December 04, 2000 6:48 PM</DIV>
<DIV><B>Subject:</B> Help us</DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT face=3DArial size=3D2>We are in the test process of=20

Replication.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>The environment is Windows 2000 = Professional=20
and Oracle 8i. (8.1.5) </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>After Installation we can not access = the=20
database.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have here provided the details. = Please help=20
us.</FONT></DIV>

<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>AT SERVER MANAGER</FONT></DIV>
<DIV><FONT face=3DArial =

size=3D2>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>= </DIV>
<DIV><FONT face=3DArial size=3D2>Connect = internal/internal_at_gxtest</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>ORA-12541: TNS:no = listener<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2> </DIV></FONT> <DIV><FONT face=3DArial size=3D2>AT =
SQL+<BR>=3D=3D=3D=3D=3D=3D=3D=3D<BR>ERROR:<BR>ORA-12541: TNS:no=20

listener<BR>----------------------------</FONT></DIV>

<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Got the following details from the=20 document</FONT></DIV>

<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>TNS-12541 TNS:no listener</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Cause: The connection request could not =

be=20
completed because the listener is not running.</FONT></DIV> <DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Action: Ensure that the supplied = destination=20
address matches one of the addresses used by the listener. Compare the=20 TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA = if the=20
connection is to go by way of an Interchange). Start the listener on the = remote=20
machine.</FONT></DIV>
<DIV> </DIV>

<DIV><FONT face=3DArial size=3D2>------------------<BR>But Our =

TNSNAME.ORA address=20

match with LISTENER.ORA.<BR>------------------</FONT></DIV>

<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>At Listener=20 Control<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FON= T></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>LSNRCTL> test<BR>TNS-12541: TNS:no=20 listener<BR> TNS-12560: TNS:protocol adapter error<BR>  = TNS-00511: No=20
listener<BR>   32-bit Windows Error: 61: Unknown=20 error<BR>    TNS-12541: TNS:no=20 listener<BR>     TNS-12560: TNS:protocol adapter=20 error<BR>      TNS-00511: No=20 listener<BR>       32-bit Windows Error: = 2: No=20

such file or directory<BR>------------------<BR>LSNRCTL&gt; show=20

current_listener <BR>Current Listener is=20

LISTENER<BR>------------------<BR>tnsping krishna<BR>TNS-12541 TNS:no=20
listener<BR>------------------<BR>We think Listener auto is also not =

woking in=20

this case.<BR>------------------<BR>The error that has been in Listener =

log file=20
is <BR>TNS-12560: TNS:protocol adapter error<BR> TNS-00530: = Protocol=20

adapter error<BR>&nbsp; 32-bit Windows Error: 38: Filename too =
long</FONT></DIV>
<DIV>&nbsp;</DIV>

<DIV><FONT face=3DArial size=3D2>Is it windows OS error.<BR>Our db file = name is 8chr=20
long. That is GXTESTDB.<BR>Is there any rules to have a db file name = with in=20
4chr.</FONT></DIV>

<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>with regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>sekar</FONT></DIV>

Received on Mon Dec 04 2000 - 08:08:40 CST