isqlplus

[anna]

Hi
I have installed oracle database 10.2.0.1 in one machine and i let the
16 students (i teach oracle to) connect to the server through the
isqlplus.. everything worked great but after a while i found the
student unable to connect to the database (with 'page cannot be found'
error) so i had to restart the isqlplus service to solve such a
problem but it is really irritating and makes the students feel that
oracle is not stable.. Actually i believe that there is a
configuration file by which i can handle such a problem ( something
like number of threads) ... please help in solving such a problem!

Anna

[fitzj...@cox.net]

I expect this is an issue with using an unpatched release of Oracle
(this should be patched up to 10.2.0.3), however this is a known issue
with iSQLPlus (and a reason it's no longer included with future
database releases). You might try starting it with this command:

nohup $ORACLE_HOME/jdk/bin/java -Djava.awt.headless=true -Xrs -
Doracle.oc4j.localhome=$ORACLE_HOME/sqlplus -Djava.security.properties=
$ORACLE_HOME/oc4j/j2ee/home/config/jazn.security.props -jar
$ORACLE_HOME/oc4j/j2ee/home/oc4j.jar -config $ORACLE_HOME/oc4j/j2ee/
isqlplus/config/server.xml &

and see where that takes you.

And I have found no advice from Oracle regarding any configuration
files and the number of allowed threads.


David Fitzjarrell