ORA-27001 on Database Startup

Database: 10gr1 10.1.0.5.0

OS: Windows 2003 sp1 standard edition

When trying to start the database after enable PAE getting below error

ORA-27001 on Database Startup

fact: Oracle Server - Enterprise Edition
fact: MS Windows Platform
symptom: Database startup fails
symptom: ORA-27100: shared memory realm already exists
symptom: DB_BLOCK_BUFFERS parameter is not set too high for the machine resources

cause: Operating system has a duplicate Oracle memory segment still in memory.

fix:

Stop and start the database service. If this does not help, then a re-boot of the server will flush the memory

Metalink Note: 208285.1

Ora-27100 even After Restarting the Windows Service
Metalink Note: 370469.1

Changes

The parameter sga_max_size was changed from 2GB to 3GB through OEM Or Command prompt

Cause
Changing the parameter from OEM will make the change in the spfile.
ORA-27100 is received as a result of changes made to parameters affecting the SGA size.The service was created to start with spfile .When the service is restarted , it will use the spfile and the error occurs due to SGA parameter change.

Solution: try to start db with pfile instead of SPFILE.

How to enable PAE on windows platform

1. open boot.ini file (it is hidden system file)

2. add '/PAE /3GB' in the following format

[boot loader]timeout=30default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS[operating systems]multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /noexecute=optout /fastdetect /PAE /3GB

3. restart WINDOWS machine

4. check the system properties for PAE addition confirmation as above picture.

ORA-01422 + ORA-06512 + "SYSMAN.MGMT_TIME_SYNC"

Platform: Windows2003

During Patchset applying process from 10gr2(10.2.0.1.0) to 10gr2(10.2.0.4.0) "catupgrd.sql" ended with below error.

ERROR at line 1:

ORA-01422: exact fetch returns more than requested number of rows

ORA-06512: at "SYSMAN.MGMT_TIME_SYNC", line 193

ORA-06512: at line 2

All oracle component was successfully upgraded except OEM becuase of above error.

Clause: After searching on metalink and google didn't find proper reason why it is happened.

Solution: Re-Run catupgrd.sql script

ORA-07445 [SIGBUS] [Invalid address alignment]

One of my friend getting below error message with his database

In alertlog file

ORA-07445: exception encountered: core dump

[0000000101849ECC] [SIGBUS] [Invalid address alignment]

[0x7AF07180C000073] [] []

ORA-07445: exception encountered: core dump

[0000000101849ECC] [SIGBUS] [Invalid address alignment]

[0x7AF07180C000073] [] []

It is due to lack of SWAP space. Increase swap space will solve the issue.

for more info: Metalink Note: 268451.1

Error-1053

C:\>set ORACLE_SID=db01

C:\>emctl stop dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://alwarid-0a49914.fakhruddin.local:5504/em/console/aboutApplication
The OracleDBConsoledb01 service is not started.

More help is available by typing NET HELPMSG 3521.


C:\>net stop OracleServiceDB01
The service could not be controlled in its present state.

More help is available by typing NET HELPMSG 2189.


C:\>NET HELPMSG 2189

The service could not be controlled in its present state.


EXPLANATION

The service is not currently accepting requests. If
the service is starting, it cannot process requests until it is fully started.

ACTION

Try the operation again in a minute or two.

If this problem persists, the service may be stuck in a partially running state.
Contact technical support. Be prepared to give the name of the service and othe
r information about the system, such as the services and applications that were
running, and the type and amount of network activity on the computer at the time
of the problem.



C:\>NET HELPMSG 3521

The *** service is not started.



C:\>rem after few minutes

C:\>emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://alwarid-0a49914.fakhruddin.local:5504/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ...The OracleDBConsoledb
01 service is starting.........................................
The OracleDBConsoledb01 service was started successfully.


C:\>net start OracleServiceDB01
The requested service has already been started.

More help is available by typing NET HELPMSG 2182.