Re: startup nomount & not logged on

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

a couple of facts about the problem
a) The installation of Oracle8i software had no errors b) This is the first database I try to create since the

   installation of the software.
c) Is the following symptom related to the problem?

   SVRMGR> connect sys/change_on_install as sysdba    Connected.
   SVRMGR> connect sys/change_on_install as sysdba    Connected.
   SVRMGR> CREATE DATABASE;
    CREATE DATABASE
   *
   ORA-01012: not logged on
   SVRMGR> connect sys/change_on_install as sysdba    ORA-12705: invalid or unknown NLS parameter value specified    SVRMGR> connect sys/change_on_install as sysdba    ORA-12705: invalid or unknown NLS parameter value specified

I'm willing to give the alert file or any related information to anybody who wants to help me.

Best regards,
George
In article <My$IqDA$9PF3IwHd_at_coalole.demon.co.uk>, Diane <Diane_at_coalole.demon.co.uk> writes:
|> 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. ]
Received on Thu Apr 15 1999 - 04:24:20 CDT