• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 938
  • Last Modified:

Oracle ODS + SQL Developer

I need to connect to an Oracle ODS instance but not sure what tool to use, can I connect with Oracle SQL Developer?
0
jseg
Asked:
jseg
1 Solution
 
sammySeltzerCommented:
Yes, you can connect with SQL Developer.

First, you make sure that tnsnames.ora which was setup when you installed oracle, is configured to point to the instance of your oracle database.

It looks something like this:

# TNSNAMES.ORA Network Configuration File: C:\oracle\product\9i\OEM\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ACS.Mydoamin.us =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = db1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ACSProduction or whatever)
    )
  )

Then on SQL Developer, you see connections to the top left corner of SQL Developer once it is launced.

Right-click on connections.

on Connection Name: give it any name.

Username: Scott or your username
Password: Tiger or your password

Choose TNS as your connection Type

Select the Network Alias radio button and give it the name you find in your tnsnames.ora and baring any mistakes, it should connect you.

You can also use SQL Plus to do so.

Hope this helps.
0
 
jsegAuthor Commented:
This was helpful, thanks.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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