Home » RDBMS Server » Server Administration » TNS:listener could not hand off client
TNS:listener could not hand off client [message #54957] Thu, 19 December 2002 14:34 Go to next message
Rajesh Verma
Messages: 21
Registered: February 2002
Junior Member
Hi,

I can connect my Database only when I am connected through internet. ( I have DSL line )

=============================
After internet disconneced
=============================
SQL> conn rajesh/rajesh@kritidb
ERROR:
ORA-12523: TNS:listener could not find instance appropriate for the client connection

SQL> conn rajesh/rajesh@kritidb
ERROR:
ORA-12518: TNS:listener could not hand off client connection

=============================
After internet connected
=============================
SQL> conn rajesh/rajesh@kritidb
Connected.
SQL>

=============================
After internet disconneced
=============================
SQL> select * from tab;
select * from tab
*
ERROR at line 1:
ORA-12571: TNS:packet writer failure

SQL>
SQL>
SQL> /
select * from tab
*
ERROR at line 1:
ORA-03114: not connected to ORACLE

SQL> conn rajesh/rajesh@kritidb
ERROR:
ORA-12560: TNS:protocol adapter error

SQL> conn rajesh/rajesh@kritidb
ERROR:
ORA-12518: TNS:listener could not hand off client connection

=============================
After internet connected
=============================
SQL> conn rajesh/rajesh@kritidb
Connected.

====================================================

How can I connect my DB when I am not connected to internet

Thanks in advance
Rajesh
Re: TNS:listener could not hand off client [message #54964 is a reply to message #54957] Fri, 20 December 2002 10:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
is your database local(ie,,in the same machine?).
if so,
as per your posting
[i]conn rajesh/rajesh@kritidb[/i]
your are using a connect string KRITIDB
1. FOR A LOCAL DATABASE YOU NEED TO USE A CONNECT STRING.
  You can connect as rajesh/rajesh.
2. IF you want to use a connect string, then,
   edit the $ORACLE_HOME/network/tnsnames.ora file
   and change value of your host to LOCALHOST.
   something like this 
kritidb =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = < substitute_your_sid > )
    )
  )

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

The issue is becuase, DSL uses floating IP.
so when you are connected to DSL the value of HOST is not the same as when you are NOT CONNECTED.
change it to LOCALHOST.
and port=1521 is the default.
if you use other, specify that.

Re: TNS:listener could not hand off client [message #54975 is a reply to message #54964] Sat, 21 December 2002 05:10 Go to previous message
Rajesh Verma
Messages: 21
Registered: February 2002
Junior Member
Yes I have local database.
Without connect string it works.

Thanks for clarification.
Rajesh
Previous Topic: ora-00604:
Next Topic: stored procedure creation hangs..
Goto Forum:
  


Current Time: Sat Dec 28 04:22:28 CST 2024