On Thu, Feb 05, 2009 at 04:26:53PM +0100, Wolf, Christian wrote: > Hi! > I hope thats ok: > [r...@berlxspw01 Desktop]# cd /usr/bin/ > [r...@berlxspw01 bin]# sqlplus spacewalk/spacew...@xe
You are not necessarily running /usr/bin/sqlplus here. The fact that you are chdir'ed to a directory does *not* mean you are running program from that directory. What command (from which directory) will be executed depends on your PATH environment variable, not on you current directory. My guess is that you actually execute /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus just like you are in the next case, and you have ORACLE_HOME set. > SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 5 16:22:42 2009 > Copyright (c) 1982, 2005, Oracle. All rights reserved. > > Connected to: > Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production > SQL> quit > > Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - > Production > [r...@berlxspw01 /]# sqlplus spacewalk/spacew...@xe I assume that this works because you have ORACLE_HOME set. > SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 5 16:22:54 2009 > Copyright (c) 1982, 2005, Oracle. All rights reserved. > > Connected to: > Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production > SQL> quit > > [r...@berlxspw01 /]# type sqlplus > sqlplus is hashed > (/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus) This shows that no matter in what directory you are, /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus will be run. That is not correct. > [r...@berlxspw01 /]# ./sqlplus > -bash: ./sqlplus: Datei oder Verzeichnis nicht gefunden This shows that there is no sqlplus in this directory. You should: - unset ORACLE_HOME; - verify that /usr/bin/sqlplus points to the InstantClient sqlplus; - try /usr/bin/sqlplus (full path) and see if it works without that ORACLE_HOME set; - unset /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin from your PATH; - run type sqlplus to verify that it shows /usr/bin/sqlplus; - run sqlplus and see if it works without that ORACLE_HOME set. -- Jan Pazdziora | adelton at #satellite*, #brno Satellite Engineering, Red Hat _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
