dcsimg
(URGENT)Unable to connect with oracle using listener
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   faisal_ishaque
Posted On:   Saturday, April 2, 2005 12:47 PM

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.    More>>

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:oracleora90NETWORKADMIN nsnames.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:oracleora90NETWORKADMINlistener.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:oracleora90)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = faisal)
(ORACLE_HOME = G:oracleora90)
(SID_NAME = faisal)
)
)

kindly help me in this regard. Its urgent now.

   <<Less
About | Sitemap | Contact