Solved

Enterprise Manager console for oracle 11g on windows server 2008

Posted on 2011-02-28
4
1,166 Views
Last Modified: 2012-05-11
Hey !

I installed Oracle 11g R2 on virtual server with windows server 2008 on it. The installation went fine, global database xyz was created on domain and a URL to access Enterprise Manager for xyz instance was created. I was able to open the link. But when I go to "Database instance: xyz" section, it says database instance is open, but the listener is unavailable and agent connection to instance failed. (ORA-12541)

I fired command lsnrctl and checked the status - which is "started". but the service instance is "CLRExtProc". I am not sure, but shouldn't it be xyz ? If yes, then how to change it ?

I also want to change the port number of Listener from default to something else. Is there anything I need to do in addition to editing Listener.ora file ?

My ultimate aim is: After configuring Database (listener port, etc), I want the database to be accessed by people using client EM from their local machine after login to VPN of my organization.  I have scripts to create logins for the users. What else do I need to do to enable remote login to the database xyz.

Lastly, I am used to of using the traditional OEM (stand alone application which used to come with 10g). Can I use it in 11g or is the web based OEM the only option ?

Thanks a lot.
0
Comment
Question by:pratz09
  • 2
  • 2
4 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 34999920
The old Fat Java based OEM that was on the install disks for 10g, was actually the 9i OEM.

I've never heard anyone trying to use that with an 11g database so I cannot say if it will work or not.

My 'guess' is not.  There are many new features in 11g that the old client/agent would not know about and I doubt the old agent would know what to do with an 11g database.

For the port on the listener:  Just change the listener.ora file and bounce the listener.
0
 

Author Comment

by:pratz09
ID: 34999978
Hmm, I suspected so. You are right, some upgraded functionalities will not be caught by 10g OEM. Can you please help me with the first error ?

I opened the Em web link after fresh installation, when I go to "Database instance: xyz" section, it says database instance is open, but the listener is unavailable and agent connection to instance failed. (ORA-12541)

I fired command lsnrctl and checked the status - which is "started". but the service instance is "CLRExtProc". I am not sure, but shouldn't it be xyz ? If yes, then how to change it ?


Secondly, I want the database to be accessed by multiple remote users. How to enable that ? I cannot see client software for 11g on Oracle website, is it like the remote users can hit the database instance with the same URL I am accessing it ? As of now, when I am opening the URL from another workstation in the same network, it is not opening.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35000068
You really should ask a single question per question.

Please take some time to review the Help pages for how EE works.

http://www.experts-exchange.com/help.jsp#hs=23&hi=23

>> but the listener is unavailable and agent connection to instance failed.

From a command prompt on the database server post the results of:
lsnrctl status
0
 

Author Comment

by:pratz09
ID: 35000234
Sorry ! My Bad. I never thought about it like that. Won't repeat.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
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…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

733 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