This forum is currently locked. You can't register or post questions at this time. (read more)

11 g on Fedora 17

All posts relating to Oracle database administration.

Moderator: Tim...

pollando
Member
Posts: 8
Joined: Tue Nov 20, 2012 7:25 pm

11 g on Fedora 17

Postby pollando » Wed Nov 28, 2012 10:21 pm

OK ... I’m using “Oracle Database 11g Release 2 (11.2) Installation On Fedora 17 (F17)” and after much wailing and gnashing of teeth I arrived at the Prerequisite Checks. I find that I am missing a korn shell package, pdksh-5.2.14.

This despite having installed the ksh package with yum, per the instructions. When I try to install pdksh-5.2.14 I find that there is “No package pdksh-5.2.14” available. Nor can I find this package in the GUI software updater.

How do I get past this point in the install?

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: 11 g on Fedora 17

Postby Tim... » Wed Nov 28, 2012 11:20 pm

Hi.

You don't need it. As per article,

"For 11.2.0.3, only the "pdksh" package will be listed as missing, which can be ignored because we installed the "ksh" package instead."

Just ignore the prerequisite failure and carry on. It will work fine.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pollando
Member
Posts: 8
Joined: Tue Nov 20, 2012 7:25 pm

Re: 11 g on Fedora 17

Postby pollando » Thu Nov 29, 2012 10:09 pm

OK ... I understand that about the korn shell now.

Near the end of the install I'm running into a problem starting the listener, apparently because of an issue with the host file. In the article there is a step to modify the host file:

Hosts File

The "/etc/hosts" file must contain a fully qualified name for the server.

<IP-address> <fully-qualified-machine-name> <machine-name>


At this step I a not using a static IP, as this is a personal lap top rather than a production server. I have to have a dynamic IP. What should I use for this entry?

Presently I am replacing the assigned entry with

127.0.0.1 charlie.subdomanname.domainname.net
::1 locahost6.localdomain6 localhost6

What is the appropriate format for this?

Thanks!

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: 11 g on Fedora 17

Postby Tim... » Fri Nov 30, 2012 11:28 am

Hi.

Regardless of how you are connecting, Oracle needs both the loopback and the machine entries in the /etc/hosts file.

The article explains the two entries you need:

http://www.oracle-base.com/articles/11g ... #HostsFile

The loopback entry must remain unchanged. The machine-specific entry must include your machine name and the IP address of the machine on your network. That is necessary for your installation. If the IP address changes in future the listener will fail and you will need to edit the hosts file to correct it.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pollando
Member
Posts: 8
Joined: Tue Nov 20, 2012 7:25 pm

Re: 11 g on Fedora 17

Postby pollando » Fri Nov 30, 2012 5:26 pm

Tim... wrote:Hi.

Regardless of how you are connecting, Oracle needs both the loopback and the machine entries in the /etc/hosts file.

The article explains the two entries you need:

http://www.oracle-base.com/articles/11g ... #HostsFile

The loopback entry must remain unchanged. The machine-specific entry must include your machine name and the IP address of the machine on your network. That is necessary for your installation. If the IP address changes in future the listener will fail and you will need to edit the hosts file to correct it.

Cheers

Tim...


Since it does not have a static IP, how is the host entry handled?

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: 11 g on Fedora 17

Postby Tim... » Fri Nov 30, 2012 5:48 pm

Hi.

You know what your host name is. You then put the currently set IP address into the entry. You get this using "ifconfig".

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pollando
Member
Posts: 8
Joined: Tue Nov 20, 2012 7:25 pm

Re: 11 g on Fedora 17

Postby pollando » Fri Nov 30, 2012 7:49 pm

Tim... wrote:Hi.

You know what your host name is. You then put the currently set IP address into the entry. You get this using "ifconfig".

Cheers

Tim...


And what, just change the hosts file every time you restart?

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: 11 g on Fedora 17

Postby Tim... » Fri Nov 30, 2012 8:39 pm

Hi.

Assuming your lease period on the IP address is very short the yes.

Alternatively, stop using a bridged connection and use host-only, that way your IP address will be fixed.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pollando
Member
Posts: 8
Joined: Tue Nov 20, 2012 7:25 pm

Re: 11 g on Fedora 17

Postby pollando » Mon Dec 03, 2012 3:05 pm

Tim... wrote:Hi.

Assuming your lease period on the IP address is very short the yes.

Alternatively, stop using a bridged connection and use host-only, that way your IP address will be fixed.

Cheers

Tim...



How would I get it to use "host-only"?

The laptop is a personal lap top so it never gets a fixed IP, even from home network.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: 11 g on Fedora 17

Postby Tim... » Tue Dec 04, 2012 12:52 am

Hi.

Host-only networking is a feature of the virtualization software (VirtualBox, VMware etc.). You can set your virtual network to be host-only, so it has nothing to do with the network of the laptop. It will use a different subnet and it won't matter if your laptop is connected to a network or not.

The down side is your VM will not be able to access the internet.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pollando
Member
Posts: 8
Joined: Tue Nov 20, 2012 7:25 pm

Re: 11 g on Fedora 17

Postby pollando » Wed Dec 05, 2012 10:04 pm

Tim... wrote:Hi.

Host-only networking is a feature of the virtualization software (VirtualBox, VMware etc.). You can set your virtual network to be host-only, so it has nothing to do with the network of the laptop. It will use a different subnet and it won't matter if your laptop is connected to a network or not.

The down side is your VM will not be able to access the internet.

Cheers

Tim...


OK well the solution to this turned out to be much simpler. I created a new first line to the hosts file with the value 127.0.1.1 followed by my fqdn and then the hostname. There is no need to use a virtual server. It works on my Fedora lap top with a dynamic IP.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: 11 g on Fedora 17

Postby Tim... » Wed Dec 05, 2012 11:52 pm

But this is what it tells you to do in the article!

When you said you had problems, I told you to,

"You know what your host name is. You then put the currently set IP address into the entry. You get this using "ifconfig"."

It was only after you still said there were issues that I suggested using a bridged connection... :)

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pollando
Member
Posts: 8
Joined: Tue Nov 20, 2012 7:25 pm

Re: 11 g on Fedora 17

Postby pollando » Thu Dec 06, 2012 11:32 am

Tim... wrote:But this is what it tells you to do in the article!

When you said you had problems, I told you to,

"You know what your host name is. You then put the currently set IP address into the entry. You get this using "ifconfig"."

It was only after you still said there were issues that I suggested using a bridged connection... :)

Cheers

Tim...


Noo .. the article said to use the machine IP and ipconfig gives me the IP as given by DHCP. If I use that IP the host file will be incorrect the next time I power on the machine. I was looking for a solution that did not assume the machine IP was static.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: 11 g on Fedora 17

Postby Tim... » Thu Dec 06, 2012 12:02 pm

Oh. you are using the loopback interface for your IP address as well as the loopback.

Please tell me you have left localhost and localhost.localdomain in that definition also. Removing these can cause problems.

An additional downside of what you have is you will not be able to connect to the database from anything external from the VM, like the host machine.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pollando
Member
Posts: 8
Joined: Tue Nov 20, 2012 7:25 pm

Re: 11 g on Fedora 17

Postby pollando » Fri Dec 14, 2012 9:39 pm

The way it reads is

127.0.1.1 charlie.subdomain.domain.net charlie
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6

I'm not needing the database to communicate with anything external to a VM. Not using a VM, just a laptop. The database does not have to communicate outside the laptop.


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 9 guests

cron