Toad foo Oracle 12.7 - TNS connector fails

ButtonPusher · June 23, 2015, 7:55am

Can you please send a support bundle from the help menu? You can send it to me off-line if you prefer. brad.boddicker@quest.com

Thanks

From: charlie.swift [mailto:bounce-charlieswift@toadworld.com]

Sent: Tuesday, June 23, 2015 10:47 AM

Subject: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Thread created by charlie.swift

I just downloaded 12.7.0.121 and all my DB connections were ported forward but all fail under 12.7 but all work under 12.6

I receive this error

A connect descriptor for SARAHP1 could not be located in tnsnames.ora file

I connect via database name SARAHP1 and here is ny TNSNAMES entry

sarahp1.world=

   (DESCRIPTION=

           (ADDRESS=(PROTOCOL=tcp)(HOST=usmtniadinfdb14.dev.emrsn.org)(PORT=34101))

       (CONNECT_DATA=

           (SID=sarahp1)

       )

   )

What do I need to do to correct this?

Thanks

Attachments:

documents.quest.com/…/create-a-variable-for-the-tnsnames-ora-file

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

JohnDorlon · June 23, 2015, 7:55am

I see you don’t have a TNS_ADMIN variable. They aren’t strictly necessary, but try creating one and see what happens.

Here’s a doc that explains how to do that:

mstaszew · June 23, 2015, 7:56am

if you add the “.WORLD” to SARAHP1 in the login window does it connect? If so, looks like you’re missing…

NAMES.DEFAULT_DOMAIN = world

…from SQLNET.ORA if you want to drop off the .WORLD when making the connection.

ButtonPusher · June 23, 2015, 11:00am

Hi Charlie,

Try re-installing 12.7 into a directory that does not contain parenthesis and try again. The default path includes (x86) which causes a known issue with 10g
clients

From: charlie.swift [mailto:bounce-charlieswift@toadworld.com]

Sent: Tuesday, June 23, 2015 10:47 AM

Subject: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Thread created by charlie.swift

I just downloaded 12.7.0.121 and all my DB connections were ported forward but all fail under 12.7 but all work under 12.6

I receive this error

A connect descriptor for SARAHP1 could not be located in tnsnames.ora file

I connect via database name SARAHP1 and here is ny TNSNAMES entry

sarahp1.world=

   (DESCRIPTION=

           (ADDRESS=(PROTOCOL=tcp)(HOST=usmtniadinfdb14.dev.emrsn.org)(PORT=34101))

       (CONNECT_DATA=

           (SID=sarahp1)

       )

   )

What do I need to do to correct this?

Thanks

Attachments:

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

charlie.swift · June 23, 2015, 11:06am

What is the best method to un-install 12.7 from it’s current location?

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Tuesday, June 23, 2015 2:01 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Reply by Brad Boddicker

Hi Charlie,

Try re-installing 12.7 into a directory that does not contain parenthesis and try again. The default path includes (x86) which causes a known issue with 10g
clients

From: charlie.swift [mailto:bounce-charlieswift@toadworld.com]

Sent: Tuesday, June 23, 2015 10:47 AM

Subject: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Thread created by charlie.swift

I just downloaded 12.7.0.121 and all my DB connections were ported forward but all fail under 12.7 but all work under 12.6

I receive this error

A connect descriptor for SARAHP1 could not be located in tnsnames.ora file

I connect via database name SARAHP1 and here is ny TNSNAMES entry

sarahp1.world=

   (DESCRIPTION=

           (ADDRESS=(PROTOCOL=tcp)(HOST=usmtniadinfdb14.dev.emrsn.org)(PORT=34101))

       (CONNECT_DATA=

           (SID=sarahp1)

       )

   )

What do I need to do to correct this?

Thanks

Attachments:

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

ButtonPusher · June 23, 2015, 11:10am

Add/Remove programs

From: charlie.swift [mailto:bounce-charlieswift@toadworld.com]

Sent: Tuesday, June 23, 2015 2:08 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Reply by charlie.swift

What is the best method to un-install 12.7 from it’s current location?

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Tuesday, June 23, 2015 2:01 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Reply by Brad Boddicker

Hi Charlie,

Try re-installing 12.7 into a directory that does not contain parenthesis and try again. The default path includes (x86) which causes a known issue with 10g
clients

From: charlie.swift [mailto:bounce-charlieswift@toadworld.com]

Sent: Tuesday, June 23, 2015 10:47 AM

Subject: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Thread created by charlie.swift

I just downloaded 12.7.0.121 and all my DB connections were ported forward but all fail under 12.7 but all work under 12.6

I receive this error

A connect descriptor for SARAHP1 could not be located in tnsnames.ora file

I connect via database name SARAHP1 and here is ny TNSNAMES entry

sarahp1.world=

   (DESCRIPTION=

           (ADDRESS=(PROTOCOL=tcp)(HOST=usmtniadinfdb14.dev.emrsn.org)(PORT=34101))

       (CONNECT_DATA=

           (SID=sarahp1)

       )

   )

What do I need to do to correct this?

Thanks

Attachments:

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Mark_Lerch · June 23, 2015, 12:21pm

I’m responsible for the Toad Oracle Installer. I’ll take this one.

Add/Remove programs

man I’m good.

From: charlie.swift [mailto:bounce-charlieswift@toadworld.com]

Sent: Tuesday, June 23, 2015 2:07 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Reply by charlie.swift

What is the best method to un-install 12.7 from it’s current location?

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Tuesday, June 23, 2015 2:01 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Reply by Brad Boddicker

Hi Charlie,

Try re-installing 12.7 into a directory that does not contain parenthesis and try again. The default path includes (x86) which causes a known issue with 10g
clients

From: charlie.swift [mailto:bounce-charlieswift@toadworld.com]

Sent: Tuesday, June 23, 2015 10:47 AM

Subject: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Thread created by charlie.swift

I just downloaded 12.7.0.121 and all my DB connections were ported forward but all fail under 12.7 but all work under 12.6

I receive this error

A connect descriptor for SARAHP1 could not be located in tnsnames.ora file

I connect via database name SARAHP1 and here is ny TNSNAMES entry

sarahp1.world=

   (DESCRIPTION=

           (ADDRESS=(PROTOCOL=tcp)(HOST=usmtniadinfdb14.dev.emrsn.org)(PORT=34101))

       (CONNECT_DATA=

           (SID=sarahp1)

       )

   )

What do I need to do to correct this?

Thanks

Attachments:

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

charlie.swift · July 1, 2015, 12:31pm

Sorry for the delay (Family crisis)

TOAD 12.7 is work after loading to a different directory

The support ticket can be closed

Thanks

Charlie

From: Mark Lerch [mailto:bounce-Mark_Lerch@toadworld.com]

Sent: Tuesday, June 23, 2015 3:22 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Reply by Mark Lerch

I’m responsible for the Toad Oracle Installer. I’ll take this one.

Add/Remove programs

man I’m good.

From: charlie.swift [mailto:bounce-charlieswift@toadworld.com]

Sent: Tuesday, June 23, 2015 2:07 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Reply by charlie.swift

What is the best method to un-install 12.7 from it’s current location?

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Tuesday, June 23, 2015 2:01 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Reply by Brad Boddicker

Hi Charlie,

Try re-installing 12.7 into a directory that does not contain parenthesis and try again. The default path includes (x86) which causes a known issue with 10g
clients

From: charlie.swift [mailto:bounce-charlieswift@toadworld.com]

Sent: Tuesday, June 23, 2015 10:47 AM

Subject: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Thread created by charlie.swift

I just downloaded 12.7.0.121 and all my DB connections were ported forward but all fail under 12.7 but all work under 12.6

I receive this error

A connect descriptor for SARAHP1 could not be located in tnsnames.ora file

I connect via database name SARAHP1 and here is ny TNSNAMES entry

sarahp1.world=

   (DESCRIPTION=

           (ADDRESS=(PROTOCOL=tcp)(HOST=usmtniadinfdb14.dev.emrsn.org)(PORT=34101))

       (CONNECT_DATA=

           (SID=sarahp1)

       )

   )

What do I need to do to correct this?

Thanks

Attachments:

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

ButtonPusher · July 1, 2015, 12:46pm

Great! Please note this is not an official support board so if you opened a ticket with support you will have to follow up with them as well… or not.

Thanks,

Brad

From: charlie.swift [mailto:bounce-charlieswift@toadworld.com]

Sent: Wednesday, July 01, 2015 3:33 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Reply by charlie.swift

Sorry for the delay (Family crisis)

TOAD 12.7 is work after loading to a different directory

The support ticket can be closed

Thanks

Charlie

From: Mark Lerch [mailto:bounce-Mark_Lerch@toadworld.com]

Sent: Tuesday, June 23, 2015 3:22 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Reply by Mark Lerch

I’m responsible for the Toad Oracle Installer. I’ll take this one.

Add/Remove programs

man I’m good.

From: charlie.swift [mailto:bounce-charlieswift@toadworld.com]

Sent: Tuesday, June 23, 2015 2:07 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Reply by charlie.swift

What is the best method to un-install 12.7 from it’s current location?

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Tuesday, June 23, 2015 2:01 PM

Subject: RE: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Reply by Brad Boddicker

Hi Charlie,

Try re-installing 12.7 into a directory that does not contain parenthesis and try again. The default path includes (x86) which causes a known issue with 10g
clients

From: charlie.swift [mailto:bounce-charlieswift@toadworld.com]

Sent: Tuesday, June 23, 2015 10:47 AM

Subject: [Toad for Oracle - Discussion Forum] Toad foo Oracle 12.7 - TNS connector fails

Thread created by charlie.swift

I just downloaded 12.7.0.121 and all my DB connections were ported forward but all fail under 12.7 but all work under 12.6

I receive this error

A connect descriptor for SARAHP1 could not be located in tnsnames.ora file

I connect via database name SARAHP1 and here is ny TNSNAMES entry

sarahp1.world=

   (DESCRIPTION=

           (ADDRESS=(PROTOCOL=tcp)(HOST=usmtniadinfdb14.dev.emrsn.org)(PORT=34101))

       (CONNECT_DATA=

           (SID=sarahp1)

       )

   )

What do I need to do to correct this?

Thanks

Attachments: