The following error is received when connecting a StarTeam Server to Oracle
There are two reasons for the this error message:
First, ensure that the listener service is running. To do this, open a command prompt and run the following command:
This will show the status of the listener and the services it is listening for.
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:
Parameters are in bold
Listening Endpoints 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