Solved

win64 Oracle11gR2 64-bit Windows 7 Enterprise

Posted on 2011-09-15
4
1,029 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

749 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