-- Connect non sys user
Syntax:
sqlplus <username>/"<password>"@<hostname>:<port#>/<database/servicename>
e.g.,
sqlplus system/"Passw0rd#"@example02:1521/testdb
e.g.,
C:\>sqlplus system/"Passw0rd#"@example02:1521/testdb
SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 18 12:31:53 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Thu Nov 15 2018 06:35:54 -05:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
SQL>
-- Connect as sysdba
Syntax:
sqlplus <username>/"<password>"@<hostname>:<port#>/<database/servicename> as sysdba
e.g.,
sqlplus sys/"Passw0rd#"@example02:1521/testdb as sysdba
C:\>sqlplus sys/"Passw0rd#"@example02:1521/testdb as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 18 12:57:26 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
SQL>
Syntax:
sqlplus <username>/"<password>"@<hostname>:<port#>/<database/servicename>
e.g.,
sqlplus system/"Passw0rd#"@example02:1521/testdb
e.g.,
C:\>sqlplus system/"Passw0rd#"@example02:1521/testdb
SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 18 12:31:53 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Thu Nov 15 2018 06:35:54 -05:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
SQL>
-- Connect as sysdba
Syntax:
sqlplus <username>/"<password>"@<hostname>:<port#>/<database/servicename> as sysdba
e.g.,
sqlplus sys/"Passw0rd#"@example02:1521/testdb as sysdba
C:\>sqlplus sys/"Passw0rd#"@example02:1521/testdb as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 18 12:57:26 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics, Real Application Testing
and Unified Auditing options
SQL>
Hi,
ReplyDeleteI must appreciate you for providing such a valuable content for us. This is one amazing piece of article. Helped a lot in increasing my knowledge.
German Classes in Chennai
German Language Classes in Chennai
German Courses in Chennai
German Language Course in Chennai
Web Designing Course in chennai
PHP Training in Chennai
Java Training in Chennai
German classes in Velachery
Great information...I am happy to find this post Very Helpful for me. oracle training in chennai
ReplyDelete
ReplyDeleteIam so thrilled because of finding your alluring website here.Actually i was searching for Oracle BPM.Your blog is so astounding and informative too..Iam very happy to find such a creative blog. Iam also find another one by mistake while am searching the same topicOracle SQL.Thank you soo much..
Wonderful piece you got here , I feel quite happy after I read your Article because I found out that we still have intelligent informative researchers who can still take time out of their busy schedule to put all this together I will instantly grab your rss feed to stay informed of any updates you make and as well take the advantage to share some latest information about. credit card hack software
ReplyDelete