How to configure Scheduler in Unix and how to solve problems

Create a database user S_NQ_SCHEDS_NQ_SCHEDsqlplus to connect to the user and execute the SQL statement $ ORACLEBI_HOMEserverSchemaSAJOBS.Oracle. SQL and SAA

Create a database user S_NQ_SCHED/S_NQ_SCHEDsqlplus to connect to the user and execute the SQL statement $ ORACLEBI_HOME/server/Schema/SAJOBS. Oracle. SQL and SAA

Create Database User S_NQ_SCHED/S_NQ_SCHED

Connect sqlplus to the user and run the SQL statement $ OracleBI_HOME/server/Schema/SAJOBS. Oracle. SQL and SAACCT. Oracle. SQL

The DSN error is prompted. You need to modify odbc. ini.

Add a DSN setting

Configure the Administrator name and password, consistent with rpd

Odbc. ini file content

[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

Configure DNS to 131.240 in database

Configure Database

[NQSError: 46029] libclntsh. so.10.1: wrong ELF class: ELFCLASS64 Error

Specify the LD_LIBRARY_PATH = $ ORACLE_HOME/lib32 64bit library. Pay attention to the differences between 32bit and 64bit oracle and oraclebi.

NQSError: 17014 ORA-12154

Configure a local tnsnames. ora data source named 131.240, which is consistent with the DSN name in schconfig.

NQSError: 17014 incorrect ORA-01017 user name and password

Configure the database username and password in schconfig

How to determine if Scheduler is started normally

Use Job Manager in Windows to connect. the username and password are the username and password configured in General in schconfig.

[NQSError: 67004] Registry value for DSN not set. You need to configure the DNS under odbc. ini and schconfig. Refer to the above steps and the name must be consistent.