Re: Creating a **DEFAULT** database

Hi,

Thanks for the reply.

I was able to sort out the problem to an extent. I am not sure if the solution is right. I am
working on HP-UX 11.0. We have 2 users one is 'oracle8i' and the other is 'user1'. The 'oracle8i' user belongs to a group - 'dba' on unix and 'user1' belongs to someother group. We were not able to
execute sqlplus from 'user1' even after setting ORACLE_BASE, ORACLE_HOME, ORACLE_SID and PATH to point to ORACLE_HOME/bin.

The moment sqlplus was executed from 'user1' login it would say

ORA 01034: Oracle not available

whereas the same thing works with 'oracle8i' login. 'oracle8i' is the unix login from which oracle was installed.

The problem was sorted out by adding the 'user1' to the 'dba' group. Does oracle have a list of
authenticated users??. The same thing is not required on Sun Solaris. On Solaris 'user1' still belongs to a different unix group.

Would help if I could get some comments on the above.

Thanks and Regards,
M Shetty

Richard Huntley wrote:

>
>
> Are you trying to connect as the Oracle software owner?
> Also, what's the OS?
>
> -----Original Message-----
> From: Mranalini Shetty [mailto:mranalini.shetty_at_patni.com]
>
> Sent: Saturday, July 27, 2002 7:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Creating a **DEFAULT** database
>
> Hi,
>
> Forgot to mention the error msg that I get on connecting
> using just the
> "username" --
>
> ORA-01034: ORACLE NOT AVAILABLE
>
> Thanks and Regards,
> Mranalini
>
> Mranalini Shetty wrote:
>
> > Hi,
> >
> > Our new database is behaving a little strange. Both our
> > Oracle Server and Client are on the same machine but
> while
> > connecting through the Client I need to specify
> > "username_at_database_name". The same does not happen when
> I
> > run sqlplus, "sqlplus scott/tiger" works.
> >
> > The variable ORACLE_SID is appropriately set, it's
> pointing
> > to the new database name. The new database is mounted
> and
> > the listener services are up.
> >
> > Someone kind of hinted that the database is created as a
>
> > remote
> > database. Can I check what it currently is ... I mean a
> > default one /
> > remote.
> >
> > We didn't face this problem with the old database. On
> > comparing the init<SID>.ora files we found that the new
> > database did not have the db_domain name set. We tried
> > setting this in the init file (was done after the
> database
> > was created).
> >
> > Would help if I got some hint on where and what to look
> for.
> >
> > Thanks and Regards,
> > M Shetty
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Mranalini Shetty
> > INET: mranalini.shetty_at_patni.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> >
> --------------------------------------------------------------------
>
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> ORACLE-L
> > (or the name of mailing list you want to be removed
> from). You may
> > also send the HELP command for other information (like
> subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Mranalini Shetty
> INET: mranalini.shetty_at_patni.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
>
> -------------------------------------------------------------------
>
> To REMOVE yourself from this mailing list, send an E-Mail
> message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information (like
> subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mranalini Shetty
  INET: mranalini.shetty_at_patni.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).