Re: column size - SQLPATH question

From: David Pintor <painterman_at_gmail.com>
Date: Thu, 21 Aug 2008 14:50:57 +0100
Message-ID: <f7321f200808210650u2d18870bga41a83c6126635ee@mail.gmail.com>

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

Received on Thu Aug 21 2008 - 08:50:57 CDT