Tracker: Support Requests

9 Oracle XE installation on Fedora 6 (Bridgepoint Consulting) - ID: 1729167
Last Update: Comment added ( sf-robot )

I have two seperate questions:

1. I have one installation of Fedora Core 6. I have a dedicated IP address
for the machine. I have updated the /etc/hosts file with the IP address.
When I try to install Oracle it installs it on the 127.0.0.1. It does not
pick up the hostname. Any suggestions? Do you have any step by step
instructions for the oracle setup? I have been following the setup
instructions from the Oracle web site.

2. On another machine I am install FC5 with EnterpriseDB. Do you have any
setup instructions for this combination?





Bridgepoint Consulting ( andalib ) - 2007-05-31 21:14

9

Closed

None

Felipe Reyes

Installation Problem (until you can log in)

None

Public


Comments ( 20 )

Date: 2007-06-30 02:20
Sender: sf-robotSourceForge.net Site Admin


This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 7 days (the time period specified by
the administrator of this Tracker).


Date: 2007-06-22 22:48
Sender: lfreyesProject Admin


Database versions:
- Oracle 10g any edition (XE, Standard, Enterprise)
- EnterpriseDB 8.1

For Linux Operating System, please refer to the list of Operating Systems
supported by the database provider.
For Oracle
http://www.oracle.com/technology/support/metalink/index.html

For EnterpriseDB
http://www.enterprisedb.com/readme_linux-x86.do


Date: 2007-06-22 21:51
Sender: andalib


Can you please list the supported Linux platforms that are tested with
Compiere? Please include the version number and the database used (oracle
or enterprisedb)?


Date: 2007-06-21 21:32
Sender: lfreyesProject Admin


Fedora 6 is not a supported platform by Oracle and as such may introduce
issues between Oracle 10g and Operating System and Compiere. We would
suggest testing the connection on a certified platform(Fedora 4) to see if
it is Fedora 6 specific. If it works on Fedora 4, then it would be
advisable to contact Oracle Support to find out if they will support Fedora
6 and if they are aware of any known issues with Oracle 10g and Fedora 6.

For your question about the Compiere installation guide with EnterpriseDB,
please take a look at this link:
http://www.compiere.org/support/install/index.html


Date: 2007-06-21 19:03
Sender: lfreyesProject Admin


I see a couple of issues from the files that you uploaded:
- The ping command is returning the IP of the local host (127.0.0.1).
Please verify your network settings and ensure that when you run "ping
fedoracle.bpoint.local" you actually get 192.168.0.23.

- The RUN_setup program is showing the error "sqlplus not found". You need
to have $ORACLE_HOME/bin in your PATH
Before executing RUN_setup please validate that you can connect to the
database using the command "sqlplus system@xe"

- Also provide the output of the command "dig fedoracle.bpoint.local"


Date: 2007-06-21 17:36
Sender: andalib


I have added allthe screen shots that you requested. I am running
everything from the same box.
File Added: tnsping.png


Date: 2007-06-21 17:29
Sender: andalib


File Added: lsnrctl.png


Date: 2007-06-21 17:23
Sender: andalib


File Added: pingoutput.png


Date: 2007-06-21 17:21
Sender: andalib


File Added: CompiereScreenshot.png


Date: 2007-06-15 17:55
Sender: lfreyesProject Admin


1) Can you ping the database server? Please provide the output of
ping fedoracle.bpoint.local

2) From the database server, please provide the output of 'lsnrctl
status'

3) From the box where you're running RUN_setup.sh, run 'tnsping xe' and
provide the output

4) Please upload a snapshot of your RUN_setup screen

BTW, are you running RUN_setup.sh from the database server or from another
box?


Date: 2007-06-15 16:35
Sender: andalib


#1 is not working.

# I am able to ping the database server name.

when I run RUN_setup.sh there is a red box next to database server. The
name of the database is xe. If I click on it the error I get is: Error
connecting via
sqlplus system/Password1@xe
@/home/oracle/Desktop/Compiere2/utils/oracle/Test.sql

when I run the setup I also get invalid user name and password.




Date: 2007-06-13 18:42
Sender: lfreyesProject Admin


Could you provide the output of the log window when you execute
RUN_setup.sh and get the red box next to the db name?

Also please try the following:
1) Can you connect with the easy connect naming method?
sqlplus username/password@host:port/service_name
For example:
sqlplus compiere/compiere@fedoracle.bpoint.local:1521/xe

2) Does the loopback test work? Run from the database server the command:
ping fedoracle.bpoint.local
Run the same command from a client machine.

3) If #1 and #2 are OK, then provide the output of "lsnrctl status"


Date: 2007-06-12 19:30
Sender: andalib


I am currently on the Compiere Server Setup page. It was able to check
everything but the Database name has a red box next to it. My database name
is xe. I get error connecting via sqlplus. Let me know if you need any
output for any files. My OS is Fedora 6.


Date: 2007-06-06 23:23
Sender: jjankeSourceForge.net Subscriber and DonorAccepting Donations


In general, DO NOT use 127.0.0.1 or localhost - this will just get yorself
into lot's of trouble. Compiere is harcoded to prevent the use of
localhost as that will result in tons of problems, especially when enyone
tries to connect from another box.
So de-install and install using the "proper" name of the box.


Date: 2007-06-06 22:15
Sender: andalib


Content of the /etc/host.conf file:

order hosts, bind

Content of the: cat /etc/nsswitch.conf |grep host->
#hosts db files nisplus nis dns
hosts: files dns

Output of hostname: fedoracle.bpoint.local





Date: 2007-06-06 15:27
Sender: lfreyesProject Admin


The installation using localhost is usually not an option as it would
produce errors and is prevented.

What edition of Oracle are you trying to install? Express Edition 10.2?
What's the content of the file /etc/host.conf?
Output of cat /etc/nsswitch.conf |grep host
Output of "hostname"


Date: 2007-06-04 21:04
Sender: andalib


/etc/hosts file has the following lines:

192.168.0.23 fedoracle.bpoint.local fedoracle
127.0.0.1 localhost.localdomain localhost

Thanks.




Date: 2007-06-01 22:56
Sender: lfreyesProject Admin


There is probably an issue with your /etc/host file, but I'd need more
details to help you further. If you are still facing this issue could you
paste the content of your host file?

For FC5 with Oracle or EnterpriseDB we don't have a document with all the
setup instructions, but if you have any specific problems we'll be more
than glad to help you.


Date: 2007-06-01 22:56
Sender: lfreyesProject Admin


*** Status set to PENDING *** If the issue solved, please CLOSE
this request - otherwise set the status back to OPEN (we only
check OPEN items). If there is no reaction within a week, the
system will automatically CLOSE it. To speed up response time,
you may want to consider a support agreement.
***


Date: 2007-06-01 19:50
Sender: ruibal


Hi,

Regarding No.1 I wrote a little hands on tutorial, you can check it out
here
http://www.google.com/notebook/public/04437693734243340576/BDQGSSwoQ3-CLw64i

If you need further help, please set a message in the forums.




Attached Files ( 4 )

Filename Description Download
CompiereScreenshot.png Compiere Setup Screen Shot Download
pingoutput.png Ping Output Download
lsnrctl.png Download
tnsping.png TNSPING Output Download

Changes ( 37 )

Field Old Value Date By
status_id Pending 2007-06-30 02:20 sf-robot
close_date 2007-06-22 22:48 2007-06-30 02:20 sf-robot
close_date - 2007-06-22 22:48 lfreyes
status_id Open 2007-06-22 22:48 lfreyes
status_id Pending 2007-06-22 21:51 andalib
close_date 2007-06-21 19:03 2007-06-22 21:51 andalib
summary Oracle Installation (Bridgepoint Consulting) 2007-06-21 21:32 lfreyes
status_id Open 2007-06-21 19:03 lfreyes
close_date - 2007-06-21 19:03 lfreyes
File Added 234087: tnsping.png 2007-06-21 17:36 andalib
File Added 234085: lsnrctl.png 2007-06-21 17:29 andalib
File Added 234082: pingoutput.png 2007-06-21 17:23 andalib
status_id Pending 2007-06-21 17:21 andalib
close_date 2007-06-15 17:55 2007-06-21 17:21 andalib
File Added 234081: CompiereScreenshot.png 2007-06-21 17:21 andalib
close_date - 2007-06-15 17:55 lfreyes
status_id Open 2007-06-15 17:55 lfreyes
status_id Pending 2007-06-15 16:35 andalib
close_date 2007-06-13 18:42 2007-06-15 16:35 andalib
status_id Open 2007-06-13 18:42 lfreyes
close_date - 2007-06-13 18:42 lfreyes
close_date 2007-06-06 23:23 2007-06-12 19:30 andalib
priority 7 2007-06-12 19:30 andalib
status_id Pending 2007-06-12 19:30 andalib
status_id Open 2007-06-06 23:23 jjanke
close_date - 2007-06-06 23:23 jjanke
close_date 2007-06-06 15:27 2007-06-06 22:15 andalib
status_id Pending 2007-06-06 22:15 andalib
close_date - 2007-06-06 15:27 lfreyes
status_id Open 2007-06-06 15:27 lfreyes
close_date 2007-06-01 22:56 2007-06-04 21:04 andalib
status_id Pending 2007-06-04 21:04 andalib
close_date - 2007-06-01 22:56 lfreyes
status_id Open 2007-06-01 22:56 lfreyes
assigned_to nobody 2007-06-01 16:06 kmpink
is_private 1 2007-06-01 15:06 andalib
priority 5 2007-06-01 15:06 andalib