| Install JServer and XMLDB manually in Oracle 10g |
|
|
|
| Written by Martin | ||||
| Saturday, 07 April 2007 | ||||
Page 1 of 2 Have you ever wondered how to manually install JServer into in existing Oracle 10g Database? Why should someone do this - that's quite simple: from a security point of view, install only what is necessary. When going through Oracle's security advisories, you'll soon find out that components such as Intermedia and - to a lesser extent - spatial - are more likely to be hit by security exploits that for example XMLDB. Anyway, this article assumes you have installed the database as in my other article "how to manually create an Oracle 10g database".
Introduction to JServer JServer is the foundation of many of the other Oracle components such as Intermedia, UltraSearch (=Oracle Text) etc. Although it's possible to install it without the natively compiled Java classes (NCOMP) I strongly recommend installing them first. Before you begin, make sure you do have at least 150M of shared pool and another 150M for your Java pool or the installation will fail miserably with ORA-00600 errors due to memory shortages: SQL> select name,value from v$parameter where name in ('shared_pool_size','java_pool_size'); If the values both are "0" then chances are high you're using automatic SGA management. In this case query v$parameter for sga_target and additionally V$SGA_DYNAMIC_COMPONENTS to get the current values for these pools Installing JServer To install JServer, all you need is to run this little script as sys: connect / as SYSDBA Once finished you're ready to continue the XMLDB installation. Check for possible problems by "grepping" for "ORA-" and "SP2-" in the install_JServer.log file. |
||||
| Last Updated ( Saturday, 07 April 2007 ) | ||||
| < Prev | Next > |
|---|