Are there Oracle DB Tools or Apps I Could Install on my machine to perform Admin tasks?

Posted on 2011-05-11
Last Modified: 2012-05-11
I am not an Oracle DBA or expert with Oracle DB.

But very often I have to access the DB to do checks on certain tables, do record counts, monitor the DB for any issues.

But right now, I don't know what Oracle tool would be the best for me to use for those tasks. Is there an app or tool I could download that would give someone like me who is not really an Oracle DBA that could allow me to access and perform some of those tasks?

We are on Oracle 11g.

Please let me know. Thanks!
Question by:matrix0511
    LVL 22

    Expert Comment

    I think that you can use free Oracle SQL Developer:

    There are also predefined reports.
    LVL 76

    Accepted Solution

    SQL Developer is more of a development tool.  For administration and monitoring Oracle comes with a web based dbConsole that will monitor a single Oracle instance.

    If you want centralized management of more than one, Oracle Grid Control.

    Grid control can be downloaded from:

    There are a lot of docs out there that will help you set up dbConsole for a single instance.

    This is for 10g but the steps should be the same for 11g:
    LVL 23

    Expert Comment

    - i would use PL/SQL Developer, SQL Developer or SQL Plus for task such as DML (insert, update, delete), check on table-index-primary key and etc.

    - for monitoring the database health and database operational task (user, tablespace management, backup and etc), i would suggest you to setup Oracle Enterprise Manager which is an Oracle GUI tool that ease the task:
    LVL 23

    Expert Comment

    - ops! sorry for the duplicate. not there when i'm typing it.
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    No problem.  Happens to all of us...

    Author Comment

    Guys, I have  Oracle SQL Developer installed on my machine but I have never used it before. All I want is to be able to login and run simple SQL queres on tables, check permissions, etc.

    Could someone help me with how to setup SQL Developer? I can send you a screen print of my setup screen that is asked for me to input SID, connection name, etc. I am just not 100% sure what all the parameters I need to put in. We use Oracle DB

    LVL 23

    Expert Comment

    - there is no setup/installer to use sql developer. download the file then extract it to a folder. then simply click on the sqldeveloper.exe file to launch it.
    - to setup the connection, kindly find the attach picture. if you are running sql developer on your database machine, you will see the list of database alias in the "network alias" listbox. choose the database alias that you desired. choose a unique name for "connection name" and supply the username and password. click on test button to test the connection / connect button to connect to the database.
    - if you are running this from a client, make sure you have oracle client installed on that machine and make sure you have tnsnames.ora file in the oracle client folder with database alias entry pointing to your database server in that file.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: 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…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now