Skip to content

Instantly share code, notes, and snippets.

@moiz-frost
Created October 5, 2017 18:49
Show Gist options
  • Save moiz-frost/601018be1e588fdff0af627c3951c845 to your computer and use it in GitHub Desktop.
Save moiz-frost/601018be1e588fdff0af627c3951c845 to your computer and use it in GitHub Desktop.
This is all I got
SQL*Plus: Release 12.1.0.1.0 Production on Wed Sep 21 12:15:12 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter user-name: / as sysadmin
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>]
Enter user-name: as /sysadmin
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>]
Enter user-name: / as sysdba
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> alter session set container = pdborcl
2 ;
Session altered.
SQL> alter pluggable database open;
alter pluggable database open
*
ERROR at line 1:
ORA-65019: pluggable database PDBORCL already open
SQL> conn scott/tiger@pdborcl
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
Warning: You are no longer connected to ORACLE.
SQL> ed
Wrote file afiedt.buf
1* alter pluggable database open
SQL> show : name
SP2-0158: unknown SHOW option ":"
SP2-0158: unknown SHOW option "name"
SQL> show con_name
SP2-0640: Not connected
SP2-0641: "SHOW CONTAINER" requires connection to server
SQL>
SQL>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment