Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL*Plus does not accept EZCONNECT string

Dimitar DimitrovJul 13 2021

I am using SQL*Plus from an Oracle 18c Express Edition install. I am trying to connect using an EZCONNECT string, but SQL*Plus does not accept it:

SQL*Plus: Release 18.0.0.0.0 - Production on Ср Юли. 14 01:07:19 2021
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.

Enter user-name: myuser@//myserver:1521/xe
SP2-0306: Invalid option.
Usage: CONN[ECT] [{logon|/|proxy} [AS {SYSDBA|SYSOPER|SYSASM|SYSBACKUP|SYSDG|SYSKM|SYSRAC}] [edition=value]]
where <logon> ::= <username>[/<password>][@<connect_identifier>]
   <proxy> ::= <proxyuser>[<username>][/<password>][@<connect_identifier>]

sqlnet.ora:

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

What is wrong? Why does not SQL*Plus accept the EZCONNECT string above?
P.S. I tried also with an SQL*Plus 10g (a windowed Windows edition). It succeeds with EZCONNECT string in the "Host String:" field in the login box, but gives the the same error above when trying with an EZCONNECT string in a CONNECT command.

This post has been answered by Solomon Yakobson on Jul 13 2021
Jump to Answer
Comments
Post Details
Added on Jul 13 2021
3 comments
538 views