Products Solutions Support Services Partners Communities Company

Solution SOL58512

Title

Getting the error "ORA-28547" While creating second session

Problem Description

If I want to create 2 sessions from TOAD, the second one always keeps giving ORA-28547 connection to server failed. The first connection is good.
If I open 2 different TOAD windows then they are fine as well.

Resolution

WORKAROUND 1:

1. Start Toad and connect to one database only
2. Fully exit Toad via File menu | Exit
3. Start Toad again and re-test the issue

WORKAROUND 2:

1. Rename file 'toad.ini' in C:\Documents and Settings\<username>\Application Data\Quest Software\Toad for Oracle\9.7\User Files
2. Launch Toad and run the setup process again - ensure "multiple Toads' is checked
3. Make one connection
4. Close Toad
5. Now relaunch Toad and try two or more connections

WORKAROUND 3:

1. Close all your Toad sessions. Open Toad.
2. Connect to one database connection.
3. Go to View | Toad Options | Startup | Check "Allow multiple copies of Toad to be loaded" | select Apply.
4. Open another Toad program session - Start | Programs | Quest Software | Toad for Oracle | Toad for Oracle 9.7.
5. On this second Toad program instance, connect to the second database.
6. Close the second Toad program instance.
7. Close the first Toad program instance.
8. Open Toad and connect to one database then to the second database using only this single Toad program instance.

Environment

Product: Toad for Oracle - 9.7.2

Feedback

How Useful was this Content?
Not at all useful    1   2   3   4   5    Extremely useful

Do you have a comment concerning this document?

 

Announcements

Featured Support Offering:
Business Critical Support Available NOW - 24x7, 365 days a year