admin 4: start stop server processes - noradle/noradle-oracle-server GitHub Wiki
Start and Stop NORADLE OSPs on oracle side
NORADLE OSPs is just a bunch of background job processes managed by oracle dbms_scheduler ,
They run as the NORADLE engine software database user, normally is "PSP".
NORADLE provide K_PMON
package to manager the server processes.
- `K_PMON.RUN_JOB`
- It will run NORADLE's pmon as a deamon and start all the parallel server job processes
- ".run_job" will check server_config_t, for each config record, start up ".min_servers" number of servers.
- if any server quit for the reason of exception, ".max_requests" reached, or ".max_lifetime" reached, the monitor deamon will re-spawn new servers, try keep server quantity to ".min_servers'.
- `K_PMON.STOP`
- It will send signal to NORADLE'S pmon and all server processes to tell them to quit
To start/stop NORADLE OSPs, just login as NORADLE engine user (normally "PSP") in sqlplus,
and execute k_pmon.run_job/k_pmon.stop
.
Then check State on the Oracle side.
check if oracle background job processes is running by the SQLs below (login as PSP user)
select * from user_scheduler_jobs a where a.job_name like 'Noradle-%';
select * from user_scheduler_running_jobs a where a.job_name like 'Noradle-%';
select a.client_info, a.module, a.action, a.*
from v$session a
where a.status = 'ACTIVE'
and a.client_info like 'Noradle-%'
order by a.client_info asc;
Read pipe named "node2psp" for any exception the Noradle servers encounters.
For example, if you use "PL/SQL Developer" IDE, you can go to menu "tools -> event monitor",
set "Event Type" to "pipe", "Event Name" to "node2psp",
press "Start" button to catch all the trace log info in the oracle side.