Toad World® Forums

Toad foo Oracle 12.7 - TNS connector fails


#1

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

Charlie.Swift@emerson.com
TOAD 12 7 error.gif


#2

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

To: toadoracle@toadworld.com

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

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

Charlie.Swift@emerson.com

Attachments:

TOAD 12 7 error.gif

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.


#3

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:

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


#4

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.


#5

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

To: toadoracle@toadworld.com

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

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

Charlie.Swift@emerson.com

Attachments:

TOAD 12 7 error.gif

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.


#6

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

To: toadoracle@toadworld.com

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

RE: 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

To: toadoracle@toadworld.com

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

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

Charlie.Swift@emerson.com

Attachments:

TOAD 12 7 error.gif

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.

Image removed by sender.

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.


#7

Add/Remove programs

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

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

To: toadoracle@toadworld.com

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

RE: 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

To: toadoracle@toadworld.com

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

RE: 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

To: toadoracle@toadworld.com

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

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

Charlie.Swift@emerson.com

Attachments:

TOAD 12 7 error.gif

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.


#8

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

To: toadoracle@toadworld.com

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

RE: 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

To: toadoracle@toadworld.com

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

RE: 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

To: toadoracle@toadworld.com

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

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

Charlie.Swift@emerson.com

Attachments:

TOAD 12 7 error.gif

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.


#9

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

To: toadoracle@toadworld.com

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

RE: 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

To: toadoracle@toadworld.com

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

RE: 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

To: toadoracle@toadworld.com

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

RE: 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

To: toadoracle@toadworld.com

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

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

Charlie.Swift@emerson.com

Attachments:

TOAD 12 7 error.gif

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.

Image removed by sender. Image removed by sender.

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.

Image removed by sender.

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.

Image removed by sender.

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.


#10

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. :slight_smile:

Thanks,

Brad

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

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

To: toadoracle@toadworld.com

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

RE: 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

To: toadoracle@toadworld.com

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

RE: 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

To: toadoracle@toadworld.com

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

RE: 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

To: toadoracle@toadworld.com

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

RE: 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

To: toadoracle@toadworld.com

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

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

Charlie.Swift@emerson.com

Attachments:

TOAD 12 7 error.gif

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.

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.