Re: ora 1247

From: ddf <oratune_at_msn.com>
Date: Thu, 30 Jul 2009 08:03:23 -0700 (PDT)
Message-ID: <249ae941-f416-4a32-a0ac-42e891fa9651_at_o6g2000yqj.googlegroups.com>



On Jul 30, 9:58 am, ilbmbo <ilbi..._at_gmail.com> wrote:
> hy, i have a problem with my database Oracle 10g on a linux pc with
> Suse distro.
>
> I'm writing a software in c++ with Visual Studio 2008:
>
> private: System::Void button1_Click(System::Object^  sender,
> System::EventArgs^  e) {
>
>     String^ connectionString = gcnew String ("Data Source=(DESCRIPTION=
> (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.55.100)(PORT=1521))(CONNECT_DATA=
> (SERVICE_NAME=AFTIDI)));User Id=user ;Password=psw");
>
>         System::Data::OracleClient::OracleConnection^ conn = gcnew
> System::Data::OracleClient::OracleConnection(connectionString);
>         try
>         {
>                 conn->Open();
>         }
>         catch(OracleException^ ex1)
>         {
>                 String^ err=ex1->ToString();
>         }
>         catch(InvalidOperationException^ ex2)
>         {
>                 String^ err=ex2->ToString();
>         }
>     String^ queryString = gcnew String  ("SELECT * INTO AFTBSKDA8");
>
>         System::Data::OracleClient::OracleCommand^ command = gcnew
> System::Data::OracleClient::OracleCommand(queryString);
>
> when the program arrive at the command  conn->Open(); this is a
> Exception that say:
>
>                 err     "System.Data.OracleClient.OracleException: ORA-12547: TNS:
> contatto perso
>
> can you help me???
>
> thanks

$ oerr ora 12547
12547, 00000, "TNS:lost contact"

// *Cause: Partner has unexpectedly gone away, usually during process
// startup.
// *Action: Investigate partner application for abnormal termination.
On an
// Interchange, this can happen if the machine is overloaded.

I would set up client-side tracing to see what caused this. No one can tell you anything without some sort of client-side trace. Maybe your network admin can assist you.

David Fitzjarrell Received on Thu Jul 30 2009 - 10:03:23 CDT

Original text of this message