Oracle Database Express Edition (XE)

We have the Oracle 11g XE database installed on a Windows 7 laptop. The Oracle XE database runs fine when the laptop not connected to a network, when connected to our corporate lan, or when connected to a cable-modem. However, when running under the Cisco AnyConnect VPN client, we are unable to connect to the Oracle XE service.

I have tried to resolve this, but am stuck. I do not if this issues is caused by:
1. There is no IPv6 address listed for the AnyConnect VPN (from ipconfig /all)?
2. Something regarding split-tunnelling that must be configured on the VPN?
3. Can the Oracle XE database run under an SSL VPN?

Below is the output of when I try to connect the Oracle XE service via sqlplus. Any suggestion or ideas are greatly appreciated.

**************************
The OracleXETNSListener service is starting.
The OracleXETNSListener service was started successfully.

The OracleServiceXE service is starting..............
The OracleServiceXE service was started successfully.


C:\ProgramData\oraclexe\app\oracle\product\11.2.0\server\bin>sqlplus system/password@XE

SQL*Plus: Release 11.2.0.2.0 Production on Fri May 31 07:03:24 2013

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

ERROR:
ORA-12546: TNS:permission denied


Enter user-name:


**************************
listener\alert\log,xml

<msg time='2013-05-31T07:03:24.950-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DEV-M-137GF'
host_addr='fe80::2884:a03d:5286:7996%21'>
<txt>31-MAY-2013 07:03:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\ProgramData\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus.exe)(HOST=DEV-M-137GF)(USER=ptavolet))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.99.8.39)(PORT=56324)) * establish * XE * 12514
</txt>
</msg>
<msg time='2013-05-31T07:03:24.958-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DEV-M-137GF'
host_addr='fe80::2884:a03d:5286:7996%21'>
<txt>TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
</txt>
</msg>
<msg time='2013-05-31T07:07:43.935-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DEV-M-137GF'
host_addr='fe80::2884:a03d:5286:7996%21'>
<txt>31-MAY-2013 07:07:43 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=ptavolet))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * status * 0
</txt>
</msg>
<msg time='2013-05-31T07:08:13.289-04:00' org_id='oracle' comp_id='tnslsnr'
type='UNKNOWN' level='16' host_id='DEV-M-137GF'
host_addr='fe80::2884:a03d:5286:7996%21'>
<txt>31-MAY-2013 07:08:13 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=ptavolet))(COMMAND=services)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647040)) * services * 0
</txt>
</msg>


**************************
listener\trace\listener.log file

Started with pid=3688
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DEV-M-137GF.paychex.com)(PORT=1521)))
Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
Fri May 31 07:03:24 2013
31-MAY-2013 07:03:24 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=XE)(CID=(PROGRAM=C:\ProgramData\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus.exe)(HOST=DEV-M-137GF)(USER=ptavolet))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.99.8.39)(PORT=56324)) * establish * XE * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor


**************************
C:\ProgramData\oraclexe\app\oracle\product\11.2.0\server\bin>lsnrctl status

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 31-MAY-2013 07:07:43

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 - Production
Start Date 31-MAY-2013 07:01:12
Uptime 0 days 0 hr. 6 min. 31 sec
Trace Level support
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\ProgramData\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
Listener Log File C:\ProgramData\oraclexe\app\oracle\diag\tnslsnr\DEV-M-137GF\listener\alert\log.xml
Listener Trace File C:\ProgramData\oraclexe\app\oracle\diag\tnslsnr\DEV-M-137GF\listener\trace\ora_3688_
5400.trc
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DEV-M-137GF.paychex.com)(PORT=1521)))
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...
The command completed successfully


**************************
C:\ProgramData\oraclexe\app\oracle\product\11.2.0\server\bin>lsnrctl service

LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 31-MAY-2013 07:08:13

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
The command completed successfully



Again, I appreciate any help. Thanks.......Paul

Edited by: 1008887 on Jun 4, 2013 10:57 AM