Home » RDBMS Server » Server Administration » [Upg 9208 - 1020] ORA-07217: sltln: environment variable cannot be evaluated. (Sun SPARC 8)
[Upg 9208 - 1020] ORA-07217: sltln: environment variable cannot be evaluated. [message #531378] Tue, 15 November 2011 12:00 Go to next message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member

After settig the proper environment whenever I issue startup upgrade at the SQL*Plus prompt i get the following error.

ORA-07217: sltln: environment variable cannot be evaluated.

I have 3 other databases on the same machine that I successfully upgraded without encoutering this error.
Re: [Upg 9208 - 1020] ORA-07217: sltln: environment variable cannot be evaluated. [message #531379 is a reply to message #531378] Tue, 15 November 2011 12:03 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

07217, 00000, "sltln: environment variable cannot be evaluated."
// *Cause:  getenv call returned a null pointer.
// *Action: Set the environment variable and try again.


post results from following OS command

env | sort
Re: [Upg 9208 - 1020] ORA-07217: sltln: environment variable cannot be evaluated. [message #531381 is a reply to message #531378] Tue, 15 November 2011 12:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check a '$' sign is not present in your init.ora or spfile.

Regards
Michel
Re: [Upg 9208 - 1020] ORA-07217: sltln: environment variable cannot be evaluated. [message #531382 is a reply to message #531379] Tue, 15 November 2011 12:41 Go to previous messageGo to next message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member

Output of command below


env | sort

EDITOR=vi
HOME=/export/home/oracle
HOSTNAME=mohudiri
HOSTTYPE=sparc
LD_LIBRARY_PATH=/usr/openwin/lib
LOGNAME=oracle
MACHTYPE=sparc-sun-solaris
MAIL=/var/mail//oracle
MANPATH=:/usr/share/man:/usr/openv/man:/usr/openv/man:/usr/openv/man/share/man:/usr
/local/samba/share/man:/opt/SUNWexplo/man:/opt/SUNWcest/man
OLDPWD=/u01/app/oracle/product/10.2.0/KFXITM/dbs
OPENWINHOME=/usr/openwin
ORACLE_HOME=/u01/app/oracle/product/10.2.0/KFXITM
ORACLE_SID=TCSP
ORATAB=/var/opt/oracle/oratab
OSTYPE=solaris
PATH=/u01/app/oracle/product/10.2.0/KFXITM/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/l
ocal/bin:/usr/ccs/bin:/usr/openwin/bin:/usr/dt/bin:/usr/platform/SUNW,Sun-Fire/sbin
:/opt/sun/bin:/opt/csw/sbin:/opt/csw/bin:/usr/openv/netbackup/bin/goodies:/usr/open
v/netbackup/bin/admincmd:/usr/openv/bin:/usr/openv/db/bin:/usr/openv/java:/usr/open
v/netbackup:/usr/openv/volmgr/bin:/usr/openv/netbackup/bin:/opt/VRTSvlic/bin:/opt/S
UNWexplo/bin:/opt/SUNWcest/bin:/usr/css/bin:/library/envs:/usr/local/bin:/u01/app/o
racle/product/10.2.0/KFXITM/bin:/library/envs:/usr/local/bin
PS1=${LOGNAME}@${HOSTNAME}:${ORACLE_SID}:${PWD}
PS2=oracle@mohudiri >
PWD=/u01/app/oracle/product/10.2.0/KFXITM/rdbms/admin
SHELL=/bin/ksh
SHLVL=1
SSH_CLIENT=10.1.31.72 52951 22
SSH_CONNECTION=10.1.31.72 52951 10.1.31.69 22
SSH_TTY=/dev/pts/2
TERM=dtterm
TZ=SAST-2SADT
USER=oracle
_=/usr/bin/env
Re: [Upg 9208 - 1020] ORA-07217: sltln: environment variable cannot be evaluated. [message #531384 is a reply to message #531382] Tue, 15 November 2011 12:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 15 November 2011 19:41
Check a '$' sign is not present in your init.ora or spfile.

Regards
Michel


... or a cariage return or a non-printable character.

Re: [Upg 9208 - 1020] ORA-07217: sltln: environment variable cannot be evaluated. [message #531385 is a reply to message #531384] Tue, 15 November 2011 13:12 Go to previous messageGo to next message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member

I checked and there appears to be NO non-printable characters in the pfile


oracle@mohudiri:TCSP:/u01/app/oracle/product/db/dbs
grep "^$" initTCSP.ora
oracle@mohudiri:TCSP:/u01/app/oracle/product/db/dbs
Re: [Upg 9208 - 1020] ORA-07217: sltln: environment variable cannot be evaluated. [message #531387 is a reply to message #531385] Tue, 15 November 2011 13:27 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>After settig the proper environment whenever I issue startup upgrade at the SQL*Plus prompt i get the following error.
>ORA-07217: sltln: environment variable cannot be evaluated.

Upgrading from which version to which version; both to 4 decimal places, please.
The above implies more than one ORACLE_HOME. Is this correct?
If so, what is other ORACLE_HOME?

post results from follow OS command

ls -ltr /u01/app/oracle/product/10.2.0/KFXITM/dbs
Re: [Upg 9208 - 1020] ORA-07217: sltln: environment variable cannot be evaluated. [message #531390 is a reply to message #531385] Tue, 15 November 2011 14:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
drovnik wrote on Tue, 15 November 2011 20:12
I checked and there appears to be NO non-printable characters in the pfile


oracle@mohudiri:TCSP:/u01/app/oracle/product/db/dbs
grep "^$" initTCSP.ora
oracle@mohudiri:TCSP:/u01/app/oracle/product/db/dbs


And $ and CR or LF inside a value?

Post the file.

Regards
Michel
Re: [Upg 9208 - 1020] ORA-07217: sltln: environment variable cannot be evaluated. [message #531420 is a reply to message #531390] Wed, 16 November 2011 00:17 Go to previous messageGo to next message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member

Yes there 2 ORACLE_HOME's the current home 9.2.0.8 and the target home 10.2.0.5


ls -ltr /u01/app/oracle/product/10.2.0/KFXITM/dbs
total 106
-rw-r----- 1 oracle dba 8385 Sep 11 1998 init.ora
-rw-r--r-- 1 oracle dba 12920 May 3 2001 initdw.ora
-rw-r--r-- 1 oracle dba 1347 Sep 16 20:28 initKFXITM.ora
-rw-rw---- 1 oracle dba 24 Sep 16 20:29 lkKFXITM
-rw-rw---- 1 oracle dba 1544 Sep 18 09:34 hc_KFXITM.dat
-rw-r--r-- 1 oracle dba 1082 Oct 31 21:37 initCCBE.ora
-rw-rw---- 1 oracle dba 24 Oct 31 21:37 lkCCBE
-rw-rw---- 1 oracle dba 1544 Oct 31 22:20 hc_CCBE.dat
-rw-r----- 1 oracle dba 3584 Nov 1 14:16 spfileCCBE.ora
-rw-r----- 1 oracle dba 2048 Nov 15 10:35 orapwKFXITM
-rw-rw---- 1 oracle dba 24 Nov 15 18:54 lkHDPROD
-rw-r--r-- 1 oracle dba 1097 Nov 15 19:24 initIPDP.ora
-rw-rw---- 1 oracle dba 24 Nov 15 19:25 lkIPDP
-rw-r--r-- 1 oracle dba 1141 Nov 15 19:28 initTCSP.ora
-rw-r--r-- 1 oracle dba 1177 Nov 15 19:33 initHDPROD.ora
-rw-rw---- 1 oracle dba 1544 Nov 15 19:34 hc_HDPROD.dat
-rw-rw---- 1 oracle dba 24 Nov 15 19:53 lkTCSP
-rw-rw---- 1 oracle dba 1544 Nov 15 19:55 hc_TCSP.dat
-rw-rw---- 1 oracle dba 1544 Nov 15 20:53 hc_IPDP.dat



The below command show "$" at the end of every line; its the only character that appears out of place.

font=Courier]
cat -v -e -t initTCSP.ora
*.audit_file_dest='$ORACLE_BASE/admin/TCSP/adump/'$
*.audit_trail='db'$
*.background_dump_dest='/u01/app/oracle/admin/TCSP/bdump'$
*.compatible='9.2.0.0.0'$
*.control_files='/TCSP/ctlfiles/cntl_01.ctl','/TCSP/ctlfiles/cntl_02.ctl'$
*.core_dump_dest='/u01/app/oracle/admin/TCSP/cdump'$
*.db_block_size=8192$
*.db_cache_size=36000$
*.db_file_multiblock_read_count=32$
*.db_files=100$
....
...
[[/font]


Is this the possible cause of the error. If so then I am puzzled as why the database startup OK in 9iR2
home ?
Re: [Upg 9208 - 1020] ORA-07217: sltln: environment variable cannot be evaluated. [message #531422 is a reply to message #531420] Wed, 16 November 2011 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is this the possible cause of the error.


Yes.

Quote:
If so then I am puzzled as why the database startup OK in 9iR2


Different versions, different bugs.

In 11.2, BlackSwan made some tests (thanks for them) and there is a clearer error message like:
LRM-00104: '$FOOBAR' is not a legal integer for...

LRM-00121: '$FOOBAR' is not an allowable value for...


Regards
Michel
Re: [Upg 9208 - 1020] ORA-07217: sltln: environment variable cannot be evaluated. [message #531598 is a reply to message #531422] Wed, 16 November 2011 23:45 Go to previous message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member

I have created the pfile afresh using the spfile and I still have the "$" at the end of each line. I checked other pfiles from the last successfully completed upgrade
and it too had non-printtable characters.

see below initHDPROD.ora

cat -evt initHDPROD.ora
License_sessions_warning= 0$
session_max_open_files = 20 $
license_max_users = 450$
log_archive_dest^I^I= /u01/app/oracle/admin/HDPROD/adump/HDPROD$
background_dump_dest^I^I= /u01/app/oracle/admin/HDPROD/bdump$
core_dump_dest^I^I^I= /u01/app/oracle/admin/HDPROD/cdump$
user_dump_dest^I^I^I= /u01/app/oracle/admin/HDPROD/udump$
$
control_files^I^I^I= ( /HDPROD/ctlfiles/cntl_01.ctl,$



Even when I issue


oracle@mohudiri:TCSP:/u01/app/oracle/admin/HDPROD/pfile
cat -evt initHDPROD.ora | tr -d "$" | tr -d "^I" > initHDPROD.ora.new
oracle@mohudiri:TCSP:/u01/app/oracle/admin/HDPROD/pfile



The contents of the new file still contain these characters


cat -evt initHDPROD.ora.new
License_sessions_warning= 0$
session_max_open_files = 20 $
license_max_users = 450$
log_archive_dest= /u01/app/oracle/admin/HDPROD/adump/HDPROD$
background_dump_dest= /u01/app/oracle/admin/HDPROD/bdump$
core_dump_dest= /u01/app/oracle/admin/HDPROD/cdump$
user_dump_dest= /u01/app/oracle/admin/HDPROD/udump$
$
control_files= ( /HDPROD/ctlfiles/cntl_01.ctl,$
/HDPROD/ctlfiles/cntl_02.ctl$
)$
$
audit_trail= db$



I managed successfully managed to upgrade other instances from the same version upto the same level as mentioned here. I restored an older backup of one of the test instances and performed the upgrade even though the pfile had these characters.
Previous Topic: Query regarding Multilingual Database
Next Topic: 10g change disk with datafiles
Goto Forum:
  


Current Time: Thu Mar 28 10:09:44 CDT 2024