ºìÁªLinuxÃÅ»§
Linux°ïÖú

UnixÏÂÅäÖÃSchedulerµÄ¹ý³ÌºÍ³öÏÖµÄÎÊÌâ

·¢²¼Ê±¼ä:2008-03-28 00:02:59À´Ô´:ºìÁª×÷Õß:Maril
´´½¨Êý¾Ý¿âÓû§S_NQ_SCHED/S_NQ_SCHED

sqlplusÁ¬½Óµ½Óû§Ï£¬Ö´ÐÐSQLÓï¾ä£¬$ORACLEBI_HOME/server/Schema/SAJOBS.Oracle.sqlºÍSAACCT.Oracle.sql

ÌáʾDSNµÄ´íÎó£¬ÐèÒªÐÞ¸Äodbc.ini

Ôö¼ÓÒ»¸öDSNµÄÉèÖÃ

ÅäÖùÜÀíÔ±Ãû×ֺ͹ÜÀíÔ±ÃÜÂ룬ÓërpdµÄÒ»ÖÂ

odbc.iniÎļþµÄÄÚÈÝ
[ODBC Data Sources]
AnalyticsWeb=Oracle BI Server
Cluster=Oracle BI Server
SSL_Sample=Oracle BI Server
131.240=libnqsdbgatewayoci10g.so
[131.240]
Driver=/usr/local/OracleBI/server/Bin/libnqsdbgatewayoci10g.so
Description=test data source
ServerMachine=192.168.131.240
DBCName=192.168.131.240
Username=S_NQ_SCHED
Password=S_NQ_SCHED
Database=orcl
DefaultDatabase=orcl

$. sa-init.sh
$schconfig
ÔÚdatabaseÖÐÅäÖÃDNSΪ131.240

ÅäÖÃÊý¾Ý¿â

[nQSError:46029]libclntsh.so.10.1: wrong ELF class: ELFCLASS64 ´íÎó
Ö¸¶¨LD_LIBRARY_PATH=$ORACLE_HOME/lib32 64bitµÄ¿â£¬×¢Òâ32bitºÍ64bitµÄoracleºÍoraclebiµÄÇø±ð

nQSError: 17014 ORA-12154
ÔÚ±¾µØÅäÖÃÒ»¸ötnsnames.oraÊý¾ÝÔ´£¬Ãû×ÖΪ131.240£¬¸ÃÃû×ÖÓëschconfigÖеÄDSNÃû×ÖÒ»ÖÂ

nQSError: 17014 ORA-01017 Óû§ÃûÃÜÂë²»¶Ô
ÔÚschconfigÖÐÅäÖúÃdatabaseµÄÓû§ÃûÃÜÂë

ÈçºÎÅжÏSchedulerÕý³£Æô¶¯
ʹÓÃWindowsϵÄJob ManagerÁ¬½Ó£¬Óû§ÃûÃÜÂëÊÇÔÚschconfigµÄGeneralÖÐÅäÖõÄÓû§ÃûºÍÃÜÂë

[nQSError: 67004] Registry value for DSN not set£¬ÐèÒªÅäÖÃodbc.iniºÍschconfigϵÄDNS£¬²Î¿¼ÉÏÃæµÄ²½Ö裬Ãû×Ö±ØÐëÒ»Ö¡£
ÎÄÕÂÆÀÂÛ

¹²ÓÐ 0 ÌõÆÀÂÛ