ORA-12154 With Local (BEQUEATH) SQL*Plus Connection (Doc ID 430312.1)

Last updated on AUGUST 30, 2013

Applies to:

Oracle Net Services - Version 9.2.0.1.0 to 10.2.0.4.0 [Release 9.2 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

When attempting to connect locally to the Oracle database (via the BEQ protocol), not using a connect string / TNS "alias," a TNS error is thrown even though TNS is never referenced.

The error may be similar to the following screen shot:

C:\Documents and Settings\oracle_test>sqlplus

SQL*Plus: Release 9.2.0.7.0 - Production on Mon May 7 14:54:09 2007

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

Enter user-name: sys
Enter password:
ERROR:
ORA-12154: TNS:could not resolve service name

Changes

The only change is that the password(s) for database access were changed.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms