Automatically starting the context server

Hi,

I have a 8.1.7 database with intermedia installed.

I have to manually start the context server everytime i shutdown/startup the database.

Is there a way I can automate this process.


Thanks

U can start context server in database operations triggers:
after STARTUP, and before SHUTDOWN.

CREATE TRIGGER start_ctx AFTER STARTUP ON DATABASE
BEGIN
....
-- start context server
END;
/

CREATE TRIGGER start_ctx BEFORE SHUTDOWN ON DATABASE
BEGIN
....
-- stop context server
END;

Hi,

It needs to execute a exe file to start the serverand thats an operating system command.

This is what is required to execute it from the dos prompt

ctxsrv -user ctxsys/ctxsys@company -personality M

i am not sure whether it can be done using some other way or not.

btw I am using 8.1.7.3 on windows 2000.

Any help would be appreciated.


Thanks

U can start externam c/c++ dll from these triggers.

0) write very small c program (as *.dll), that can start host command (for example ctx_start_stop.dll)
1) create library
CREATE LIBRARY ctx_start AS 'c/prg_exterlal/ctx_start_stop.dll';
2) create "wrap" procedures/functions on pl/sql

CREATE OR REPLACE FUNCTION p_ctx_start
RETURN BINARY_INTEGER
AS LANGUAGE C
LIBRARY ctx_start
NAME "c_start";

CREATE OR REPLACE FUNCTION p_ctx_stop
RETURN BINARY_INTEGER
AS LANGUAGE C
LIBRARY ctx_start
NAME "c_stop";

then u can use its in ur triggers.