sqlplus behaving strange 2005-02-07 - By Mike Tierney
Hi If you want to rule out an Environment setting issue, do this in each of those two logins:
env | grep -i ora
That will show you if the basic Oracle environment settings (ORACLE_HOME, ORACLE_SID, LD_LIBRARY_PATH(?)) are there.
Or maybe it's something else!
I'd also do a whoami just to make 100% sure that you are logged in as the exact same unix user both times.
> -- --Original Message-- -- > From: suse_list [mailto:suse_list@(protected)] > Sent: Tuesday, 8 February 2005 10:14 a.m. > To: suse-oracle@(protected) > Subject: [suse-oracle] sqlplus behaving strange > > Hi, > > I am not certain how the Xlogin via kdm on a SuSE 9.2 professional > installation affects oracle sqlplus, but i have noticed a strange > behaviour. > If i log into a workstation via ssh for instance i can run the sqlplus / > command just fine and any program that makes use of sqlplus, but if i log > in > via a Xsession on the machine sqlplus gives me a wrong user error. (See > below > for example sessions). > I am thinking that there is some sort of config missing or something is > not > run via login on a Xsession or something conflicts with it. If anyone has > any > ideas as to which files i should maybe check, please let me know. > I am trying to test this with both the 10.1.0.2 and 10.1.0.3 > libraries/sqlplus. > > Example session: > SSH session: > $ sqlplus / > SQL*Plus: Release 10.1.0.2.0 - Production on Mon Feb 7 14:11:24 2005 > > Copyright (c) 1982, 2004, Oracle. All rights reserved. > > > Connected to: > Oracle Database 10g Release 10.1.0.2.0 - Production > > SQL> > ======================================== > X-session: > $ sqlplus / > > SQL*Plus: Release 10.1.0.2.0 - Production on Mon Feb 7 14:11:03 2005 > > Copyright (c) 1982, 2004, Oracle. All rights reserved. > > ERROR: > ORA-01017 (See ORA-01017.ora-code.com): invalid username/password; logon denied > > > ============================== > > Thanks for any help > > Sascha > > -- > To unsubscribe, email: suse-oracle-unsubscribe@(protected) > For additional commands, email: suse-oracle-help@(protected) > Please see http://www.suse.com/oracle/ before posting
-- To unsubscribe, email: suse-oracle-unsubscribe@(protected) For additional commands, email: suse-oracle-help@(protected) Please see http://www.suse.com/oracle/ before posting
|
|