Oracle Database Discussions

Guys, this is the 1st time i'm setting up Oracle 11g database on my windows 2008 server.

I'm getting so many errors. Pls help me to connect to SQL Developer, as I'm able to connect to SQL PLUS successfully.

I have input the following information in the connection window:
username: hr
password: hr
hostname: localhost
port: 1521
service name: HYPAMA

I'm getting an error once i click the test button. Please help.

-------------------------------------------------------------------------------------------------------------------------------------
This is my LISTENER FILE:


# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)

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

ADR_BASE_LISTENER = D:\app\Administrator
-------------------------------------------------------------------------------------------------------------------------------------


=============================================================
This is my TNS file

# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

HYPAMA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.254.73.183)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = HYPAMA)
)
)

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

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.254.73.183)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.254.73.183)
)
)

=============================================================


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
This is my sqlnet.ora file

# sqlnet.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

# 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)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++