Solved

toad error list index out of bounds(0)

Posted on 2006-11-30
2
11,293 Views
Last Modified: 2013-12-12
When i try to click tnsnames editor from toad window i get a  toad error :list index out of bounds(0).Why is this and how to solve this
0
Comment
Question by:suhinrasheed
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
DLyall earned 500 total points
ID: 18044091
This error is a result of a corrupted or invalid entry in the TNSNAMES.ORA file not recognized by TOAD.

An example would be the following TNSNAMES.ORA entries containing spaces on the left hand side of the "=" sign and spaces to the right of the "=" sign:

The first one should fail due to the spaces between each value (after the commas). The second one should succeed.

Remove any invalid entries in the TNSNAMES.ORA file. (ie: extra spaces on left hand side)

This issue is fixed in TOAD 8.5.
0
 

Author Comment

by:suhinrasheed
ID: 18044130
Full marks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to take different types of Oracle backups using RMAN.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question