Q

Multiple Oracle Unix IDs

The Oracle database for Unix creates a single Oracle Unix ID, which can manage multiple databases and versions

in a single machine. Is there a way we can create say two databases using 8i and 9i and be able to have two Oracle Unix IDs. The oracle Unix IDs should be exclusive to its own database. Can this be done?

You can do it if you want. The process is described in the installation guide for your OS.

For example, the following information is found in the Installation Guide for Sun SPARC Solaris:

Create a UNIX Account to Own Oracle Software
-------------------------------------------
The Oracle account is the UNIX user account that owns the Oracle8i software after installation. Run Oracle Universal Installer with this user account. Use the admintool or useradd utility to create an oracle account with the following properties.

Login Name: Any name, but this document refers to it as the Oracle account.
Primary GID: The oinstall group.
Secondary GID: The dba group.
Home Directory: Choose a home directory consistent with other user home directories. The home directory of the oracle account does not have to be the same as the ORACLE_HOME directory.
Login Shell The default shell can be /usr/bin/sh, /usr/bin/csh, or /usr/bin/ksh, but the examples in this document assume the Bourne shell (/usr/bin/sh).
Caution: Use the Oracle account only for installing and maintaining Oracle software. Never use it for purposes unrelated to the Oracle8i Server. Do not use root as the Oracle account.

Sites with multiple ORACLE_HOMEs on one system may install Oracle Software with the same Oracle account, or separate ones. Each Oracle account must have oinstall as its primary group.

This was first published in October 2003

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close