Problem:

The following error is received when connecting a StarTeam Server to Oracle

Resolution:

There are two reasons for the this error message:

1. The TNS Listener for the source repository has not been started
2. The parameters entered in the StarTeam Server configuration are incorrect

First, ensure that the listener service is running. To do this, open a command prompt and run the following command:

C:\>lsnrctl stat

This will show the status of the listener and the services it is listening for. 

For example:

If the service is not running start the listener service using lsnrctl from a command prompt

set ORACLE_HOME= cd %ORACLE_HOME%/bin

lsnrctl start LISTENER

If the listener service is not running, re-start the listener service using the Windows task manager or use the DOS command line utility to re-start the Windows service with the "net start" command:

C:\Documents and Settings\ME>net start OracleOraDb10g_home1TNSListener

You can use the lsnrctl status command to verify that the listener is down, and lsnrctl start to start your listener.

If the service is running but the parameters to enter into StarTeam Server are not known, check the parameters by using the lsnrctl command:

C:\>lsnrctl stat

Parameters are in bold

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Services Summary...

Service "orcl.133.12.143" has 1 instance(s).

Instance "orcl", status READY, has 1 handler(s) for this service...

The Database Server Name: is the HOSTname or address of where the Oracle database is located

In this case: HOST=127.0.0.1

The Database Server Port: is 1521 which is the default port number

The Service Name is orcl.133.12.143