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 -
// Interchange, this can happen if the machine is overloaded.
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