Re: column size - SQLPATH question

Hi,

Yes, I had tried that... I tried also truss -o toto.log $ORACLE_HOME/bin/sqlplus but same problem... When I 'file' it, it's the same in both cases:

*/u01/oracle/ora92/bin/sqlplus: ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped*

I am waiting a feedback from the unix guy in the team...but any other ideas are welcome.

Thanks for your help!

David

2008/8/21 Mark W. Farnham <mwf_at_rsiz.com>

> Try "which sqlplus" or "whence sqlplus" or whatever the correct name of
> that command is for your shell. It will probably find a sqlplus file that is
> probably a wrapper script that truss cannot execute.
>
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *David Pintor
> *Sent:* Thursday, August 21, 2008 9:51 AM
> *To:* zhuchao_at_gmail.com
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: column size - SQLPATH question
>
>
>
> Thanks for your mail.
>
> It looks like the files are being opened indeed... these are the last
> entries in staging:
>
> ...
> open("/etc/ttysrch", O_RDONLY) = 8
> open("/u01/oracle/ora92/rdbms/mesg/oraus.msb", O_RDONLY) = 8
> open("/u01/oracle/ora92/sqlplus/mesg/sp1us.msb", O_RDONLY) = 3
> open("/u01/oracle/ora92/sqlplus/mesg/sp2us.msb", O_RDONLY) = 4
> *open("/u01/oracle/ora92/sqlplus/admin/login.sql", O_RDONLY) = 8
> open("/u01/oracle/ora92/sqlplus/admin/glogin.sql", O_RDONLY) = 11*
>
>
> The problem now is that I can't compare with production as when I truss the
> sqlplus command in there I get the error below:
>
> truss: cannot find/execute program: sqlplus
>
>
> I'm trying to find out where is the truss problem coming from... but if you
> have any other ideas in the meanwhile please let me know.
>
> Thanks!!
>
> David
>
> 2008/8/21 <zhuchao_at_gmail.com>
>
> Try:
> Truss -o /tmp/a.log sqlplus /
> Exit
> And grep open /tmp/a.log see which file the sqlplus opened?
>
> Sent via BlackBerry by AT&T
> ------------------------------
>
> *From*: "David Pintor" <painterman_at_gmail.com>
> *Date*: Thu, 21 Aug 2008 12:36:06 +0100
> *To*: <oracle-l_at_freelists.org>
> *Subject*: column size - SQLPATH question
>
> Hello,
>
> *- Oracle 9.2.0.8.0
> - Solaris 8*
>
> I have two servers as above. One for production and one for staging.
>
> In both I have an oracle user, in which profiles I have the following
> lines:
>
> export ORACLE_HOME=/u01/oracle/ora92
> ...
> export SQLPATH=$ORACLE_HOME/sqlplus/admin
>
>
> I have the same default glogin.sql in the SQLPATH for both but also a
> login.sql with the following lines:
>
> define editor=vi
> set lines 150
> set pages 999
>
>
> The configuration looks exactly the same for me.
>
> However, when I go to prod and type something like 'show parameter sga' I
> get:
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> lock_sga boolean FALSE
> pre_page_sga boolean FALSE
> sga_max_size big integer 3222769816
>
>
>
> And the same in staging gives me:
>
> NAME TYPE VALUE
> ------------------------------------ --------------------------------
> ------------------------------
> lock_sga boolean FALSE
> pre_page_sga boolean FALSE
> sga_max_size big integer
> 2098694720
>
>
>
> I don't understand why the size of the columns is different if all in
> SQLPATH is exactly the same and the Oracle version (and patch) are at the
> same level.
>
> Any ideas?
>
> Thanks for your help!
>
> David
>
>
>
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l