Re: Enterprise 8i on linux - default dba?

My 2 cents (if problem has not been resolved by now what I can imagine): Oracle is generally configured to give all operating system users that log on either as the installation user (usually oracle) and all other users that are within the same OS group as the installation user (usually oinstall) the right to be a privileged user. That means you can start Server Manager (svrmgrl) or SQL* Plus if you use version (8.1 or higher) and then do a connect internal.

You should then have the right to startup and shutdown your database. But you can make any other user a privileged user by creating a password file with the command line utility orapw (creates a standard password file in the dbs dirctory) and then granting sysdba rights to that user. If you then use that user with the password given at the time of creation of the password file and connect "as sysdba" this user should also be able to start/stop the database.

best regards,
SOS
<gerald_bastin_at_my-deja.com> wrote in message news:91qjdp$47q$1_at_nnrp1.deja.com...
> Hummm your post scare me because my sys user doesn't have rights to
> stop my database. By the way System cannot stop it either.
> It seems that nobody can stop it..... May I have a problem. How can I
> check it ?
>
> In article <91q64b$g2a$1_at_soap.pipex.net>,
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:
> > as oulined in sybrands post sys is more powerful than system.
 sys/internal -
> > you can think of them as the same account for most purposes - has
 sysdba
> > privileges, whereas system doesn't. This means for example that sys
 can
> > startup/shutdown the db and perform incomplete recovery - system
 cannot.
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > <gerald_bastin_at_my-deja.com> wrote in message
> > news:91pvi8$kn1$1_at_nnrp1.deja.com...
> > > Is certainly the first question I have asked to myself when I saw
 the
> > > login screen. I have a nice database but how can I log to it ?
> > > There is 2 buit-in users with Oracle
> > > system with password manager
> > > sys with password change_on_install
> > >
> > > System seems to have more rights than sys so he is more powerful.
> > >
> > > I don't know more, I am a newbie trying to understand the great
 world
> > > of Oracle !
> > >
> > > Regards
> > >
> > > Gérald Bastin
> > >
> > > In article <3a40582f_at_monitor.lanset.com>,
> > > "John McClain" <jmcclain1_at_lanset.com> wrote:
> > > > I have installed enterprise 8i on suse linux 7.0. The install
 appears
 to
> > > > have been successfull. ( how can I really tell for sure??)
> > > > BUT, I would like to have access to the database I just installed!
> > > > Throughout the entire isntall process ( using the universal
 installer) I
> > > > never once was give a user and password for a login to sqlplus.
 Should there
> > > > be one? where could I find it? Do I need to setup db accounts
 using
 another
> > > > tool? if so what tool?
> > > > The issue is that when I type sqlplus, it prompts me for a user
 and
 login
> > > > makes sense) but I don't have one, so it returns 'invalid
 login/password
> > > > ...' Anyone out there that can help???
> > > >
> > > > --
> > > > John and Michelle McClain
> > > > 7604 Muschetto Ct.
> > > > Citrus Heights, Ca. 95621
> > > > (916)728-5223
> > > >
> > > >
> > >
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sat Feb 24 2001 - 08:15:53 CST