DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Hard Oracle Install

  1. #1
    Join Date
    Sep 2000
    Posts
    155

    Hard Installation of ORACLE:

    I tar'd the enitre oracle home directory and ftp'd onto a different machine.
    Then I untar'd it.

    I have created the user "oracle" on the new machine, created groups (oinstall, dba),
    set the env. for the user "oracle".

    Then, I started the DB and the listner. Everything works fine as "oracle user".
    $ sqlplus system/manager
    $sqlplus system/manager@orcl

    But, by logging in as a different OS user (say johnd) and do:
    $ sqlplus system/manager, it says ORACLE NOT AVAILABLE.

    But, if you do:
    $sqlplus system/manager@orcl, it works.

    I did set the env. variables for this OS user (johnd).


    Could anyone help me, if I have missed anything here....

    Thanks in advance!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Your environment variables are wrong. When you connect via the @alias this shows that the database is up and accepting connections. Also, it shows that sqlplus is in your path. Make sure ORACLE_SID, ORACLE_HOME, and LD_LIBRARY_PATH are defined correctly. I would bet your ORACLE_SID is not set.

  3. #3
    Join Date
    Sep 2000
    Posts
    155

    marist89, thanks for responding.

    The env. variables are correct. I double checked everything.
    Still it says, "ORACLE NOT available."

    Everything work fine if you work as "oracle" OS user.

  4. #4
    Join Date
    Nov 2000
    Posts
    71
    On what platform do you get this problem?
    I remember I had the same on a Linux machine with Oracle 8.0.4
    First of all look for free resources on the machine you are working on.
    Second look if your /var/tmp is full.
    I had to reinstall the entire product.Then it worked fine with all the OS user but it is the last thing to do because if the problem depends on the machine you're using may be it could be come back later.
    I had it only 1 time and only on Linux platform but i think it does not depend by the OS.

  5. #5
    Join Date
    Sep 2000
    Posts
    155
    oradbadmin,

    The /var/tmp is not full.

    Well... my platform is:

    Oracle 8.1.6 on Red Hat Linux 6.2


    The ironic thing is:
    $ sqlplus system/manager works for "oracle" user and NOT for other OS users
    while $ sqlplus system/manager@orcl works for everyone.

    The env. variables are set identical for everyone.

  6. #6
    Join Date
    Jun 2000
    Posts
    295
    make sure oracle excutable under $ORACLE_HOME/bin
    has 7555

  7. #7
    Join Date
    Sep 2000
    Posts
    155
    sysdba, I granted 755 to $ORACLE_HOME/bin.

    Still, the same error.

  8. #8
    Join Date
    Jun 2000
    Posts
    295
    No, it should be 7555 instead of 755!


  9. #9
    Join Date
    Jun 2000
    Posts
    295
    BTW, the first 7 is used for setuid and setgid.

  10. #10
    Join Date
    Sep 2000
    Posts
    155

    Yep. I did that (7555). No success yet.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width