-
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!
-
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.
-
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.
-
make sure oracle excutable under $ORACLE_HOME/bin
has 7555
-
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.
-
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.
-
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
-
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.
-
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.
-
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.
-
Gald you got your problem solved!