Home » RDBMS Server » Server Administration » Brand new client installation
Brand new client installation [message #210413] Wed, 20 December 2006 13:19 Go to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I have down this hundreds of times, but this is the 1st time I have seen this problem & am out of ideas.
I know the problem is PEBKAC, but I don't know how to solve it.
OS user "oracle" owns the whole directory tree.
[root@sp07 10.2.0]# uname -a
Linux sp07.hitbox.com 2.6.9-34.ELsmp #1 SMP Wed Mar 8 00:27:03 CST 2006 i686 i686 i386 GNU/Linux
The "root" OS user has run $ORACLE_HOME/root.sh

When user "oracle" invokes sqlplus, it just "hangs".

Running strace against the sqlplus process show many line like:
times(NULL) = -1853244925
times(NULL) = -1853244925
times(NULL) = -1853244925
times(NULL) = -1853244925
times(NULL) = -1853244925
times(NULL) = -1853244925

The environment for OS user "oracle" is as follows:
<bid1-oracle@sp07.hitbox.com:/a/oracle/product/10.2.0/bin:> env | sort
_=/bin/env
DBA=/b/oracle/admin/bid1
EDITOR=vi
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/b/oracle
HOSTNAME=sp07.hitbox.com
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LD_LIBRARY_PATH=/a/oracle/product/10.2.0/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32: *.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*. zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01; 35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
MAIL=/var/spool/mail/oracle
NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS
NLS_LANG=AMERICAN
NLS_LANGUAGE=AMERICAN
OH=/a/oracle/product/10.2.0
OLDPWD=/a/oracle/product/10.2.0/network/admin
ORACLE_HOME=/a/oracle/product/10.2.0
ORACLE_SID=bid1
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/a/oracle/product/10.2.0/bin
PS1=<bid1-oracle@sp07.hitbox.com:${PWD}:>
PWD=/a/oracle/product/10.2.0/bin
SHELL=/bin/bash
SHLVL=1
TERM=vt100
USER=oracle
<bid1-oracle@sp07.hitbox.com:/a/oracle/product/10.2.0/bin:> sqlplus

<bid1-oracle@sp07.hitbox.com:/a/oracle/product/10.2.0/bin:> uname -a
Linux sp07.hitbox.com 2.6.9-34.ELsmp #1 SMP Wed Mar 8 00:27:03 CST 2006 i686 i686 i386 GNU/Linux
<bid1-oracle@sp07.hitbox.com:/a/oracle/product/10.2.0/bin:> sqlplus

<bid1-oracle@sp07.hitbox.com:/a/oracle/product/10.2.0/bin:>

I've done:
$ORACLE_HOME/bin/relink all
& did not see any errors

Any ideas on what needs to change to allow sqlplus to work would be greatly appreciated
Re: Brand new client installation [message #210422 is a reply to message #210413] Wed, 20 December 2006 15:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Related to bug#4612267?
Did you also check metalink note 338461.1 ?
Regards~
Re: Brand new client installation [message #210426 is a reply to message #210413] Wed, 20 December 2006 15:45 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
<bid1-oracle@sp07.hitbox.com:/b/oracle:> uptime
13:35:54 up 233 days, 21 min, 6 users, load average: 0.02, 0.02, 0.00

but everything else closely matches what is in Note:338461.1

Now I am off to find the patch & install it.

THANKS!
Re: Brand new client installation [message #210431 is a reply to message #210413] Wed, 20 December 2006 16:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
The developer was VERY impatient & bounced the box.
The patch requires an SR, but since the box was bounced I can no longer reproduce the problem.
This fix belongs to the Micro$oft school of s/w development.
Ctl-Alt-Del

Thanks Again!
Re: Brand new client installation [message #210435 is a reply to message #210431] Wed, 20 December 2006 16:56 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
cool Smile
Previous Topic: Is it possible to report a bug in RDBMS Oracle?
Next Topic: OPTIMAL_LOGFILE_SIZE
Goto Forum:
  


Current Time: Fri Sep 20 04:24:49 CDT 2024