Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1028
  • Last Modified:

How i run TOAD 8.5.0.50 free with Oracle 10g Express Edition

Hi Experts,
    I need use TOAD 8.5.0.50 free with Oracle 10g Express Edition and the toad show me the error ORA-28547 server conection fail,  My tsname is OK,  and i can connect with  principal  page of Oracle Express.  Thanks a lot.
0
jlguerra
Asked:
jlguerra
  • 3
  • 2
1 Solution
 
johnsmith1962Commented:
Can you tnsping the listener successfully?
0
 
DavidSenior Oracle Database AdministratorCommented:
You need to define TNS_ADMIN for TOAD.  Check for "SET" on Windows or "echo $TNS_ADMIN" on UNIX.
0
 
jlguerraAuthor Commented:
the toad and Oracle Express run on windows
0
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!

 
jlguerraAuthor Commented:
Please dvz how i set on windows,  it´s only "set directory" ?
0
 
DavidSenior Oracle Database AdministratorCommented:
At a command prompt (cmd.exe), one is able to view all environment variables.  The command SET by itself will display what's there.  In order to set TNS_ADMIN, you need to go into the Control Panel | Performance & Maintenance | System |  Advanced | Environment Variables | User settings.  Create a new value for TNS_ADMIN, providing the full path to the directory that contains your tnsnames.ora.  You'll need to log out and back in to use it.
0
 
jlguerraAuthor Commented:
Thank you men,  but i reinstall the aplication TOAD and work for me,  but your solution too is right
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now