Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1043
  • Last Modified:

win64 Oracle11gR2 64-bit Windows 7 Enterprise

Experts,

     I downloaded, unzipped and installed the 64-bit version of Oracle 11gR2 on my new Windows 7 Enterprise x64 laptop.  I initially chose "server software only", Enterprise Edition.  Then when the software finished installing, I ran Database Configuration Assistant to create the database.

     Now I can connect to the database through SQL*Plus, but I can't connect to it through Net Manager or SQL Developer.  Net Manager gives me a NO LISTENER error.  SQL Developer gives me the error "the network adapter could not establish the connection".

     I've never needed to create a listener before when I've installed Oracle on many 32-bit Windows XP and/or Windows 2003 Server R2 machines so I'm a little confused.

     What could I be doing wrong?

Thanks
Joe
0
DalTXColtsFan
Asked:
DalTXColtsFan
  • 2
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
Just run network config. Assistant and create one.

You should have the microsoft loopback adapter installed.  At least on previous windows versions.  Never installed Oracle on win 7 yet.
0
 
DalTXColtsFanAuthor Commented:
Strange that I've never had to create a listener before, but your suggestion worked.

Also, I had created a listener in Net Manager and that DIDN'T work.

I've closed the question, but if you have any closing thoughts on why it would work through Net Config Assistant but not Net Manager I'd love to hear them, or why I've never had to do that step on a 32-bit machine.

Thanks
DTXCF
0
 
slightwv (䄆 Netminder) Commented:
I cannot remember this from my last install but 'Software Only' should be just the software.

I cannot remember if DBCA automatically created a Listener for me or not if one didn't exist.  I'll take you at your word that it used to in 10g days.  Maybe they just changed it in 11g days for some reason.

Also going from memory:  Network Manager, 'manages' pre-existing configs? Where Config Assistant is a 'creation/configuration' wizard?
0
 
DalTXColtsFanAuthor Commented:
Just in case anyone's still interested, I saw the same thing on 32-bit Windows XP.

When I install Oracle, I usually have the original installer not only install the server software but create the initial database.  These last 2 times I had the installer create the software only, then I used Database Configuration Assistant to create the database.

Both times (once in 64 bit once in 32 bit) there was no listener created, both times slightwv's suggestion of using Net Configuration Assistant to create the listener then creating the Service Name in Net Manager resolved the issue.

So, while I can't scientificatlly prove it, it appears that the Oracle installer creates the listener IF you create the database in the first step, otherwise it does not.

Who knows.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now