Re: OS groups for Oracle on Linux?

I do wish people would get into the habit of quoting the entire error message string and not just the number (there is no innate "oerr ora" on NT, for example!)

But anyway: no you're not screwed, just not quite up to speed with 9i yet.

In 9i, Server Manager doesn't exist anymore. In 9i, Internal doesn't exist anymore.
And in 9i, SYS cannot log on as a normal (though powerful) User anymore.

Since your error message is "ORA-28009: connection to sys should be as sysdba or sysoper", the last of these changes applies to you.

This has nothing to do with configuration or installation. It just means you are trying to log on as SYS without the 'as sysdba' keywords needed to alert Oracle to the fact that you wish to use the password file or O/S authentication methods instead of the data dictionary authentication method. The correct connection string will therefore read:

connect / as sysdba (if you are using O/S authentication) OR connect sys/change_on_install as sysdba (if using password authentication).

There's a large document on my site (under 'books') detailing this and all other 9i new features.

Regards
HJR

--
Resources for OracleT: www.geocities.com/howardjr2000
=========================================


"Stan Brown" <stanb_at_panix.com> wrote in message
news:9qfdqt$7k5$1_at_panix2.panix.com...


> This weekend I installed 9i on a Linux box. I thought i had everythign

> working OK, untill this morning.

>

> First I had been suing the "system" user to admin things this weekend.

Then


> today I tried to connect as "sys". I got an ORA-28009. Now I'm wondering

if


> I havemade a big mistake.

>

> Acording to my reading of the documnetation the "oracle" user should be

> primary group "ORAINVENTORY" (in my case oinstall). He should also be a

> member of the "ISDBA" group (in my case DBA). that is how I set it yup,

and


> I then ran the oracle installer as this "oracle" user. However in the past

> I remeber the Oracle user needing to be (primary Ithink) group DBA.

>

> So, am I screwd? Install only took about 36 hours, so I'm not anxious to

do


> it again :-)

>

> Or is thie a "point of fear" thing?

>

> Can I fix this?

>

> --

> "They that would give up essential liberty for temporary safety deserve

> neither liberty nor safety."

> -- Benjamin Franklin