000021283 - SQL plus authentication errors

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000021283
Applies ToOracle 8.1.x
Sun Solaris 2.8
IssueSQL plus authentication errors
Error: "ERROR: ORA-07217 - sltln: environment variable cannot be evaluated" after executing ./sqlplus, when prompted to authenticate
CauseThe ORACLE_SID environment variable is not set to the value used to create the database initially.
ResolutionIf you created a database named ORCL, make sure the ORACLE_SID is set to ORCL (these values are case sensitive). The SID value can be found from viewing the listener.ora file (typically located at ORACLE_HOME/network/admin/listener.ora). View this file and locate the value of the SID_NAME parameter.
Legacy Article IDa21963