VMware Cloud Community
sandra82
Contributor
Contributor

NEWBIE seeks help with Setting up networking for VMWare server running ORACLE 10g on LINUX Redhat ...

G'Day Guys

I am fairly new at ORACLE and have set up a VMWare server on my USB disk, so that i can access it from both work and home to 'practise' ORACLE (and LINUX) stuff on...

At one stage i had everything working beautifully in terms of the networking side, i.e. i could connect to the ORACLE instance on the USB drive via an ORACLE client (PL/SQL Developer) installed on my work laptop. Basically the network guys had set my laptop up such that it had a fixed IP address on the network.

also, i had some assistance with setting up the networking on the VMWare server (on the USB disk). anyway, at that stage i made a backup of the VMWare disk.

After that something went wrong on my work laptop - somehow i messed up something to do with the network settings on my laptop and from then on i could no longer connect from the ORACLE PL/SQL developer on my laptop to the ORACLE database on the VMWare server on the USB.

I've tried my best to sort through it and get it going again, but after a week of struggling i have to concede defeat, and acknowledge my limitations as far as general networking knowledge and VMware are concerned.

I am hoping that somebody here will have the inclination to assist me step by step in working through this ball of yarn, as at this point i'm just plain confused about how/what to setup and my confidence levels are at an all time low!

So if there is a "good samaritan" out there amongst you who is willing to help out this very confused person - and have lots of patience - since i'm going to need to be led via idiot-proof little baby steps ... then i'd be much obliged to hear from you.

Regarding the ORACLE side - i have started up the database, but i cant get the listener up - there is something amiss there - i'm pretty sure it is probably related to the networking side as well.

thanks in advance.

S

Reply
0 Kudos
9 Replies
sandra82
Contributor
Contributor

My apologies if i've left out important information, but please just ask anything you need to know in order to form a picture of what my setup is.

I'm hoping to learn a fair bit through this exercise...

Reply
0 Kudos
athlon_crazy
Virtuoso
Virtuoso

Do you have any log to show from oracle?

$netstat -tulpn show no oracle listening port?

http://www.no-x.org
Reply
0 Kudos
sandra82
Contributor
Contributor

i ran

>netstat - tulpn

I could not see anything in the results which indicated the ORACLE listener was up.

i also ran

>ps - ef | grep oracle

but did not see anything indicating an oracle listener being up.

also if i run

>lsnrctl status listener

It says:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.37.128)(PORT=1522)))

and just hangs there...

There are two obvious things wrong with the above address:

1. The IP address there is incorrect, as i have a new laptop now and have therefore reinstalled VMWare Server, and i believe that the IP address(es) of the two VMWare "network cards" have changed.

2. Also, when i created the oracle database originally, it was meant to create the listener on port 1521, but there was some problem message given at the time (in DBCA) to the effect about a port not being available or something like that.

So i know the listener has been an issue since i recreated the database, i.e. it has never worked.

Before i got the new laptop, i.e. when the IP indicated above was in fact correct, i.e. corresponded to the relevant virtual (VMWare) network card, i already had the problem with the listener, so that is not THE issue, but certainly getting that IP sorted out in the listener.ora file will obviously be one of the things i'll need to do.

I'm just not sure how to even start with setting up the virtual network card for the VM...

Thanks for your help thus far.

Reply
0 Kudos
sandra82
Contributor
Contributor

i ran

>netstat - tulpn

I could not see anything in the results which indicated the ORACLE listener was up.

i also ran

>ps - ef | grep oracle

but did not see anything indicating an oracle listener being up.

also if i run

>lsnrctl status listener

It says:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.37.128)(PORT=1522)))

and just hangs there...

There are two obvious things wrong with the above address:

1. The IP address there is incorrect, as i have a new laptop now and have therefore reinstalled VMWare Server, and i believe that the IP address(es) of the two VMWare "network cards" have changed.

2. Also, when i created the oracle database originally, it was meant to create the listener on port 1521, but there was some problem message given at the time (in DBCA) to the effect about a port not being available or something like that.

So i know the listener has been an issue since i recreated the database, i.e. it has never worked.

Before i got the new laptop, i.e. when the IP indicated above was in fact correct, i.e. corresponded to the relevant virtual (VMWare) network card, i already had the problem with the listener, so that is not THE issue, but certainly getting that IP sorted out in the listener.ora file will obviously be one of the things i'll need to do.

I'm just not sure how to even start with setting up the virtual network card for the VM...

Thanks for your help thus far.

Reply
0 Kudos
athlon_crazy
Virtuoso
Virtuoso

Although I'm not too familiar with oracle, but here are my suggestion :-

1) Verify basic networking

Configure your network setting with your correct IP. Temporarily by running "$ifconfig eth0 10.1.1.75 netmask 255.0.0.0 up" is enough and make sure you able to ping successfully from and to this IP.

2) /etc/hosts file

Frankly, I wasn't able to bring up my oracle http (port 8080) last time due to incorrect /etc/hosts config.

$cat /etc/hosts

127.0.0.1 localhost myhost

10.1.1.75 myhost.com.my myhost

3) Oracle listener.ora

Must use same IP that you use in step1 or fqdn in step2

4) Reconfigure,

Your last choice!. for express edition, you should able to do this easily.

http://www.no-x.org
sandra82
Contributor
Contributor

hey athlon_crazy

i just wanted to say thanks a lot for your suggestions. i worked through all of them and that led me on to related issues... and i eventually got it sorted!

so thanks again!

is it usually this quiet though, or is it just that my Q was too basic? (just asking as you were the only one who responded Smiley Wink

Reply
0 Kudos
sandra82
Contributor
Contributor

hey athlon_crazy

i just wanted to say thanks a lot for your suggestions. i worked through all of them and that led me on to related issues... and i eventually got it sorted!

so thanks again!

is it usually this quiet though, or is it just that my Q was too basic? (just asking as you were the only one who responded Smiley Wink

Reply
0 Kudos
sandra82
Contributor
Contributor

Say, has anybody had this "feature" enabled on their profile whereby every post is duplicated???

Not sure what i've done that's caused this, but it's a little irritating

Reply
0 Kudos
sandra82
Contributor
Contributor

Say, has anybody had this "feature" enabled on their profile whereby every post is duplicated???

Not sure what i've done that's caused this, but it's a little irritating

Reply
0 Kudos