Re: instance stuck in initialization

Barnel, I think we're on to something. My database was also manually created.

When I initially installed (ok the 4th time), the software got installed cleanly, but the script to build the initial database bombed out. I figured that was probably ok and proceeded to build a database by hand. Along the way, I discovered that catalog.sql had never been executed, so I ran it to build the dba_ tables. There must be another key script that needs to be executed.

Peggy

In article <39ADD737.E4AB304C_at_ottawa.com>,   Barnel <barnel_at_ottawa.com> wrote:
> Funny you should also have this problem. I am in the same situation
 as you
> are. The last thing (ok the last foolish thing) I remember doing was
> setting a my temporary tablespace to the permanent option and then
 back to
> temporary using Oracle's Storage Manager Utility. The thing is that
 when I
> was flickered the radio button between the 2 options and hitting the
 apply
> button. I don't remember seeing the "You were successful in doing what
 you
> were doing dialog box".
>
> The other thing that I see going against me is the fact that I
 manually
> created my database. Meaning I could not get dbassist to create my
 database
> or generate my db creation script (that another long story) so I
 found
> myself creating, altering and running the scripts from the
> $ORACLE_HOME/rdbms directory by myself. So I'm wondering if there is
 script
> or a procedure that I may have forgotten?
>
> Any suggestion (hopefully not involving having to re-create this God
> forsaking database) ?
>
> Thanks
>
> pjohns23_at_my-deja.com wrote:
>
> > I have a new installation of 8.1.5 on Solaris 7 that seems to be
 getting
> > hung up in an initialization mode.
> >
> > When I bring up the instance this happens:
> > SVRMGR> connect internal
> > Connected
> > SVRMGR> startup open dev1
> > ORACLE instance started.
> > Total System Global Area 37182864 bytes
> > Fixed Size 64912 bytes
> > Variable Size 10723328 bytes
> > Database Buffers 26214400 bytes
> > Redo Buffers 180224 bytes
> > Database mounted.
> > ORA-01403: no data found
> > SVRMGR>
> >
> > As long as I remain connected as internal, I can do whatever I want
> > (create a database, create/drop tablespaces, create/drop tables,
 ...).
> > However, when I try to connect as another user, this happens:
> > SVRMGR> connect dbauser/xxxxxxx
> > ORA-01033: ORACLE initialization or shutdown in progress
> > SVRMGR>
> >
> > This same ORA-01033 error occurs in sqlplus, imp, and every utility
 I've
> > tried, as well.
> >
> > Any ideas are greatly appreciated.
> > --
> > Thanks,
> > Peggy D. Johnson
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

--
Thanks,
Peggy D. Johnson


Sent via Deja.com http://www.deja.com/
Before you buy.