Configure Scheduler service on OBIEE 10.1.3.4.1

1.Setup Database schema for the scheduler.

cd /u01/app/obiee/OracleBI/server/Schema

SQL>create user S_NQ_SCHED identified by S_NQ_SCHED;

SQL>grant connect,resource to S_NQ_SCHED;

SQL>alter user S_NQ_SCHED default tablespace OLAP;

SQL>alter user S_NQ_SCHED temporary tablespace TEMP;

SQL>alter user S_NQ_SCHED quota unlimited on OLAP;

SQL>connect S_NQ_SCHED/S_NQ_SCHED@;

SQL>@SAJOBS.Oracle.sql

2. Add the tns entries of the database in the tnsnames.ora

for ex:

TEST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=asteroid.com)(PORT=1521))
(CONNECT_DATA=
(SID=TEST)
)
)


3. Configure datasource in odbc.ini

cd /u01/app/obiee/OracleBI/setup

[obiee@asteroid setup]$ . ./user.sh
[obiee@asteroid setup]$ . ./sa-init.sh
[obiee@asteroid setup]$ schconfig
Copyright (c) 1997-2009 Oracle Corporation, All rights reserved

***** Delivers Configuration Menu *****
1 - Configure Scheduler
2 - Configure Mail
3 - Configure iBots
4 - Configure Workflow
5 - Configure Java Extension
0 - Quit
>>> Enter Choice:
***** Scheduler Configuration *****
1 - Database
2 - General
3 - Advanced
0 - Quit

>>> Enter Choice: 1

***** Scheduler Database Configuration *****
1 - Database Type : Oracle 10g R2
2 - Call Interface : OCI 10g
3 - Data Source Name : TEST <-- Instance Name from the TNSNAMES.ORA
4 - User Name : S_NQ_SCHED
5 - Password : *****
6 - Timeout (Minutes) : 60
7 - Maximum Connections : 5
8 - Bulk Fetch Buffer Size (bytes) : 33792
9 - Database Table for Jobs : S_NQ_JOB
10 - Database Table for Instances : S_NQ_INSTANCE
11 - Database Table for Parameters : S_NQ_JOB_PARAM
12 - Database Table for Messages : S_NQ_ERR_MSG
13 - DEFAULT VALUES
0 - Quit

>>> Enter Choice: 2

***** Scheduler General Configuration *****
1 - Scheduler Script Path : /u01/app/obiee/OracleBI/server/Scripts/Scheduler
2 - Default Script Path : /u01/apps/obiee/OracleBI/server/Scripts/Common
3 - Temporary File Path : /u01/app/obiee/OracleBIData/tmp
4 - Port Number : 9705 <--- Port Number of scheduler service
5 - Purge Old instances after X days : 7
6 - Purge DB every X minutes : 5
7 - Minimum Execution Threads : 1
8 - Maximum Execution Threads : 100
9 - Pause When Service Starts : False
10 - Administrator Name : Administrator
11 - Administrator Password : *****
12 - DEFAULT VALUES
0 - Quit

Enter 0 and then save YES and exit

select option 3 to receive email from BI scheduler, You can choose Configure Workflow if you need workflow to be enabled.

***** Mail General Configuration *****
1 - From Display Name : Oracle Delivers
2 - Sender Address : mail@asteroid.com
3 - SMTP Server : asteroid.com
4 - SMTP Port : 25
5 - Number of Retries Upon Failure : 1
6 - Maximum Recipients : 0
7 - Use Bcc : True
8 - Authenticate against SMTP server: False
9 - User Name :
10 - Password : *****
11 - DEFAULT VALUES
0 - Quit


4. Configure presentation service to talk to the scheduler.

Add the scheduler port number in the instanceconfig.xml

cd /u01/app/obiee/OracleBIData/web/config

vi instanceconfig.xml

Add the port number:

Alerts
ScheduleServer Asteroid.com:9705/ScheduleServer
/Alerts


Add the credentialstore information:

CredentialStore
CredentialStorage type="file" path="/u01/app/obiee/OracleBIData/web/config /credentialstore.xml" passphrase="obiee"/
/CredentialStore




5. Run Cryptotools to add the latest update in credential store.xml

[obiee@asteroid config]$ cd /u01/app/obiee/OracleBI/setup/
[obiee@asteroid setup]$ . ./sysenvinit.sh
[obiee@asteroid setup]$ cd ../web/bin
[obiee@asteroid bin]$ pwd
/u01/app/obiee/OracleBI/web/bin


cryptotools credstore -add –infile /u01/app/obiee/OracleBIData/web/config/credentialstore.xml


Credential Alias: admin
Username: Administrator
Password: xxxxxxx
Do you want to encrypt the password? y/n (y): y
Passphrase for encryption: xxxxxx
Do you want to write the passphrase to the xml? y/n (n): y

Please make sure that credentialstore.xml file is updated with the following section at the end of the file.


6. Start the scheduler service

cd /u01/app/obiee/OracleBI/setup

[obiee@asteroid setup]$ ./run-sch.sh start
Oracle BI Scheduler startup initiated.
Execute the following command to check the Oracle BI Scheduler logfile and see if it started.
tail -f /u01/app/obiee/OracleBI/server/Log/NQScheduler.log

You can confirm if the scheduler is running by tailing the log file.

[obiee@asteroid setup]$ tail -f /u01/app/obiee/OracleBI/server/Log/NQScheduler.log
2011-01-18 08:55:11
[16020] Metadata Database Type: Oracle 10g R2
Data Source Name: TEST
Data Source Type: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64b
2011-01-18 08:55:11
[68013] Service started.
2011-01-18 08:55:11
Service started.

You can as well confirm by checking if the port number is listening to the incoming requests.
netstat -anp | grep 9705
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp 0 0 0.0.0.0:9705 0.0.0.0:* LISTEN 20527/nqscheduler

Install Apache on Linux

1. tar -xzf apache-tomcat-5.XX.tar.gz
2. sudo mv apache-tomcat-5.XX /usr/local/
3.cd /usr/local/
4. sudo ln -s apache-tomcat-5.XX/ tomcat
5. SET JAVA_HOME
6. SET CATALINA_HOME to /usr/local/tomcat

7. Use below script as startup scriptand put this under /etc/init.d

# This is the init script for starting up the
# Jakarta Tomcat server
#
# chkconfig: 345 91 10
# description: Starts and stops the Tomcat daemon.
#
# Source function library.
. /etc/rc.d/init.d/functions
# Get config.
. /etc/sysconfig/network
# Check that networking is up.
[ "${NETWORKING}" = "no" ] && exit 0
tomcat=/usr/local/tomcat
startup=$tomcat/bin/startup.sh
shutdown=$tomcat/bin/shutdown.sh
export JAVA_HOME=JAVA PATH
JAVA_OPTS=-Xmx1000m; export JAVA_OPTS
start(){
echo -n $"Starting Tomcat service: "
#daemon -c
$startup
RETVAL=$?
echo
}
stop(){
action $"Stopping Tomcat service: " $shutdown
RETVAL=$?
echo
}
restart(){
stop
start
}
# See how we were called.
case "$1" in
start)
start
;;
stop)
stop
;;
status)
# This doesn't work
status tomcat
;;
restart)
restart
;;
*)
echo $"Usage: $0 {start|stop|status|restart}"
exit 1
esac
exit 0





8. sudo chmod +x /etc/init.d/tomcat

9. sudo chkconfig --add tomcat

10. sudo service tomcat start

Oracle Apps Issues.

1. The Internal Concurrent Manager has encountered an error.

Review concurrent manager log file for more detailed information. : 06-JUL-2010
08:04:23 -


Shutting down Internal Concurrent Manager : 06-JUL-2010 08:04:23

List of errors encountered:
.............................................................................

_ 1 _
Routine AFPCSQ encountered an ORACLE error. .

Review your error messages for the cause of the error. (=)
.............................................................................



List of errors encountered:
.............................................................................

_ 1 _

2. Oracle apps login page not opening or showing blank:

Error in log file: [Sat Jul 10 15:13:30 2010] [notice] Accept mutex: fcntl (Default: fcntl)

Solution:

stop apps
go to $COMMON_TOP
remove contents of the folder _pages
perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 5
start apps

3. Oracle CM - Standard Manager not Starting up and giving below issue:
Routine AFPESA cannot construct the name of an executable file for REQID

Soln:

Add Custom Top in the ENV file and restart CM

4. Cloning issue after adcfgclone perl dbTier

RC-50004: Fatal: Error occurred in ApplyDatabase:
Control file creation failed


apply dbtechstack option and clone manually

5. RC-20200: Fatal -- Unzip issue - -add unzip to the path

Replaced unzip version with 5.5.2 and it worked.

6. APP-FND-01564 ORACLE error 942 in afpoload


apps user accnt locked

7. Oracle Apps login page is loaded, but the regular sysadmin and front-end user's password is not working(Even though the passwords aren't changed).

Check if all the background processes are running, particularly "mmon" in case of 10g and 11g: ps -ef | grep mmon

Check Alert log of the database to see if there was an errror during database shutdown.

Oracle Apps R12 Issues

Oracle CM - Standard Manager not Starting up and giving below issue:

Routine AFPESA cannot construct the name of an executable file for REQID


Soln: Add Custom Top in the ENV file and restart CM


Oracle apps login page not opening or showing blank:

Error in log file: [Sat Jul 10 15:13:30 2010] [notice] Accept mutex: fcntl (Default: fcntl)

Soln:

stop apps
go to $COMMON_TOP
remove contents of the folder _pages
perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 5
start apps

frm-92050 failed to connect to server; /forms/lservlet: -1

Soln: Internet Explorer Has Modified This Page To Prevent Cross-site Scripting [ID 1059574.1]