Oracle SqlPlus statement bit by bit records start Oracle listening: lsnrctl start view Oracle listening status: lsnrctl status start OracleServiceORCL service: net start OracleServiceORCL view the service name of the Oracle database to be connected, sysdba login is required: show parameter service_names; view current user: show user; close database: shutdown; Start Database: startup; sqlplus basic format: sqlplus <username> [/<password>] [@ <connect_identifier>] |/[as sysdba | as sysoper] |/nolog Oracle 10 Gb later, you can use a convenient connection method: username/password @ ip: port/service_name, as follows: sqlplus sys/ch Ange_on_install@128.160.176.29/orcl as sysdba View table structure: describe <tablename> today encountered a strange thing, with sqlplus and Oracle SQL Developer can be connected to ORCL database, is PL/SQL Developer can not connect. Then, add localhost: 1521/ORCL to the Database in the connection window of PL/SQL Developer to connect to the Database!