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: startup nomount & not logged on

Re: startup nomount & not logged on

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 15 Apr 1999 08:58:22 -0700
Message-ID: <37160C9D.D663B39@us.oracle.com> 





George



Here's what happened when I tried some similar stuff with 8.1.5 on NT (comments inline):



First start the service from within the control panel to do some checking.  Then:



C:\oracle81\BIN>svrmgrl



Oracle Server Manager Release 3.1.5.0.0 - Production



(c) Copyright 1997, Oracle Corporation.  All Rights Reserved.



Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options


PL/SQL Release 8.1.5.0.0 - Production



SVRMGR> connect internal


Connected.


SVRMGR> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
INTERNAL                       TRUE  TRUE
SYS                            TRUE  TRUE


2 rows selected.



OK, SYS has the SYSDBA role by default (notice I haven't granted it anything at this stage, this
is the default database build).



SVRMGR> connect sys/change_on_install as sysdba;
Connected.



Seems to have connected OK, let's try a command to check:



SVRMGR> create database;


create database


*


ORA-01501: CREATE DATABASE failed


ORA-01100: database already mounted



Well, no 1012 error, but instead the expected error that the database was already mounted so we
could check things out.  Let's shut it down.



SVRMGR> shutdown


Database closed.


Database dismounted.


ORACLE instance shut down.


SVRMGR> create database;


create database


*


ORA-01034: ORACLE not available



Makes sense.  We did a complete shutdown, so before we can issue a create database statement we
need to start the instance.



SVRMGR> startup nomount


ORACLE instance started.

Total System Global Area                         71495628 bytes
Fixed Size                                          65484 bytes
Variable Size                                    54579200 bytes
Database Buffers                                 16777216 bytes
Redo Buffers                                        73728 bytes


SVRMGR> create database;


create database


*

ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: 'c:\oracle81\oradata\orcl\control01.ctl'
ORA-27038: skgfrcre: file exists
OSD-04010: <create> option specified, file already exists





Again, expected because I had already built a database using the default file locations, and NT
won't overwrite the existing file.



It seems everything is working OK.  Of course, the wisdom of just doing a create database with
everything defaulting is a different issue, but let's ignore that for the moment.  So here's
some things to check:



    
  
  1.   Try to connect internal then select from v$pwfile_users.  What does it say for SYS?  Does it
have the SYSDBA role?

  
  2.   Try the create database statement when connected as INTERNAL.  Do you get the same error?

  
  3.   Send us your init.ora file so we can check the NLS parameters.






HTH.


Pete



georgios varsamopoulos wrote:



> > 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. ]





--




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









Received on Thu Apr 15 1999 - 10:58:22 CDT












Original text of this message













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