Unable to access Oracle Enterprise Manager from remote systems

Hello Experts,

I have installed an Oracle 11g instance on Oracle Linux 6.5. I can access Enterprise Manager GUI and can connect to the Database using sqlplus from the local system where Oracle is installed. However i can not access EM from any other system from the same network.

The Listener is configured to show the FQDN of the server. I did some Google search but did not find any specific answer though.

I tried to add another listener using the IP of the server, but it crashed everything. No UI and DB down.

How can i access EM GUI from other systems and how can i connect to DB using sqlplus as well.

Any help in this regard is greatly appreciated. Thanks.

Best Regards
Raghav.
LVL 7
RaghavIT SpecialistAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gerwin Jansen, EE MVETopic Advisor Commented:
Check firewall settings, you may need to add a rule to allow em port, which is 1158 I believe.
0
RaghavIT SpecialistAuthor Commented:
Hi Gerwin,

Thanks for your reply.

I have already added exceptions in the firewall. Didn't help.

Is there any other way? Thanks

Best Regards
Raghav.
0
sethu_uuuCommented:
Are you able to telnet the port from the system you are trying to access
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Gerwin Jansen, EE MVETopic Advisor Commented:
- Can you ping the Oracle Linux server?
- Can you ssh to the Oracle Linux server?
- Can you tnsping the database on the Oracle Linux server?
If all are a no then disable the firewall on the Oracle Linux server for testing. If you can connect then, review your firewall settings, both on the Oracle Linux server as well as on the machine you are connecting from.
1
RaghavIT SpecialistAuthor Commented:
Hi Sethu,

I can not telnet to any port.

Hi Gerwin,

I can ping the server and ssh to it. I have not tried tnsping yet. Will do it and post the results.

and by the way, firewall on the oracle server is turned off. Thanks

Best Regards
Raghav.
0
slightwv (䄆 Netminder) Commented:
When you try sqlplus, what is the error?

>>and by the way, firewall on the oracle server is turned off

That doesn't mean there isn't a firewall in the network...

>>but it crashed everything. No UI and DB down.

No listener should NEVER crash the database.  If the database truly crashed, something else is going on.
0
Gerwin Jansen, EE MVETopic Advisor Commented:
Ok, what do you get when you use a web browser to go to: http://<servername>:1158/em

Or do you have a different port number? Have a look in $ORACLE_HOME/install/portlist.ini - the em port number should be in there.
0
RaghavIT SpecialistAuthor Commented:
Hi Gerwin,

I get connection timed out error.

Thanks

Best Regards
Raghav.
0
slightwv (䄆 Netminder) Commented:
And the error from sqlplus?
0
RaghavIT SpecialistAuthor Commented:
TNS time out

Best Regards
Raghav
0
slightwv (䄆 Netminder) Commented:
99.999% of the time this is a firewall issue.  I have only see that error once in my life not be a firewall and it was long ago and I cannot remember what that one instance was.

My bet is something between your client machine and database serer is blocking the high port packets the listener is creating.

>>I have not tried tnsping yet. Will do it and post the results

I didn't see where you posted the results.  My guess this will work.
0
Gerwin Jansen, EE MVETopic Advisor Commented:
Did you try connecting to the IP adress of the server instead of the (FQDN) name?

It this a physical or virtual server? If it's virtual then you have to look at the (virtual) network interface, that could be blocking your connection attempts.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RaghavIT SpecialistAuthor Commented:
Hi Gerwin,

So like you said it turned out to be a firewall issue. I turned off the firewall on oracle server and disabled configuration. Additionally i have also set DNS right to resolve the IP, Hostname and vice versa.

It looks fine now. May be later i will enable the firewall and add required rules to allow ports.

Thanks for your pointers and help.

Best Regards
Raghav.
0
Gerwin Jansen, EE MVETopic Advisor Commented:
You're welcome ;)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Remote Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.