Enterprise Manager console for oracle 11g on windows server 2008
Posted on 2011-02-28
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.