?
Solved

Oracle ODS + SQL Developer

Posted on 2010-08-18
2
Medium Priority
?
896 Views
Last Modified: 2013-12-19
I need to connect to an Oracle ODS instance but not sure what tool to use, can I connect with Oracle SQL Developer?
0
Comment
Question by:jseg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
sammySeltzer earned 500 total points
ID: 33468026
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
 

Author Closing Comment

by:jseg
ID: 33474173
This was helpful, thanks.  
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question