| Maxim |
Posted: Aug 19, 2004 08:42:40 AM |
Total Post: 1
Joined: Aug, 2004
|
RDBMS Version: 9.2.0.5
Operating System and Version: AIX 5.2
Hi!
I'm used to the concept of running different Oracle instances (even of the same Oracle version) in different Unix users.
I set up all of those Unix users to be of group dba, everything runs perfectly and we have about 12 Oracle instances on each Unix machine.
Such setup gives me the following advantages:
1. I have a guarantee that in no way one instance can "bother" another one, because we increase the level of granulation/separation at Unix level.
2. If some instance fails in the way that even shutdown abort doesn't clean up all the processes and SGA, I can very quickly kill all the parasitic processes that are still in the air and clean SGA via ipcrm, because ipcs command clearly tells me who is who in this case.
3. I can put a different environment in .profile of each of those distinct Unix users.
Our new DBA instead wants all those instances to be run from the same Unix user, telling that it's easier to him not having to remember which Unix user runs each instance and it's an Oracle recommendation.
Could you enlight, please, on advantages and disadvantages of each method - separate Unix users for each instance or one user for all instances, taking into the account that the work for the separation (chown etc) is already done?
Thanks much,
Maxim.
|
|
|
 Vigyan |
| Posted: Dec 02, 2004 10:27:01 AM |  |
|
Total Post: 386
Joined: May, 2001
|
I would prefer running Oracle instances under single user e.g. oracle:dba . It is more for easy database management.
Regards,
Vigyan
|
|
|
|
|
| Steve |
| Posted: Dec 27, 2004 10:02:17 PM | |
|
Total Post: 8
Joined: Nov, 2004
|
In addition using a single oracle user you can switch instances to work with by something like: export ORACLE_SID=
|
|
|
|
|
| SURESH |
| Posted: Aug 22, 2006 03:18:58 AM | |
|
Total Post: 27
Joined: Aug, 2006
|
Hi All,
I am suresh.we are using oracle10g as server in LINUX (redhat 9)ehen ever we want to go back to previous code in same line.the cursor will delete all the charecters one by one to avoid this we are use editor for that what is the command i can type plz tell me sir.In windows i type ed as command to go to editor(buffer)than what is the command in linux supported oracle10g.plz help me.if we type ed as the command in sql than the error is:
sp2-0107:Nothing to save
plz give me the command.
bye
suresh.m
|
|
|
|
|
| ramesh |
| Posted: Jan 12, 2007 02:49:02 PM | |
|
Total Post: 16
Joined: Dec, 2006
|
hi suresh
you need to make an entry in .bash_profile file in which user's account your database is runnig.eg:oracle,make the following entry in the above said file,
EDITOR="vim";export EDITOR
save & quit.
now you need to exit from oracle or reboot your machine it will work.
|
|
|
|
|
| SURESH |
| Posted: Jan 13, 2007 08:58:11 PM | |
|
Total Post: 27
Joined: Aug, 2006
|
Hi Ramesh,
Thanks to ur advise i tried that one and succeded
bye
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
