Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

win64 Oracle11gR2 64-bit Windows 7 Enterprise

Posted on 2011-09-15
4
Medium Priority
?
1,039 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 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 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 78

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
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 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 copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

963 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