Re: Can't create user to login

Try to set up your unix environment variables like : setenv ORACLE_SID sid_name
where sid_name is the name of the instance and
setenv ORACLE_HOME oracle_path
where oracle_path is LIKE .../server/app/oracle/product/8.x etc . Before doing this make sure that they have not been set by typing env | grep ORACLE at the unix prompt.
If they have been set and they are not right try to do unsetenv ORACLE_SID
unsetenv ORACLE_HOME
and then do the setting ..
Hope this helps

--
Ravi Alluru
IS Consultant
On Site: Geoquest-Schlumberger
Cquay
PH (403) 298-4805
ralluru_at_cquay.com
" <jackling_at_singnet.com.sg> wrote in message
news:97io65$i3i$1_at_newton.pacific.net.sg...


> verison: 8.1.7  (on solaris 8)

> parameter REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

>

> I'm new to Oracle and this is a new installation. Hv trouble on connecting

> the database/instance

> with user other than Internal.

>

> This is a local login i.e. login directly to the server, not thru network

> login etc.

>

> 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, If I logon as

> Internal, I STILL no need

> password even I re-create the orapwdphoenixx password file and set a

> different password other than default 'oracle'. Why?

>

>

> Hope someone can tell me what's wrong.

> thanks,

> jackling

>

>

>

>

>

>