Re: Oracle 10.2G windows service started but instance is in nomunt mode

On Dec 18, 12:04 pm, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> On Dec 18, 10:20 am, radian7 <radi..._at_poczta.onet.pl> wrote:
>
>
>
>
>
> > On 18 Gru, 13:36, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> > > On Dec 18, 5:13 am, radian7 <radi..._at_poczta.onet.pl> wrote:
>
> > > > On 18 Gru, 11:05, vitalis..._at_gmail.com (Jerome Vitalis) wrote:
>
> > > > > radian7 wrote:
> > > > > > Can You help me ?
>
> > > > > Hi,
>
> > > > > Show us the alert.log contents.
> > > > > -----
> > > > > échangez opinions et commentaires dans les forums de discussion.http://www.usenetgratuit.com/
>
> > > > in oradim.log I found following error:
> > > > Tue Dec 18 05:00:02 2007
> > > > ORA-01017: incorrect username/password; logon refuse
>
> > > > but I didn't change any password...
>
> > > > This is my alertlog:
>
> > > > Tue Dec 18 05:00:01 2007
> > > > ORACLE V10.2.0.2.0 - Production vsnsta=0
> > > > vsnsql=14 vsnxtr=3
> > > > Windows Server 2003 Version V5.2 Service Pack 1
> > > > CPU : 4 - type 586, 2 Physical Cores
> > > > Process Affinity : 0x00000000
> > > > Memory (Avail/Total): Ph:1468M/2047M, Ph+PgF:3527M/3947M, VA:1940M/
> > > > 2047M
> > > > Tue Dec 18 05:00:01 2007
> > > > Starting ORACLE instance (normal)
>
> > > > Regards
>
> > > What users are in the ora_dba group (Computer Management in the
> > > Administrative Tools Control Panel, System Tools, Local Users and
> > > Groups, Groups, ora_dba). Also, what users are in the Administrators
> > > group? Specifically, is the username that you logged into at the
> > > server currently listed in both groups? The user does not need to be
> > > in the Administrators group, but does need appropriate permissions to
> > > access/modify Oracle related files and registry settings.
>
> > > Charles Hooper
> > > IT Manager/Oracle DBA
> > > K&M Machine-Fabricating, Inc.- Ukryj cytowany tekst -
>
> > > - Poka¿ cytowany tekst -
>
> > In ora_dba group is local administrator...
> > I run oradim as loacal administrator...
>
> > Regards
>
> If the database was created with Oracle's DBCA, you may be able to use
> the following to start the instance and open the database:
> C:\> ORADIM -STARTUP -SID sid_name
>
> David offers a good alternative - I believe that the method requires
> the service to be running, and you may need to execute the following
> before starting SQLPLUS:
> C:\> SET ORACLE_SID=sid_name
>
> Note: you should be able to just starting the service (in the Control
> Panel) for the database instance, the database should automatically
> mount and open.
>
> Charles Hooper
> IT Manager/Oracle DBA
> K&M Machine-Fabricating, Inc.- Hide quoted text -
>
> - Show quoted text -

The issue is that the service is started, but the database isn't. I suggested what I did so the OP could see what Oracle was complaining about during startup.

David Fitzjarrell Received on Tue Dec 18 2007 - 12:20:41 CST