XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myservername.domainname.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

ORACLR_CONNECTION_DATA = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
    ) 
    (CONNECT_DATA = 
      (SID = CLRExtProc) 
      (PRESENTATION = RO) 
    ) 
  ) 

ORCL.WORLD =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = myservername.mydomain.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL.WORLD)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = myservername.mydomain.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = myservername.mydomain.com)(PORT = 1521))
    )
  )

DEFAULT_SERVICE_LISTENER = (ORCL)

# This file is actually generated by netca. But if customers choose to 
# install "Software Only", this file wont exist and without the native 
# authentication, they will not be able to connect to the database on NT.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

C:\Documents and Settings\skhorram>SET ORACLE_SID=XE

C:\Documents and Settings\skhorram>sqlplus scott/tiger

SQL*Plus: Release 11.2.0.2.0 Production on Wed Nov 2 18:23:53 2011

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

ERROR:
ORA-01017: invalid username/password; logon denied

C:\Documents and Settings\skhorram>sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Wed Nov 2 18:51:17 2011

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

Enter user-name: SYSTEM
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name:

C:\Documents and Settings\skhorram>SET
ALLUSERSPROFILE=C:\Documents and Settings\All Users
APPDATA=C:\Documents and Settings\skhorram\Application Data
ClusterLog=C:\WINDOWS\Cluster\cluster.log
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=DPSONYEMAIL
ComSpec=C:\WINDOWS\system32\cmd.exe
DEBIX_CONFIG=F:\sonyM3workspace\Debix\Program Files
FP_NO_HOST_CHECK=NO
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\skhorram
JAVA_HOME=C:\Program Files\Java\jre6
lib=C:\Program Files\SQLXML 4.0\bin\
LOGONSERVER=\\ZEUS
NUMBER_OF_PROCESSORS=8
ORACLE_SID=XE
OS=Windows_NT
Path=C:\oraclexe\app\oracle\product\11.2.0\server\bin;;C:\Program Files\HP\NCU
:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Micros
t SQL Server\80\Tools\Binn\;C:\Program Files\Microsoft SQL Server\90\DTS\Binn\
:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\Program Files\Microsoft
QL Server\90\Tools\Binn\VSShell\Common7\IDE\;C:\Program Files\Microsoft Visual
tudio 8\Common7\IDE\PrivateAssemblies\;C:\WINDOWS\system32\WindowsPowerShell\v
0;C:\WINDOWS\system32\WindowsPowerShell\v1.0;C:\Program Files\HP\P4000\HP P400
CLI
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.PSC1;.PSC1
PEGASUS_HOME=C:\Program Files\HP\P4000\HP P4000 VSS Provider\CIM
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 6 Model 15 Stepping 11, GenuineIntel
PROCESSOR_LEVEL=6
PROCESSOR_REVISION=0f0b
ProgramFiles=C:\Program Files
PROMPT=$P$G
PSModulePath=C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\
SESSIONNAME=RDP-Tcp#6
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\skhorram\LOCALS~1\Temp
TMP=C:\DOCUME~1\skhorram\LOCALS~1\Temp
USERDNSDOMAIN=DIRECTPARTNERS.COM
USERDOMAIN=DIRECTPARTNERS
USERNAME=skhorram
USERPROFILE=C:\Documents and Settings\skhorram
VBOX_INSTALL_PATH=C:\Program Files\Oracle\VirtualBox\
windir=C:\WINDOWS

C:\Documents and Settings\skhorram>

C:\Documents and Settings\skhorram>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 02-NOV-2011 19:55
:37

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 11.2.0.2.0 - Produ
ction
Start Date                31-OCT-2011 23:48:09
Uptime                    1 days 20 hr. 7 min. 27 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Default Service           ORCL
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\dpsonyemail\listen
er\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dpsonyemail.directpartners.com)(PORT
=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dpsonyemail.directpartners.com)(PORT
=8080))(Presentation=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" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
The command completed successfully

C:\Documents and Settings\skhorram>lsnrctl service

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 02-NOV-2011 19:55
:49

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
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:6 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: DPSONYEMAIL, pid: 6916>
         (ADDRESS=(PROTOCOL=tcp)(HOST=dpsonyemail.directpartners.com)(PORT=3144)
)
Service "xe" has 1 instance(s).
  Instance "xe", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:4 refused:0 state:ready
         LOCAL SERVER
The command completed successfully

C:\Documents and Settings\skhorram>