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:[EMAIL PROTECTED]]
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@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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to