- Welcome to Support
- Support Home
- Contact Support
- Getting Started
- License Keys
- SupportLink Login
-
- Case Management
- Documentation
- Downloads & Updates
- Product Resources
- Search Knowledgebase
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.
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.
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 |









