Originally posted by Shiva Thanks Jeff. That worked. I used
bash-2.05$ . oraenv to set the variables. But I have to do this each and every time I connect to the server - should it not be a one-time thing ?
[Edited by Shiva on 04-23-2002 at 10:45 AM]
No, its not a one-time thing. You have to set you environment each and every time you login to the box. If you are only working with one instance on this box, you could set your environment variables in your .profile. Otherwise, you could call oraenv from your .profile...
Or if you foresee multiple versions of Oracle or different tools on the same server, you can execute scripts after logging in.
For example, if you plan to run an application server or drive your backup from the same server, the environmental variables might be different. It depends on the number of databases you plan to have and the number of admins.