Oracle 11g R1 WinXP SP2 CPU 100 percent all the time

[Lanying & Manfred Chen-Fischer]

Hello

I've installed Oracle trial/demo EE software (Oracle site) Win XP SP2
computer 2 gigabyte storage without applying any rotten tricks. (Easy and
basic installation, no pre installation warnings, nothing!). Administrator
of WinXP is in the ora_dba group, allow batch and so on is set, dba_group +
admin can run batch operations and so on, all set like I did it in Ora 10g
(10g EE runs perfect). After rebooting, the oracle.exe process claims 100
percent of CPU usage (task manager). No Client application is stressing the
database. No SQL Developer, nothing!. What in the hell is oracle.exe doing?
Stopping emct (emctl stop dbconsole) all looks fine.
Any idea?

Manfred

[Charles Hooper]

On Apr 20, 12:22 pm, "Lanying & Manfred Chen-Fischer" <man...@t-

Have you checked the alert log for the database instance or the
listener log? Is it possible that Oracle is busy performing recovery
due to a previous shutdown abort, and had not yet registered the
database with the listener, yet the Enterprise Manager DB Control
service is repeatedly attempting to connect to the database instance?

In the alert log, do you see an error like this:
****************************
Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.1.0.6.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
11.1.0.6.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version
11.1.0.6.0 - Production
Time:
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=x))
WARNING: inbound connection timed out (ORA-3136)
****************************
In the alert log, are you seeing entries indicating recovery is
needed? Any errors reported?

In the listener log, does it appear that the database is attempting to
register itself several times per minute? Are you seeing multiple
connection attempts per minute from nmesrvc.exe (I believe that is the
name of the service)? Any errors reported?

FYI, the locations of the alert log and listener log have changed from
their relative locations on 10g. If you installed Oracle to the D:
drive, you might find the alert log here:
D:\Oracle\Product\diag\rdbms\instance\instance\trace

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.

[Lanying & Manfred Chen-Fischer]

Thank you, after registering the database
alter system register database;
no significant change

I think it must be a tremendous Oracle error, public patches are available?

Once again, I only installed the Oracle product, I've changed nothing

"Charles Hooper" <hoope...@yahoo.com> schrieb im Newsbeitrag
news:e56b25f4-8a13-408d...@q24g2000prf.googlegroups.com...