Solved

win64 Oracle11gR2 64-bit Windows 7 Enterprise

Posted on 2011-09-15
4
1,025 Views
Last Modified: 2012-05-12
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
Comment
Question by:DalTXColtsFan
  • 2
  • 2
4 Comments
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 125 total points
ID: 36546276
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
 
LVL 2

Author Closing Comment

by:DalTXColtsFan
ID: 36546307
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
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36546418
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
 
LVL 2

Author Comment

by:DalTXColtsFan
ID: 36550865
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now