Re: Oracle 8.0.5.0.0 setup under Win NT

I saw similar questions were already responded to, but anyway..

1. No, one system is fine. You do need two databases though. Otherwise you run in the situation you are shutting the system with the OEM repository in it, and then you can't use OEM anymore This is what we call the chicken and egg problem
2. You need to setup a user distinct from sys or system, I usually call them <SID>DBA. As soon as you connect to that user in the OEM console the repository will be created for you. The user will need SYSDBA privilege. You don't need to a different computer, you need an account in the database you created for OEM purposes.
3. Oracle Web Server is software to publish data on the web. If you are using Oracle Designer/Developer forms and reports through a browser, you probably need Oracle Application Server, and then you will have a 3-tier architecture. Oracle Web Server in itself has nothing to do with 3-tier archictecture, nor is Net8, that's just the networking software to connect to an Oracle database.
4. You can only create a table when you have connected to a database. This is the database the table will be created in. Which database receives the table is your decision.

Hth,

Sybrand Bakker, Oracle DBA

poonek_at_my-dejanews.com wrote in message <7hmhi4$n0a$1_at_nnrp1.deja.com>...
>Here is my questions about Oracle.
>
>1) Do I need to use at least two computers to install the Oracle
>8.0.5.0.0 server, one computer is used as a managed server while the
>other computer is used as console and respository? As I look at the
>manual come with the Oracle 8 product, it suggests that we must not
>install a repository and a production (managed) database in the same
>Oracle 8 database, is it necessary?
>
>2) What do I need for setup so that I can use the OEM (in the manual, it
>says that I need to create a repository account, does it mean that I
>need to use another computer and set it as console and respository? Can
>I use OEM in the managed database without lossing any database
>administration tasks such as starting or shutting down the database?)
>
>3) What is Oracle Web Server? Is it necessary to use it for a three
>tier setting if a Oracle database server is being installed? Can I use
>Net 8 in such a way?
>
>4) I want to use SQL Plus to create a table in a database (I have two
>databases with two SID, ORCL and ORC1 in the same computer). If I
>issue a command CREATE TABLE... Where would the table goes, in ORCL
>or ORC1?
>
>5) What is ConText Cartridge?
>
>Thanks for your help
>
>Edmond
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Sun May 16 1999 - 09:48:02 CDT