• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1171
  • Last Modified:

Enterprise Manager console for oracle 11g on windows server 2008

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
pratz09
Asked:
pratz09
  • 2
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
pratz09Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
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
 
pratz09Author Commented:
Sorry ! My Bad. I never thought about it like that. Won't repeat.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now