Skip to Main Content
  • Questions
  • normal user connection problem in 12c

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Balakrishna.

Asked: June 03, 2016 - 11:37 am UTC

Last updated: June 04, 2016 - 3:37 am UTC

Version: 12c

Viewed 1000+ times

You Asked

Hi tom,



system :dba user

i created new user name: krishna


while i'm log in as a new user i'm getting this error please solve it.?

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

and Connor said...

Dont use "conn" as the username. You only need when *changing* connectin.

Examples

C:\Users\comcdona>sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Sat Jun 4 11:36:03 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


SQL> conn scott/tiger
Connected.



C:\Users\comcdona>sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Sat Jun 4 11:36:31 2016

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Enter user-name: scott/tiger

Last Successful login time: Sat Jun 04 2016 11:36:11 +08:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Advanced Analytics
and Real Application Testing options




Is this answer out of date? If it is, please let us know via a Comment

More to Explore

VLDB

If you are new to partitioning, check out Connor McDonald's introduction series here.

VLDB

Documentation set on VLDB and Partitioning.