Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8.0.5.0.0 setup under Win NT
You do not have to have another computer and set it up as console and
respository. The choice is yours. You can use OEM in the managed
database without lossing database administration tasks.
example:
CREATE TABLESPACE OEM_REPOSIT
DATAFILE 'C:\ORANT\DATABASE\oemprod.dbf' SIZE 15M
DEFAULT STORAGE (INITIAL 100K NEXT 100K MINEXTENTS 1 PCTINCREASE 1)
ONLINE PERMANENT;
CREATE USER SYSMAN IDENTIFIED BY SYSMAN
DEFAULT TABLESPACE OEM_REPOSIT
TEMPORARY TABLESPACE TEMPORARY_DATA;
GRANT DBA TO SYSMAN IDENTIFIED BY SYSMAN;
QUESTION 4:
if you do startup an instance and connect to a database, that database
will host all your created objects.
hope that helps.
wozi_at_dhc.net
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 - 23:30:43 CDT