I create the User with Yast and assign the default group to dba It has the same shell that the one that has the Oracle user. if I do a ls -la command it shows this: icarus:/home/kwebb # ls -la total 228 drwx------ 6 kwebb dba 4096 Oct 2 13:22 . drwxr-xr-x 4 kwebb dba 4096 Oct 2 13:18 .. -rw-r--r-- 1 kwebb dba 5742 Oct 2 13:18 .Xdefaults -rw-r--r-- 1 kwebb dba 1305 Oct 2 13:18 .Xmodmap lrwxrwxrwx 1 kwebb dba 10 Oct 2 13:18 .Xresources -> .Xdefault -rw------- 1 kwebb dba 124 Oct 2 13:23 .bash_history -rw-r--r-- 1 kwebb dba 680 Oct 2 13:18 .bash_profile -rw-r--r-- 1 kwebb dba 1392 Oct 2 13:18 .bashrc -rw-r--r-- 1 kwebb dba 0 Oct 2 13:18 .dayplan -rw------- 1 kwebb dba 0 Oct 2 13:18 .dayplan.priv -rw-r--r-- 1 kwebb dba 208 Oct 2 13:18 .dvipsrc -rw-r--r-- 1 kwebb dba 4143 Oct 2 13:18 .emacs -rw-r--r-- 1 kwebb dba 1124 Oct 2 13:18 .exrc -rw-r--r-- 1 kwebb dba 5376 Oct 2 13:18 .gimprc drwx------ 2 kwebb dba 4096 Oct 2 13:18 .grok drwxr-xr-x 2 kwebb dba 4096 Oct 2 13:18 .hotjava -rw-r--r-- 1 kwebb dba 7924 Oct 2 13:18 .jazz -rw-r--r-- 1 kwebb dba 164 Oct 2 13:18 .kermrc -rw-r--r-- 1 kwebb dba 10376 Oct 2 13:18 .lyxrc -rw-r--r-- 1 kwebb dba 2286 Oct 2 13:18 .muttrc -rw-r--r-- 1 kwebb dba 2070 Oct 2 13:18 .nc_keys -rw-r--r-- 1 kwebb dba 492 Oct 2 13:18 .profile drwx------ 2 kwebb dba 4096 Oct 2 13:18 .seyon -rw-r--r-- 1 kwebb dba 42 Oct 2 13:18 .stonxrc -rw-r--r-- 1 kwebb dba 94 Oct 2 13:18 .susephone -rw-r--r-- 1 kwebb dba 8 Oct 2 13:18 .tex -rw-r--r-- 1 kwebb dba 10972 Oct 2 13:18 .uitrc.console -rw-r--r-- 1 kwebb dba 9394 Oct 2 13:18 .uitrc.vt100 -rw-r--r-- 1 kwebb dba 9394 Oct 2 13:18 .uitrc.vt102 -rw-r--r-- 1 kwebb dba 10687 Oct 2 13:18 .uitrc.xterm -rw-r--r-- 1 kwebb dba 324 Oct 2 13:18 .urlview -rw-r--r-- 1 kwebb dba 341 Oct 2 13:18 .vimrc -rw-r--r-- 1 kwebb dba 7913 Oct 2 13:18 .xcoralrc drwxr-xr-x 2 kwebb dba 4096 Oct 2 13:18 .xfm -rwxr-xr-x 1 kwebb dba 2036 Oct 2 13:18 .xinitrc -rw-r--r-- 1 kwebb dba 795 Oct 2 13:18 .xserverrc.secure -rwxr-xr-x 1 kwebb dba 2751 Oct 2 13:18 .xsession -rw-r--r-- 1 kwebb dba 119 Oct 2 13:18 .xtalkrc -rw-r--r-- 1 kwebb dba 10 Oct 2 13:18 .zsh also it's .bash_profile is: icarus:/home/kwebb # cat .bash_profile # # Oracle Stuff Goes Here # alias dir='ls -la' alias cls='clear' ORACLE_HOME=/opt/oracle/8i/u01/app/oracle/product/8.1.6 ORACLE_BASE=/opt/oracle/8i/u01/app/oracle ORACLE_OWNER=oracle ORACLE_SID=PRODUC export ORACLE_HOME ORACLE_BASE ORACLE_OWNER ORACLE_SID NLS_SORT=BINARY NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P9 NLS_DATE_FORMAT="RRRRMMDD" ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data ORACLE_TERM=vt100 LD_LIBRARY_PATH=$ORACLE_HOME/lib PATH=$PATH:$ORACLE_HOME/bin umask 022 export NLS_LANG ORA_NLS33 PATH LD_LIBRARY_PATH NLS_SORT export NLS_LANG NLS_DATE_FORMAT # # Java Stuff Goes Here # export JAVA_HOME=/usr/local/jre export PATH=$JAVA_HOME/bin:$PATH
Hi...
I'm trying to make a O.S user that could run the SQL PLUS, ORA OERR and other Oracle programs, I copy the .bash_profile and ALL the other /opt/oracle/* files including the hidden ones, but I'm still unable to use those programs ? why and what should I do ?
thanks
-ed
-- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the FAQ at http://www.suse.com/support/faq
<font color="#0000FF"><b>I create the User with Yast and assign the default group to dba It has the same shell that the one that has the Oracle user. if I do a ls -la command it shows this: </b></font>icarus:/home/kwebb # ls -la total 228 drwx------ 6 kwebb dba 4096 Oct 2 13:22 . drwxr-xr-x 4 kwebb dba 4096 Oct 2 13:18 .. -rw-r--r-- 1 kwebb dba 5742 Oct 2 13:18 .Xdefaults -rw-r--r-- 1 kwebb dba 1305 Oct 2 13:18 .Xmodmap lrwxrwxrwx 1 kwebb dba 10 Oct 2 13:18 .Xresources -> .Xdefault -rw------- 1 kwebb dba 124 Oct 2 13:23 .bash_history -rw-r--r-- 1 kwebb dba 680 Oct 2 13:18 .bash_profile -rw-r--r-- 1 kwebb dba 1392 Oct 2 13:18 .bashrc -rw-r--r-- 1 kwebb dba 0 Oct 2 13:18 .dayplan -rw------- 1 kwebb dba 0 Oct 2 13:18 .dayplan.priv -rw-r--r-- 1 kwebb dba 208 Oct 2 13:18 .dvipsrc -rw-r--r-- 1 kwebb dba 4143 Oct 2 13:18 .emacs -rw-r--r-- 1 kwebb dba 1124 Oct 2 13:18 .exrc -rw-r--r-- 1 kwebb dba 5376 Oct 2 13:18 .gimprc drwx------ 2 kwebb dba 4096 Oct 2 13:18 .grok drwxr-xr-x 2 kwebb dba 4096 Oct 2 13:18 .hotjava -rw-r--r-- 1 kwebb dba 7924 Oct 2 13:18 .jazz -rw-r--r-- 1 kwebb dba 164 Oct 2 13:18 .kermrc -rw-r--r-- 1 kwebb dba 10376 Oct 2 13:18 .lyxrc -rw-r--r-- 1 kwebb dba 2286 Oct 2 13:18 .muttrc -rw-r--r-- 1 kwebb dba 2070 Oct 2 13:18 .nc_keys -rw-r--r-- 1 kwebb dba 492 Oct 2 13:18 .profile drwx------ 2 kwebb dba 4096 Oct 2 13:18 .seyon -rw-r--r-- 1 kwebb dba 42 Oct 2 13:18 .stonxrc -rw-r--r-- 1 kwebb dba 94 Oct 2 13:18 .susephone -rw-r--r-- 1 kwebb dba 8 Oct 2 13:18 .tex -rw-r--r-- 1 kwebb dba 10972 Oct 2 13:18 .uitrc.console -rw-r--r-- 1 kwebb dba 9394 Oct 2 13:18 .uitrc.vt100 -rw-r--r-- 1 kwebb dba 9394 Oct 2 13:18 .uitrc.vt102 -rw-r--r-- 1 kwebb dba 10687 Oct 2 13:18 .uitrc.xterm -rw-r--r-- 1 kwebb dba 324 Oct 2 13:18 .urlview -rw-r--r-- 1 kwebb dba 341 Oct 2 13:18 .vimrc -rw-r--r-- 1 kwebb dba 7913 Oct 2 13:18 .xcoralrc drwxr-xr-x 2 kwebb dba 4096 Oct 2 13:18 .xfm -rwxr-xr-x 1 kwebb dba 2036 Oct 2 13:18 .xinitrc -rw-r--r-- 1 kwebb dba 795 Oct 2 13:18 .xserverrc.secure -rwxr-xr-x 1 kwebb dba 2751 Oct 2 13:18 .xsession -rw-r--r-- 1 kwebb dba 119 Oct 2 13:18 .xtalkrc -rw-r--r-- 1 kwebb dba 10 Oct 2 13:18 .zsh <font color="#0000FF"><b>also it's .bash_profile is: </b></font>icarus:/home/kwebb # cat .bash_profile # # Oracle Stuff Goes Here # alias dir='ls -la' alias cls='clear' ORACLE_HOME=/opt/oracle/8i/u01/app/oracle/product/8.1.6 ORACLE_BASE=/opt/oracle/8i/u01/app/oracle ORACLE_OWNER=oracle ORACLE_SID=PRODUC export ORACLE_HOME ORACLE_BASE ORACLE_OWNER ORACLE_SID NLS_SORT=BINARY NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P9 NLS_DATE_FORMAT="RRRRMMDD" ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data ORACLE_TERM=vt100 LD_LIBRARY_PATH=$ORACLE_HOME/lib PATH=$PATH:$ORACLE_HOME/bin umask 022 export NLS_LANG ORA_NLS33 PATH LD_LIBRARY_PATH NLS_SORT export NLS_LANG NLS_DATE_FORMAT # # Java Stuff Goes Here # export JAVA_HOME=/usr/local/jre export PATH=$JAVA_HOME/bin:$PATH <blockquote type=cite class=cite cite>Hi... I'm trying to make a O.S user that could run the SQL PLUS, ORA OERR and other Oracle programs, I copy the .bash_profile and ALL the other /opt/oracle/* files including the hidden ones, but I'm still unable to use those programs ? why and what should I do ? thanks -ed -- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the FAQ at <a href="http://www.suse.com/support/faq%A0%A0%A0%A0%A0" eudora="autourl">http://www.suse.com/support/faq </a> </blockquote>