Versions Compared

Old Version 4

changes.mady.by.user Rashmi Likhite

Saved on

compared with

New Version 5

changes.mady.by.user Rashmi Likhite

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Celoxis JDBC Probe is a java program that helps understanding of connection issues with your database server. 

...

Info

This test needs to be run from the server where Celoxis will be installed; NOT on the database server.

Usage

...

  1. Unzip the jdbc-probe.zip file. It should create a folder with the file JDBCProbe.class in it.
  2. Open a command prompt and cd to the folder that contains the JDBCProbe.class file.

  3. On Microsoft Windows run the program (substituting values according to your configuration) as:

    Code Block
    java -cp .;drivers/* JDBCProbe product=oracle name=celoxis user=tim password=fox host=localhost


    On Linux or Mac OS run the program (substituting values according to your confiuration) as: 

    Code Block
    java -cp '.:drivers/*' JDBCProbe product=oracle name=celoxis user=tim password=fox host=localhost

...

Understanding the Error Messages

Common errors for Oracle

ERROR MESSAGEPOSSIBLE CAUSES
The Network Adapter could not establish the connection
  • The host name cannot be resolved by the DNS server.
  • Database server is not running on the host.
  • The database port on the database server is inaccessible because of a firewall 
Invalid username/password; logon deniedUsername or password is incorrect
Connection refused(DESCRIPTION=(TMP=) (VSNNUM=153092352)(ERR=12505) (ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
  • The database name is incorrect
  • The user doesn't have privileges to logon to the database

...