Re: connect question

sdg wrote:

> Ok, now I am more confused if that is possible. Are you saying that if user
> abc did not install oracle, this slight difference in the (connection
> string?) (one not inserting the password and one inserting it) is correct
> syntax?
>
> Daniel Morgan wrote:
>
> > sdg wrote:
> >
> > > Using 8.1.7.0.0
> > >
> > > When I use SQLPlus to start database following happens and I can not
> > > determine if this is correct.
> > >
> > > Connect abc as sysdba
> > > Enter password: ******
> > > ERROR:
> > > ORA-01034: ORACLE not available
> > > ORA-27101: shared memory realm does not exist
> > >
> > > connect abc/password as sysdba
> > > Connected to an idle instance.
> > > SQL>
> > >
> > > Entering the password as opposed to not causes this error and is
> > > correct?
> >
> > If I understand your posting the issue is one of privileges. ABC did not
> > install, and does not own, the Oracle executables.
> > --
> > Daniel Morgan
> > http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> > (remove one 'x' from my email address to reply)

Yes. If you are not a member of the operating system group ORA_DBA (Windows), DBA (UNIX) you must use the password.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
(remove one 'x' from my email address to reply)