Oracle Database Discussions

I had a working installation of 11g on 'Vista Home Premium 64 bit' and then I upgraded to 'Vista Ultimate 64 bit' and now I can't connect to my database due to a TNS-12514 error.

The upgrade took away my 'Network Loopback Adapter' entry so I recreated it and chose the address 192.168.1.1 per the Oracle installation instructions. Below is the error I'm receiving as presented in my listener.log file, followed by the relevant entries in my HOSTS file, listener.ora, tnsnames.ora, sqlnet.ora. I note that the port the error refers to (49953) does not correspond to the port in my tnsnames entry (1522) but not sure why or if it should be the same or not. The name of the computer is 'goa', the name of the 11g database is 'sky'. Any help would be appreciated


Error in listener.log

02-JUL-2009 23:57:06 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SERVER=DEDICATED)(SERVICE_NAME=SKY)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.1)(PORT=49953)) * establish * SKY * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor






Here are the entries in my relevant files:

Host file (as per instructions with configuring MS Loopback adapter)
# Copyright (c) 1993-2006 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#

127.0.0.1 localhost
::1 localhost
192.168.1.1 goa goa



Listener.ora file

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = goa)(PORT = 1522))
)
)





tnsnames.ora file

LISTENER_SKY =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = goa)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = goa)(PORT = 1522))
)


SKY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Goa)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SKY)
)
)



sqlnet.ora file

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)