Here are the steps to re-link the database to the Operating System:

  1. Shut down the Instance. 
  2. Shut down the listener

    from the Unix prompt , make the following setting change:

cd $ORACLE_HOME/bin
relink all > /tmp/relink9sep.log 2>&1

once finished re-start the listener and the instance


If you cannot shut down the database, you can do the following:

cd $ORACLE_HOME/ctx/lib
make -f ins_ctx.mk install > <logfile> 2>&1


Note!: No text processes can be running (NO searches running , NO sync of indexes , NO optimization running ...) during this operation.