I have problem in getting connection with oracle instance on my local PC.
My instance named 'faisal' started successfuly from Windows 2000 server 'Serivces' menu.
But when I start 'OracleOraHome90TNSListener' from windows 2000 server 'services' menu, it starts but stop. If i start and stop by myself then following exception was shown.
---------------------------
Microsoft Management Console
---------------------------
Could not stop the OracleOraHome90TNSListener service on Local Computer.Error 1067: The process terminated unexpectedly.
---------------------------
So, I am unable to connect with oracle instance.
Following is "tnsnames.ora" file content.
# TNSNAMES.ORA Network Configuration File: G:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = faisal)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION =
http://HRService) )
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
FAISAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = faisal)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = faisal)
)
)
Following is "listener.ora" file contents
# LISTENER.ORA Network Configuration File: G:\oracle\ora90\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = faisal)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = G:\oracle\ora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = faisal)
(ORACLE_HOME = G:\oracle\ora90)
(SID_NAME = faisal)
)
)
kindly help me in this regard. Its urgent now.
[ April 02, 2005: Message edited by: Jeanne Boyarsky ]