Compiere ERP + CRM Business Solution

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).

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

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)?

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

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"

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

File Added: lsnrctl.png

File Added: pingoutput.png

File Added: CompiereScreenshot.png

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?

#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.

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"

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.

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.

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

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"

/etc/hosts file has the following lines:

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

Thanks.

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.

*** 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.
***

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.