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!
Click Here to Expand Forum to Full Width