Help! very strange security problems.

verison: 8.1.7 (on solaris 8)

This is a new installation. Hv trouble on connecting the database/instance with user other than Internal

My setting:
Unix user name: phoenixx
Primary group for phoenixx: dba
SID: phoenixx

(as recommended in some articles, I hv also created these b4 oracle installation:)
Oracle installation Unix user name: oracle Primary group for that: oinstall

The oracle s/w directories and the datafiles directories are owned by oracle unix user and oinstall unix group.

Have created orapwphoenixx password file under $ORACLE_HOME/dbs directory.

OK to connect using internal e.g. sqlplus internal (password remains as oracle so no need to provide) but ...

Main Problem:
Except using Internal, unable to connect using other user accounts e.g. sqlplus system/manager, sqlplus sysdba/change_on_install (those are default passwords I've never changed)
System refuse to let me in.

If I connect as internal first eg sqlplus internal then connect system/manager, system will either disconnect me or has following msgs and disconnect me:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory

Anything I can do to fix this? Is it my configuration problem? Pls help.

In fact, I want to create a oracle db user and login as this user. But hv this problem and I can't continue.

Question 2:
Is it true that the phoenixx Unix user must have dba as the primary group?

Question 3:
After I include phoenixx Unix user as member of dba group, STILL no need password even I re-create the orapwdphoenixx password file and set a different password otherr than default 'oracle'. Why?

Hope someone can tell me what's wrong.
thanks,
jackling Received on Wed Feb 28 2001 - 10:05:05 CST