MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
C:\Documents and Settings\Owner>lsnrctl status LSNRCTL for 32-bit Windows: Version 220.127.116.11.0 - Production on 17-MAR-2012 17:00 :53 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for 32-bit Windows: Version 18.104.22.168.0 - Produ ction Start Date 17-MAR-2012 13:28:22 Uptime 0 days 3 hr. 32 min. 34 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Default Service XE Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\a dmin\listener.ora Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\kasutaja-e3f985\li stener\alert\log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kasutaja-e3f985)(PORT=1521))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
C:\Documents and Settings\Owner>nslookup kasutaja-e3f985 Server: dsldevice.lan Address: 192.168.1.254 Name: kasutaja-e3f985.lan Address: 192.168.1.71 C:\Documents and Settings\Owner>nslookup 127.0.0.1 Server: dsldevice.lan Address: 192.168.1.254 Name: dsldevice.lan Address: 127.0.0.1
Enter password: Connected to an idle instance. SQL> SQL> select dbms_xdb.gethttport from dual; select dbms_xdb.gethttport from dual * ERROR at line 1: ORA-01034: ORACLE not available Process ID: 0 Session ID: 0 Serial number: 0
C:\Documents and Settings\Owner>ping localhost Pinging kasutaja-e3f985 [127.0.0.1] with 32 bytes of data: Reply from 127.0.0.1: bytes=32 time<1ms TTL=128 Reply from 127.0.0.1: bytes=32 time<1ms TTL=128 Reply from 127.0.0.1: bytes=32 time<1ms TTL=128 Reply from 127.0.0.1: bytes=32 time<1ms TTL=128 Ping statistics for 127.0.0.1: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 0ms, Maximum = 0ms, Average = 0ms
Enter password: Connected to an idle instance. SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file 'C:\oraclexe\app\oracle\product\11.2.0\serv er\dbs/spfileXE.ora' ORA-27046: file size is not a multiple of logical block size OSD-04012: file size mismatch (OS 2917)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.