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