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
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!
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.
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.
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.
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.
make sure oracle excutable under $ORACLE_HOME/bin
sysdba, I granted 755 to $ORACLE_HOME/bin.
Still, the same error.
No, it should be 7555 instead of 755!
BTW, the first 7 is used for setuid and setgid.
Yep. I did that (7555). No success yet.