Re: Creating a database for more than 500 concurrent users

From: D_Kroma <jaf12466_at_yahoo.com>
Date: 26 Oct 2001 11:27:11 -0700
Message-ID: <63b32117.0110261027.122180d6_at_posting.google.com>

This note describes what sql scripts are needed to fully install all components of Oracle8i JVM, in version 8.1.5, 8.1.6 and 8.1.7. Scripts must be executed as SYS or INTERNAL. The 'initjvm.sql' script is responsible for the installation of the JVM,
the subsequent scripts mentioned will install the added functionality described by the corresponding comments (prefixed by the "--" characters).  

SCOPE & APPLICATION

---

Manual istallation of Oracle8i JVM

---

Folow the checklist guide for a manual install of the Oracle8i JVM as described in
[NOTE:105472.1] <ml2_documents.showDocument?p_id=105472.1&p_database_id=NOT>Setup, Configuration, and Use of the Java Virtual Machine (JVM) [NOTE:103855.1] <ml2_documents.showDocument?p_id=103855.1&p_database_id=NOT> Jserver Installation for Oracle8i

Note: ? is sqlplus substitution fo $ORACLE_HOME or %ORACLE_HOME% and it can be used on both Unix and Windows platforms.

Scripts needed for JVM version 8.1.5

---

Only script needed for 8.1.5 version is initjvm.sql

• Script jvm_install_815.sql start ------------------
  -- Setup a database for running Java and the ORB
  spool initjvm.log spool off
• Script jvm_install_815.sql end ------------------

Scripts needed for JVM version 8.1.6

---

In 8.1.6 additional scripts are needed:

• Script jvm_install_816.sql start ------------------
  -- Setup a database for running Java and the ORB
  spool initjvm.log spool off
  • Initializes Java library needed by PL/SQL spool initplsj.log spool off
  • Load AQ/JMS jar files into the database spool initaqjms.log spool off
  • Load RepAPI server classes and publish 'repapi' obj spool initrepapi.log spool off
• Script jvm_install_816.sql end ------------------

Scripts needed for JVM version 8.1.7

---

In 8.1.7 many new Java API's and components are added. So, we need to run even more scripts :

• Script jvm_install_817.sql start ------------------
  -- Setup a database for running Java and the ORB
  spool jvminst.log spool off
  • Loads xml components into the JServer spool initxml.log spool off
  • loads the XMLSQL Utility (XSU) into the database spool catxsu.log spool off
  • JIS (OSE) installation spool init_jis.log spool off
  • Turn on JAccelerator (ncomp) for JIS spool jisja.log spool off
  • Adds the set of default end points to the server
  • with hardcoded values for the admin service spool jisaephc.log spool off
  • Load PLSQL Gateway Servlet jar files into the database spool initplgs.log spool off
  • Install Oracle JSP spool initjsp.log spool off
  • Turn on JAccelerator for JSP libs spool jspja.log spool off
  • Initializes Java library needed by PL/SQL spool initplsj.log spool off
  • Load AQ/JMS jar files into the database spool initjms.log spool off
  • Load RepAPI server classes and publish 'repapi' obj spool initrepapi.log spool off
  • loads sql, objects, extensibility and xml related java spool initsoxx.log spool off
  • Configure OSE defauls admin Web Service spool jisaep.log spool off
• Script jvm_install_817.sql end ------------------

RELATED DOCUMENTS

---

Note.105472.1 Setup, Configuration, and Use of the Java Virtual Machine (JVM)
Note.103855.1 Jserver Installation for Oracle8i Note:156477.1 JVM Installation on 8.1.7
.

########## and search this articles in http://metalink.oracle.com ##########

Jorge Acevedo
Santiago
Chile.

usharamakrishna2001_at_yahoo.com (usha) wrote in message news:<50f52462.0110200336.7461da7d_at_posting.google.com>...

> hi,
> 
> As  I wanted to create a database for more than 500 concurrent users.
> Can anyone help me the  configuration  of the following along with
> calculations why we  r using  that.
> 
> 
> Roll BAck Segments.
> db_block_size : 8K 
> MTS and Dedicated server
> Sort_area_size
> 
> Large_pool_size
> For MTS : > 500 MB
> For Dedicated Server : Min < 1 M
> 
> db_block_buffers
> shared_pool_size
> processes: > 515
> log_buffer
> open_cursors :> 100
> max_enqabled_roles :> 30
> 
> 2. 
> 
> Database physical Design

Received on Fri Oct 26 2001 - 20:27:11 CEST