Troubleshooting guidelines for issues faced during Oracle data collection or asset import

book

Article ID: 170526

calendar_today

Updated On:

Products

Control Compliance Suite Control Compliance Suite Standards Server Control Compliance Suite Unix Control Compliance Suite Windows Control Compliance Suite Databases Oracle

Issue/Introduction

Steps to troubleshoot common issues faced during Oracle data collection and asset import are required.

Resolution

Refer to the following table for guidelines to troubleshoot common issues that are faced during Oracle data collection and asset import.

Steps to troubleshoot Oracle data collection and asset import issues
Error message Troubleshooting steps
ORA-12505: TNS listener does not currently know of SID given in connect descriptor
  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=10.211.106.64)(PORT=1521)))(CONNECT_DATA=(SID=orcl)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=5)(DELAY=10))))"

ORA-12541 TNS no listener
  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.
 
The parameter is incorrect=0D=0A. Scope is server <server name>

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:

Linux:

###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}'

Failed to read Window's Registry information during  Oracle data collection on Windows.
We use API ::RegConnectRegistry to connect to remote registry. RegConnectRegistry requires the Remote Registry service to be running on the remote computer. By default, this service is configured to be started manually. To configure the Remote Registry service to start automatically, run Services.msc, and change the Startup Type of the service to Automatic.
Oracle asset import fails

 

  1. Get instance names

##ps -eaf | grep pmon

  1. Get instance home directory 
##ls -lad /proc/<instance pid>/exe

 

  1. Get listeners running on machine

##ps -eaf | grep tnslsnr

  1. 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
Oracle connectivity issues

To test the Oracle connection from CCS manager machine, run the test utility available in the OCCI_Test.zip package in the Download Files section on this page. An example of how to use the OCCI utility is also given in the .zip package.

 

Attachments

OCCI_Test.zip get_app