Situation: Oracle 9i 9.2.0.1 on Windows XP SP2
When installing Oracle 9i, I used as much default settings as possible (also following a few tutorials). Getting it installed was an accomplishment in itself, with restarting the listener process while the default database was being created.
Right now I am able to connect using SQL*PLUS, however, only when
not specifying the host. For example: I can connect using SQL*PLUS if I use scott/tiger, but not when using scott/tiger@orcl.world (which is the alias present in the tnsnames.ora file). I can't either get any other application to connect to the database using the tnsnames.ora alias. The application simply hangs. I tried using tnsping:
tnsping orcl.world
The utility then hangs after outputting:
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = dwlpt006)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
I have absolutely no idea what to do to be able to use the tnsnames.ora alias and get an application (SQL*PLUS, TOAD) to connect to the database.
Is there anyone who has encountered the same problem and would be able to give some directions on how to solve it?
=====
tnsnames.ora:
ORCL.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dwlpt006)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
=====
listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dwlpt006)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Programs\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = C:\Programs\oracle\ora92)
(SID_NAME = orcl)
)
)