Solved

Enterprise Manager console for oracle 11g on windows server 2008

Posted on 2011-02-28
4
1,162 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 76

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 76

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

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

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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
Via a live example, show how to take different types of Oracle backups using RMAN.

708 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

15 Experts available now in Live!

Get 1:1 Help Now