1. Check whether listener is running on the server, and check the tnsnames.ora file for service name and SID.

2. Run the following command to check whether listener is running on the specified port and SID (Export ORACLE_HOME and ORACLE_SID before running this command)

./sqlplus <UserName>/<Password>@"(DESCRIPTION=(FAILOVER=ON)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)

(HOST=192.68.10.10)(PORT=1521)))(CONNECT_DATA=(SID=orcl)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=5)(DELAY=10))))"

1. Check whether the Listener service is running on the server or not. If the the Listener service is not running, start the service. If it is running already, make sure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file.
2. In the CCS Console, check the port on which oracle database is configured on.
3. Open the listener.ora file, and verify whether the Listener is configured to listen for incoming requests on the same port. If not, delete the registered database. Re-configure the database, and enter the correct port number on which the Listener is running.

On Windows target computer

The Oracle services running on the machine must have the admin privileges on CCS user.

Make sure that the permission on Oracle Home folder and other Oracle files such as data files and control files are present for user which is used for data collection.

On UNIX target computer

To check whether Oracle process is running and to check its Oracle Home and SID name:

###ps -eo "pid,args" | grep pmon |   grep -v "grep" | while read Instances; do instanceID=$(echo $Instances |   egrep  -o '\b([0-9]+)\b'); instanceName=$(echo $Instances |   awk -F" " '{print $2}'); OraHome=$(  ls -llad /proc/$instanceID/exe |   awk -F"->" '{print$2}'); echo $instanceName=$OraHome; done

###ps -eo pid,command | grep tnslsnr | grep -v \"grep\" | awk -F' ' '{print$1":"$2":"$3}'

Solaris:

###ps -eo "pid,args" | grep pmon | grep -v "grep"

###pwdx <PID of pmon service> | awk -F" " '{print $2}'

###ps -eo pid,args | grep tnslsnr | grep -v "grep" | awk -F' ' '{print$1":"$2":"$3}'

1. Get instance names

##ps -eaf | grep pmon

2. Get instance home directory 

3. Get listeners running on machine

##ps -eaf | grep tnslsnr

4. Get the IP address and the port of running listeners. Get service names.(Export ORACLE_HOME and ORACLE_SID before running this command)##lsnrctl status <Listener Name>

Run the following commands to see the listeners which are currently running and if they are using TNS_ADMIN:

1. ps –ef | grep tnsls
2. Run the following command for all listeners:

pargs –e <pid of listener> | grep TNS_ADMIN

Oracle Data collection fails with Error:Platform =  not Supported in the logs

If an Oracle asset is added manually, make sure that the following asset type properties are updated properly.

• Operating System
• Operating System Version