Oracle Database Discussions

Hi everyone!

I 'm just desperate , I searched all day for a solution , but nothing helps . Here's the problem

I 'm installed Oracle 11gR2 ( not Express ) on a Windows Vista. I created a DB instance and set up a listener .

If I connect locally with the DB via SQLPlus it's no Problem. But if i try it on the way outside of my intranet through dyndns with NAT on my router, every time I get the following error:

ERROR:
ORA-12560: TNS: Fehler bei Protokolladapter

The tnsnames.ora on the Client:
FLUGDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = meinServer.dyndns.org)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = flugDB.meineDomain)
)
)



The listener.ora on Server:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\XXXXX\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\XXXXXX\product\11.2.0\dbhome_1\bin\oraclr11.dll"
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\XXXXXX\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\XXXXX\product\11.2.0\dbhome_1\bin\oraclr11.dll"
)
(SID_DESC =
(GLOBAL_DBNAME = flugDB.meineDomain)
(ORACLE_HOME = C:\app\XXXXX\product\11.2.0\dbhome_1)
(SID_NAME = flugdb)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

ADR_BASE_LISTENER = C:\app\XXXXXX

I hope that somebody could help me.

Regards
Sascha