How would we easily test our Oracle database/schema connection for ALM?

  • Questions
  • How would we easily test our Oracle database/schema connection for ALM?
Question ID: 107768
1
0

We would like an easy way to test our Oracle database connection for a given schema/user used by ALM.

Every once in awhile, we get an expired password for one of our projects and want a quick way to test the connection/password.

Is there an easy-to-install client that we can use without bothering the DBA (much)?

Marked as spam
Posted by (Questions: 87, Answers: 6)
Asked on July 25, 2017 9:32 pm
2 views
Answers
1
Private answer

Yes, get Oracle SQL Developer (free, but you may need a free Oracle login to download)
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

You can use the latest one for Oracle 12c, or 11g.

You might need to download and install Java JDK 8 first:
http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

Also, you might need the Oracle ''SID'' for your Oracle instance (usually the same as the server name.)

In SQLDeveloper, you can setup ''connections'' -- one for each ''schema'' you want to work with, for instance:
''qcsiteadmin_db'' is an Oracle Schema and an Oracle User at the same time.

The ALM Demo project in the Default domain might have the schema/user name of:
default_almdemo_db

Usually, all you need to do is check to see if you know a password and that it still works.

here is an example of a SQLDeveloper connection.
We know the IP address of the ORACLE server and the SID. We are trying to connect to qcsiteadmin_db and know the password.

![alt text][1]

We fill in the values and click TEST. If we see ''success'' for the status, we are correct.
Often, this is all we need to do to confirm connectivity.

From here, we can examine the various tables and rows of data in the Schema.

**BE CAREFUL!!!!**

You might be able to alter/modify/delete critical data, do not do so unless you know what you are doing.

[1]: /storage/temp/639-sqldev.jpg

Marked as spam
Posted by (Questions: 3, Answers: 448)
Answered on July 25, 2017 9:47 pm