Re: Post-Install: Oracle v9.2.0 on Mandrake9.2

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 3 Feb 2004 09:38:02 -0000
Message-ID: <401f6bfb$0$9388$ed9e5944@reading.news.pipex.net>

"php newbie" <newtophp2000_at_yahoo.com> wrote in message news:124f428e.0402022037.6c39d611_at_posting.google.com...
> "Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message
news:<kAATb.4822$cq2.44681499_at_news-text.cableinet.net>...
> > > users: oracle, test
> > > user oracle's groups: oinstall, dba, oracle
> > > user test's groups: test, oracle
> > > Global DB Name: db_lx92
> > > SID: lx92
> >
> > the test user is not in the dba group
>
>
> No, that is not it. I had tried it before, and tried it again just
> now. The test user still gets the same error message when trying to
> connect to the database.

Lets split your problems into 2, not so that there are twice as many, but so that we can break the problem down.

Unable to start or shutdown a database.

In order to do this an osuser MUST be in the dba group assuming that you aren't doing remote startup with a password file. If you want the test user to manage the database with SYSDBA privs then you should put it into the dba group.

2. Unable to connect because of the 'lost contact' message. This I can't help with, but it does look like a permissions problem as well. Received on Tue Feb 03 2004 - 03:38:02 CST