[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Enterprise Manager console for oracle 11g on windows server 2008

Posted on 2011-02-28
4
Medium Priority
?
1,169 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 77

Accepted Solution

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
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

656 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