Cannot Connect to SQLPLUS when Password Contains Slash (/) SP2-0306

(Doc ID 264375.1)

Last updated on MAY 01, 2018

Applies to:

SQL*Plus - Version to [Release 8.1.7 to 11.2]
Information in this document applies to any platform.


The error SP2-0306 comes when the password for the schema user contains '/' (slash ) in it.
For example:

C:\>sqlplus test/"test/"@oracle92

SQL*Plus: Release - Production on Tue Dec 16 16:16:41 2003

(c) Copyright 2001 Oracle Corporation. All rights reserved.

SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where ::= [/ ][@] | /
Enter user-name:

The same above syntax works fine when you are already in the sqlplus.

For example:

C:\>sqlplus system/manager@oracle92

SQL>connect test/"test/"@oracle92
SQL> show user


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