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
Solved

Enterprise Manager console for oracle 11g on windows server 2008

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

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle - SQL Parse String 5 44
Oracle SQL Select unique values from two columns 4 66
Oracle DB Slows After Datapump Until Next Reboot 27 90
format dd/mm/yyyy parameter 16 29
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

792 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