Hi, I delete the user files and copy the .bash_profile and set the respective permisions of the user and to the group. but also have problems with running programs Thanks --ed icarus:/home/kwebb # ls -la total 28 drwx------ 6 kwebb dba 4096 Oct 2 14:29 . drwxr-xr-x 4 kwebb dba 4096 Oct 2 13:18 .. -rwxrwxrwx 1 kwebb dba 680 Oct 2 14:29 .bash_profile drwx------ 2 kwebb dba 4096 Oct 2 13:18 .grok drwxr-xr-x 2 kwebb dba 4096 Oct 2 13:18 .hotjava drwx------ 2 kwebb dba 4096 Oct 2 13:18 .seyon drwxr-xr-x 2 kwebb dba 4096 Oct 2 13:18 .xfm icarus:/home/kwebb # whoami root icarus:/home/kwebb # su - kwebb kwebb@icarus:~ > sqlplus bash: sqlplus: command not found kwebb@icarus:~ > oerr ora 0600 bash: oerr: command not found kwebb@icarus:~ >
Ack! You really didn't need to copy those extra dot-files. The only one you really needed to copy was .bash_profile actually, I wouldn't even have copied it, I would have just copied the oracle stuff. Try cleaning those files out and copying all the default stuff from /etc/skel then just copy the oracle sections into your .bash_profile.
Let us know what happens then.
JW
Note: the the reason for this is because all the other dot-files have nothing to do with oracle
At 01:56 PM 10/2/2000 -0600, you wrote:
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
-- 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
-- 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