Home » Infrastructure » Linux » ORA-07217: sltln: environment variable cannot be evaluated. (linux)
ORA-07217: sltln: environment variable cannot be evaluated. [message #309737] Fri, 28 March 2008 11:17 Go to next message
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>
Re: ORA-07217: sltln: environment variable cannot be evaluated. [message #309746 is a reply to message #309737] Fri, 28 March 2008 12:04 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
The error is obvious.
You could only connect to oracle as user that installed oracle.
Re: ORA-07217: sltln: environment variable cannot be evaluated. [message #309753 is a reply to message #309737] Fri, 28 March 2008 12:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
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
Re: ORA-07217: sltln: environment variable cannot be evaluated. [message #309789 is a reply to message #309737] Fri, 28 March 2008 16:33 Go to previous messageGo to next message
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)
)
)

Re: ORA-07217: sltln: environment variable cannot be evaluated. [message #309790 is a reply to message #309737] Fri, 28 March 2008 16:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Are both GOOGLE & the search function on this forum broken for you?
If so, you should get a refund from your ISP.
Re: ORA-07217: sltln: environment variable cannot be evaluated. [message #310242 is a reply to message #309737] Mon, 31 March 2008 12:36 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Oracle version & OS?
How are you trying to connect?

Post the connection script.
Re: ORA-07217: sltln: environment variable cannot be evaluated. [message #310419 is a reply to message #310242] Tue, 01 April 2008 03:39 Go to previous messageGo to next message
sipmaster
Messages: 4
Registered: March 2008
Location: Germany
Junior Member
Hi,

i am using

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

os is Linux

i am tring to access from my PC using oracle Client.

Re: ORA-07217: sltln: environment variable cannot be evaluated. [message #310459 is a reply to message #309737] Tue, 01 April 2008 06:21 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member

Post the connection script.

conn user/pass@...
Re: ORA-07217: sltln: environment variable cannot be evaluated. [message #310526 is a reply to message #310459] Tue, 01 April 2008 08:45 Go to previous message
sipmaster
Messages: 4
Registered: March 2008
Location: Germany
Junior Member
CTI =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = asdb1)(PORT = 1521))
(CONNECT_DATA = (SID = NET1A))
)
Previous Topic: Installation Oracle Developer Suits 10
Next Topic: Installing OWB on Oracle 11g
Goto Forum:
  


Current Time: Mon Nov 04 05:24:45 CST 2024