Re: startup nomount & not logged on

But did using connect / as sysdba work? As I haven't got 8i I can't experiment!

In article <3714C2EC.6ED84BB2_at_us.oracle.com>, Pete Sharman <psharman_at_us.oracle.com> writes
>My goodness! Someone who reads the manuals - you must have too much time on
>your
>hands, Andrew!
>
>Thanks for the heads up - this is the first I've seen that specifies version
>numbers where the connect internal is desupported.
>
>Pete
>
>Andrew Babb wrote:
>
>> Quoting from the Oracle8 New Features guide for Oracle8 v8.1.5
>>
>> "CONNECT INTERNAL will be completely desupported in Oracle8i, release 8.2"
>>
>> This is in Chapter 6, under the chapter "Deprecated and Desupported Features"
>>
>> Let's get modifying :-)
>>
>> Andrew
>>
>> Pete Sharman wrote:
>>
>> > Connect internal is still supported for backward compatibility. I've seen
>> > nothing that says when that support will stop. It's certainly still there
>in
>> > 8.1.5.
>> >
>> > HTH.
>> >
>> > Pete
>> >
>> > Diane wrote:
>> >
>> > > I think connect internal is supposed to be replaced by connect / as
>> > > sysdba
>> > > I did hear connect internal was not supported but all the support staff
>> > > I've talked to still use it
>> > > (I'm only on 8.0.5 so can't be definite)
>> > >
>> > > In article <7etopi$128_at_clannad.cs.colostate.edu>, georgios varsamopoulos
>> > > <varsamop_at_cs.colostate.edu> writes
>> > > >Hi,
>> > > > I'm installing Oracle8i on a Solaris 2.7 machine and
>> > > >I have created the necessary sripts through dbassist to create
>> > > >a database. The first script had the following lines
>> > > >
>> > > >spool somefile
>> > > >connect internal
>> > > >startup nomount pfile = /somewhere/oracle/admin/SOLDB/pfile/initSOLDB.ora
>> > > >
>> > > >and I'm getting the following:
>> > > >
>> > > > ORACLE instance started.
>> > > > ORA-01012: not logged on
>> > > >
>> > > >The first one is expected, the second is not. What's is going on?
>> > > >(note that the next command is a CREATE DATABASE statement that doesn't
>> > > >get executed because "ORA-01012: not logged on")
>> > > >
>> > > >Can anybody help me sove this problem?
>> > > >
>> > > >Thank you in advance,
>> > > >George Varsamopoulos
>> > > >
>> > >
>> > > --
>> > > Diane
>> >
>> > --
>> >
>> > Regards
>> >
>> > Pete
>> >
>> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> > Peter Sharman Email: psharman_at_us.oracle.com
>> > WISE Course Development Manager Phone: +1.650.607.0109 (int'l)
>> > Worldwide Internal Services Education (650)607 0109 (local)
>> > San Francisco
>> >
>> > SQL> select standard_disclaimer, witty_remark
>> > 2 from company_requirements;
>> >
>> > Opinions are mine and do not necessarily reflect those of Oracle
>> > Corporation
>> >
>> > "Controlling application developers is like herding cats."
>> > Kevin Loney, ORACLE DBA Handbook
>> > "Oh no it's not! It's much harder than that!"
>> > Bruce Pihlamae, long term ORACLE DBA
>> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>--
>
>
>Regards
>
>Pete
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Peter Sharman Email: psharman_at_us.oracle.com
>WISE Course Development Manager Phone: +1.650.607.0109 (int'l)
>Worldwide Internal Services Education (650)607 0109 (local)
>San Francisco
>
>SQL> select standard_disclaimer, witty_remark
> 2 from company_requirements;
>
>Opinions are mine and do not necessarily reflect those of Oracle
>Corporation
>
>"Controlling application developers is like herding cats."
>Kevin Loney, ORACLE DBA Handbook
>"Oh no it's not! It's much harder than that!"
>Bruce Pihlamae, long term ORACLE DBA
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
>[ A MIME text / x-vcard part was included here. ]
>

--
Diane Received on Wed Apr 14 1999 - 15:50:07 CDT