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>
|
|
|
|
|
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)
)
)
|
|
|
|
|
|
|
|