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

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. Received on Tue Dec 18 2007 - 12:04:07 CST