Home » RDBMS Server » Server Administration » Problems with Oracle XE on win xp (DBA's please help! - Problems with Oracle XE on Win XP)
Problems with Oracle XE on win xp [message #552598] Thu, 26 April 2012 15:51 Go to next message
rahul15june
Messages: 35
Registered: May 2008
Member
Hi,

I have oracle XE installed on my machine and it was working absolutely fine for the last year or so. Today there was an trojan intrusion which caused some issues with my windows xp OS like hiding some files, desktop etc. After everything was cleaned up and things back to normal. I am having issues with XE.

1. I can start and stop XE with out any issues
2. When I use the run sql command line, I can connect using - connect sys/sys as sydba.
3. I can also run a query to see all the users and see the HR user also.

However,
1. When I connect to my hr user using connect hr/password@xe, it just hangs
2. I tried the- go to Oracle XE admin page but it just hangs for a long time and returns page cannot be found.
3. I can tnsping the xe instance.

Not sure what the issue is? I am not a DBA and don't have much knowledge on this. Is a fresh install the only option? or is there any way to correct this using the sys/sys user?

Please help!

Thanks,
Rahul

Re: Problems with Oracle XE on win xp [message #552600 is a reply to message #552598] Thu, 26 April 2012 17:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
is OS Services for the listener started & running?
Make OS listener service is running before proceeding below.

open a Command Window & issue following OS commands

lsnrctl start
lsnrctl status
lsnrctl service

COPY commands & results then PASTE all back here
Re: Problems with Oracle XE on win xp [message #552609 is a reply to message #552600] Thu, 26 April 2012 22:20 Go to previous messageGo to next message
rahul15june
Messages: 35
Registered: May 2008
Member
Hi Blackswan, attaching the same. Looks like the listener is fine.

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\rahu>lsnrctl start

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-APR-2012 08:48
:43

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started

C:\Documents and Settings\rahu>lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-APR-2012 08:49
:01

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
Start Date                27-APR-2012 08:42:51
Uptime                    0 days 0 hr. 6 min. 12 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           XE
Listener Parameter File   C:\oraclexe\app\oracle\product\10.2.0\server\network\a
dmin\listener.ora
Listener Log File         C:\oraclexe\app\oracle\product\10.2.0\server\network\l
og\listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rahu-lap)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rahu-lap)(PORT=8080))(Presentatio
n=HTTP)(Session=RAW))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
Service "xe" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\Documents and Settings\rahu>lsnrctl service

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-APR-2012 08:49
:23

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
Service "XEXDB" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1002 state:ready
         DISPATCHER <machine: rahu-lap, pid: 2236>
         (ADDRESS=(PROTOCOL=tcp)(HOST=rahu-lap)(PORT=1045))
Service "XE_XPT" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "xe" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
The command completed successfully


[Updated on: Thu, 26 April 2012 22:24]

Report message to a moderator

Re: Problems with Oracle XE on win xp [message #552610 is a reply to message #552609] Thu, 26 April 2012 22:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
try to connect to the DB to force the failure again
Then post last 100 or so lines from file below
C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
Re: Problems with Oracle XE on win xp [message #552625 is a reply to message #552610] Fri, 27 April 2012 01:49 Go to previous messageGo to next message
rahul15june
Messages: 35
Registered: May 2008
Member
Blackswan, I see the errors in the listener log as mentioned by you

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-APR-2012 00:40:26

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

System parameter file is C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
Log messages written to C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
Trace information written to C:\oraclexe\app\oracle\product\10.2.0\server\network\trace\listener.trc
Trace level is currently 0

Started with pid=4032
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sunnair-lap)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
27-APR-2012 00:41:23 * service_register * xe * 0
27-APR-2012 00:41:32 * service_update * xe * 0
27-APR-2012 00:42:08 * service_update * xe * 0
27-APR-2012 00:42:20 * service_update * xe * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sunnair-lap)(PORT=8080))(Presentation=HTTP)(Session=RAW))
27-APR-2012 00:42:26 * service_update * xe * 0
27-APR-2012 00:42:29 * service_update * xe * 0
27-APR-2012 00:42:35 * service_update * xe * 0
27-APR-2012 00:42:41 * service_update * xe * 0
27-APR-2012 00:42:50 * service_update * xe * 0
27-APR-2012 00:47:15 * service_update * xe * 0
27-APR-2012 00:52:12 * service_update * xe * 0
27-APR-2012 00:56:36 * service_update * xe * 0
27-APR-2012 01:06:39 * service_update * xe * 0
27-APR-2012 01:11:27 * service_update * xe * 0
27-APR-2012 01:14:45 * service_update * xe * 0
27-APR-2012 01:24:46 * service_update * xe * 0
27-APR-2012 01:26:55 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1460)) * handoff * http * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12560: TNS:protocol adapter error
27-APR-2012 01:27:25 * service_update * xe * 0
27-APR-2012 01:27:39 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1466)) * handoff * http * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12560: TNS:protocol adapter error
27-APR-2012 01:32:37 * service_update * xe * 0
27-APR-2012 01:36:22 * service_update * xe * 0
27-APR-2012 01:37:31 * service_update * xe * 0
27-APR-2012 01:47:35 * service_update * xe * 0
27-APR-2012 01:54:44 * service_update * xe * 0
27-APR-2012 01:54:47 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\oraclexe\app\oracle\product\10.2.0\server\BIN\sqlplus.exe)(HOST=sunnair-lap)(USER=sunnair))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.154.88.116)(PORT=1627)) * establish * XE * 0
27-APR-2012 01:54:54 * service_update * xe * 0
27-APR-2012 02:02:18 * service_update * xe * 0
27-APR-2012 02:03:11 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1675)) * handoff * http * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12560: TNS:protocol adapter error
27-APR-2012 02:07:36 * service_update * xe * 0
27-APR-2012 02:09:35 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\oraclexe\app\oracle\product\10.2.0\server\BIN\sqlplus.exe)(HOST=sunnair-lap)(USER=sunnair))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.154.88.116)(PORT=1754)) * establish * XE * 0
27-APR-2012 02:09:36 * service_update * xe * 0
27-APR-2012 02:11:30 * service_update * xe * 0
27-APR-2012 02:21:33 * service_update * xe * 0
27-APR-2012 02:28:15 * service_update * xe * 0
27-APR-2012 02:31:09 * service_update * xe * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sunnair-lap)(PORT=8080))(Presentation=HTTP)(Session=RAW))
27-APR-2012 02:31:46 * service_died * xe * 12547
TNS-12547: TNS:lost contact

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-APR-2012 08:08:33

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

System parameter file is C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
Log messages written to C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
Trace information written to C:\oraclexe\app\oracle\product\10.2.0\server\network\trace\listener.trc
Trace level is currently 0

Started with pid=1716
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sunnair-lap)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
27-APR-2012 08:09:12 * service_register * xe * 0
27-APR-2012 08:09:21 * service_update * xe * 0
27-APR-2012 08:09:36 * service_update * xe * 0
27-APR-2012 08:09:45 * service_update * xe * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sunnair-lap)(PORT=8080))(Presentation=HTTP)(Session=RAW))
27-APR-2012 08:09:54 * service_update * xe * 0
27-APR-2012 08:10:06 * service_update * xe * 0
27-APR-2012 08:10:15 * service_update * xe * 0
27-APR-2012 08:10:24 * service_update * xe * 0
27-APR-2012 08:10:48 * service_update * xe * 0
27-APR-2012 08:11:03 * service_update * xe * 0
27-APR-2012 08:11:22 * service_update * xe * 0
27-APR-2012 08:20:40 * service_update * xe * 0
27-APR-2012 08:20:55 * service_update * xe * 0
27-APR-2012 08:21:07 * service_update * xe * 0
27-APR-2012 08:31:07 * service_update * xe * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sunnair-lap)(PORT=8080))(Presentation=HTTP)(Session=RAW))
27-APR-2012 08:40:00 * service_died * xe * 12547
TNS-12547: TNS:lost contact

TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-APR-2012 08:42:50

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

System parameter file is C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
Log messages written to C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
Trace information written to C:\oraclexe\app\oracle\product\10.2.0\server\network\trace\listener.trc
Trace level is currently 0

Started with pid=480
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sunnair-lap)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
27-APR-2012 08:43:28 * service_register * xe * 0
27-APR-2012 08:43:37 * service_update * xe * 0
27-APR-2012 08:43:55 * service_update * xe * 0
27-APR-2012 08:44:04 * service_update * xe * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sunnair-lap)(PORT=8080))(Presentation=HTTP)(Session=RAW))
27-APR-2012 08:44:15 * service_update * xe * 0
27-APR-2012 08:44:25 * service_update * xe * 0
27-APR-2012 08:44:40 * service_update * xe * 0
27-APR-2012 08:44:43 * service_update * xe * 0
27-APR-2012 08:45:25 * service_update * xe * 0
27-APR-2012 08:48:43 * ping * 0
27-APR-2012 08:49:01 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=sunnair))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
27-APR-2012 08:49:23 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=sunnair))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * services * 0
27-APR-2012 08:54:22 * service_update * xe * 0
27-APR-2012 08:55:28 * service_update * xe * 0
27-APR-2012 09:05:31 * service_update * xe * 0
27-APR-2012 09:15:34 * service_update * xe * 0
27-APR-2012 09:15:47 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2241)) * handoff * http * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12560: TNS:protocol adapter error
27-APR-2012 09:25:37 * service_update * xe * 0
27-APR-2012 09:25:43 * service_update * xe * 0
27-APR-2012 09:28:04 * service_update * xe * 0
27-APR-2012 09:30:49 * service_update * xe * 0
27-APR-2012 09:35:13 * service_update * xe * 0
27-APR-2012 09:35:49 * service_update * xe * 0
27-APR-2012 09:45:49 * service_update * xe * 0
27-APR-2012 09:55:49 * service_update * xe * 0
27-APR-2012 09:56:01 * service_update * xe * 0
27-APR-2012 10:06:01 * service_update * xe * 0
27-APR-2012 10:16:02 * service_update * xe * 0
27-APR-2012 10:16:26 * service_update * xe * 0
27-APR-2012 10:26:29 * service_update * xe * 0
27-APR-2012 10:32:23 * service_update * xe * 0
27-APR-2012 10:36:29 * service_update * xe * 0
27-APR-2012 10:46:32 * service_update * xe * 0
27-APR-2012 10:56:33 * service_update * xe * 0
27-APR-2012 11:06:33 * service_update * xe * 0
27-APR-2012 11:06:42 * service_update * xe * 0
27-APR-2012 11:16:45 * service_update * xe * 0
27-APR-2012 11:26:48 * service_update * xe * 0
27-APR-2012 11:26:51 * service_update * xe * 0
27-APR-2012 11:30:30 * service_update * xe * 0
27-APR-2012 11:36:57 * service_update * xe * 0
27-APR-2012 11:46:57 * service_update * xe * 0
27-APR-2012 11:49:18 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=112.251.244.75)(PORT=8888)) * handoff * http * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12560: TNS:protocol adapter error
27-APR-2012 11:56:57 * service_update * xe * 0
27-APR-2012 11:57:09 * service_update * xe * 0
27-APR-2012 12:01:51 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=3878)) * handoff * http * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12560: TNS:protocol adapter error
27-APR-2012 12:04:48 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=14.97.174.86)(PORT=2286)) * handoff * http * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12560: TNS:protocol adapter error
27-APR-2012 12:04:48 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=14.97.174.86)(PORT=2292)) * handoff * http * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12560: TNS:protocol adapter error
27-APR-2012 12:07:12 * service_update * xe * 0
27-APR-2012 12:14:02 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=58.248.1.123)(PORT=44868)) * handoff * http * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12560: TNS:protocol adapter error
27-APR-2012 12:14:11 * http * (ADDRESS=(PROTOCOL=tcp)(HOST=58.248.1.123)(PORT=13114)) * handoff * http * 12518
TNS-12518: TNS:listener could not hand off client connection
 TNS-12560: TNS:protocol adapter error
27-APR-2012 12:17:15 * service_update * xe * 0
Re: Problems with Oracle XE on win xp [message #552626 is a reply to message #552625] Fri, 27 April 2012 01:51 Go to previous messageGo to next message
rahul15june
Messages: 35
Registered: May 2008
Member
Also as seen online, I am also posting the details of v$Resource_limit. Not sure if this was required. thanks!
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 27 12:17:26 2012

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect sys/sys as sysdba
Connected.
SQL> select * from v$resource_limit;

RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL
------------------------------ ------------------- --------------- ----------
LIMIT_VALU
----------
processes                                       21              25         40
        40

sessions                                        22              25         49
        49

enqueue_locks                                   13              21        790
       790


RESOURCE_NAME                  CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_AL
------------------------------ ------------------- --------------- ----------
LIMIT_VALU
----------
enqueue_resources                               13              36        432
 UNLIMITED

ges_procs                                        0               0          0
         0

ges_ress                                         0               0          0
 UNLIMITED
Re: Problems with Oracle XE on win xp [message #552911 is a reply to message #552598] Mon, 30 April 2012 03:24 Go to previous messageGo to next message
rahul15june
Messages: 35
Registered: May 2008
Member
Hi,

Can anyone please help!

thanks,
Re: Problems with Oracle XE on win xp [message #552915 is a reply to message #552911] Mon, 30 April 2012 03:45 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not a DBA, but I have used various XE versions for years.

First of all, why didn't you use a decent anti-virus software? What security precautions did (or, did NOT) you take? Anyway, it is too late to cry over it now.

Here's what I would do: make sure that no viruses exist on that computer. If possible, I'd reformat it and reinstall the operating system, as well as the database. Then, I'd restore data from backup (I suppose you have one, haven't you?). Finally, apply anti-this and anti-that so that sh*t wouldn't happen that soon again.

But that's just me; perpahs you'd rather wait for someone smarter who knows EXACTLY what to do.
Re: Problems with Oracle XE on win xp [message #552917 is a reply to message #552915] Mon, 30 April 2012 03:50 Go to previous messageGo to next message
rahul15june
Messages: 35
Registered: May 2008
Member
Little foot. I have Mcafee enterprise edition. And the machine is now clean. I am not crying over it Smile Just looking at fixing the issue. I tried a fresh install after removing XE. but the same issue.

Yes, I have all data backed up. I just need to get this thing running.
Re: Problems with Oracle XE on win xp [message #552922 is a reply to message #552917] Mon, 30 April 2012 03:56 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you didn't reformat the disk and reinstalled the operating system, although the machine is "clean" now doesn't mean that it works properly. Who knows what damage virus(es) caused?

Besides, sometimes removing Oracle software isn't trivial. Recent versions are better than previous ones and Oracle Universal Installer does most of the job. However, there might be certain registry entries that should be removed manually. Did you do that as well? Because, XE installation is a simple task and I have NEVER failed to do it properly, nor had any problems with accessing it.

I'm sorry for not being able to help much; as I said - reformat and start over is my choice. Most probably not the best one, but works for sure.
Previous Topic: oracle hang
Next Topic: do I need access to db server machine login ?
Goto Forum:
  


Current Time: Thu Mar 28 11:32:57 CDT 2024