topic Re: ora-07217: sltln: environment cannot be evaluated in Operating System - HP-UX

ora-07217: sltln: environment cannot be evaluated

tom quach_1 — Tue, 03 May 2005 15:57:46 GMT

i have service guard package that start, stop and monitor oracle database.
the last time when i stop and restart the package, oracle failed to start. the error shows up in packgage log.
SQL*Plus: Release 9.2.0.5.0 - Production on Mon May 2 16:39:08 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected.
SQL> ORA-07217: sltln: environment variable cannot be evaluated.
SQL> Disconnected
logout
May 2 16:39:09 - Node "sunuxdb2" Oracle startup done.
May 2 16:39:09 - Node "sunuxdb2" Not starting the listener, configured not to start.
May 2 16:39:09 - Node "sunuxdb2": Starting service RMAN_mon using
"/etc/cmcluster/RMAN/toolkit.sh monitor"
DATE='Mon May 2 16:39:09 PDT 2005'
DEBUG=no

it seems like oracle can connect, but can not start the database. if i disable the maintenance flag the package will be up and i can start oracle using command line.
I have a case open with HP support, but so far no result yet!
Attached is a package logfile for your reference.
Does anyone has seen this problem before.

Thanks in advance.

Tom

Re: ora-07217: sltln: environment cannot be evaluated

Rick Garland — Tue, 03 May 2005 16:06:48 GMT

What does the oerr ora-07127 say? Have you checked metalink?

Was there a fail over and the package was not completely moved back?

Check the logs for the cmcluster as well. There could be some clues in there. Start in the syslog.log file.

Re: ora-07217: sltln: environment cannot be evaluated

tom quach_1 — Tue, 03 May 2005 19:02:54 GMT

Hi Rick,
Thanks for your reply.
check with oracle and it is something with the environment. But oracle toolkit comes with it own config files, so i don't know where it went wrong. Both of my Oracle packages failed.

Thanks, Tom

Re: ora-07217: sltln: environment cannot be evaluated

Eric Antunes — Wed, 04 May 2005 04:22:20 GMT

Hi Tom,

Check if $ORACLE_SID is set correctly.

Best Regards,

Eric Antunes

Re: ora-07217: sltln: environment cannot be evaluated

tom quach_1 — Wed, 04 May 2005 12:38:39 GMT

Hi Eric,

The ORACLE_SID was set corectly in
haoracle.conf file
in oracle toolkit (5 scripts)
haoracle.sh
haoracle.conf
haoracle.mon
toolkit.sh
haoracle_sql.sh
all envoronment were define in haoracle.conf
and oracle_sql.sh is the one to start the database.somehow it couldnot get ENV from the script, so when i added ORACLE_SID=BK
to oracle profile, the oracle package starts up fine. But the problem is, i have more than one database packages. can not define it in oracle profile. so i defined it in one of startup and shutdown scripts (haoracle_sal.sh)
and it works fine. I should not have to define it there, troubleshooting later. but for now it works.
Thanks for your help.
Regards,
Tom