aspose file tools*
The moose likes Oracle/OAS and the fly likes Unable to connect to oracle instance using  listener Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Unable to connect to oracle instance using  listener" Watch "Unable to connect to oracle instance using  listener" New topic
Author

Unable to connect to oracle instance using listener

faisal khan
Ranch Hand

Joined: Mar 13, 2002
Posts: 47
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30512
    
150

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


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Carol Enderlin
drifter
Ranch Hand

Joined: Oct 10, 2000
Posts: 1364
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

Joined: Jul 11, 2001
Posts: 254
Are you sure that the host name is faizal? Try changing it to the ip address and connect!!

Beksy
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unable to connect to oracle instance using listener