What are the methods of logging in to Oracle database with sqlplus command

This article will explain in detail the methods of logging in to Oracle database with sqlplus commands. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

1 Overview

There are two ways for sql*plus to log in to the Oracle database from the command line

Method 1: through the sql*plus command window (when downloading Oracle, bring it)

Method 2: through the cmd window (you can log in even if you forget your password)

2 three login methods: 1: > sqlplus / as sysdba mode 2: > sqlplus username/password@ip:port/sid > sqlplus username/password@orcl-abbreviation (premise: TNS is configured), the following is the same way 3: (recommended) > sqlplus / nolog > conn username/password@ip:port/sid

If "TNS snooping" is configured, it can be abbreviated.

2.1 sqlplus / as sysdba > sqlplus / as sysdba

2.2 sqlplus username/password@ip:port/sid > sqlplus scott/scott@orcl-- abbreviation > > sqlplus username/password@ip:port/sid-- full name

2.3 sqlplus / nolog

Log in without log first, do not connect to the database for the time being

Benefits: avoid disclosure of login username and password

> sqlplus / nolog > conn scott/scott@orcl

3 alternative commands > exit exit > ho cls clear screen on "what are the methods of sqlplus commands to log on to the Oracle database?" this article ends here. I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.