Oracletool is a web based oracle DBA tool, most often used as an alternative to developers using
SQL Plus. It allows developers to query the oracle data
dictionary to retrieve information about oracle databases without having to know the
structure of the oracle data dictionary views. Most developers utilize Oracletool for reviewing
table structures and contents on their own instances. Basically, Oracletool informs the developer
as to whether or not the data they are expecting to appear in their application is actually the data
that exists in the database.
To use Oracletool, developers first need to have a username and password for the oracle
instance that is being connected to. Next, they must be added to an oracle role named
MT_ORT' on the instances that they like to use Oracletool, which provides select access
on the oracle data dictionary views accessed by Oracletool.
Secaccts can grant users access to this role on
an instance where the developer has an account.
NOTE: If a developer does not have access to the necessary instance(s), the appropriate
functional manager should be contacted in order for permission to be granted.
If a developer would like to use Oracletool on an instance that isn't listed in the opening
drop down list of the homepage, Chris Shelton will need to add
an entry to the 'tnsnames.ora' file on aspen for that instance.
This instance must allow connections from aspen for Oracletool to function. Many of the
production oracle instances have IP filtering setup to restrict connections to a limited
set of IP addresses. For Oracletool to work, aspen.fms.indiana.edu (129.79.25.12) must be
allowed to connect to the instance.
To go directly to the Oracletool homepage, click
here.
« back to top »
There are a number of applications and organizations that are associated with Oracletool
for accessing data:
« back to top »
|