OraFAQ Forum: Linux » ORA-07217: sltln: environment variable cannot be evaluated.

Home » Infrastructure » Linux » ORA-07217: sltln: environment variable cannot be evaluated. (linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-07217: sltln: environment variable cannot be evaluated. [message #309737]

Fri, 28 March 2008 11:17

sipmaster
Messages: 4
Registered: March 2008
Location: Germany

Junior Member

Hi All,

i am unable to access my oracle server from my client PC.

on server i observed that i can access only if login as oracle user.

Here is data.

please guide me which steps i need to perfomrs on my linux machine.

[root@asdb1 root]# sqlplus
Enter user-name: system/system
ERROR:
ORA-07217: sltln: environment variable cannot be evaluated.

---------

[root@asdb1 root]# su oracle
[oracle@asdb1 root]$ sqlplus

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Mar 28 17:16:48 2008

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

Enter user-name: system/system

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

SQL>

Report message to a moderator

Re: ORA-07217: sltln: environment variable cannot be evaluated. [message #309746 is a reply to message #309737]

Fri, 28 March 2008 12:04

varu123
Messages: 754
Registered: October 2007

Senior Member

The error is obvious.
You could only connect to oracle as user that installed oracle.

Report message to a moderator

Re: ORA-07217: sltln: environment variable cannot be evaluated. [message #309753 is a reply to message #309737]

Fri, 28 March 2008 12:18

Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Never use root for anything but root work, that is system maintenance.

Regards
Michel

Report message to a moderator

Re: ORA-07217: sltln: environment variable cannot be evaluated. [message #309789 is a reply to message #309737]

Fri, 28 March 2008 16:33

sipmaster
Messages: 4
Registered: March 2008
Location: Germany

Junior Member

i am getting follwoing error while trying to connect oracle server from my PC

TNS-12505: TNS:listener could not resolve SID given in connect descriptor

Here is my listener.ora and tnsnames.ora Files

# LISTENER.ORA Network Configuration File: /home/oracle/OraHome/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = asdb1)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCPS)(HOST = asdb1)(PORT = 2484))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = NET1A)
(ORACLE_HOME = /home/oracle/OraHome)
(PROGRAM = extproc)
)
------------------------

# TNSNAMES.ORA Network Configuration File: /home/oracle/OraHome/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ahmed =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host=asdb1)(Port= 1521))
(CONNECT_DATA =
(SID = NET1A)
)
)

Report message to a moderator