DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16
  1. #11
    Join Date
    Nov 2000
    Are you using a directory alias?
    for example, directory /u01/d001/disk/oracle/ has an alias '/h' , so /u01/d001/disk/oracle/ = /h/oracle/ .
    If you are using a directory alias , even though both are pointing to the same directory, Oracle could understand differently, so use one in env and init.ora.
    I hope that this will be helpful.

  2. #12
    Join Date
    Nov 2000
    Are you sure other OS users have their ORACLE_SID environment variable setted?

    This should be the problem if with
    $sqlplus system/manager@orcl
    works fine for everyone

  3. #13
    Join Date
    Sep 2000

    oradbadmin, ORACLE_SID is set in the env. On top of it, I am again setting ORACLE_SID before running the sqlplus command.

    chobo, there are NO aliasas for the directories.

  4. #14
    Join Date
    Sep 2000
    Finally, i was able to locate the problem.

    $ chmod 7555 $ORACLE_HOME/bin/oracle

    I was missing 7555 to the oracle executable in the bin direcotry.

    Now, I have figured out a fastest way to migrate the entire ORACLE folder
    and start it up on a different machine thus, avoiding to use Intsaller and create
    database etc.... Of course, it would work as long as the OS is identical.

    Thanks everyone for all your help.

  5. #15
    Join Date
    Sep 2000

    Thanks SYSDBA

    sysdba, I think you are correct.

    When you have told me to do:

    $ chmod 7555 $ORACLE_HOME/bin/oracle, instead I did:

    $ chmod 7555 $ORACLE_HOME/bin. I didn't read your response carefully :-)

    I have realised now. Thanks for your help again.

  6. #16
    Join Date
    Jun 2000
    Gald you got your problem solved!

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.