Solved

Oracle ODS + SQL Developer

Posted on 2010-08-18
2
874 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 28

Accepted Solution

by:
sammySeltzer earned 125 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MULTIPLE DATE QUERY 15 103
what privileges needed for S2 for this function (Oracle 12c)? 3 30
Oracle collections 15 39
pl/sql parameter is null sometimes 2 25
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

726 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