Solved

win64 Oracle11gR2 64-bit Windows 7 Enterprise

Posted on 2011-09-15
4
1,033 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

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 77

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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Suggested Courses

617 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