sql-plus failure over network

[Advocate]

i had a unix crontab sqlplus failure last night ...

oracle 8.16 and aix

the network was down but all packages/data were on same server

3 packages run ok (before and after failure) were called by using following unix script syntax :

set LOADPRODUCT=`sqlplus -s $USERNAME/$USERNAME @$SQLSCRIPTS/products.sql`

package failed with following unix script syntax :

sqlplus -s $USERNAME/$USERNAME @$SQLSCRIPTS/stats.sql

dba believes @ causes sqlplus to look over network for db but does not know why different syntax failed/passed

any ideas please ?
Best of Irish Luck, David.
djwilkes@hotmail.com

 

[did02]

Hi David,

Here is the difference of syntax :

* first case :
I don't know how your LOADPRODUCT string is executed, but I think the resolution of the connection uses the tnsnames.ora. So oracle access the DB through the network.

Ex: sqlplus login/pwd@connect_string

* second case :
I think you were working on the server and you previously set ORACLE_SID and ORACLE_HOME variables. The connection to DB does not use there the tnsnames.ora.

Ex:
ORACLE_HOME=/opt/ora816
ORACLE_SID=DB_Name
sqlplus login/pwd


Hope it helps you.
Rgds,
Did02

 

[Advocate]

did02,

thanks for suggestion but we had a red herring ...

cause was actually an error in user profile ! i had to track it down and educate the dba ...

query closed.
Best of Irish Luck, David.
djwilkes@hotmail.com