pratz09
asked on
Enterprise Manager console for oracle 11g on windows server 2008
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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please post your listener.ora file.
You need to setup a TCP listener. You ought to have a sample listener.ora under %ORACLE_HOME%\network\admi n\sample\l istener.or a, copy/paste the TCP part, using port 1521, and stop/start the listener. Note you've not given the output for lsnrctl services, but the thing is that you need the TCP listener, or else the instance won't find it when it wants to register.
ASKER
Thanks guys. Sorry for late response. Your inputs solved the problem.
ASKER
I executed ALTER SYSTEM REGISTER COMMAND and did another lsnrctl status/service. Same output :
How to change the service to xyz service name ?