#4472 Oracle XE installation on Fedora 6 (Bridgepoint Consulting)

closed
9
2007-06-30
2007-05-31
No

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?

Discussion

1 2 > >> (Page 1 of 2)
  • Bridgepoint Consulting

    • priority: 5 --> 7
     
  • Kathy Pink

    Kathy Pink - 2007-06-01
    • assigned_to: nobody --> lfreyes
     
  • Felipe Reyes

    Felipe Reyes - 2007-06-01
    • status: open --> pending
     
  • Felipe Reyes

    Felipe Reyes - 2007-06-01

    Logged In: YES
    user_id=1793135
    Originator: NO

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

     
  • Felipe Reyes

    Felipe Reyes - 2007-06-01

    Logged In: YES
    user_id=1793135
    Originator: NO

    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.

     
  • Bridgepoint Consulting

    Logged In: YES
    user_id=1747729
    Originator: YES

    /etc/hosts file has the following lines:

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

    Thanks.

     
  • Bridgepoint Consulting

    • status: pending --> open
     
  • Felipe Reyes

    Felipe Reyes - 2007-06-06
    • status: open --> pending
     
  • Felipe Reyes

    Felipe Reyes - 2007-06-06

    Logged In: YES
    user_id=1793135
    Originator: NO

    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"

     
  • Bridgepoint Consulting

    Logged In: YES
    user_id=1747729
    Originator: YES

    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

     
  • Bridgepoint Consulting

    • status: pending --> open
     
  • Jorg Janke

    Jorg Janke - 2007-06-06
    • status: open --> pending
     
  • Jorg Janke

    Jorg Janke - 2007-06-06

    Logged In: YES
    user_id=87038
    Originator: NO

    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.

     
  • Bridgepoint Consulting

    • priority: 7 --> 9
    • status: pending --> open
     
  • Bridgepoint Consulting

    Logged In: YES
    user_id=1747729
    Originator: YES

    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.

     
  • Felipe Reyes

    Felipe Reyes - 2007-06-13
    • status: open --> pending
     
  • Felipe Reyes

    Felipe Reyes - 2007-06-13

    Logged In: YES
    user_id=1793135
    Originator: NO

    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"

     
  • Bridgepoint Consulting

    Logged In: YES
    user_id=1747729
    Originator: YES

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

     
  • Bridgepoint Consulting

    • status: pending --> open
     
  • Felipe Reyes

    Felipe Reyes - 2007-06-15

    Logged In: YES
    user_id=1793135
    Originator: NO

    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?

     
  • Felipe Reyes

    Felipe Reyes - 2007-06-15
    • status: open --> pending
     
  • Bridgepoint Consulting

    • status: pending --> open
     
  • Bridgepoint Consulting

    Logged In: YES
    user_id=1747729
    Originator: YES

    File Added: CompiereScreenshot.png

     
1 2 > >> (Page 1 of 2)

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks