Re: What will happen after this senario?

Commens embedded.
2ooo wrote:
> Hi All,
>
> I've install oracle 9i with 9.0.2.5 patch on windows 2000 server as
> "ABC" user who member windows administrator group.

Which flies in the face of convention, intuitive installation and the
accepted guidelines provided by Oracle as no one, with the lone
exception of yourself, will know this ABC user is the Oracle software
owner. And, you apparently haven't seen fit to pass this information
to anyone else outside of this newsgroup.

> Then I've create a small database ("DB1") and its listener... and then
> opened them. They are working properly and clients are connecting and
> using nicely. Everything is fine..

For now.

> But some day, Administrator of
> windows will log in the OS and drop the user ABC by mistake...

So out of the blue, so to speak, this Administrator will simply choose,
at random, this ABC user to drop, without investigating WHAT
applications and software this user's abscence might affect. How
thoughtful and thorough this Administrator must be...

> he
> doesn't know password of ABC user... So dropped the owner of oracle
> services and binaries... and then he will restart the server...
> now what will happen?

The service will die an agonising death. Actually, it will fail to
start. Oh, and your database won't start. And both you and your
Administrator will be looking for new employment. Anyone who drops a
user without first investigating WHY that user exists is a poor example
of an Administrator. And anyone who installs a major software product
and ignores the pre-installation checklist and accepted guidelines
needs to find some other line of work.

> Does the oracle database DB1 still live?

Only in your fondest dreams.

> if answer no then what will happen when re-create the ABC user
> different password? is it related spfile or password file ? etc..etc...

You COULD recreate the ABC user and grant it the same access as it
currently enjoys, and your service and instance will probably run.
And, no, it's not related at ALL to the spfile and it's not dependent
upon the password file, either. But, had you created an ORACLE user
instead of this ABC business you wouldn't be asking this question, nor
would you be considering this problem.

> What do you think about this problem?

I think you should have paid more attention to what you were doing, and
should have followed the accepted guidelines for an Oracle installation
rather than making up your own rules. You have successfully set
yourself up for failure with this situation, and you've done it with
what appears to be a production instance. When this system fails you
and your wonderful Windows Adminstrator will likely be shown the door;
you, for failing to follow accepted guidelines and your Administrator
for failing to properly research an action to ensure it didn't affect
the availability of your database and, as a result, adversely impact
user productivity. There is a place for creative thought in the IT
world, but installing major software using undocumented user accounts
is not one of them. Nor is installing such software and failing to
notify the server Administrator you've done so. Then, if this were my
shop this question wouldn't have seen the light of day, as the
installation would have been performed properly, according to the
guidelines set forth in the installation documentation. And the server
Administrator would have been informed of the installation and of the
user accounts required for its proper operation.

You have set yourself up for failure, on a grand scale. You should
update your resume, and do it quickly, as I you'll likely be looking
for new employment.


David Fitzjarrell

.

Relevant Pages

  • Re: Error when starting DBCA
    ... Are you reading and following the installation instructions or did ... Puget Sound Oracle Users Groupwww.psoug.org-ZitiertenTextausblenden - ... no problems with starting the dbca. ... I'm logged in as domain administrator so i have local administration ...
    (comp.databases.oracle.server)
  • Re: What will happen after this senario?
    ... > "ABC" user who member windows administrator group. ... > windows will log in the OS and drop the user ABC by mistake... ... > Does the oracle database DB1 still live? ...
    (comp.databases.oracle.server)
  • Re: Creating directories on Vista machines using .NET
    ... application that installs to the Program Files directory. ... For example, what do you mean by "using administrator rights, having ... This is the case with most modern games. ... It will *not* write to that installation path under ...
    (microsoft.public.dotnet.framework)
  • Re: Creating directories on Vista machines using .NET
    ... There are a number of relatively standard methods for maintaining application settings, none of which involve an Access database, nor storing the settings under the Program Files directory hierarchy. ... For example, what do you mean by "using administrator rights, having logged on as a normal user"? ... This includes changing the permissions of the root directory to prevent non-administrator accounts from having write access, as well as changing from the default installation directory to one under the Program Files tree. ... I’m hence considering this as a viable way to release my applications in future, since all of them will probably involve significant interactions with local Access databases. ...
    (microsoft.public.dotnet.framework)
  • Re: Problems installing SQL Server 2005 in two node cluster
    ... I'm assuming that SQL Server 2005 doesn't need to be an administrator ... that make sure you are not using domain admin-level accounts for the service ... Server2005Setup Log Files" and "StartingSQLServerManually." ... This is the fifth attempt at installation, ...
    (microsoft.public.sqlserver.clustering)