C:\>set ALLUSERSPROFILE=C:\Documents and Settings\All Users APPDATA=C:\Documents and Settings\Administrator.DIETECH.000\Application CLIENTNAME=LINUX ClusterLog=C:\WINDOWS\Cluster\cluster.log CommonProgramFiles=C:\Program Files\Common Files COMPUTERNAME=ERPSERVER ComSpec=C:\WINDOWS\system32\cmd.exe FP_NO_HOST_CHECK=NO HOMEDRIVE=C: HOMEPATH=\Documents and Settings\Administrator.DIETECH.000 JSERV=D:\oracle\ora90/Apache/Jserv/conf LOGONSERVER=\\MAINSERVER NUMBER_OF_PROCESSORS=4 OLAP_HOME=D:\oracle\ora90\olap OS=Windows_NT Path=D:\oracle\ora90\bin;D:\oracle\ora90\Apache\Perl\5.00503\bin\mswin32 Program Files\Oracle\jre\1.1.8\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WIN tem32\Wbem PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 6 Model 23 Stepping 10, GenuineIntel PROCESSOR_LEVEL=6 PROCESSOR_REVISION=170a ProgramFiles=C:\Program Files PROMPT=$P$G SESSIONNAME=RDP-Tcp#1 SystemDrive=C: SystemRoot=C:\WINDOWS TEMP=C:\DOCUME~1\ADMINI~1.000\LOCALS~1\Temp\1 TMP=C:\DOCUME~1\ADMINI~1.000\LOCALS~1\Temp\1 USERDNSDOMAIN=DIETECH.COM USERDOMAIN=DIETECH USERNAME=administrator USERPROFILE=C:\Documents and Settings\Administrator.DIETECH.000 windir=C:\WINDOWS WV_GATEWAY_CFG=D:\oracle\ora90\Apache\modplsql\cfg\wdbsvr.app C:\>lsnrctl status LSNRCTL for 32-bit Windows: Version 9.0.1.1.1 - Production on 21-NOV-2011 13:46: 09 Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 9.0.1.1.1 - Produc tion Start Date 20-NOV-2011 08:24:23 Uptime 1 days 5 hr. 21 min. 46 sec Trace Level off Security OFF SNMP OFF Listener Parameter File D:\oracle\ora90\network\admin\listener.ora Listener Log File D:\oracle\ora90\network\log\listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpserver.dietech.com)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.52.52.61)(PORT=8080))(PRESENTATI ON=http://admin)(SESSION=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=192.52.52.61)(PORT=9090))(PRESENTAT ION=http://admin)(SESSION=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.52.52.61)(PORT=2481))(PRESENTATI ON=GIOP)(SESSION=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=192.52.52.61)(PORT=2482))(PRESENTAT ION=GIOP)(SESSION=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.52.52.61)(PORT=8080))(PRESENTATI ON=http://admin)(SESSION=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=192.52.52.61)(PORT=9090))(PRESENTAT ION=http://admin)(SESSION=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.52.52.61)(PORT=2481))(PRESENTATI ON=GIOP)(SESSION=RAW)) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=192.52.52.61)(PORT=2482))(PRESENTAT ION=GIOP)(SESSION=RAW)) Services Summary... Service "PRODUCTION" has 2 instance(s). Instance "PRODUCTION", status UNKNOWN, has 1 handler(s) for this service... Instance "PRODUCTION", status READY, has 3 handler(s) for this service... Service "MODOSE" has 2 instance(s). Instance "PRODUCTION", status READY, has 1 handler(s) for this service... Instance "TESTDB", status READY, 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 "TESTDB" has 2 instance(s). Instance "TESTDB", status UNKNOWN, has 1 handler(s) for this service... Instance "TESTDB", status READY, has 4 handler(s) for this service... The command completed successfully C:\>lsnrctl service LSNRCTL for 32-bit Windows: Version 9.0.1.1.1 - Production on 21-NOV-2011 13:46: 44 Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) Services Summary... Service "PRODUCTION" has 2 instance(s). Instance "PRODUCTION", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:86 refused:0 LOCAL SERVER Instance "PRODUCTION", status READY, has 3 handler(s) for this service... Handler(s): "DEDICATED" established:144 refused:0 state:ready LOCAL SERVER "D002" established:0 refused:0 current:0 max:1002 state:ready DISPATCHER (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpserver.dietech.com)(PORT=1 786))(PRESENTATION=oracle.aurora.server.SGiopServer)(SESSION=RAW)) "D001" established:0 refused:0 current:0 max:1002 state:ready DISPATCHER (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpserver.dietech.com)(PORT=1 785))(PRESENTATION=oracle.aurora.server.GiopServer)(SESSION=RAW)) Service "MODOSE" has 2 instance(s). Instance "PRODUCTION", status READY, has 1 handler(s) for this service... Handler(s): "D000" established:0 refused:0 current:0 max:1002 state:ready DISPATCHER (ADDRESS=(PROTOCOL=tcp)(HOST=erpserver.dietech.com)(PORT=1783)) Instance "TESTDB", status READY, has 1 handler(s) for this service... Handler(s): "D000" established:0 refused:0 current:0 max:1002 state:ready DISPATCHER (ADDRESS=(PROTOCOL=tcp)(HOST=erpserver.dietech.com)(PORT=1037)) 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 "TESTDB" has 2 instance(s). Instance "TESTDB", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Instance "TESTDB", status READY, has 4 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 state:ready LOCAL SERVER "D003" established:0 refused:0 current:0 max:1002 state:ready DISPATCHER (ADDRESS=(PROTOCOL=tcp)(HOST=erpserver.dietech.com)(PORT=1041)) "D002" established:0 refused:0 current:0 max:1002 state:ready DISPATCHER (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpserver.dietech.com)(PORT=1 040))(PRESENTATION=oracle.aurora.server.SGiopServer)(SESSION=RAW)) "D001" established:0 refused:0 current:0 max:1002 state:ready DISPATCHER (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=erpserver.dietech.com)(PORT=1 039))(PRESENTATION=oracle.aurora.server.GiopServer)(SESSION=RAW)) The command completed successfully C:\>