Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Unable to connect to oracle instance using listener

 
faisal khan
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34095
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Faisal,
While we had our laughs with the "urgent" forum yesterday (April Fool's Day), we prefer people not put urgent in their subjects. For more details, see the reasons why. I'll edit your subject for you.

Jeanne
Oracle Forum Bartender
 
Carol Enderlin
drifter
Ranch Hand
Posts: 1364
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you don't find more details about why it is failing in event log, you could try running it from the command-line to try to see more details about what's going wrong.
 
Beksy Kurian
Ranch Hand
Posts: 254
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you sure that the host name is faizal? Try changing it to the ip address and connect!!

Beksy
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic