Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Creating a **DEFAULT** database

Re: Creating a **DEFAULT** database

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 30 Jul 2002 01:50:02 -0700
Message-ID: <1e8276d6.0207300050.5878bcb6@posting.google.com>


mshetty_at_mail.com (mshetty) wrote in message news:<bfbb8fd4.0207291738.34ee64f1_at_posting.google.com>...
> Hi,
>
> 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.

Maybe you should start reading NET8 Admin guide, especially parts about listener, listener.ora, tnsnames.ora and relations between them. Is not a very good idea to add ordinary users to DBA group and there is *NO NEED* to do this. You should properly setup your NET8 environment and everything will be OK and you would even be able to log from remote computer (what a miracle!). ;-)

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Tue Jul 30 2002 - 03:50:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US