RE: Ownership of multiple databases in the same box

From: Djordje Jankovic <djankovic_at_corp.attcanada.ca>
Date: Wed, 2 Aug 2000 17:21:58 -0400
Message-Id: <10577.113659@fatcity.com>

Thanks to everybody who replied.

I also created one user. The thing that made me think is that when I am using top to see which processes are consuming most resources, I don't know on which instance the process is connected to. Having different usernames would make life a bit easier there. But I agree that for the upgrade it should be easier to have one user.

Djordje Jankovic
Senior Database Administrator
AT&T Canada
Internet and E-Business Services
905 King St. W.
Toronto, ON M6K 3G9
Tel.: (416) 341-5813
Fax.:(416) 341-5725
djankovic_at_corp.attcanada.ca <mailto:djordjej_at_netcom.ca>

		-----Original Message-----
		From:	root_at_fatcity.com [mailto:root_at_fatcity.com] On Behalf
Of William Beilstein
		Sent:	August 1, 2000 10:16 AM
		To:	Multiple recipients of list ORACLE-L
		Subject:	Re: Ownership of multiple databases in the

same box

At our site we have a single Unix user (oracle) that owns all the instances. We wrote a .profile script that gives the user a list of instances and asks them what database they want to administer. After they select it sets the various environmental information (ORACLE_HOME, ORACLE_BASE, SID....etc).

>>> Djordje Jankovic <djankovic_at_corp.attcanada.ca> 08/01/00
09:23AM >>>

Hi listers,

I need an opinion, experience.

When you have multiple instances running on the same server do you think

that it is better that each database has its own unix user/owner or that

each database has its own unix user.

I don't remember OFA mentioning anything about that ?

Djordje Jankovic

		-- 
		Author: Djordje Jankovic
		  INET: djankovic_at_corp.attcanada.ca 

		Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
		San Diego, California        -- Public Internet access /

Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

		the message BODY, include a line containing: UNSUB ORACLE-L
		(or the name of mailing list you want to be removed from).
You may
		also send the HELP command for other information (like

subscribing).

		-- 
		Author: William Beilstein
		  INET: BeilstWH_at_obg.com

		Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
		San Diego, California        -- Public Internet access /

Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

		the message BODY, include a line containing: UNSUB ORACLE-L
		(or the name of mailing list you want to be removed from).

Received on Wed Aug 02 2000 - 16:21:58 CDT