Operating System - HP-UX
1748183 Members
3394 Online
108759 Solutions
New Discussion юеВ

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

 
SOLVED
Go to solution
tom quach_1
Super Advisor

ora-07217: sltln: environment cannot be evaluated

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
4 REPLIES 4
Rick Garland
Honored Contributor

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

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.
tom quach_1
Super Advisor

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

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
Eric Antunes
Honored Contributor
Solution

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

Hi Tom,

Check if $ORACLE_SID is set correctly.

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
tom quach_1
Super Advisor

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

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