Re: error: ora 12547

From: ddf <oratune_at_msn.com>
Date: Thu, 30 Jul 2009 08:09:46 -0700 (PDT)
Message-ID: <2194ec38-cc87-40d6-8660-c11ed6b828a2_at_c1g2000yqi.googlegroups.com>

On Jul 30, 10:08 am, ilbmbo <ilbi..._at_gmail.com> wrote:
> On 30 Lug, 17:04, ddf <orat..._at_msn.com> wrote:
>
>
>
>
>
> > On Jul 30, 10:01 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
>
> > Stop posting the same thing more than once, and give peoople TIME to
> > consider their responses.  You would do well to check your original
> > thread.
>
> > David Fitzjarrell
>
> sorry...- Hide quoted text -
>
> - Show quoted text -

From your original post which you inexplicably deleted:

$ 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:09:46 CDT