Siebel Error: ODBC error 08003 in SQLConnect: [DataDirect][ODBC lib] Connection not open (native error 0). Unable to login using specified ODBC parameters.

Sometimes you may get below error while starting Siebel. 

Siebel Error:

ODBC error 08003 in SQLConnect:

[DataDirect][ODBC lib] Connection not open

(native error 0).

Unable to login using specified ODBC parameters.

Resolution :

1) Check ORACLE_HOME is set or not?

2) Check LD_LIBRARY_PATH is set or not?

3) Check TNS_ADMIN is set or not?

4) Check PATH is set in or not?

If all oracle parameters are not then set it.

Example :

bash-3.2$ export ORACLE_HOME=/app/oracle/product/11.2.0/client_32

bash-3.2$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

bash-3.2$ export TNS_ADMIN=/app/oracle/product/11.2.0/client_32

bash-3.2$ export PATH=$ORACLE_HOME/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin

PX Deq Credit: send blkd wait event in AWR

• PX Deq Credit: send blkd 
  
  
  • The PX Deq Credit: send blkd is an idle event in a parallel execution wait event for RAC. 
  • It may happen that several Object  in schema were defined that "degree of parallelism’ different from 1.
  • Use of Oracle parallel queries may cause optimized to choose ‘full table scan’ and ‘hash join’ instead of index access and ‘nested loops join’.
  • So, parallelism is not usually employed in OLTP systems. You can alter all those objects with NOPARALLEL option.
  
  
  You can check it in any DB with the following queries:
  SELECT TABLE_NAME FROM USER_TABLES WHERE TRIM(DEGREE) <> '1' ORDER BY 1;
  SELECT INDEX_NAME FROM USER_INDEXES WHERE TRIM(DEGREE) <> '1' ORDER BY 1;