Loopback Network connection on stand alone w2k box

[Guinea]

Hi There,

I want to create a loopback connection on my w2k machine runing 8i1.6 to practice using the DBA studio tools on the database running on the same box. I was told if I use host 127.0.0.1 I can do this.


My Tsnames=

# TNSNAMES.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

MYNAME.MARC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = marc.marc)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MYNAME)
)
)

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

myname =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MYNAME)
)
)



My listner=

# LISTENER.ORA Network Configuration File: C:\Oracle\Ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = marc)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = mrosoff1)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = MYNAME)
)
)


When I try to connect I get a ORA-12154:TNS:could not resolve service name.

When I try to start the listner using lsnrctl I get:

TNS-12546: TNSermission denied
TNS-12560: TNSrotocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 5: Input/output error


Any suggestions ? My computer is not hooked onto a network. The full computer name is marc.marc, workgroup = WORKGROUP.
Thanks,
Marc Guinea pigs make the world a nicer place!

Piggydad30@hotmail.com