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

On Dec 18, 10:20 am, radian7 <radi...@xxxxxxxxxxxxxx> wrote:
On 18 Gru, 13:36, Charles Hooper <hooperc2...@xxxxxxxxx> wrote:
On Dec 18, 5:13 am, radian7 <radi...@xxxxxxxxxxxxxx> wrote:

On 18 Gru, 11:05, vitalis...@xxxxxxxxx (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.
.

Relevant Pages
Loading