How to set Oracle database path with Oracle Developer

5 pts.
Tags:
Microsoft Windows Server 2003
Oracle
Oracle administration
Oracle Database
Oracle Developer
How do I set an Oracle database path with Oracle Developer?

Software/Hardware used:
DELL Computer,Windows Server 2003

Answer Wiki

Thanks. We'll let you know when a new response is added.

You don’t specify the database path in Oracle Developer.

You specify the server address, the port and the SID or service name in a configuration file named TNSNAMES.ORA, which is usually in the following path:

<ORACLE_DEVELOPER_HOME>\\NETWORK\\ADMIN

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Brijesh
    Set it by using the following command :
    set ORACLE_HOME=path to your oracle database
    14,450 pointsBadges:
    report
  • ironik
    There are many different ways to configure SQL-Developer to connect.to your database. I will explain 3 of them. After selecting the green plus sign you can select connection type midway down. Basic connection type allows you to input database address info bypassing any Oracle environment setup on your system. TNS connection type allows you to use your network path on your Oracle client on you system as mentioned by carlosdl. My favorite LDAP connection type can be used if your company has an LDAP Oracle naming service setup. This will ask you for a series of question to get setup and can bypass any Oracle client install.
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: