Re: connect question

sdg wrote:

> See inline response
>
> Daniel Morgan wrote:
>
>> 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.
>
> I think you are missing my question/problem. User abc is a member
> (Windose) ORA_DBA. I am obviously presenting the problem/question
> poorly.
> In both examples I gave the system was given a password.
> In first example the user name was given and the password was given in
> response to system query. So, both user name and password given, but
> system errored out.
> Connect abc as sysdba
> Enter password: ****** <-- system generated 'Enter password:' and I
> entered password.
> ERROR:
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> In second example I input both user name and password (connect
> abc/password) and the system responds correctly.
> connect abc/password as sysdba
> Connected to an idle instance.
> SQL> here is where is issue startup.
> I do not understand why there is a difference. Same user, same
> password. Only difference is password IS NOT entered with connect
> string 'connect abc as sysdba' but entered when system requests it vs.
> password IS enterned, 'connect abc/password as sysdba' in initial
> string.
>
>>
>> --
>> Daniel Morgan
>> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
>> (remove one 'x' from my email address to reply)
>

Can't tell you why. All I can do is tell you that both messages are interpretable as ... instance wasn't started ... and the solution is the same as someone else previously noted.

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