After a Fresh Install ORA-12203 is Returned Trying to Login to Oracle Clinical - Thesaurus Management System (Doc ID 304562.1)

Last updated on JULY 29, 2010

Applies to:

Oracle Thesaurus Management System - Version: 4.5 and later   [Release: 4.5 and later ]
Oracle Clinical - Version: 4.5 and later    [Release: 4.5 and later]
Information in this document applies to any platform.
***Checked for relevance on 29-JUL-2010***

Symptoms

After a fresh install when trying to login to TMS the following error is returned:


ORA-12203 TNS unable to connect to destination.


It is possible to login to the database using the SQL*Plus executable under any of the oracle home directories e.g.
  • Oracle\806
  • Oracle\isuites
  • Oracle\9iDS
which confirms that the SQL*Net set-up is correct.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms