I recently inherited support of a Progress database. All of my previous DBA
experience was with ORACLE. In ORACLE on a UNIX box we create an oracle user
that would own the software, have its own crontab, and have the ability to
start and stop the database among other things. With Progress I am hearing
that it is recommended that root do all of the things that the oracle user
I am used to did. This makes my UNIX admin nervous, can anyone give me some
advantages and disadvantages either way to help me decide which way to go on
this issue?
Dan Rohl
drohl@andersencorp.com
"Dan Rohl" wrote:
>
>I recently inherited support of a Progress database. All of my previous
>DBA
>experience was with ORACLE. In ORACLE on a UNIX box we create an oracle
>user
>that would own the software, have its own crontab, and have the ability
>to
>start and stop the database among other things. With Progress I am hearing
>that it is recommended that root do all of the things that the oracle
>user
>I am used to did. This makes my UNIX admin nervous, can anyone give me
>some
>advantages and disadvantages either way to help me decide which way to
>go on
>this issue?
>Dan Rohl
>drohl@andersencorp.com
"James Bailey" wrote:
>
"Dan Rohl" wrote:
>>
>>I recently inherited support of a Progress database. All of my previous
>>DBA
>>experience was with ORACLE. In ORACLE on a UNIX box we create an oracle
>>user
>>that would own the software, have its own crontab, and have the ability
>>to
>>start and stop the database among other things. With Progress I am hearing
>>that it is recommended that root do all of the things that the oracle
>>user
>>I am used to did. This makes my UNIX admin nervous, can anyone give me
>>some
>>advantages and disadvantages either way to help me decide which way to
>>go on
>>this issue?
>>Dan Rohl
>>drohl@andersencorp.com
This is not necessarily the case.
If Progress starts the databases then Progress can shut the databases via Porshut.
A Prolib user can do most other things.
Although Progress do recommend that all Databases are owned by root it is not
written in stone that this has to be so.
There are ways ound all problems.